Name: PSS BID ITEMS
Display Field: ID
Type: Table
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description: Iowa DOT project bid data from Project Scheduling System (PSS) for public use.
Copyright Text: Iowa Department of Transportation
Max Record Count: 2000
Supported query Formats: JSON
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:
IsSystemMaintained : True
Global ID Field: GLOBALID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- ID (type: esriFieldTypeInteger, alias: ID, SQL Type: sqlTypeOther, nullable: false, editable: true)
- STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- PIN (type: esriFieldTypeString, alias: PIN, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
- PROJECT_NUMBER (type: esriFieldTypeString, alias: PROJECT_NUMBER, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
- DIV_KEY (type: esriFieldTypeString, alias: DIV_KEY, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- ITEM_NO (type: esriFieldTypeString, alias: ITEM_NO, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
- ITEM_DESC (type: esriFieldTypeString, alias: ITEM_DESC, SQL Type: sqlTypeOther, length: 121, nullable: true, editable: true)
- CPS_LINE_NO (type: esriFieldTypeString, alias: CPS_LINE_NO, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- PROPOSAL_LINE_NO (type: esriFieldTypeString, alias: PROPOSAL_LINE_NO, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- UNIT (type: esriFieldTypeString, alias: UNIT, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- UK (type: esriFieldTypeInteger, alias: UK, SQL Type: sqlTypeOther, nullable: true, editable: true)
- REST_UPDATED (type: esriFieldTypeDate, alias: Rest Service Last Updated (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- REST_UTC_OFFSET (type: esriFieldTypeString, alias: REST UTC Offset, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
- GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Templates:
Name: PSS BID ITEMS
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Relationships:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 3/27/2024 11:50:11 PM
Schema Last Edit Date: 3/27/2024 11:50:11 PM
Data Last Edit Date: 3/27/2024 11:50:11 PM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Query Related Records
Generate Renderer
Validate SQL
Get Estimates