View In:   ArcGIS Online Map Viewer

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)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata