All Layers and Tables (IMPS)

Layers:

Tables:

IMPS (0)

Name:

Display Field:

Type:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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:

Relationships:

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

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

ACTIVE (1)

Name:

Display Field:

Type:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
Contract_Id (type: esriFieldTypeString, alias: Contract Id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Letting_Date (type: esriFieldTypeDate, alias: Letting Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Letting_Call_Order (type: esriFieldTypeInteger, alias: Letting Call Order, SQL Type: sqlTypeOther, nullable: true, editable: true)
Contract_Award_Amount (type: esriFieldTypeDouble, alias: Contract Award Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
MDOT_Award_Date (type: esriFieldTypeDate, alias: MDOT Award Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Construction_Begin_Date (type: esriFieldTypeDate, alias: Construction Begin Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Pct_Complete__Earnings_ (type: esriFieldTypeDouble, alias: Pct Complete (Earnings), SQL Type: sqlTypeOther, nullable: true, editable: true)
Date_Open_To_Traffic (type: esriFieldTypeDate, alias: Date Open To Traffic, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Orig__Specified_Compl__Date (type: esriFieldTypeDate, alias: Orig. Specified Compl. Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Current_Specified_Compl__Date (type: esriFieldTypeDate, alias: Current Specified Compl. Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
JobNumber (type: esriFieldTypeString, alias: JobNumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Relationships:

To SMART (2) -- Related To: SMART (2)
To IMPS (0) -- Related To: IMPS (0)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

SMART (2)

Name:

Display Field:

Type:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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)
Year (type: esriFieldTypeInteger, alias: Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
TSC__Location_ (type: esriFieldTypeString, alias: TSC_(Location), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Job_Type (type: esriFieldTypeString, alias: Job_Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
JN (type: esriFieldTypeInteger, alias: JN, SQL Type: sqlTypeOther, nullable: true, editable: true)
Major_Route__Report_ (type: esriFieldTypeString, alias: Major_Route_(Report), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Location__Report_ (type: esriFieldTypeString, alias: Location_(Report), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Location__Detailed_ (type: esriFieldTypeString, alias: Location_(Detailed), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Construction_Length (type: esriFieldTypeDouble, alias: Construction_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
Major_Control_Section (type: esriFieldTypeInteger, alias: Major_Control_Section, SQL Type: sqlTypeOther, nullable: true, editable: true)
Lane_Miles (type: esriFieldTypeDouble, alias: Lane_Miles, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_Lane_Miles (type: esriFieldTypeString, alias: Total_Lane_Miles, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Work_Description__Detailed_ (type: esriFieldTypeString, alias: Work_Description (Detailed), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Scheduled_End_Date (type: esriFieldTypeDate, alias: Scheduled_End_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Actual_End_Date (type: esriFieldTypeDate, alias: Actual_End_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Scheduled_Let_Date (type: esriFieldTypeDate, alias: Scheduled_Let_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Actual_Let_Date (type: esriFieldTypeDate, alias: Actual_Let_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Scheduled_Plan_Completion_Date (type: esriFieldTypeDate, alias: Scheduled_Plan_Completion_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Finance_System (type: esriFieldTypeString, alias: Finance_System, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Budget_Amt__Fed_State_ (type: esriFieldTypeDouble, alias: Budget_Amt_(Fed_State), SQL Type: sqlTypeOther, nullable: true, editable: true)
Budget_Amt__Local_ (type: esriFieldTypeDouble, alias: Budget_Amt_(Local), SQL Type: sqlTypeOther, nullable: true, editable: true)
Contract_Type (type: esriFieldTypeString, alias: Contract_Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Scheduled_Open_To_Traffic (type: esriFieldTypeDate, alias: Scheduled_Open To Traffic, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Contract_ID (type: esriFieldTypeString, alias: Contract_ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Award_Amt (type: esriFieldTypeDouble, alias: Award_Amt, SQL Type: sqlTypeOther, nullable: true, editable: true)
Budget___Award (type: esriFieldTypeString, alias: Budget - Award, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Regression_Total (type: esriFieldTypeDouble, alias: Regression Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
Award_Date (type: esriFieldTypeDate, alias: Award_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PR_Number (type: esriFieldTypeInteger, alias: PR_Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
PR_Beg_MP (type: esriFieldTypeDouble, alias: PR_Beg_MP, SQL Type: sqlTypeOther, nullable: true, editable: true)
PR_End_MP (type: esriFieldTypeDouble, alias: PR_End_MP, SQL Type: sqlTypeOther, nullable: true, editable: true)
PR_Major_Indicator (type: esriFieldTypeString, alias: PR_Major_Indicator, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PR_Route (type: esriFieldTypeString, alias: PR_Route, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Lane_Miles__PR_Segment_ (type: esriFieldTypeDouble, alias: Lane_Miles_(PR_Segment), SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_PR_Length__Segment_ (type: esriFieldTypeDouble, alias: Total_PR_Length_(Segment), SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_Lane_Mile (type: esriFieldTypeDouble, alias: Total_Lane_Mile, SQL Type: sqlTypeOther, nullable: true, editable: true)
Structure_Number (type: esriFieldTypeInteger, alias: Structure_Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
Bridge_ID (type: esriFieldTypeString, alias: Bridge_ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NBI_Num (type: esriFieldTypeString, alias: NBI_Num, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Number_Of_Lanes (type: esriFieldTypeDouble, alias: Number_Of_Lanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
Major_Work_Type_Code__PR_Segmen (type: esriFieldTypeInteger, alias: Major_Work_Type_Code_(PR_Segment), SQL Type: sqlTypeOther, nullable: true, editable: true)
Major_Work_Type_Description__Sh (type: esriFieldTypeString, alias: Major_Work_Type_Description_(Short), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Revised_Grouping (type: esriFieldTypeString, alias: Revised Grouping, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Anticipated_Construction_Start_ (type: esriFieldTypeDate, alias: Anticipated Construction Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Construction_Year_s_ (type: esriFieldTypeString, alias: Construction Year(s), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Concrete__Syds_ (type: esriFieldTypeInteger, alias: Concrete_(Syds), SQL Type: sqlTypeOther, nullable: true, editable: true)
HMA__Tons_ (type: esriFieldTypeString, alias: HMA_(Tons), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Steal_Beams__Lbs_ (type: esriFieldTypeDouble, alias: Steal_Beams_(Lbs), SQL Type: sqlTypeOther, nullable: true, editable: true)
Cocrete_Beams__Lft_ (type: esriFieldTypeDouble, alias: Cocrete_Beams_(Lft), SQL Type: sqlTypeOther, nullable: true, editable: true)
Aggregate__Tons_ (type: esriFieldTypeDouble, alias: Aggregate_(Tons), SQL Type: sqlTypeOther, nullable: true, editable: true)
Aggregate__Syds_ (type: esriFieldTypeDouble, alias: Aggregate_(Syds), SQL Type: sqlTypeOther, nullable: true, editable: true)
Aggregate__Cyds_ (type: esriFieldTypeDouble, alias: Aggregate_(Cyds), SQL Type: sqlTypeOther, nullable: true, editable: true)
Subbase__syds_ (type: esriFieldTypeDouble, alias: Subbase_(syds), SQL Type: sqlTypeOther, nullable: true, editable: true)
STIP_Comment (type: esriFieldTypeString, alias: STIP Comment, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
JobNumber (type: esriFieldTypeString, alias: JobNumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Relationships:

To IMPS (1) -- Related To: IMPS (0)
To ACTIVE (2) -- Related To: ACTIVE (1)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: