Name: XTREME_DTE.job_info

Display Field: job_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

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:

• trouble_name ( type: esriFieldTypeString, alias: Trouble Per, editable: true, nullable: true, length: 255, defaultValue: null, modelName: trouble_name )
• traffic ( type: esriFieldTypeString, alias: Traffic, editable: true, nullable: true, length: 255, defaultValue: null, modelName: traffic , Coded Values: [Yes: Yes] , [No: No] )
• crane ( type: esriFieldTypeString, alias: Crane, editable: true, nullable: true, length: 255, defaultValue: null, modelName: crane , Coded Values: [Yes: Yes] , [No: No] )
• ferry ( type: esriFieldTypeString, alias: Ferry, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ferry , Coded Values: [Yes: Yes] , [No: No] )
• 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 )
• parent_GID ( type: esriFieldTypeGUID, alias: parent_GID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: parent_GID )
• job_name ( type: esriFieldTypeString, alias: Job Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: job_name )
• work_type ( type: esriFieldTypeString, alias: Work Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: work_type )
• circuit ( type: esriFieldTypeString, alias: Circuit, editable: true, nullable: true, length: 255, defaultValue: null, modelName: circuit )
• service_area ( type: esriFieldTypeString, alias: Service Area, editable: true, nullable: true, length: 255, defaultValue: null, modelName: service_area )
• hydrovac ( type: esriFieldTypeString, alias: Hydrovac, editable: true, nullable: true, length: 255, defaultValue: null, modelName: hydrovac , Coded Values: [Yes: Yes] , [No: No] )
• facilitator ( type: esriFieldTypeString, alias: Facilitator, editable: true, nullable: true, length: 255, defaultValue: null, modelName: facilitator )
• event_number ( type: esriFieldTypeString, alias: Event Number, editable: true, nullable: true, length: 13, defaultValue: null, modelName: event_number )
• stone_used ( type: esriFieldTypeString, alias: Stone Used?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: stone_used , Coded Values: [Yes: Yes] , [No: No] )
• total_bags ( type: esriFieldTypeInteger, alias: Total Bags, editable: true, nullable: true, defaultValue: null, modelName: total_bags )
• start_time ( type: esriFieldTypeString, alias: Start Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: start_time )
• stop_time ( type: esriFieldTypeString, alias: Stop Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: stop_time )
• qty_or_hrs ( type: esriFieldTypeDouble, alias: Qty or Hrs, editable: true, nullable: true, defaultValue: null, modelName: qty_or_hrs )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: notes )
• job_info_html_row ( type: esriFieldTypeString, alias: job_info_html_row, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: job_info_html_row )
• employee_html_rows ( type: esriFieldTypeString, alias: employee_html_rows, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: employee_html_rows )
• employee_html_table ( type: esriFieldTypeString, alias: Employee and Equipment Hours, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: employee_html_table )
• 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 )
• address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: address )
• storm_trouble ( type: esriFieldTypeString, alias: storm_trouble, editable: true, nullable: true, length: 20, defaultValue: null, modelName: storm_trouble , Coded Values: [Storm: Storm] , [Trouble: Trouble] )
• cmm_html_rows ( type: esriFieldTypeString, alias: cmm_html_rows, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: cmm_html_rows )
• cmm_html_row_join ( type: esriFieldTypeString, alias: cmm_html_row_join, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: cmm_html_row_join )
• rain_time ( type: esriFieldTypeString, alias: Rain Time?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: rain_time , Coded Values: [Yes: Yes] , [No: No] )
• raintime_total_hours ( type: esriFieldTypeDouble, alias: Total Rain Time, editable: true, nullable: true, defaultValue: null, modelName: raintime_total_hours )
• start_time_list_1 ( type: esriFieldTypeString, alias: Job Start Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: 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... )
• stop_time_list_1 ( type: esriFieldTypeString, alias: Job Stop Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: 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... )
• raintime_start_time_list_1 ( type: esriFieldTypeString, alias: Raintime Start Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: raintime_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... )
• raintime_stop_time_list_1 ( type: esriFieldTypeString, alias: Raintime Stop Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: raintime_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... )
• work_date_job ( type: esriFieldTypeDate, alias: Work Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: work_date_job )
• yard_job ( type: esriFieldTypeString, alias: Yard, editable: true, nullable: true, length: 255, defaultValue: null, modelName: yard_job )
• day_breakdown_html_rows ( type: esriFieldTypeString, alias: day_breakdown_html_rows, editable: true, nullable: true, length: 255, defaultValue: null, modelName: day_breakdown_html_rows )
• day_breakdown_html_row_join ( type: esriFieldTypeString, alias: day_breakdown_html_join, editable: true, nullable: true, length: 255, defaultValue: null, modelName: day_breakdown_html_row_join )
• coh_num ( type: esriFieldTypeString, alias: COH, editable: true, nullable: true, length: 255, defaultValue: null, modelName: coh_num )
• po_num ( type: esriFieldTypeString, alias: PO, editable: true, nullable: true, length: 255, defaultValue: null, modelName: po_num )

Templates:

• Name: XTREME_DTE.job_info
  Description:
  Prototype:
  coh_num: null
  trouble_name: null
  traffic: null
  crane: null
  ferry: null
  po_num: null
  parent_GID: null
  job_name: null
  work_type: null
  circuit: null
  service_area: null
  hydrovac: null
  facilitator: null
  event_number: null
  stone_used: null
  total_bags: null
  start_time: null
  stop_time: null
  qty_or_hrs: null
  notes: null
  job_info_html_row: null
  employee_html_rows: null
  employee_html_table: null
  day_breakdown_html_row_join: null
  day_breakdown_html_rows: null
  yard_job: null
  work_date_job: null
  address: null
  storm_trouble: null
  cmm_html_rows: null
  cmm_html_row_join: null
  rain_time: null
  raintime_total_hours: null
  start_time_list_1: null
  stop_time_list_1: null
  raintime_start_time_list_1: null
  raintime_stop_time_list_1: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• XTREME_DTE.crew_member_minutes (3) -- Related To: XTREME_DTE.crew_member_minutes (5)
• XTREME_DTE.day_breakdown (4) -- Related To: XTREME_DTE.day_breakdown (3)
• XTREME_DTE.Timesheet (1) -- 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   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata