Name: MdotJobsWithSources_v49

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)
• CanonicalJobSource (type: esriFieldTypeString, alias: Canonical Job Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Expand (type: esriFieldTypeString, alias: Expand Flag, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PredictFlag (type: esriFieldTypeString, alias: Predict Flag, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CalendarRows (type: esriFieldTypeInteger, alias: Number of Calendar Rows, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RevisedGrouping_Attr_value (type: esriFieldTypeString, alias: Revised Grouping, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• RevisedGrouping_Attr_source (type: esriFieldTypeString, alias: Revised Grouping Source, 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)
• Region_Attr_source (type: esriFieldTypeString, alias: Region Source, 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)
• TSC_Attr_source (type: esriFieldTypeString, alias: TSC Source, 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)
• MajorRoute_Attr_source (type: esriFieldTypeString, alias: Major Route Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LocationReport_Attr_value (type: esriFieldTypeString, alias: Loaction Report, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• LocationReport_Attr_source (type: esriFieldTypeString, alias: Location Report Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• WorkDescription_Attr_value (type: esriFieldTypeString, alias: Work Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• WorkDescription_Attr_source (type: esriFieldTypeString, alias: Work Description Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ConstructionStart_Attr_value (type: esriFieldTypeDate, alias: Construction Start, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ConstructionStart_Attr_source (type: esriFieldTypeString, alias: Construction Start Source, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• ConstructionEnd_Attr_value (type: esriFieldTypeDate, alias: Construction End, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ConstructionEnd_Attr_source (type: esriFieldTypeString, alias: Construction End Source, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• PercentComplete_Attr_value (type: esriFieldTypeDouble, alias: Percent Complete, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PercentComplete_Attr_source (type: esriFieldTypeString, alias: Percent Complete Source, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• DemandType_Attr_value (type: esriFieldTypeString, alias: Demand Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• DemandType_Attr_source (type: esriFieldTypeString, alias: Demand Type Source, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• PointProjects_Attr_value (type: esriFieldTypeInteger, alias: Point Projects, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PointProjects_Attr_source (type: esriFieldTypeString, alias: Point Projects Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LineProjects_Attr_value (type: esriFieldTypeInteger, alias: Line Projects, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LineProjects_Attr_source (type: esriFieldTypeString, alias: Line Projects Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• TotalProjectLength_Attr_value (type: esriFieldTypeDouble, alias: Total Project Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalProjectLength_Attr_source (type: esriFieldTypeString, alias: Total Project Length Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• OriginalSpend_Attr_value (type: esriFieldTypeDouble, alias: Original Spend, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OriginalSpend_Attr_source (type: esriFieldTypeString, alias: Original Spend Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• TotalLaneMiles_Attr_value (type: esriFieldTypeString, alias: Total Lane Miles, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• TotalLaneMiles_Attr_source (type: esriFieldTypeString, alias: Total Lane Miles Source, 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)
• StructureNumber_Attr_source (type: esriFieldTypeString, alias: Structure Number Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• BridgeId_Attr_value (type: esriFieldTypeString, alias: Bridge ID, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• BridgeId_Attr_source (type: esriFieldTypeString, alias: Bridge ID Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• NBI_Attr_value (type: esriFieldTypeString, alias: NBI, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• NBI_Attr_source (type: esriFieldTypeString, alias: NBI Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• FinanceSystem_Attr_value (type: esriFieldTypeString, alias: Finance System, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• FinanceSystem_Attr_source (type: esriFieldTypeString, alias: Finance System Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Spend_Actuals_value (type: esriFieldTypeDouble, alias: Spend (Actuals), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Spend_Actuals_source (type: esriFieldTypeString, alias: Spend (Actuals) Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• HMA_Actuals_value (type: esriFieldTypeDouble, alias: HMA (Actuals), SQL Type: sqlTypeOther, nullable: true, editable: true)
• HMA_Actuals_source (type: esriFieldTypeString, alias: HMA (Actuals) Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Concrete_Actuals_value (type: esriFieldTypeDouble, alias: Concrete (Actuals), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Concrete_Actuals_source (type: esriFieldTypeString, alias: Concrete (Actuals) Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Aggregate_Actuals_value (type: esriFieldTypeDouble, alias: Aggregate (Actuals), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Aggregate_Actuals_source (type: esriFieldTypeString, alias: Aggregate (Actuals) Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Labor_Actuals_value (type: esriFieldTypeDouble, alias: Labor (Actuals), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Labor_Actuals_source (type: esriFieldTypeString, alias: Labor (Actuals) Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Spend_Estimates_value (type: esriFieldTypeDouble, alias: Spend (Estimates), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Spend_Estimates_source (type: esriFieldTypeString, alias: Spend (Estimates) Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• HMA_Estimates_value (type: esriFieldTypeDouble, alias: HMA (Estimates), SQL Type: sqlTypeOther, nullable: true, editable: true)
• HMA_Estimates_source (type: esriFieldTypeString, alias: HMA (Estimates) Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Concrete_Estimates_value (type: esriFieldTypeDouble, alias: Concrete (Estimates), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Concrete_Estimates_source (type: esriFieldTypeString, alias: Concrete (Estimates) Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Aggregate_Estimates_value (type: esriFieldTypeDouble, alias: Aggregate (Estimates), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Aggregate_Estimates_source (type: esriFieldTypeString, alias: Aggregate (Estimates) Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Labor_Estimates_value (type: esriFieldTypeDouble, alias: Labor (Estimates), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Labor_Estimates_source (type: esriFieldTypeString, alias: Labor (Estimates) Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• HMA_Factors_value (type: esriFieldTypeDouble, alias: HMA Prediction Factors, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HMA_Factors_source (type: esriFieldTypeString, alias: HMA Factors (Source), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Concrete_Factors_value (type: esriFieldTypeDouble, alias: Concrete Prediction Factors, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Concrete_Factors_source (type: esriFieldTypeString, alias: Concrete Factors (Source), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Aggregate_Factors_value (type: esriFieldTypeDouble, alias: Aggregate Prediction Factors, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Aggregate_Factors_source (type: esriFieldTypeString, alias: Aggregate Factors (Source), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Labor_Factors_value (type: esriFieldTypeDouble, alias: Labor Prediction Factors, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Labor_Factors_source (type: esriFieldTypeString, alias: Labor Factors (Source), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• HMA_Predictions_value (type: esriFieldTypeDouble, alias: HMA Prediction, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HMA_Predictions_source (type: esriFieldTypeString, alias: HMA Prediction (Source), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Concrete_Predictions_value (type: esriFieldTypeDouble, alias: Concrete Prediction, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Concrete_Predictions_source (type: esriFieldTypeString, alias: Concrete Prediction (Source), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Aggregate_Predictions_value (type: esriFieldTypeDouble, alias: Aggregate Prediction, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Aggregate_Predictions_source (type: esriFieldTypeString, alias: Aggregate Prediction (Source), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Labor_Predictions_value (type: esriFieldTypeDouble, alias: Labor Predictions, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Labor_Predictions_source (type: esriFieldTypeString, alias: Spend Predictions (Source), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Spend_Expand_value (type: esriFieldTypeDouble, alias: Spend Expand, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Spend_Expand_source (type: esriFieldTypeString, alias: Spend Expand (Source), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• HMA_Expand_value (type: esriFieldTypeDouble, alias: HMA Expand, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HMA_Expand_source (type: esriFieldTypeString, alias: HMA Expand (Source), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Concrete_Expand_value (type: esriFieldTypeDouble, alias: Concrete Expand, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Concrete_Expand_source (type: esriFieldTypeString, alias: Concrete Expand (Source), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Aggregate_Expand_value (type: esriFieldTypeDouble, alias: Aggregate Expand, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Aggregate_Expand_source (type: esriFieldTypeString, alias: Aggregate Expand (Source), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Labor_Expand_value (type: esriFieldTypeDouble, alias: Labor Expand, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Labor_Expand_source (type: esriFieldTypeString, alias: Labor Expand (Source), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)

Templates:

Name: MdotJobsWithSources_v49
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/27/2023 8:46:06 PM

Schema Last Edit Date: 3/27/2023 8:46:06 PM

Data Last Edit Date: 3/1/2023 6:48:13 PM

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