CSV Excel

   Description: No description available

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

CSV Excel

   Description: No description available

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

CSV Excel

   Description: This is a test. This dataset is compiled by combining multiple datasets. Owner: TRAK

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

CSV Excel

   Description: No description available

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