Name: TAMP Monthly Analysis

Display Field: WI_BASE_YEAR

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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:

• WI_BASE_YEAR (type: esriFieldTypeString, alias: Base Year, SQL Type: sqlTypeOther, length: 4, nullable: false, editable: true)
• DIST_NO (type: esriFieldTypeDouble, alias: Maint. Dist., SQL Type: sqlTypeOther, nullable: true, editable: true)
• COUNTY_NO (type: esriFieldTypeDouble, alias: County Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
• JOB_PIECE (type: esriFieldTypeString, alias: Job Piece, SQL Type: sqlTypeOther, length: 7, nullable: false, editable: true)
• JP_WORK_CODE_DESC (type: esriFieldTypeString, alias: Work Code, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• WI_LET_DATE_YEAR (type: esriFieldTypeString, alias: Work Plan Let Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• WI_LET_DATE_MONTH (type: esriFieldTypeString, alias: Work Plan Let Month, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• WI_WORKPLAN_YORN (type: esriFieldTypeString, alias: Work Plan Project, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• WI_FISCAL_YEAR (type: esriFieldTypeString, alias: Work Plan FY, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• JP_DESC (type: esriFieldTypeString, alias: JP Description, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• TAMP_PROJ_ELIGIBLE (type: esriFieldTypeString, alias: TAMP Project Eligible, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• TAMP_PROJ_TYPE (type: esriFieldTypeString, alias: TAMP Project Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CURRENT_JP_FY (type: esriFieldTypeString, alias: Current FY, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• CURRENT_JP_LET_CODE (type: esriFieldTypeString, alias: Current Let Code, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• CURRENT_JP_LET_DATE_YEAR (type: esriFieldTypeString, alias: Current Let Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• CURRENT_JP_LET_DATE_MONTH (type: esriFieldTypeString, alias: Current Let Month, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• CURRENT_JP_LET_DATE (type: esriFieldTypeDate, alias: Current Let Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CURRENT_JP_AWARD_DATE (type: esriFieldTypeDate, alias: Current Award Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LET_DATE_MONTH (type: esriFieldTypeString, alias: Let Date, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• AWARD_MONTH (type: esriFieldTypeString, alias: Award Date, SQL Type: sqlTypeOther, length: 42, nullable: true, editable: true)
• WI_TOTAL_FED_INFL (type: esriFieldTypeDouble, alias: Work Plan Fed Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WI_TOTAL_ST_INFL (type: esriFieldTypeDouble, alias: Work Plan State Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WI_TOTAL_AMT_INFL (type: esriFieldTypeDouble, alias: Work Plan Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EST_AMT_DATE (type: esriFieldTypeDate, alias: Estimated Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• JP_HIST_EST_FED_AMOUNT (type: esriFieldTypeDouble, alias: Estimated Fed Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JP_HIST_EST_STATE_AMOUNT (type: esriFieldTypeDouble, alias: Estimated State Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JP_HIST_EST_TOT_AMOUNT (type: esriFieldTypeDouble, alias: Estimated Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AUTH_AMT_DATE (type: esriFieldTypeDate, alias: Authorized Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• JP_HIST_AUTH_FED_AMOUNT (type: esriFieldTypeDouble, alias: Authorized Fed Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JP_HIST_AUTH_STATE_AMOUNT (type: esriFieldTypeDouble, alias: Authorized State Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JP_HIST_AUTH_TOT_AMOUNT (type: esriFieldTypeDouble, alias: Authorized Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AWARD_AMT_DATE (type: esriFieldTypeDate, alias: Awarded Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• JP_HIST_AWARD_FED_AMOUNT (type: esriFieldTypeDouble, alias: Awarded Fed Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JP_HIST_AWARD_STATE_AMOUNT (type: esriFieldTypeDouble, alias: Awarded State Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JP_HIST_AWARD_TOT_AMOUNT (type: esriFieldTypeDouble, alias: Awarded Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PLAN_VS_AWARD_FED_DIFF (type: esriFieldTypeDouble, alias: Planned vs Awarded Fed Difference, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PLAN_VS_AWARD_ST_DIFF (type: esriFieldTypeDouble, alias: Planned vs Awarded State Difference, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PLAN_VS_AWARD_TOT_DIFF (type: esriFieldTypeDouble, alias: Planned vs Awarded Difference, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PLAN_AMT_EXCESS_PCT (type: esriFieldTypeDouble, alias: Planned Amount % Excess, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROJ_MOVE_OUT_YEAR (type: esriFieldTypeDouble, alias: Projected Year Moved Out, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROJ_MOVE_INTO_YEAR (type: esriFieldTypeDouble, alias: Projected Year Moved In, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROJ_LET_MONTH_LATE (type: esriFieldTypeDouble, alias: Projected Month Late, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROJ_LET_MONTH_EARLY (type: esriFieldTypeDouble, alias: Projects Month Early, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CURRENT_JP_FED_AMOUNT (type: esriFieldTypeDouble, alias: Current Fed Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CURRENT_JP_ST_AMOUNT (type: esriFieldTypeDouble, alias: Current State Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CURRENT_JP_TOT_AMOUNT (type: esriFieldTypeDouble, alias: Current Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROUTEID (type: esriFieldTypeString, alias: RouteID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FROMMEASURE (type: esriFieldTypeSingle, alias: From Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOMEASURE (type: esriFieldTypeSingle, alias: To Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OBJECTID (type: esriFieldTypeOID, alias: ARC_ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• NBI (type: esriFieldTypeString, alias: NBI, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Bridge_Pave_Proj (type: esriFieldTypeString, alias: Bridge_Pave_Proj, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Proj_Year_Change (type: esriFieldTypeString, alias: Projected Year Change, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)

Templates:

Name: TAMP Monthly Analysis
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• WI_BASE_YEAR:
• JOB_PIECE:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/8/2024 7:59:30 PM

Schema Last Edit Date: 5/8/2024 7:59:30 PM

Data Last Edit Date: 5/8/2024 7:59:30 PM

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