Name: Project Line Cityworks

Display Field: RelationID

Type: Table

Geometry Type: N/A

Description: Cityworks work orders and/or service requests can be added to ProTrack+ project scope. When a prroject location work is completed the work order task will be also closed.

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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

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 )
• RelationID ( type: esriFieldTypeGUID, alias: RelationID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: RelationID )
• IntegrationType ( type: esriFieldTypeSmallInteger, alias: IntegrationType, editable: true, nullable: false, defaultValue: null, modelName: IntegrationType , Coded Values: [1: Service Request] , [2: Work Order] )
• RequestID ( type: esriFieldTypeInteger, alias: RequestID, editable: true, nullable: true, defaultValue: null, modelName: RequestID )
• RequestStatus ( type: esriFieldTypeSmallInteger, alias: RequestStatus, editable: true, nullable: true, defaultValue: null, modelName: RequestStatus , Coded Values: [1: PTP - Pending Award] , [2: PTP - Awarded] , [3: PTP - Under Construction] , ...7 more... )
• WorkOrderID ( type: esriFieldTypeString, alias: WorkOrderID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WorkOrderID )
• WorkOrderTaskID ( type: esriFieldTypeInteger, alias: WorkOrderTaskID, editable: true, nullable: true, defaultValue: null, modelName: WorkOrderTaskID )
• WorkOrderTaskStatus ( type: esriFieldTypeSmallInteger, alias: WorkOrderTaskStatus, editable: true, nullable: true, defaultValue: null, modelName: WorkOrderTaskStatus , Coded Values: [1: PTP - Pending Award] , [2: PTP - Awarded] , [3: PTP - Under Construction] , ...7 more... )
• WorkOrderStatus ( type: esriFieldTypeSmallInteger, alias: WorkOrderStatus, editable: true, nullable: true, defaultValue: null, modelName: WorkOrderStatus , Coded Values: [1: PTP - Pending Award] , [2: PTP - Awarded] , [3: PTP - Under Construction] , ...7 more... )
• CreatedDate ( type: esriFieldTypeDate, alias: CreatedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CreatedDate )
• LastUpdatedDate ( type: esriFieldTypeDate, alias: LastUpdatedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastUpdatedDate )

Templates:

• Name: Project Line Cityworks
  Description:
  Prototype:
  CreatedDate: null
  LastUpdatedDate: null
  RelationID: null
  IntegrationType: 0
  RequestID: null
  RequestStatus: null
  WorkOrderID: null
  WorkOrderTaskID: null
  WorkOrderTaskStatus: null
  WorkOrderStatus: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PTPLineCityworks to PTPLine (6) -- Related To: Project Line (3)

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata