Name: Task Work Order (TWO) Based Contracts

Display Field:

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• UNIT (type: esriFieldTypeString, alias: UNIT, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FINANCIAL_PROJECT_IDENTIFICATIO (type: esriFieldTypeString, alias: FINANCIAL PROJECT IDENTIFICATION (FPID), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PROJECT_DESCRIPTION (type: esriFieldTypeString, alias: PROJECT DESCRIPTION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• WORK_MIX (type: esriFieldTypeString, alias: WORK MIX, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PROJECT_MANAGER (type: esriFieldTypeString, alias: PROJECT MANAGER, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CONTACT_NUMBER (type: esriFieldTypeString, alias: CONTACT NUMBER, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• CONTRACT_TYPE (type: esriFieldTypeString, alias: CONTRACT TYPE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ESTIMATED_CONTRACT_AMOUNT (type: esriFieldTypeString, alias: ESTIMATED CONTRACT AMOUNT, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ESTIMATED_EXECUTION_DATE (type: esriFieldTypeString, alias: ESTIMATED EXECUTION MONTH/YEAR, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• CONTRACT_LENGTH__MONTHS_ (type: esriFieldTypeString, alias: CONTRACT LENGTH (MONTHS), SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• BDI__YES_OR_NO_ (type: esriFieldTypeString, alias: BDI (YES OR NO), SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MAJOR_WORK_TYPES (type: esriFieldTypeString, alias: MAJOR WORK TYPES, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MINOR_WORK_TYPES (type: esriFieldTypeString, alias: MINOR WORK TYPES, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ADDITIONAL_INFORMATION (type: esriFieldTypeString, alias: ADDITIONAL INFORMATION, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/11/2025 7:08:15 PM

Schema Last Edit Date: 1/29/2025 1:23:33 PM

Data Last Edit Date: 2/11/2025 4:06:48 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat