Name: IMPS

Display Field: Region

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

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:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Region (type: esriFieldTypeString, alias: Region, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Job_Number (type: esriFieldTypeInteger, alias: Job Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Job_Description (type: esriFieldTypeString, alias: Job Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Primary_Contract_if_different_J (type: esriFieldTypeInteger, alias: Primary Contract if different JN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• All_Other_Job_Numbers_Affiliate (type: esriFieldTypeString, alias: All Other Job Numbers Affiliated to Primary, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Active_Contract_Status_Contract (type: esriFieldTypeString, alias: Active Contract Status Contract Id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Balanced_Letting_Contract_Id (type: esriFieldTypeString, alias: Balanced Letting Contract Id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Contract_Value_Source (type: esriFieldTypeString, alias: Contract Value Source, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Issues___Contract_Value_Source (type: esriFieldTypeString, alias: Issues - Contract Value Source, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Active_Contract_Status_Award_Am (type: esriFieldTypeDouble, alias: Active Contract Status Award Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PSC_Milestone_Update_Constructi (type: esriFieldTypeDouble, alias: PSC Milestone Update Construction Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Actual_Cost_Source (type: esriFieldTypeString, alias: Actual Cost Source, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Issues___Actual_Cost_Source (type: esriFieldTypeString, alias: Issues - Actual Cost Source, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Active_Contract_Status_Contra_1 (type: esriFieldTypeDouble, alias: Active Contract Status Contract Award Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Active_Contract_Status___Comple (type: esriFieldTypeDouble, alias: Active Contract Status % Complete, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Actual_Cost__Calculated_ (type: esriFieldTypeDouble, alias: Actual Cost (Calculated), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Letting_Date_Source (type: esriFieldTypeString, alias: Letting Date Source, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Issues___Letting_Date_Source (type: esriFieldTypeString, alias: Issues - Letting Date Source, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Active_Contract_Status_Letting_ (type: esriFieldTypeString, alias: Active Contract Status Letting Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PSC_Milestone_Update_Letting_Da (type: esriFieldTypeString, alias: PSC Milestone Update Letting Date Budgeted, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Proposal_Actual_Letting_Date (type: esriFieldTypeString, alias: Proposal Actual Letting Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Construction_Start_Source (type: esriFieldTypeString, alias: Construction Start Source, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Issues___Construction_Start_Sou (type: esriFieldTypeString, alias: Issues - Construction Start Source, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Active_Contract_Status_Construc (type: esriFieldTypeString, alias: Active Contract Status Construction Begin Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Let_Date___60_Days__Calculated_ (type: esriFieldTypeString, alias: Let Date + 60 Days (Calculated), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Proposal_Open_to_Traffic (type: esriFieldTypeString, alias: Proposal Open to Traffic, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Final_Completion_Date_Source (type: esriFieldTypeString, alias: Final Completion Date Source, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Issues___Final_Completion_Date_ (type: esriFieldTypeString, alias: Issues - Final Completion Date Source, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Active_Contract_Status_Current_ (type: esriFieldTypeString, alias: Active Contract Status Current Specified Compl Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Proposal_Final_Completion (type: esriFieldTypeString, alias: Proposal Final Completion, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Balanced_Letting_Construction_Y (type: esriFieldTypeString, alias: Balanced Letting Construction Years, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HNTB_Estimated_Duration (type: esriFieldTypeDouble, alias: HNTB Estimated Duration, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Truckline_Quantities_Concrete_p (type: esriFieldTypeInteger, alias: Truckline Quantities Concrete pavement quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Truckline_Quantities_Asphalt_pa (type: esriFieldTypeString, alias: Truckline Quantities Asphalt pavement quantity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Truckline_Quantities_Aggregate_ (type: esriFieldTypeInteger, alias: Truckline Quantities Aggregate quantities tons, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Truckline_Quantities_Aggregate1 (type: esriFieldTypeInteger, alias: Truckline Quantities Aggregate quantities cyds, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Truckline_Quantities_Aggregat_1 (type: esriFieldTypeInteger, alias: Truckline Quantities Aggregate quantities syds, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Truckline_Quantities_Subbase_qu (type: esriFieldTypeInteger, alias: Truckline Quantities Subbase quantities cyds, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Truckline_Quantities_Concrete_b (type: esriFieldTypeInteger, alias: Truckline Quantities Concrete beam quantities, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Truckline_Quantities_Steel_beam (type: esriFieldTypeInteger, alias: Truckline Quantities Steel beam quantities, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Field41 (type: esriFieldTypeString, alias: Field41, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• P6_Expected_Contract_Value (type: esriFieldTypeString, alias: P6 Expected Contract Value, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• P6_Expected_Actual_Cost (type: esriFieldTypeString, alias: P6 Expected Actual Cost, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• P6_Expected_Letting_Date (type: esriFieldTypeString, alias: P6 Expected Letting Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• P6_Expected_Final_Completion_Da (type: esriFieldTypeString, alias: P6 Expected Final Completion Date, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Field46 (type: esriFieldTypeString, alias: Field46, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Field47 (type: esriFieldTypeString, alias: Field47, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Field48 (type: esriFieldTypeString, alias: Field48, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Field49 (type: esriFieldTypeString, alias: Field49, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• GIS_Construction_Start (type: esriFieldTypeString, alias: GIS Construction Start, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• GIS_Remaining_Cost (type: esriFieldTypeString, alias: GIS Remaining Cost, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Field52 (type: esriFieldTypeString, alias: Field52, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Job_Description___short (type: esriFieldTypeString, alias: Job Description - short, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PSC_Milestone_Work_Type_Code (type: esriFieldTypeInteger, alias: PSC Milestone Work Type Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PSC_Milestone_Work_Type (type: esriFieldTypeString, alias: PSC Milestone Work Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Balanced_Letting_Contract_Type (type: esriFieldTypeString, alias: Balanced Letting Contract Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Balanced_Letting_Major_Work_Typ (type: esriFieldTypeString, alias: Balanced Letting Major Work Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Balanced_Letting_Work_Type_Cate (type: esriFieldTypeString, alias: Balanced Letting Work Type Category, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Balanced_Letting_Work_Type_Subc (type: esriFieldTypeString, alias: Balanced Letting Work Type Subcategory, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LD_Status (type: esriFieldTypeString, alias: LD Status, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Package_ID (type: esriFieldTypeString, alias: Package ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Package_Title (type: esriFieldTypeString, alias: Package Title, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Field63 (type: esriFieldTypeString, alias: Field63, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• JobNumberText (type: esriFieldTypeString, alias: JobNumberText, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: IMPS
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• To ACTIVE (0) -- Related To: ACTIVE (1)
• To SMART (1) -- Related To: SMART (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/14/2023 9:16:40 AM

Schema Last Edit Date: 2/14/2023 9:16:40 AM

Data Last Edit Date: 9/25/2022 6:11:32 AM

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