Name: XTREME_DTE.employee_hours
Display Field: employee_name
Type: Table
Geometry Type: N/A
Description: null
Service Item Id: 3a716ccf2cee4b08992ff08be0d2f3b1
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 2000
MaxSelectionCount: 0
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:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
-
employee_name
(
type: esriFieldTypeString, alias: Name, length: 255
)
-
traveler
(
type: esriFieldTypeString, alias: Traveler?, length: 255
)
-
employee_num
(
type: esriFieldTypeString, alias: Employee Number, length: 255
)
-
employee_class
(
type: esriFieldTypeString, alias: Employee Class, length: 255
)
-
bill_code
(
type: esriFieldTypeString, alias: Billing Code, length: 255
)
-
local
(
type: esriFieldTypeString, alias: Local?, length: 255
, Coded Values:
[Local: Local]
, [Non Local: Non Local]
)
-
employee_start_time
(
type: esriFieldTypeString, alias: Start Time, length: 255
)
-
employee_stop_time
(
type: esriFieldTypeString, alias: Stop Time, length: 255
)
-
employee_start_time_list_1
(
type: esriFieldTypeString, alias: Employee Start Time, length: 255
, Coded Values:
[00:00:00: 00:00:00]
, [00:15:00: 00:15:00]
, [00:30:00: 00:30:00]
, ...93 more...
)
-
employee_stop_time_list_1
(
type: esriFieldTypeString, alias: Employee Stop Time, length: 255
, Coded Values:
[00:00:00: 00:00:00]
, [00:15:00: 00:15:00]
, [00:30:00: 00:30:00]
, ...93 more...
)
-
calculated_total_time
(
type: esriFieldTypeDouble, alias: Total Time
)
-
straight_time1
(
type: esriFieldTypeDouble, alias: Straight Time
)
-
over_time1
(
type: esriFieldTypeDouble, alias: Over Time
)
-
meal_time1
(
type: esriFieldTypeDouble, alias: Meal(s)
)
-
double_time1
(
type: esriFieldTypeDouble, alias: Double Time
)
-
employee_html_row
(
type: esriFieldTypeString, alias: employee_html_row, length: 2000
)
-
created_user
(
type: esriFieldTypeString, alias: created_user, length: 255
)
-
created_date
(
type: esriFieldTypeDate, alias: created_date, length: 8
)
-
last_edited_user
(
type: esriFieldTypeString, alias: last_edited_user, length: 255
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, length: 8
)
-
parent_gid
(
type: esriFieldTypeGUID, alias: parent_gid, length: 38
)
-
work_thru_lunch
(
type: esriFieldTypeString, alias: Work through Lunch, length: 255
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
equip_html_table
(
type: esriFieldTypeString, alias: equip_html_table, length: 255
)
-
equip_html_row_join
(
type: esriFieldTypeString, alias: equip_html_row_join, length: 255
)
-
callout
(
type: esriFieldTypeString, alias: Callout, length: 255
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
work_date_employee
(
type: esriFieldTypeDate, alias: Work Date, length: 8
)
-
total_hours
(
type: esriFieldTypeDouble, alias: Total
)
-
yard_employee
(
type: esriFieldTypeString, alias: yard_employee, length: 255
)
-
crew_transfer
(
type: esriFieldTypeString, alias: Crew Transfer, length: 255
, Coded Values:
[Yes: Yes]
, [No: No]
)
Relationships:
Supported Operations:
Query
Query Attachments
Query Analytic
Query Related Records
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata