Name: WorkItemRegistry

Display Field:

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

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:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• WorkID (type: esriFieldTypeString, alias: Work ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• BridgeID (type: esriFieldTypeString, alias: Bridge ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• MaintType (type: esriFieldTypeString, alias: Maintenance Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Preventative: Preventative], [Routine: Routine])
• WorkType (type: esriFieldTypeString, alias: Work Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Railing-Repair: Railing-Repair], [Deck-Methacrylate: Deck-Methacrylate], [Joints-Repair: Joints-Repair], ... 37 more ...)
• WorkDescription (type: esriFieldTypeString, alias: Work Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RecordedDate (type: esriFieldTypeDate, alias: Recorded Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DueDate (type: esriFieldTypeDate, alias: Due Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WorkComplete (type: esriFieldTypeString, alias: Work Complete, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• CompletionDate (type: esriFieldTypeDate, alias: Completion Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CompleteByContract (type: esriFieldTypeString, alias: Complete By Contract, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• WorkRecommendedBy (type: esriFieldTypeString, alias: Work Recommended By, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Caltrans: Caltrans], [County: County], [Consultant: Consultant])
• BPMPFiscalYear (type: esriFieldTypeString, alias: BPMP Fiscal Year, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• BPMPAmmend (type: esriFieldTypeString, alias: BPMP Ammend, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• PriorityLevel (type: esriFieldTypeString, alias: Priority Level, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Very Low: Very Low], [Low: Low], [Moderate: Moderate], ... 2 more ...)
• ToBeSenttoRoadyard (type: esriFieldTypeString, alias: To Be Sent to Roadyard, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Comment (type: esriFieldTypeString, alias: Comment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Relationships:

• Bridge2WorkItem (2) -- Related To: BridgesOver20FT (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/20/2020 4:51:57 AM

Schema Last Edit Date: 5/20/2020 4:51:57 AM

Data Last Edit Date: 5/20/2020 4:51:57 AM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat