Name: XTREME_DTE.Timesheet

Display Field: work_date

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3a716ccf2cee4b08992ff08be0d2f3b1

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -9276039.7786
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: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• minute_log_required ( type: esriFieldTypeString, alias: Crew Member Minutes, length: 255 )
• crew_number ( type: esriFieldTypeString, alias: Crew Number, length: 255 )
• yard ( type: esriFieldTypeString, alias: Yard, length: 255 , Coded Values: [ARM: ARM] , [CAN: CAN] , [MAR: MAR] , ...4 more... )
• work_date ( type: esriFieldTypeDate, alias: Date, length: 8 )
• comments ( type: esriFieldTypeString, alias: Comments, length: 1000 )
• day_of_week ( type: esriFieldTypeString, alias: Day, length: 10 )
• crew_foreman_date ( type: esriFieldTypeDate, alias: Crew Foreman Date, length: 8 )
• sign_off_date ( type: esriFieldTypeDate, alias: Sign Off Date, length: 8 )
• xpc_rep_summary ( type: esriFieldTypeString, alias: XPC Representative, length: 255 )
• dte_rep_summary ( type: esriFieldTypeString, alias: Utility Representative, length: 255 )
• sign_off_date_summary ( type: esriFieldTypeString, alias: Date, length: 255 )
• survey_review ( type: esriFieldTypeString, alias: Summary Reviewed, length: 255 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• employee_html_rows ( type: esriFieldTypeString, alias: employee_html_rows, length: 2000 )
• employee_html_table ( type: esriFieldTypeString, alias: employee_html_table, length: 2000 )
• exported ( type: esriFieldTypeString, alias: Exported, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• exported_date ( type: esriFieldTypeDate, alias: Exported Date, length: 8 )
• approved ( type: esriFieldTypeString, alias: Approved, length: 255 , Coded Values: [Not Approved: Not Approved] , [Approved: Approved] , [Rejected: Rejected] , ...1 more... )
• approved_by ( type: esriFieldTypeString, alias: Approved By, length: 255 )
• approved_date ( type: esriFieldTypeDate, alias: Approved Date, length: 8 )
• submitted_by ( type: esriFieldTypeString, alias: Submitted By, length: 255 )
• billing_review ( type: esriFieldTypeString, alias: Billing Review, length: 255 , Coded Values: [Not Approved: Not Approved] , [Approved: Approved] , [Rejected: Rejected] , ...1 more... )
• billing_review_by ( type: esriFieldTypeString, alias: Billing Review By, length: 255 )
• billing_review_date ( type: esriFieldTypeDate, alias: Billing Review Date, length: 8 )
• exported_by ( type: esriFieldTypeString, alias: Exported By, length: 255 )
• bill_exported ( type: esriFieldTypeString, alias: Bill Exported, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• bill_exported_date ( type: esriFieldTypeDate, alias: Bill Exported Date, length: 8 )
• bill_exported_by ( type: esriFieldTypeString, alias: Bill Exported By, length: 255 )
• equip_exported ( type: esriFieldTypeString, alias: Equip Exported, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• equip_exported_date ( type: esriFieldTypeDate, alias: Equip Exported Date, length: 8 )
• equip_exported_by ( type: esriFieldTypeString, alias: Equip Exported By, length: 255 )
• gf_notes ( type: esriFieldTypeString, alias: GF Notes, length: 1000 )
• billing_notes ( type: esriFieldTypeString, alias: Billing Notes, length: 1000 )
• billing_reject ( type: esriFieldTypeString, alias: Billing Reject Reason, length: 1000 )
• yard_reporting ( type: esriFieldTypeString, alias: Yard (Reporting), length: 255 )
• start_time_list ( type: esriFieldTypeString, alias: start_time_list, length: 255 , 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, length: 255 , Coded Values: [Yes: Yes] , [No: No] )

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)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata