Field | Data Type | Description |
---|---|---|
TRAK_ORG_PROGRAM | STRING | TRAK Program is a method of classifying work into themes. These categories are sourced from projecting numbering systems throughout the Cabinet. Due to exceptions in our business procedures and user-entered data, these may not always be completely accurate. |
SYP_NO | STRING | Six Year Plan Number |
PROJECT_NM | STRING | None |
PROGRAM_CODE | STRING | None |
LETTING_DATE | DATE | None |
FUND_CODE | STRING | None |
FED_PROJECT_NUM | STRING | Federal Project Number |
DISTRICT | STRING | None |
COUNTY | STRING | None |
CONTRACT_ID | STRING | None |
CONTRACTOR | STRING | None |
CALCULATED_AWARDED_AMOUNT | FLOAT | None |
AWARD_AMOUNT | FLOAT | None |
Field | Data Type | Description |
---|---|---|
TYPE_WORK | STRING | None |
SYP_NO | STRING | None |
RSY_YEAR | INTEGER | None |
RSY_FUND | FLOAT | None |
ROUTE_PREFIX | STRING | None |
ROUTE_NO | STRING | None |
ROUTE | STRING | None |
NUMBER_OF_LETTINGS | INTEGER | None |
LATEST_LETTING_DATE | DATE | None |
FUND_CODE | STRING | None |
ENACT_YEAR | INTEGER | None |
ENACT_PHASE | STRING | None |
ENACT_INITIAL_YEAR | INTEGER | None |
EMP | FLOAT | None |
DISTRICT | STRING | None |
DESCRIPTION | STRING | None |
COUNTY | STRING | None |
BRIDGE_ID | STRING | None |
BMP | FLOAT | None |
AWARDED | STRING | None |
Field | Data Type | Description |
---|---|---|
TRAK_ORG_PROGRAM | STRING | TRAK Program is a method of classifying work into themes. These categories are sourced from projecting numbering systems throughout the Cabinet. Due to exceptions in our business procedures and user-entered data, these may not always be completely accurate. |
TRAK_GEO_DISTRICT | STRING | Describes a KYTC District geographic boundary that contains multiple counties. This will is used for reporting and should be formatted as "District xx" |
TRAK_GEO_COUNTY | STRING | KY County Name using proper case naming. |
QUARTER | INTEGER | None |
PROGRAM_CODE | STRING | None |
PHASE_CODE | STRING | None |
MONTH | INTEGER | None |
ITEM_NO | FLOAT | None |
FUND_CODE | STRING | None |
FISCAL_YEAR | INTEGER | None |
EXPENDED | FLOAT | None |
DIST_NO | INTEGER | None |
Field | Data Type | Description |
---|---|---|
TRAK_GEO_DISTRICT | STRING | None |
TRAK_GEO_COUNTY | STRING | None |
STATE_FISCAL_YEAR | INTEGER | None |
SCOPE_LINES | STRING | None |
RT_NUMBER | STRING | None |
ROAD_NAME | STRING | None |
REMARK_LINE | STRING | None |
PROJECT_TYPE | STRING | None |
PROGRAM_CODE | STRING | None |
PHASE_CODE | STRING | None |
MOD_LEVEL | INTEGER | None |
LENGTH | STRING | None |
ITEM_NUMBER | STRING | None |
FUND_NBR | STRING | None |
FISCAL_YEAR | INTEGER | None |
EMARS_PROGRAM_CODE | STRING | None |
CURRENT_MOD_LEVEL | INTEGER | None |
CONTRACT_ID | STRING | None |
AUTH_NBR | INTEGER | None |
AUTHORIZED | FLOAT | None |
APPROVED_DATE | DATE | None |
APPROPRIATION_CODE | STRING | None |