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: -9247548.8666
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:
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: 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...
)
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 )
job_info_html_rows
( type: esriFieldTypeString, alias: job_info_html_rows, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: job_info_html_rows )
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_table
( type: esriFieldTypeString, alias: Day Breakdown, editable: true, nullable: true, length: 255, defaultValue: null, modelName: day_breakdown_html_table )
cmm_html_rows
( type: esriFieldTypeString, alias: cmm_html_rows, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: cmm_html_rows )
cmm_html_table
( type: esriFieldTypeString, alias: cmm_html_table, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: cmm_html_table )
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 )
job_info_html_table_summary
( type: esriFieldTypeString, alias: Job Info, editable: true, nullable: true, length: 255, defaultValue: null, modelName: job_info_html_table_summary )
employee_html_table_summary
( type: esriFieldTypeString, alias: Employee Hours, editable: true, nullable: true, length: 255, defaultValue: null, modelName: employee_html_table_summary )
day_breakdown_html_table_sum
( type: esriFieldTypeString, alias: Day Breakdown, editable: true, nullable: true, length: 255, defaultValue: null, modelName: day_breakdown_html_table_sum )
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] )
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 )
cmm_table_summary
( type: esriFieldTypeString, alias: Crew Member Minutes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cmm_table_summary )
equip_html_rows
( type: esriFieldTypeString, alias: equip_html_rows, editable: true, nullable: true, length: 255, defaultValue: null, modelName: equip_html_rows )
equip_html_table
( type: esriFieldTypeString, alias: equip_html_table, editable: true, nullable: true, length: 255, defaultValue: null, modelName: equip_html_table )
equip_html_table_summary
( type: esriFieldTypeString, alias: Equipment Hours, editable: true, nullable: true, length: 255, defaultValue: null, modelName: equip_html_table_summary )
job_info_html_table
( type: esriFieldTypeString, alias: job_info_html_table, editable: true, nullable: true, length: 255, defaultValue: null, modelName: job_info_html_table )
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] )
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 )
Templates:
Name: XTREME_DTE.Timesheet
Description:
Prototype:
equip_exported_date:
null
equip_exported_by:
null
minute_log_required:
null
crew_number:
null
yard:
null
work_date:
null
comments:
null
day_of_week:
null
job_info_html_rows:
null
day_breakdown_html_rows:
null
day_breakdown_html_table:
null
cmm_html_rows:
null
cmm_html_table:
null
crew_foreman_date:
null
sign_off_date:
null
job_info_html_table_summary:
null
employee_html_table_summary:
null
day_breakdown_html_table_sum:
null
xpc_rep_summary:
null
dte_rep_summary:
null
sign_off_date_summary:
null
survey_review:
null
equip_exported:
No
bill_exported_by:
null
bill_exported_date:
null
bill_exported:
No
employee_html_rows:
null
employee_html_table:
null
exported:
No
exported_date:
null
approved:
Not Approved
approved_by:
null
approved_date:
null
cmm_table_summary:
null
equip_html_rows:
null
equip_html_table:
null
equip_html_table_summary:
null
job_info_html_table:
null
submitted_by:
null
billing_review:
Not Approved
billing_review_by:
null
billing_review_date:
null
exported_by:
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
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)
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
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 )
employee_name
( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: employee_name )
traveler
( type: esriFieldTypeString, alias: Traveler?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: traveler )
employee_num
( type: esriFieldTypeString, alias: Employee Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: employee_num )
employee_class
( type: esriFieldTypeString, alias: Employee Class, editable: true, nullable: true, length: 255, defaultValue: null, modelName: employee_class )
bill_code
( type: esriFieldTypeString, alias: Billing Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: bill_code )
local
( type: esriFieldTypeString, alias: Local?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: local ,
Coded Values:
[Local: Local] , [Non Local: Non Local] )
employee_start_time
( type: esriFieldTypeString, alias: Start Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: employee_start_time )
employee_stop_time
( type: esriFieldTypeString, alias: Stop Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: employee_stop_time )
employee_start_time_list_1
( type: esriFieldTypeString, alias: Employee Start Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: employee_start_time_list_1 ,
Coded Values:
[00:00:00: 00:00:00] , [00:15:00: 00:15:00] , [00:30:00: 00:30:00]
, ...93 more...
)
employee_stop_time_list_1
( type: esriFieldTypeString, alias: Employee Stop Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: employee_stop_time_list_1 ,
Coded Values:
[00:00:00: 00:00:00] , [00:15:00: 00:15:00] , [00:30:00: 00:30:00]
, ...93 more...
)
calculated_total_time
( type: esriFieldTypeDouble, alias: Total Time, editable: true, nullable: true, defaultValue: null, modelName: calculated_total_time )
straight_time1
( type: esriFieldTypeDouble, alias: Straight Time, editable: true, nullable: true, defaultValue: null, modelName: straight_time1 )
over_time1
( type: esriFieldTypeDouble, alias: Over Time, editable: true, nullable: true, defaultValue: null, modelName: over_time1 )
meal_time1
( type: esriFieldTypeDouble, alias: Meal(s), editable: true, nullable: true, defaultValue: null, modelName: meal_time1 )
double_time1
( type: esriFieldTypeDouble, alias: Double Time, editable: true, nullable: true, defaultValue: null, modelName: double_time1 )
employee_html_row
( type: esriFieldTypeString, alias: employee_html_row, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: employee_html_row )
created_user
( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
created_date
( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
parent_gid
( type: esriFieldTypeGUID, alias: parent_gid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: parent_gid )
work_thru_lunch
( type: esriFieldTypeString, alias: Work through Lunch, editable: true, nullable: true, length: 255, defaultValue: null, modelName: work_thru_lunch ,
Coded Values:
[Yes: Yes] , [No: No] )
equip_html_table
( type: esriFieldTypeString, alias: equip_html_table, editable: true, nullable: true, length: 255, defaultValue: null, modelName: equip_html_table )
equip_html_row_join
( type: esriFieldTypeString, alias: equip_html_row_join, editable: true, nullable: true, length: 255, defaultValue: null, modelName: equip_html_row_join )
callout
( type: esriFieldTypeString, alias: Callout, editable: true, nullable: true, length: 255, defaultValue: null, modelName: callout ,
Coded Values:
[Yes: Yes] , [No: No] )
work_date_employee
( type: esriFieldTypeDate, alias: Work Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: work_date_employee )
total_hours
( type: esriFieldTypeDouble, alias: Total, editable: true, nullable: true, defaultValue: null, modelName: total_hours )
yard_employee
( type: esriFieldTypeString, alias: yard_employee, editable: true, nullable: true, length: 255, defaultValue: null, modelName: yard_employee )
crew_transfer
( type: esriFieldTypeString, alias: Crew Transfer, editable: true, nullable: true, length: 255, defaultValue: null, modelName: crew_transfer ,
Coded Values:
[Yes: Yes] , [No: No] )
Templates:
Name: XTREME_DTE.employee_hours
Description:
Prototype:
yard_employee:
null
crew_transfer:
null
employee_name:
null
traveler:
null
employee_num:
null
employee_class:
null
bill_code:
null
local:
null
employee_start_time:
null
employee_stop_time:
null
employee_start_time_list_1:
null
employee_stop_time_list_1:
null
calculated_total_time:
null
straight_time1:
null
over_time1:
null
meal_time1:
null
double_time1:
null
employee_html_row:
null
total_hours:
null
work_date_employee:
null
callout:
null
equip_html_row_join:
null
parent_gid:
null
work_thru_lunch:
null
equip_html_table:
null
Drawing Tool: esriFeatureEditToolNone
Relationships:
XTREME_DTE.equipment_hours (5) --
Related To
:
XTREME_DTE.equipment_hours
(6)
XTREME_DTE.Timesheet (0) --
Related To
:
XTREME_DTE.Timesheet
(0)
Table:
XTREME_DTE.day_breakdown
(3)
Name:
XTREME_DTE.day_breakdown
Display Field:
day_breakdown_html_row
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:
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 )
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 )
day_breakdown_html_row
( type: esriFieldTypeString, alias: day_breakdown_html_row, editable: true, nullable: true, length: 255, defaultValue: null, modelName: day_breakdown_html_row )
created_user
( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
created_date
( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
parent_GID
( type: esriFieldTypeGUID, alias: parent_GID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: parent_GID )
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
timesheet_globalID
( type: esriFieldTypeGUID, alias: timesheet_globalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: timesheet_globalID )
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 )
Templates:
Name: XTREME_DTE.day_breakdown
Description:
Prototype:
total_bags_day:
null
description_day:
null
location_worked:
null
time_at_location:
null
percent_complete:
null
day_breakdown_html_row:
null
stone_used_day:
No
crane_day:
No
traffic_day:
No
hydrovac_day:
No
parent_GID:
null
timesheet_globalID:
null
job_name_lookup_day:
null
work_date_day:
null
yard_day:
null
Drawing Tool: esriFeatureEditToolNone
Relationships:
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
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:
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
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 )
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 )
cmm_html_row
( type: esriFieldTypeString, alias: cmm_html_row, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: cmm_html_row )
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 )
yard_cmm
( type: esriFieldTypeString, alias: Yard, editable: true, nullable: true, length: 255, defaultValue: null, modelName: yard_cmm )
Templates:
Name: XTREME_DTE.crew_member_minutes
Description:
Prototype:
timesheet_globalid:
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
cmm_html_row:
null
yard_cmm:
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
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:
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_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 )
equip_html_row
( type: esriFieldTypeString, alias: equip_html_row, editable: true, nullable: true, length: 255, defaultValue: null, modelName: equip_html_row )
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 )
equip_start_time_list_1
( type: esriFieldTypeString, alias: Equipment Start Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: equip_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...
)
equip_stop_time_list_1
( type: esriFieldTypeString, alias: Equipment Stop Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: equip_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...
)
equip_total_hours
( type: esriFieldTypeDouble, alias: Total, editable: true, nullable: true, defaultValue: null, modelName: equip_total_hours )
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_straight_time1
( type: esriFieldTypeDouble, alias: Equip S.T., editable: true, nullable: true, defaultValue: null, modelName: equip_straight_time1 )
equip_rental
( type: esriFieldTypeString, alias: Rental, editable: true, nullable: true, length: 255, defaultValue: null, modelName: equip_rental )
Templates:
Name: XTREME_DTE.equipment_hours
Description:
Prototype:
equip_straight_time1:
null
equip_num:
null
equip_bill_code:
null
equip_type:
null
equip_rental:
null
yard_equip:
null
employee_lookup:
null
equip_total_hours:
null
equip_stop_time_list_1:
null
equip_html_row:
null
parent_gid:
null
timesheet_globalid:
null
work_date_equip:
null
equip_start_time_list_1:
null
Drawing Tool: esriFeatureEditToolNone
Relationships:
XTREME_DTE.employee_hours (5) --
Related To
:
XTREME_DTE.employee_hours
(2)
Table:
XTREME_DTE.Job_Employee_Summary_Table
(7)
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