Name: XTREME_DTE.employee_hours

Display Field: employee_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: ba04414c57f6410abeeed413231d36cd

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

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: true
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: false
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• employee_name ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: employee_name )
• traveler ( type: esriFieldTypeString, alias: Traveler?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: traveler )
• employee_num ( type: esriFieldTypeString, alias: Employee Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: employee_num )
• employee_class ( type: esriFieldTypeString, alias: Employee Class, editable: true, nullable: true, length: 255, defaultValue: null, modelName: employee_class , Coded Values: [CFM: CFM] , [JL: JL] , [GF: GF] , ...15 more... )
• bill_code ( type: esriFieldTypeString, alias: Billing Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: bill_code )
• local ( type: esriFieldTypeString, alias: Local?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: local , Coded Values: [Local: Local] , [Non Local: Non Local] )
• employee_start_time ( type: esriFieldTypeString, alias: Start Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: employee_start_time )
• employee_stop_time ( type: esriFieldTypeString, alias: Stop Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: employee_stop_time )
• employee_start_time_list_1 ( type: esriFieldTypeString, alias: Employee Start Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: employee_start_time_list_1 , 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, editable: true, nullable: true, length: 255, defaultValue: null, modelName: employee_stop_time_list_1 , 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, editable: true, nullable: true, defaultValue: null, modelName: calculated_total_time )
• straight_time1 ( type: esriFieldTypeDouble, alias: Straight Time, editable: true, nullable: true, defaultValue: null, modelName: straight_time1 )
• over_time1 ( type: esriFieldTypeDouble, alias: Over Time, editable: true, nullable: true, defaultValue: null, modelName: over_time1 )
• meal_time1 ( type: esriFieldTypeDouble, alias: Meal(s), editable: true, nullable: true, defaultValue: null, modelName: meal_time1 )
• double_time1 ( type: esriFieldTypeDouble, alias: Double Time, editable: true, nullable: true, defaultValue: null, modelName: double_time1 )
• employee_html_row ( type: esriFieldTypeString, alias: employee_html_row, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: employee_html_row )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• parent_gid ( type: esriFieldTypeGUID, alias: parent_gid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: parent_gid )
• work_thru_lunch ( type: esriFieldTypeString, alias: Work through Lunch, editable: true, nullable: true, length: 255, defaultValue: null, modelName: work_thru_lunch , Coded Values: [Yes: Yes] , [No: No] )
• callout ( type: esriFieldTypeString, alias: Callout, editable: true, nullable: true, length: 255, defaultValue: null, modelName: callout , Coded Values: [Yes: Yes] , [No: No] )
• work_date_employee ( type: esriFieldTypeDate, alias: Work Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: work_date_employee )
• total_hours ( type: esriFieldTypeDouble, alias: Total, editable: true, nullable: true, defaultValue: null, modelName: total_hours )
• yard_employee ( type: esriFieldTypeString, alias: yard_employee, editable: true, nullable: true, length: 255, defaultValue: null, modelName: yard_employee )
• crew_transfer ( type: esriFieldTypeString, alias: Crew Transfer, editable: true, nullable: true, length: 255, defaultValue: null, modelName: crew_transfer , Coded Values: [Yes: Yes] , [No: No] )
• employee_terminated ( type: esriFieldTypeString, alias: Terminated, editable: true, nullable: true, length: 255, defaultValue: null, modelName: employee_terminated , Coded Values: [Yes: Yes] , [No: No] )
• crew_number_employee ( type: esriFieldTypeString, alias: crew_number_employee, editable: true, nullable: true, length: 255, defaultValue: null, modelName: crew_number_employee )
• approved_employee ( type: esriFieldTypeString, alias: approved_employee, editable: true, nullable: true, length: 255, defaultValue: Not Approved, modelName: approved_employee , Coded Values: [Not Approved: Not Approved] , [Approved: Approved] , [Rejected: Rejected] , ...1 more... )
• billing_review_employee ( type: esriFieldTypeString, alias: billing_review_employee, editable: true, nullable: true, length: 255, defaultValue: Not Approved, modelName: billing_review_employee , Coded Values: [Not Approved: Not Approved] , [Approved: Approved] , [Rejected: Rejected] , ...1 more... )
• approved_date_employeee ( type: esriFieldTypeDate, alias: approved_date_employeee, editable: true, nullable: true, length: 8, defaultValue: null, modelName: approved_date_employeee )
• billing_review_date_employee ( type: esriFieldTypeDate, alias: billing_review_date_employee, editable: true, nullable: true, length: 8, defaultValue: null, modelName: billing_review_date_employee )
• weather_out_time ( type: esriFieldTypeDouble, alias: Weather Out Time, editable: true, nullable: true, defaultValue: null, modelName: weather_out_time )

Templates:

• Name: XTREME_DTE.employee_hours
  Description:
  Prototype:
  billing_review_date_employee: null
  weather_out_time: null
  employee_name: null
  traveler: null
  employee_num: null
  employee_class: null
  bill_code: null
  local: null
  employee_start_time: null
  employee_stop_time: null
  employee_start_time_list_1: null
  employee_stop_time_list_1: null
  calculated_total_time: null
  straight_time1: null
  over_time1: null
  meal_time1: null
  double_time1: null
  employee_html_row: null
  approved_date_employeee: null
  billing_review_employee: Not Approved
  approved_employee: Not Approved
  crew_number_employee: null
  parent_gid: null
  work_thru_lunch: null
  callout: null
  work_date_employee: null
  total_hours: null
  yard_employee: null
  crew_transfer: null
  employee_terminated: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• XTREME_DTE.equipment_hours (5) -- Related To: XTREME_DTE.equipment_hours (6)
• XTREME_DTE.Timesheet (0) -- Related To: XTREME_DTE.Timesheet (0)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata