Name: XTREME_DTE.storm_trouble_breakdown

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

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:

• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• event_number ( type: esriFieldTypeString, alias: Event Number, editable: true, nullable: true, length: 13, defaultValue: null, modelName: event_number )
• address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: address )
• work_status ( type: esriFieldTypeString, alias: Work Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: work_status , Coded Values: [Complete: Complete] , [Restored w/FU: Restored w/FU] , [Nothing Restored / FU Required: Nothing Restored / FU Required] )
• work_description_ST ( type: esriFieldTypeString, alias: Work Description, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: work_description_ST )
• work_date ( type: esriFieldTypeDate, alias: Work Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: work_date )
• hydrovac_ST ( type: esriFieldTypeString, alias: Hydrovac, editable: true, nullable: true, length: 255, defaultValue: null, modelName: hydrovac_ST , Coded Values: [Yes: Yes] , [No: No] )
• crane_ST ( type: esriFieldTypeString, alias: Crane, editable: true, nullable: true, length: 255, defaultValue: null, modelName: crane_ST , Coded Values: [Yes: Yes] , [No: No] )
• traffic_ST ( type: esriFieldTypeString, alias: Traffic, editable: true, nullable: true, length: 255, defaultValue: null, modelName: traffic_ST , Coded Values: [Yes: Yes] , [No: No] )
• stone_ST ( type: esriFieldTypeString, alias: Stone, editable: true, nullable: true, length: 255, defaultValue: null, modelName: stone_ST , Coded Values: [Yes: Yes] , [No: No] )
• stone_used_ST ( type: esriFieldTypeInteger, alias: Stone Used, editable: true, nullable: true, defaultValue: null, modelName: stone_used_ST )
• crew_number ( type: esriFieldTypeString, alias: Crew Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: crew_number )
• parent_gid ( type: esriFieldTypeGUID, alias: parent_gid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: parent_gid )
• timesheet_globalid ( type: esriFieldTypeGUID, alias: timesheet_globalid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: timesheet_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 )
• city ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 255, defaultValue: null, modelName: city )
• trouble_per ( type: esriFieldTypeString, alias: Trouble Per, editable: true, nullable: true, length: 255, defaultValue: null, modelName: trouble_per )
• additional_COH ( type: esriFieldTypeString, alias: Additional COH, editable: true, nullable: true, length: 255, defaultValue: null, modelName: additional_COH )
• rain_time_ST ( type: esriFieldTypeString, alias: Rain Time?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: rain_time_ST , Coded Values: [Yes: Yes] , [No: No] )
• breakdown_order_ST ( type: esriFieldTypeInteger, alias: Location Breakdown Order (Storm or Trouble), editable: true, nullable: true, defaultValue: null, modelName: breakdown_order_ST )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• duration_ST ( type: esriFieldTypeDouble, alias: Duration, editable: true, nullable: true, defaultValue: null, modelName: duration_ST )
• job_name_lookup_ST ( type: esriFieldTypeString, alias: Job Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: job_name_lookup_ST )
• all_raintime_range_ST ( type: esriFieldTypeString, alias: Rain Time (Range), editable: true, nullable: true, length: 255, defaultValue: null, modelName: all_raintime_range_ST )
• all_raintime_hours_ST ( type: esriFieldTypeDouble, alias: Rain Time (Total Hours), editable: true, nullable: true, defaultValue: null, modelName: all_raintime_hours_ST )

Templates:

• Name: XTREME_DTE.storm_trouble_breakdown
  Description:
  Prototype:
  all_raintime_range_ST: null
  all_raintime_hours_ST: null
  event_number: null
  address: null
  work_status: null
  work_description_ST: null
  work_date: null
  hydrovac_ST: null
  crane_ST: null
  traffic_ST: null
  stone_ST: null
  stone_used_ST: null
  crew_number: null
  parent_gid: null
  timesheet_globalid: null
  duration_ST: null
  job_name_lookup_ST: null
  breakdown_order_ST: null
  rain_time_ST: null
  city: null
  trouble_per: null
  additional_COH: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• XTREME_DTE.storm_trouble_raintime (8) -- Related To: XTREME_DTE.storm_trouble_raintime (9)
• XTREME_DTE.job_info (5) -- Related To: XTREME_DTE.job_info (1)

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