Name: XTREME_DTE.Job_Employee_Summary_Table

Display Field: OBJECTID

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

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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 )
• 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 )
• timesheet_GID ( type: esriFieldTypeGUID, alias: timesheet_GID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: timesheet_GID )
• employee_hours_GID ( type: esriFieldTypeGUID, alias: employee_hours_GID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: employee_hours_GID )
• equip_hours_GID ( type: esriFieldTypeGUID, alias: equip_hours_GID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: equip_hours_GID )
• job_info_GID ( type: esriFieldTypeGUID, alias: job_info_GID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: job_info_GID )
• t_crew_number ( type: esriFieldTypeString, alias: Crew Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: t_crew_number )
• t_work_date ( type: esriFieldTypeDate, alias: Work Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: t_work_date )
• t_yard ( type: esriFieldTypeString, alias: Yard, editable: true, nullable: true, length: 255, defaultValue: null, modelName: t_yard )
• t_day ( type: esriFieldTypeString, alias: Day, editable: true, nullable: true, length: 10, defaultValue: null, modelName: t_day )
• t_exported ( type: esriFieldTypeString, alias: Exported, editable: true, nullable: true, length: 10, defaultValue: null, modelName: t_exported )
• t_exported_date ( type: esriFieldTypeDate, alias: Exported Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: t_exported_date )
• t_approved ( type: esriFieldTypeString, alias: Approved, editable: true, nullable: true, length: 20, defaultValue: null, modelName: t_approved )
• t_approved_by ( type: esriFieldTypeString, alias: Approved By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: t_approved_by )
• t_approved_date ( type: esriFieldTypeDate, alias: Approved Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: t_approved_date )
• j_job_name ( type: esriFieldTypeString, alias: Job Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: j_job_name )
• j_work_type ( type: esriFieldTypeString, alias: Work Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: j_work_type )
• j_service_area ( type: esriFieldTypeString, alias: Service Area, editable: true, nullable: true, length: 255, defaultValue: null, modelName: j_service_area )
• j_facilitator ( type: esriFieldTypeString, alias: Facilitator, editable: true, nullable: true, length: 255, defaultValue: null, modelName: j_facilitator )
• j_storm_trouble ( type: esriFieldTypeString, alias: Storm of Trouble?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: j_storm_trouble )
• j_trouble_name ( type: esriFieldTypeString, alias: Troubled By?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: j_trouble_name )
• j_event_num ( type: esriFieldTypeString, alias: Event Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: j_event_num )
• j_address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: j_address )
• j_stone_used ( type: esriFieldTypeString, alias: Stone Used, editable: true, nullable: true, length: 10, defaultValue: null, modelName: j_stone_used )
• j_total_bags ( type: esriFieldTypeInteger, alias: Total Bags, editable: true, nullable: true, defaultValue: null, modelName: j_total_bags )
• j_start_time_list_1 ( type: esriFieldTypeString, alias: Job Start Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: j_start_time_list_1 )
• j_stop_time_list_1 ( type: esriFieldTypeString, alias: Job Stop Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: j_stop_time_list_1 )
• j_raintime ( type: esriFieldTypeString, alias: Rain Time, editable: true, nullable: true, length: 10, defaultValue: null, modelName: j_raintime )
• j_raintime_start_time_list_1 ( type: esriFieldTypeString, alias: Raintime Start Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: j_raintime_start_time_list_1 )
• j_raintime_stop_time_list_1 ( type: esriFieldTypeString, alias: Raintime Stop Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: j_raintime_stop_time_list_1 )
• j_circuit ( type: esriFieldTypeString, alias: Circuit, editable: true, nullable: true, length: 255, defaultValue: null, modelName: j_circuit )
• j_hydrovac ( type: esriFieldTypeString, alias: Hydrovac, editable: true, nullable: true, length: 10, defaultValue: null, modelName: j_hydrovac )
• j_traffic ( type: esriFieldTypeString, alias: Traffic, editable: true, nullable: true, length: 10, defaultValue: null, modelName: j_traffic )
• j_crane ( type: esriFieldTypeString, alias: Crane, editable: true, nullable: true, length: 10, defaultValue: null, modelName: j_crane )
• j_ferry ( type: esriFieldTypeString, alias: Ferry, editable: true, nullable: true, length: 10, defaultValue: null, modelName: j_ferry )
• em_traveller ( type: esriFieldTypeString, alias: Traveller, editable: true, nullable: true, length: 255, defaultValue: null, modelName: em_traveller )
• em_local ( type: esriFieldTypeString, alias: Local, editable: true, nullable: true, length: 255, defaultValue: null, modelName: em_local )
• em_employee_name ( type: esriFieldTypeString, alias: Employee Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: em_employee_name )
• em_employee_num ( type: esriFieldTypeString, alias: Employee Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: em_employee_num )
• em_employee_class ( type: esriFieldTypeString, alias: Employee Class, editable: true, nullable: true, length: 255, defaultValue: null, modelName: em_employee_class )
• em_bill_code ( type: esriFieldTypeString, alias: Bill Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: em_bill_code )
• em_callout ( type: esriFieldTypeString, alias: Call Out, editable: true, nullable: true, length: 255, defaultValue: null, modelName: em_callout )
• em_lunch ( type: esriFieldTypeString, alias: Lunch, editable: true, nullable: true, length: 255, defaultValue: null, modelName: em_lunch )
• em_employee_start_time_list_1 ( type: esriFieldTypeString, alias: Employee Start Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: em_employee_start_time_list_1 )
• em_employee_stop_time_list_1 ( type: esriFieldTypeString, alias: Employee Stop Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: em_employee_stop_time_list_1 )
• em_calculated_total_time ( type: esriFieldTypeDouble, alias: Total Time, editable: true, nullable: true, defaultValue: null, modelName: em_calculated_total_time )
• em_straight_time1 ( type: esriFieldTypeDouble, alias: Straight Time, editable: true, nullable: true, defaultValue: null, modelName: em_straight_time1 )
• em_over_time1 ( type: esriFieldTypeDouble, alias: Over Time, editable: true, nullable: true, defaultValue: null, modelName: em_over_time1 )
• em_double_time1 ( type: esriFieldTypeDouble, alias: Double Time, editable: true, nullable: true, defaultValue: null, modelName: em_double_time1 )
• em_total_hours ( type: esriFieldTypeDouble, alias: Total, editable: true, nullable: true, defaultValue: null, modelName: em_total_hours )
• em_meal_time1 ( type: esriFieldTypeDouble, alias: Meal(s), editable: true, nullable: true, defaultValue: null, modelName: em_meal_time1 )
• em_meal_time2 ( type: esriFieldTypeDouble, alias: No. of Meals Covered, editable: true, nullable: true, defaultValue: null, modelName: em_meal_time2 )
• eq_equip_num ( type: esriFieldTypeString, alias: Equip #, editable: true, nullable: true, length: 255, defaultValue: null, modelName: eq_equip_num )
• eq_equip_bill_code ( type: esriFieldTypeString, alias: Bill Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: eq_equip_bill_code )
• eq_equip_type ( type: esriFieldTypeString, alias: Equipment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: eq_equip_type )
• eq_equip_start_time_list_1 ( type: esriFieldTypeString, alias: Equipment Start Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: eq_equip_start_time_list_1 )
• eq_equip_stop_time_list_1 ( type: esriFieldTypeString, alias: Equipment Stop Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: eq_equip_stop_time_list_1 )
• eq_equip_total_hours ( type: esriFieldTypeDouble, alias: Equipment Total, editable: true, nullable: true, defaultValue: null, modelName: eq_equip_total_hours )
• adjusted_straight_time ( type: esriFieldTypeDouble, alias: S.T., editable: true, nullable: true, defaultValue: null, modelName: adjusted_straight_time )
• adjusted_over_time ( type: esriFieldTypeDouble, alias: O.T., editable: true, nullable: true, defaultValue: null, modelName: adjusted_over_time )
• adjusted_double_time ( type: esriFieldTypeDouble, alias: D.T., editable: true, nullable: true, defaultValue: null, modelName: adjusted_double_time )
• adjusted_total_time ( type: esriFieldTypeDouble, alias: Total Hrs, editable: true, nullable: true, defaultValue: null, modelName: adjusted_total_time )
• valid ( type: esriFieldTypeString, alias: Valid?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: valid )
• emp_start_time_export ( type: esriFieldTypeString, alias: emp_start_time_export, editable: true, nullable: true, length: 255, defaultValue: null, modelName: emp_start_time_export )
• emp_stop_time_export ( type: esriFieldTypeString, alias: emp_stop_time_export, editable: true, nullable: true, length: 255, defaultValue: null, modelName: emp_stop_time_export )
• equip_start_time_export ( type: esriFieldTypeString, alias: equip_start_time_export, editable: true, nullable: true, length: 255, defaultValue: null, modelName: equip_start_time_export )
• equip_stop_time_export ( type: esriFieldTypeString, alias: equip_stop_time_export, editable: true, nullable: true, length: 255, defaultValue: null, modelName: equip_stop_time_export )

Templates:

• Name: XTREME_DTE.Job_Employee_Summary_Table
  Description:
  Prototype:
  equip_start_time_export: null
  equip_stop_time_export: null
  emp_stop_time_export: null
  emp_start_time_export: null
  valid: null
  adjusted_total_time: null
  timesheet_GID: null
  employee_hours_GID: null
  equip_hours_GID: null
  job_info_GID: null
  t_crew_number: null
  t_work_date: null
  t_yard: null
  t_day: null
  t_exported: null
  t_exported_date: null
  t_approved: null
  t_approved_by: null
  t_approved_date: null
  j_job_name: null
  j_work_type: null
  j_service_area: null
  j_facilitator: null
  j_storm_trouble: null
  j_trouble_name: null
  j_event_num: null
  j_address: null
  j_stone_used: null
  j_total_bags: null
  j_start_time_list_1: null
  j_stop_time_list_1: null
  j_raintime: null
  j_raintime_start_time_list_1: null
  j_raintime_stop_time_list_1: null
  j_circuit: null
  j_hydrovac: null
  j_traffic: null
  j_crane: null
  j_ferry: null
  em_traveller: null
  em_local: null
  em_employee_name: null
  em_employee_num: null
  em_employee_class: null
  em_bill_code: null
  em_callout: null
  em_lunch: null
  em_employee_start_time_list_1: null
  em_employee_stop_time_list_1: null
  em_calculated_total_time: null
  em_straight_time1: null
  em_over_time1: null
  em_double_time1: null
  em_total_hours: null
  em_meal_time1: null
  em_meal_time2: null
  eq_equip_num: null
  eq_equip_bill_code: null
  eq_equip_type: null
  eq_equip_start_time_list_1: null
  eq_equip_stop_time_list_1: null
  eq_equip_total_hours: null
  adjusted_straight_time: null
  adjusted_over_time: null
  adjusted_double_time: null
  
  Drawing Tool: esriFeatureEditToolNone

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

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   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata