Name: Project Point Cityworks

Display Field: CreatedByName

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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

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 )
• 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 )
• CreatedBy ( type: esriFieldTypeGUID, alias: CreatedBy, editable: true, nullable: true, length: 38, defaultValue: null, modelName: CreatedBy )
• LastUpdatedBy ( type: esriFieldTypeGUID, alias: LastUpdatedBy, editable: true, nullable: true, length: 38, defaultValue: null, modelName: LastUpdatedBy )
• CreatedByName ( type: esriFieldTypeString, alias: CreatedByName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CreatedByName )
• LastUpdatedByName ( type: esriFieldTypeString, alias: LastUpdatedByName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LastUpdatedByName )
• RelationID ( type: esriFieldTypeGUID, alias: RelationID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: RelationID )
• IsRemoved ( type: esriFieldTypeSmallInteger, alias: IsRemoved, editable: true, nullable: true, defaultValue: 0, modelName: IsRemoved , Coded Values: [0: False] , [1: True] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Project Point Cityworks
  Description:
  Prototype:
  IsRemoved: 0
  RelationID: null
  IntegrationType: 0
  RequestID: null
  RequestStatus: null
  WorkOrderID: null
  WorkOrderTaskID: null
  WorkOrderTaskStatus: null
  WorkOrderStatus: null
  CreatedDate: null
  LastUpdatedDate: null
  CreatedBy: null
  LastUpdatedBy: null
  CreatedByName: null
  LastUpdatedByName: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PTPPointCityworks to PTPPoint (1) -- Related To: Project Point (1)

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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