Name: Leaf Employee Table
Display Field: DailyCrewID
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
DailyWorkID
(
type: esriFieldTypeInteger, alias: DailyWorkID
)
-
DailyCrewID
(
type: esriFieldTypeOID, alias: DailyCrewID
)
-
DateID
(
type: esriFieldTypeInteger, alias: DateID
)
-
EmployeeNumber
(
type: esriFieldTypeString, alias: EmployeeNumber, length: 50
)
-
Date
(
type: esriFieldTypeDate, alias: Date, length: 8
)
-
department
(
type: esriFieldTypeString, alias: department, length: 25
)
-
Division
(
type: esriFieldTypeString, alias: Division, length: 25
)
-
Section
(
type: esriFieldTypeString, alias: Section, length: 25
)
-
Status
(
type: esriFieldTypeString, alias: Status, length: 10
)
-
hours
(
type: esriFieldTypeDouble, alias: hours
)
-
TotalHours
(
type: esriFieldTypeDouble, alias: TotalHours
)
-
OvertimeHours
(
type: esriFieldTypeDouble, alias: OvertimeHours
)
-
BusinessUnit
(
type: esriFieldTypeString, alias: BusinessUnit, length: 51
)
-
EmployeeStatus
(
type: esriFieldTypeString, alias: EmployeeStatus, length: 25
)
-
Activity
(
type: esriFieldTypeString, alias: Activity, length: 25
)
-
StatusCategory
(
type: esriFieldTypeString, alias: StatusCategory, length: 10
)
-
ComputedStatus
(
type: esriFieldTypeString, alias: ComputedStatus, length: 10
)
-
FullTimeEquivalent
(
type: esriFieldTypeDouble, alias: FullTimeEquivalent
)
-
OvertimeEquivalent
(
type: esriFieldTypeDouble, alias: OvertimeEquivalent
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata