Layers:

Tables:

MDOTDemandCalendar (4)


Name: MDOTDemandCalendar

Display Field: CanonicalJobNumber

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:

Type ID Field:

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• CanonicalJobNumber (type: esriFieldTypeString, alias: Canonical Job Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CanonicalDataSource (type: esriFieldTypeString, alias: Canonical Data Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• RevisedGrouping_Attr_value (type: esriFieldTypeString, alias: Revised Grouping, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Region_Attr_value (type: esriFieldTypeString, alias: Region, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• TSC_Attr_value (type: esriFieldTypeString, alias: TSC, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• MajorRoute_Attr_value (type: esriFieldTypeString, alias: Major Route, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LocationReport_Attr_value (type: esriFieldTypeString, alias: Location Report, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• WorkDescription_Attr_value (type: esriFieldTypeString, alias: Work Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• ConstructionStart_Attr_value (type: esriFieldTypeDate, alias: Construction Start, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ConstructionEnd_Attr_value (type: esriFieldTypeDate, alias: Construction End, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PercentComplete_Attr_value (type: esriFieldTypeDouble, alias: Percent Complete, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DemandType_Attr_value (type: esriFieldTypeString, alias: Demand Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PointProjects_Attr_value (type: esriFieldTypeInteger, alias: Point Projects, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LineProjects_Attr_value (type: esriFieldTypeInteger, alias: Line Projects, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalProjectLength_Attr_value (type: esriFieldTypeDouble, alias: Total Project Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OriginalSpend_Attr_value (type: esriFieldTypeDouble, alias: Original Spend, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalLaneMiles_Attr_value (type: esriFieldTypeString, alias: Lane Miles, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• StructureNumber_Attr_value (type: esriFieldTypeString, alias: Structure Number, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• BridgeId_Attr_value (type: esriFieldTypeString, alias: Bridge ID, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• NBI_Attr_value (type: esriFieldTypeString, alias: NBI, SQL Type: sqlTypeOther, length: 1999, nullable: true, editable: true)
• FinanceSystem_Attr_value (type: esriFieldTypeString, alias: Finance System, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• StartYear_Attr_value (type: esriFieldTypeInteger, alias: Project Start Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EndYear_Attr_value (type: esriFieldTypeInteger, alias: Project End Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• nmonths_Attr_value (type: esriFieldTypeInteger, alias: Number of Project Months, SQL Type: sqlTypeOther, nullable: true, editable: true)
• nyears_Attr_value (type: esriFieldTypeInteger, alias: Number of Project Years, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IsBridgeProject_Attr_value (type: esriFieldTypeInteger, alias: Is Bridge Project, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RollForwardProject_Attr_value (type: esriFieldTypeInteger, alias: Is Roll Forward Project, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JobNumber (type: esriFieldTypeString, alias: Job Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ExpandedDate (type: esriFieldTypeDate, alias: Expanded Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ExpandedAmount (type: esriFieldTypeDouble, alias: Expanded Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DataSource (type: esriFieldTypeString, alias: Data Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• DemandType (type: esriFieldTypeString, alias: Demand Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• MaterialType (type: esriFieldTypeString, alias: Material Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• VisualDemandClass (type: esriFieldTypeString, alias: Visual Demand Class, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IntegerYear (type: esriFieldTypeInteger, alias: IntegerYear, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EditComplete (type: esriFieldTypeString, alias: EditComplete, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ExpandedAmountChange (type: esriFieldTypeDouble, alias: ExpandedAmountChange, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: MDOTDemandCalendar
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/24/2023 2:40:25 PM

Schema Last Edit Date: 5/24/2023 2:40:25 PM

Data Last Edit Date: 5/24/2023 2:40:25 PM