Name: MdotDemandCalendar_v70r0

Display Field: CanonicalContractID

Type: Table

Description:

Copyright Text:

Max Record Count: 32000

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)
• CanonicalContractID (type: esriFieldTypeString, alias: Canonical Contract ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CanonicalDataSource (type: esriFieldTypeString, alias: Canonical Data Source, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• JobNumbers_Attr_value (type: esriFieldTypeString, alias: Job Numbers, SQL Type: sqlTypeOther, length: 1000, 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: 250, 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)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• IntegerYear (type: esriFieldTypeInteger, alias: Integer Year, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: MdotDemandCalendar_v70r0
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• MdotJobsWithSources_v70r0 (4) -- Related To: MdotJobsWithSources_v70r0 (5)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/9/2024 6:33:02 PM

Schema Last Edit Date: 5/9/2024 6:33:02 PM

Data Last Edit Date: 5/9/2024 6:33:02 PM

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