ArcGIS REST Services Directory
Login
Home
>
services
>
Xtreme_Timesheet (FeatureServer)
>
All Layers and Tables
API Reference
JSON
All Layers and Tables (Xtreme_Timesheet)
Layers:
Layer:
XTREME_DTE.Timesheet
(0)
Name:
XTREME_DTE.Timesheet
Display Field:
work_date
Type:
Feature Layer
Geometry Type:
esriGeometryPoint
Description:
Service Item Id:
ba04414c57f6410abeeed413231d36cd
Copyright Text:
Default Visibility: true
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0.0
Max Scale:
0.0
Supports Advanced Queries:
true
Supports Statistics:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Supports Datum Transformation:
true
Extent:
XMin: -9326439.9237
YMin: 0.0
XMax: 0.0
YMax: 5464578.383299999
Spatial Reference: 102100 (3857) LatestVCSWkid(0)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSMSCircle
Color:
[168, 69, 53, 255]
Size:
4.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[0, 0, 0, 255]
Width:
0
Label:
N/A
Description:
N/A
Transparency:
0
Labeling Info:
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: true
HasM: false
Has Attachments:
true
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
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 )
minute_log_required
( type: esriFieldTypeString, alias: Crew Member Minutes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: minute_log_required )
crew_number
( type: esriFieldTypeString, alias: Crew Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: crew_number )
yard
( type: esriFieldTypeString, alias: Yard, editable: true, nullable: true, length: 255, defaultValue: null, modelName: yard ,
Coded Values:
[ARM: ARM] , [CAN: CAN] , [MAR: MAR]
, ...4 more...
)
yard_reporting
( type: esriFieldTypeString, alias: Yard (Reporting), editable: true, nullable: true, length: 255, defaultValue: null, modelName: yard_reporting )
work_date
( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: work_date )
comments
( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: comments )
day_of_week
( type: esriFieldTypeString, alias: Day, editable: true, nullable: true, length: 10, defaultValue: null, modelName: day_of_week )
crew_foreman_date
( type: esriFieldTypeDate, alias: Crew Foreman Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: crew_foreman_date )
sign_off_date
( type: esriFieldTypeDate, alias: Sign Off Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: sign_off_date )
xpc_rep_summary
( type: esriFieldTypeString, alias: XPC Representative, editable: true, nullable: true, length: 255, defaultValue: null, modelName: xpc_rep_summary )
dte_rep_summary
( type: esriFieldTypeString, alias: Utility Representative, editable: true, nullable: true, length: 255, defaultValue: null, modelName: dte_rep_summary )
sign_off_date_summary
( type: esriFieldTypeString, alias: Date, editable: true, nullable: true, length: 255, defaultValue: null, modelName: sign_off_date_summary )
survey_review
( type: esriFieldTypeString, alias: Summary Reviewed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: survey_review )
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 )
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_html_table, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: employee_html_table )
exported
( type: esriFieldTypeString, alias: Exported, editable: true, nullable: true, length: 255, defaultValue: No, modelName: exported ,
Coded Values:
[Yes: Yes] , [No: No] )
exported_date
( type: esriFieldTypeDate, alias: Exported Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: exported_date )
approved
( type: esriFieldTypeString, alias: Approved, editable: true, nullable: true, length: 255, defaultValue: Not Approved, modelName: approved ,
Coded Values:
[Not Approved: Not Approved] , [Approved: Approved] , [Rejected: Rejected]
, ...1 more...
)
approved_by
( type: esriFieldTypeString, alias: Approved By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: approved_by )
approved_date
( type: esriFieldTypeDate, alias: Approved Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: approved_date )
submitted_by
( type: esriFieldTypeString, alias: Submitted By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: submitted_by )
billing_review
( type: esriFieldTypeString, alias: Billing Review, editable: true, nullable: true, length: 255, defaultValue: Not Approved, modelName: billing_review ,
Coded Values:
[Not Approved: Not Approved] , [Approved: Approved] , [Rejected: Rejected]
, ...1 more...
)
billing_review_by
( type: esriFieldTypeString, alias: Billing Review By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: billing_review_by )
billing_review_date
( type: esriFieldTypeDate, alias: Billing Review Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: billing_review_date )
exported_by
( type: esriFieldTypeString, alias: Exported By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: exported_by )
bill_exported
( type: esriFieldTypeString, alias: Bill Exported, editable: true, nullable: true, length: 255, defaultValue: No, modelName: bill_exported ,
Coded Values:
[Yes: Yes] , [No: No] )
bill_exported_date
( type: esriFieldTypeDate, alias: Bill Exported Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: bill_exported_date )
bill_exported_by
( type: esriFieldTypeString, alias: Bill Exported By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: bill_exported_by )
equip_exported
( type: esriFieldTypeString, alias: Equip Exported, editable: true, nullable: true, length: 255, defaultValue: No, modelName: equip_exported ,
Coded Values:
[Yes: Yes] , [No: No] )
equip_exported_date
( type: esriFieldTypeDate, alias: Equip Exported Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: equip_exported_date )
equip_exported_by
( type: esriFieldTypeString, alias: Equip Exported By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: equip_exported_by )
gf_notes
( type: esriFieldTypeString, alias: GF Notes, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: gf_notes )
billing_notes
( type: esriFieldTypeString, alias: Billing Notes, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: billing_notes )
billing_reject
( type: esriFieldTypeString, alias: Billing Reject Reason, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: billing_reject )
start_time_list
( type: esriFieldTypeString, alias: Start Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: start_time_list ,
Coded Values:
[00:00:00: 00:00:00] , [00:15:00: 00:15:00] , [00:30:00: 00:30:00]
, ...93 more...
)
weather_out
( type: esriFieldTypeString, alias: Weather Out?, editable: true, nullable: true, length: 255, defaultValue: No, modelName: weather_out ,
Coded Values:
[Yes: Yes] , [No: No] )
Templates:
Name: XTREME_DTE.Timesheet
Description:
Prototype:
start_time_list:
null
weather_out:
No
minute_log_required:
null
crew_number:
null
yard:
null
yard_reporting:
null
work_date:
null
comments:
null
day_of_week:
null
crew_foreman_date:
null
sign_off_date:
null
xpc_rep_summary:
null
dte_rep_summary:
null
sign_off_date_summary:
null
survey_review:
null
billing_reject:
null
billing_notes:
null
gf_notes:
null
equip_exported_by:
null
employee_html_rows:
null
employee_html_table:
null
exported:
No
exported_date:
null
approved:
Not Approved
approved_by:
null
approved_date:
null
submitted_by:
null
billing_review:
Not Approved
billing_review_by:
null
billing_review_date:
null
exported_by:
null
bill_exported:
No
bill_exported_date:
null
bill_exported_by:
null
equip_exported:
No
equip_exported_date:
null
Drawing Tool: esriFeatureEditToolPoint
Relationships:
XTREME_DTE.job_info (1) --
Related To
:
XTREME_DTE.job_info
(1)
XTREME_DTE.employee_hours (0) --
Related To
:
XTREME_DTE.employee_hours
(2)
XTREME_DTE.minute_daily_log (2) --
Related To
:
XTREME_DTE.minute_daily_log
(4)
Tables:
Table:
XTREME_DTE.job_info
(1)
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
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:
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 )
work_date_job
( type: esriFieldTypeDate, alias: Work Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: work_date_job )
crew_number_job
( type: esriFieldTypeString, alias: crew_number_job, editable: true, nullable: true, length: 255, defaultValue: null, modelName: crew_number_job )
trouble_name
( type: esriFieldTypeString, alias: Trouble Per, editable: true, nullable: true, length: 255, defaultValue: null, modelName: trouble_name )
facilitator
( type: esriFieldTypeString, alias: Facilitator, editable: true, nullable: true, length: 255, defaultValue: null, modelName: facilitator )
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] )
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 )
notes
( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: notes )
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 )
city
( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 255, defaultValue: null, modelName: city )
storm_trouble
( type: esriFieldTypeString, alias: storm_trouble, editable: true, nullable: true, length: 20, defaultValue: null, modelName: storm_trouble ,
Coded Values:
[Storm: Storm] , [Trouble: Trouble] )
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...
)
qty_or_hrs
( type: esriFieldTypeDouble, alias: Qty or Hrs, editable: true, nullable: true, defaultValue: null, modelName: qty_or_hrs )
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...
)
yard_job
( type: esriFieldTypeString, alias: Yard, editable: true, nullable: true, length: 255, defaultValue: null, modelName: yard_job )
job_name
( type: esriFieldTypeString, alias: Job Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: job_name )
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 )
rain_snow_out
( type: esriFieldTypeString, alias: Rain/Snow Out, editable: true, nullable: true, length: 255, defaultValue: null, modelName: rain_snow_out ,
Coded Values:
[Yes: Yes] , [No: No] )
rain_snow_out_start
( type: esriFieldTypeString, alias: Rain/Snow Out (Start), editable: true, nullable: true, length: 255, defaultValue: null, modelName: rain_snow_out_start ,
Coded Values:
[00:00:00: 00:00:00] , [00:15:00: 00:15:00] , [00:30:00: 00:30:00]
, ...93 more...
)
rain_snow_out_stop
( type: esriFieldTypeString, alias: Rain/Snow Out (Stop), editable: true, nullable: true, length: 255, defaultValue: null, modelName: rain_snow_out_stop ,
Coded Values:
[00:00:00: 00:00:00] , [00:15:00: 00:15:00] , [00:30:00: 00:30:00]
, ...93 more...
)
duration
( type: esriFieldTypeDouble, alias: Job Duration, editable: true, nullable: true, defaultValue: null, modelName: duration )
start_time_decimal
( type: esriFieldTypeDouble, alias: Start Time (Decimal), editable: true, nullable: true, defaultValue: null, modelName: start_time_decimal )
stop_time_decimal
( type: esriFieldTypeDouble, alias: Stop Time (Decimal), editable: true, nullable: true, defaultValue: null, modelName: stop_time_decimal )
start_time_display
( type: esriFieldTypeString, alias: Start Time (Display), editable: true, nullable: true, length: 255, defaultValue: null, modelName: start_time_display )
stop_time_display
( type: esriFieldTypeString, alias: Stop Time (Display), editable: true, nullable: true, length: 255, defaultValue: null, modelName: stop_time_display )
job_order
( type: esriFieldTypeInteger, alias: Job Order, editable: true, nullable: true, defaultValue: null, modelName: job_order )
Templates:
Name: XTREME_DTE.job_info
Description:
Prototype:
stop_time_display:
null
traffic:
null
crane:
null
ferry:
null
job_order:
null
parent_GID:
null
work_date_job:
null
crew_number_job:
null
trouble_name:
null
facilitator:
null
work_type:
null
circuit:
null
service_area:
null
hydrovac:
null
event_number:
null
stone_used:
null
total_bags:
null
notes:
null
start_time_display:
null
stop_time_decimal:
null
start_time_decimal:
null
duration:
null
address:
null
city:
null
storm_trouble:
null
rain_time:
null
raintime_total_hours:
null
start_time_list_1:
null
stop_time_list_1:
null
qty_or_hrs:
null
raintime_start_time_list_1:
null
raintime_stop_time_list_1:
null
yard_job:
null
job_name:
null
coh_num:
null
po_num:
null
rain_snow_out:
null
rain_snow_out_start:
null
rain_snow_out_stop:
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.storm_trouble_breakdown (5) --
Related To
:
XTREME_DTE.storm_trouble_breakdown
(7)
XTREME_DTE.Timesheet (1) --
Related To
:
XTREME_DTE.Timesheet
(0)
Table:
XTREME_DTE.employee_hours
(2)
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 )
parent_gid
( type: esriFieldTypeGUID, alias: parent_gid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: parent_gid )
work_date_employee
( type: esriFieldTypeDate, alias: Work Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: work_date_employee )
employee_name
( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: employee_name )
employee_num
( type: esriFieldTypeString, alias: Employee Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: employee_num )
created_date
( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
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_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 )
created_user
( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
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] )
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] )
approved_employee
( type: esriFieldTypeString, alias: Approved, 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, 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, editable: true, nullable: true, length: 8, defaultValue: null, modelName: approved_date_employeee )
billing_review_date_employee
( type: esriFieldTypeDate, alias: Billing Review Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: billing_review_date_employee )
straight_time2
( type: esriFieldTypeDouble, alias: Straight Time, editable: true, nullable: true, defaultValue: null, modelName: straight_time2 )
over_time2
( type: esriFieldTypeDouble, alias: Over Time, editable: true, nullable: true, defaultValue: null, modelName: over_time2 )
double_time2
( type: esriFieldTypeDouble, alias: Double Time, editable: true, nullable: true, defaultValue: null, modelName: double_time2 )
calculated_total_time2
( type: esriFieldTypeDouble, alias: Total Hours, editable: true, nullable: true, defaultValue: null, modelName: calculated_total_time2 )
Templates:
Name: XTREME_DTE.employee_hours
Description:
Prototype:
double_time2:
null
calculated_total_time2:
null
parent_gid:
null
work_date_employee:
null
employee_name:
null
employee_num:
null
over_time2:
null
straight_time2:
null
employee_class:
null
bill_code:
null
local:
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
billing_review_date_employee:
null
approved_date_employeee:
null
work_thru_lunch:
null
callout:
null
total_hours:
null
yard_employee:
null
crew_transfer:
null
employee_terminated:
null
approved_employee:
Not Approved
billing_review_employee:
Not Approved
Drawing Tool: esriFeatureEditToolNone
Relationships:
XTREME_DTE.equipment_hours (6) --
Related To
:
XTREME_DTE.equipment_hours
(6)
XTREME_DTE.Timesheet (0) --
Related To
:
XTREME_DTE.Timesheet
(0)
Table:
XTREME_DTE.day_breakdown
(3)
Name:
XTREME_DTE.day_breakdown
Display Field:
job_name_lookup_day
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 )
location_worked
( type: esriFieldTypeInteger, alias: Location Worked, editable: true, nullable: true, defaultValue: null, modelName: location_worked )
work_Location
( type: esriFieldTypeString, alias: Work Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: work_Location )
time_at_location
( type: esriFieldTypeDouble, alias: Time at Location, editable: true, nullable: true, defaultValue: null, modelName: time_at_location )
percent_complete
( type: esriFieldTypeInteger, alias: Percent Complete, editable: true, nullable: true, defaultValue: null, modelName: percent_complete )
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 )
timesheet_globalID
( type: esriFieldTypeGUID, alias: timesheet_globalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: timesheet_globalID )
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
job_name_lookup_day
( type: esriFieldTypeString, alias: Job Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: job_name_lookup_day )
work_date_day
( type: esriFieldTypeDate, alias: Work Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: work_date_day )
yard_day
( type: esriFieldTypeString, alias: Yard, editable: true, nullable: true, length: 255, defaultValue: null, modelName: yard_day )
hydrovac_day
( type: esriFieldTypeString, alias: Hydrovac, editable: true, nullable: true, length: 255, defaultValue: No, modelName: hydrovac_day ,
Coded Values:
[Yes: Yes] , [No: No] )
traffic_day
( type: esriFieldTypeString, alias: Traffic, editable: true, nullable: true, length: 255, defaultValue: No, modelName: traffic_day ,
Coded Values:
[Yes: Yes] , [No: No] )
crane_day
( type: esriFieldTypeString, alias: Crane, editable: true, nullable: true, length: 255, defaultValue: No, modelName: crane_day ,
Coded Values:
[Yes: Yes] , [No: No] )
stone_used_day
( type: esriFieldTypeString, alias: Stone Used, editable: true, nullable: true, length: 255, defaultValue: No, modelName: stone_used_day ,
Coded Values:
[Yes: Yes] , [No: No] )
total_bags_day
( type: esriFieldTypeInteger, alias: Total Bags, editable: true, nullable: true, defaultValue: null, modelName: total_bags_day )
description_day
( type: esriFieldTypeString, alias: Work Description, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: description_day )
crew_number_day
( type: esriFieldTypeString, alias: crew_number_day, editable: true, nullable: true, length: 255, defaultValue: null, modelName: crew_number_day )
event_number_day
( type: esriFieldTypeString, alias: Event Number, editable: true, nullable: true, length: 13, defaultValue: null, modelName: event_number_day )
address_day
( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: address_day )
city_day
( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 255, defaultValue: null, modelName: city_day )
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] )
duration_day
( type: esriFieldTypeDouble, alias: Duration, editable: true, nullable: true, defaultValue: null, modelName: duration_day )
rain_time_day
( type: esriFieldTypeString, alias: Rain Time?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: rain_time_day ,
Coded Values:
[Yes: Yes] , [No: No] )
breakdown_order_day
( type: esriFieldTypeInteger, alias: Location Breakdown Order, editable: true, nullable: true, defaultValue: null, modelName: breakdown_order_day )
all_raintime_range_day
( type: esriFieldTypeString, alias: Rain Time (Range), editable: true, nullable: true, length: 255, defaultValue: null, modelName: all_raintime_range_day )
all_raintime_hours_day
( type: esriFieldTypeDouble, alias: Rain Time (Total Hours), editable: true, nullable: true, defaultValue: null, modelName: all_raintime_hours_day )
Templates:
Name: XTREME_DTE.day_breakdown
Description:
Prototype:
all_raintime_range_day:
null
all_raintime_hours_day:
null
location_worked:
null
work_Location:
null
time_at_location:
null
percent_complete:
null
breakdown_order_day:
null
rain_time_day:
null
duration_day:
null
work_status:
null
parent_GID:
null
timesheet_globalID:
null
job_name_lookup_day:
null
work_date_day:
null
yard_day:
null
hydrovac_day:
No
traffic_day:
No
crane_day:
No
stone_used_day:
No
total_bags_day:
null
description_day:
null
crew_number_day:
null
event_number_day:
null
address_day:
null
city_day:
null
Drawing Tool: esriFeatureEditToolNone
Relationships:
XTREME_DTE.day_raintime (7) --
Related To
:
XTREME_DTE.day_raintime
(8)
XTREME_DTE.job_info (4) --
Related To
:
XTREME_DTE.job_info
(1)
Table:
XTREME_DTE.minute_daily_log
(4)
Name:
XTREME_DTE.minute_daily_log
Display Field:
indirect_category_minute
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:
true
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
pole_location_minute
( type: esriFieldTypeInteger, alias: Pole Location #, editable: true, nullable: true, defaultValue: null, modelName: pole_location_minute )
crew_member_minutes
( type: esriFieldTypeInteger, alias: Crew Member Minutes, editable: true, nullable: true, defaultValue: null, modelName: crew_member_minutes )
indirect_category_minute
( type: esriFieldTypeString, alias: Indirect Category, editable: true, nullable: true, length: 255, defaultValue: null, modelName: indirect_category_minute )
indirect_code_minute
( type: esriFieldTypeString, alias: Indirect Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: indirect_code_minute )
description_minute
( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: description_minute )
minute_html_row
( type: esriFieldTypeString, alias: minute_html_row, editable: true, nullable: true, length: 255, defaultValue: null, modelName: minute_html_row )
parentrowid
( type: esriFieldTypeGUID, alias: ParentRowID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: parentrowid )
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 )
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
Templates:
Name: XTREME_DTE.minute_daily_log
Description:
Prototype:
parentrowid:
null
parent_gid:
null
pole_location_minute:
null
crew_member_minutes:
null
indirect_category_minute:
null
indirect_code_minute:
null
description_minute:
null
minute_html_row:
null
Drawing Tool: esriFeatureEditToolNone
Relationships:
XTREME_DTE.Timesheet (2) --
Related To
:
XTREME_DTE.Timesheet
(0)
Table:
XTREME_DTE.crew_member_minutes
(5)
Name:
XTREME_DTE.crew_member_minutes
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:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
crew_member_minutes_cmm
( type: esriFieldTypeInteger, alias: Crew Member Minutes, editable: true, nullable: true, defaultValue: null, modelName: crew_member_minutes_cmm )
indirect_code_cmm
( type: esriFieldTypeString, alias: Indirect Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: indirect_code_cmm )
subtype_cmm
( type: esriFieldTypeString, alias: Subtype, editable: true, nullable: true, length: 255, defaultValue: null, modelName: subtype_cmm )
man_count_cmm
( type: esriFieldTypeInteger, alias: Man Count, editable: true, nullable: true, defaultValue: null, modelName: man_count_cmm )
total_minutes_cmm
( type: esriFieldTypeInteger, alias: Total Minutes, editable: true, nullable: true, defaultValue: null, modelName: total_minutes_cmm )
description_cmm
( type: esriFieldTypeString, alias: Description , editable: true, nullable: true, length: 255, defaultValue: null, modelName: description_cmm )
total_st_minutes_cmm
( type: esriFieldTypeInteger, alias: Total ST Minutes, editable: true, nullable: true, defaultValue: null, modelName: total_st_minutes_cmm )
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 )
parent_gid
( type: esriFieldTypeGUID, alias: parent_gid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: parent_gid )
job_name_lookup_cmm
( type: esriFieldTypeString, alias: Job Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: job_name_lookup_cmm )
timesheet_globalid
( type: esriFieldTypeGUID, alias: timesheet_globalid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: timesheet_globalid )
work_date_cmm
( type: esriFieldTypeDate, alias: Work Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: work_date_cmm )
crew_number_cmm
( type: esriFieldTypeString, alias: crew_number_cmm, editable: true, nullable: true, length: 255, defaultValue: null, modelName: crew_number_cmm )
Templates:
Name: XTREME_DTE.crew_member_minutes
Description:
Prototype:
work_date_cmm:
null
crew_member_minutes_cmm:
null
indirect_code_cmm:
null
subtype_cmm:
null
man_count_cmm:
null
total_minutes_cmm:
null
description_cmm:
null
total_st_minutes_cmm:
null
crew_number_cmm:
null
timesheet_globalid:
null
job_name_lookup_cmm:
null
parent_gid:
null
Drawing Tool: esriFeatureEditToolNone
Relationships:
XTREME_DTE.job_info (3) --
Related To
:
XTREME_DTE.job_info
(1)
Table:
XTREME_DTE.equipment_hours
(6)
Name:
XTREME_DTE.equipment_hours
Display Field:
equip_num
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:
equip_num
( type: esriFieldTypeString, alias: Equip #, editable: true, nullable: true, length: 255, defaultValue: null, modelName: equip_num )
equip_bill_code
( type: esriFieldTypeString, alias: Bill Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: equip_bill_code )
equip_straight_time1
( type: esriFieldTypeDouble, alias: Equip S.T., editable: true, nullable: true, defaultValue: null, modelName: equip_straight_time1 )
equip_type
( type: esriFieldTypeString, alias: Equipment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: equip_type )
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 )
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
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 )
work_date_equip
( type: esriFieldTypeDate, alias: work_date_equip, editable: true, nullable: true, length: 8, defaultValue: null, modelName: work_date_equip )
employee_lookup
( type: esriFieldTypeString, alias: Employee Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: employee_lookup )
yard_equip
( type: esriFieldTypeString, alias: Yard, editable: true, nullable: true, length: 255, defaultValue: null, modelName: yard_equip )
equip_rental
( type: esriFieldTypeString, alias: Rental, editable: true, nullable: true, length: 255, defaultValue: null, modelName: equip_rental )
equip_straight_time2
( type: esriFieldTypeDouble, alias: Equip ST, editable: true, nullable: true, defaultValue: null, modelName: equip_straight_time2 )
Templates:
Name: XTREME_DTE.equipment_hours
Description:
Prototype:
equip_rental:
null
equip_num:
null
equip_bill_code:
null
equip_straight_time1:
null
equip_type:
null
equip_straight_time2:
null
yard_equip:
null
employee_lookup:
null
work_date_equip:
null
timesheet_globalid:
null
parent_gid:
null
Drawing Tool: esriFeatureEditToolNone
Relationships:
XTREME_DTE.employee_hours (6) --
Related To
:
XTREME_DTE.employee_hours
(2)
Table:
XTREME_DTE.storm_trouble_breakdown
(7)
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)
Table:
XTREME_DTE.day_raintime
(8)
Name:
XTREME_DTE.day_raintime
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 )
parent_GID
( type: esriFieldTypeGUID, alias: parent_GID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: parent_GID )
job_info_GID
( type: esriFieldTypeGUID, alias: job_info_GID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: job_info_GID )
job_name_day
( type: esriFieldTypeString, alias: Job Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: job_name_day )
raintime_start_time_list_day
( type: esriFieldTypeString, alias: Rain Start Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: raintime_start_time_list_day ,
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_day
( type: esriFieldTypeString, alias: Rain Stop Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: raintime_stop_time_list_day ,
Coded Values:
[00:00:00: 00:00:00] , [00:15:00: 00:15:00] , [00:30:00: 00:30:00]
, ...93 more...
)
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 )
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
raintime_total_hours_day
( type: esriFieldTypeDouble, alias: Total Rain Time, editable: true, nullable: true, defaultValue: null, modelName: raintime_total_hours_day )
raintime_range_day
( type: esriFieldTypeString, alias: Rain Time Range, editable: true, nullable: true, length: 255, defaultValue: null, modelName: raintime_range_day )
Templates:
Name: XTREME_DTE.day_raintime
Description:
Prototype:
raintime_total_hours_day:
null
raintime_range_day:
null
parent_GID:
null
job_info_GID:
null
job_name_day:
null
raintime_start_time_list_day:
null
raintime_stop_time_list_day:
null
Drawing Tool: esriFeatureEditToolNone
Relationships:
XTREME_DTE.day_breakdown (7) --
Related To
:
XTREME_DTE.day_breakdown
(3)
Table:
XTREME_DTE.storm_trouble_raintime
(9)
Name:
XTREME_DTE.storm_trouble_raintime
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 )
parent_GID
( type: esriFieldTypeGUID, alias: parent_GID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: parent_GID )
job_info_GID
( type: esriFieldTypeGUID, alias: job_info_GID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: job_info_GID )
job_name_ST
( type: esriFieldTypeString, alias: Job Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: job_name_ST )
rain_time_ST
( type: esriFieldTypeString, alias: Rain, editable: true, nullable: true, length: 255, defaultValue: null, modelName: rain_time_ST ,
Coded Values:
[Yes: Yes] , [No: No] )
raintime_start_time_list_ST
( type: esriFieldTypeString, alias: Rain Start Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: raintime_start_time_list_ST ,
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_ST
( type: esriFieldTypeString, alias: Rain Stop Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: raintime_stop_time_list_ST ,
Coded Values:
[00:00:00: 00:00:00] , [00:15:00: 00:15:00] , [00:30:00: 00:30:00]
, ...93 more...
)
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 )
raintime_total_hours_ST
( type: esriFieldTypeDouble, alias: Total Rain Time (ST), editable: true, nullable: true, defaultValue: null, modelName: raintime_total_hours_ST )
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
raintime_range_ST
( type: esriFieldTypeString, alias: Rain Time Range, editable: true, nullable: true, length: 255, defaultValue: null, modelName: raintime_range_ST )
Templates:
Name: XTREME_DTE.storm_trouble_raintime
Description:
Prototype:
raintime_total_hours_ST:
null
raintime_range_ST:
null
parent_GID:
null
job_info_GID:
null
job_name_ST:
null
rain_time_ST:
null
raintime_start_time_list_ST:
null
raintime_stop_time_list_ST:
null
Drawing Tool: esriFeatureEditToolNone
Relationships:
XTREME_DTE.storm_trouble_breakdown (8) --
Related To
:
XTREME_DTE.storm_trouble_breakdown
(7)