Skip to contentU.S. Department of Transportation/Federal Highway Administration
 

HERS-ST Highway Economic Requirements System - State Version: User's Guide

Data Dictionary

tdControlObjects
Field Data Type Description
fnObjectID AutoNumber Unique record identification number
fwControlID Long Integer Foreign key referencing higher level table
fsClass Text, 50 Characters Class type of object
fsDescription Text, 255 Characters Object description
fsUserName Text, 50 Characters Last user to modify the object
ftLastModified Date/Time Timestamp of the last modification
foFile Memo Encoded contents of the object
tdControls
Field Data Type Description
fnControlID AutoNumber Unique record identification number
fsName Text, 50 Characters Name of the Control object
fsDescription Text, 255 Characters Object description
fsUserName Text, 50 Characters Last user to modify the object
ftLastModified Date/Time Timestamp of the last modification
tdHighwayErrors
Field Data Type Description
fwHighwayID Long Integer Foreign key referencing higher level table
fwState Integer State FIPS Code
fwCnty Integer County FIPS Code
fsSecID Text, 14 Characters HPMS highway section identifier
fwMessageID Long Integer Identification number for the error message
tdHighways
Field Data Type Description
fnHighwayID AutoNumber Unique record identification number
fsName Text, 50 Characters Name of the Highway Data object
fsDescription Text, 255 Characters Object description
fsUserName Text, 50 Characters Last user to modify the object
ftLastModified Date/Time Timestamp of the last modification
fsShapeFile Text, 255 Characters Location of the associated GIS shape file
fsLinkFields Text, 50 Characters Link information for the GIS shape file
tdHighwaySections00
Field Data Type Description
fwParentID Long Integer Foreign key referencing higher level table
ID AutoNumber Unique record identification number
Selected Yes/No Flag indicating that the record is selected
Error Yes/No Flag indicating that the record has errors
Comment Text, 100 Characters User comment
Yr Integer Year of data
State Integer State FIPS code
Metric Yes/No Reporting unit
Cnty Integer County FIPS code
SecID Text, 14 Characters Highway section identifier
Sample Yes/No Is Standard sample
Donut Yes/No Is Donut sample
SCF Text, 102 Characters State Control Field
Grouped Yes/No Is Grouped
LRSID Text, 34 Characters LRS Identifier
BegMP Single LRS Beginning milepost
EndMP Single LRS Ending milepost
RurUrb Byte Rural/Urban designation
UrbSampTech Byte Urbanized area sampling technique
UrbAreaCode Integer Urbanized area code
NonAttainCode Integer NAAQS Nonattainment area code
FC Integer Function system code
GFC Byte Generated functional system code
NHS Byte National Highway System
Unblt Byte Planned, unbuilt facility
InstRtNum Text, 7 Characters Interstate route number
RouteSign Byte Route signing
RouteSignQual Byte Route sign qualifier
SignRtNum Text, 10 Characters Signed route number
GovOwn Byte Governmental ownership
SpecSys Yes/No Special systems
FT Byte Type of facility
TrkRoute Yes/No Designated truck route
Toll Yes/No Toll road
SLen Single Section length
DonutGrpID Byte Donut area sample AADT volume group
StdGrpID Single Standard sample AADT volume group
AADT Long Integer Average Annual Daily Traffic
TLanes Integer Number of through lanes
IRI Single International Roughness Index
PSR Single Present Serviceability rating
HOV Byte High Occupancy Vehicle operations
HWSurvSysA Yes/No Highway surveillance systems
HWSurvSysB Yes/No Highway surveillance systems
HWSurvSysC Yes/No Highway surveillance systems
HWSurvSysD Yes/No Highway surveillance systems
HWSurvSysE Yes/No Highway surveillance systems
HWSurvSysF Yes/No Highway surveillance systems
HWSurvSysG Yes/No Highway surveillance systems
HWSurvSysH Yes/No Highway surveillance systems
HWSurvSysI Yes/No Highway surveillance systems
SampID Text, 14 Characters Sample identifier
DonutExpFact Double Donut area sample expansion factor
ExpFac Double Standard sample expansion factor
Surf Byte Surface pavement type
SNorD Single Structural Number of Depth
Climate Byte Climate zone
ImpYr Integer Year of last surface improvement
LaneW Single Lane width
Access Byte Access control
MedT Byte Median type
MedW Single Median width
ShldT Byte Shoulder type
RShldW Single Right shoulder width
LShldW Single Left shoulder width
PkPark Byte Peak parking
WdFeas Byte Widening feasibility
LCurvA Single Length of class A curves
LCurvB Single Length of class B curves
LCurvC Single Length of class C curves
LCurvD Single Length of class D curves
LCurvE Single Length of class E curves
LCurvF Single Length of class F curves
HorAln Byte Horizontal alignment
Terrn Byte Type of terrain
VerAln Byte Vertical alignment
LGradeA Single Length of class A grades
LGradeB Single Length of class B grades
LGradeC Single Length of class C grades
LGradeD Single Length of class D grades
LGradeE Single Length of class E grades
LGradeF Single Length of class F grades
PSD Integer Percent passing sight distance
WDS Integer Weighted Design Speed
SpdLim Integer Speed limit
PcPkSU Integer Percent peak single-unit trucks
PcAvSU Integer Percent average daily single-unit trucks
PcPkCM Integer Percent peak combination trucks
PcAvCM Integer Percent average daily combination trucks
KFac Integer K-Factor
DFac Integer Directional factor
PLanes Integer Number of peak lanes
LTurn Byte Left turning lanes available
RTurn Byte Right turning lanes available
SigType Byte Prevailing type of signalization
PctGrn Integer Typical peak percentage of green time
NSig Integer At-grade intersections with signals
NStop Integer At-grade intersections with signs
NOInts Integer At grade intersections with other/none
PkCap Long Integer Peak capacity
VSF Single Volume-to-Service flow ratio
FAADT Long Integer Future AADT
FAADTYr Integer Year of Future AADT
LCF Single Local cost factor
UDF1 Text, 50 Characters User defined field 1
UDF2 Text, 50 Characters User defined field 2
UDF3 Text, 50 Characters User defined field 3
UDF4 Text, 50 Characters User defined field 4
tdImprovements
Field Data Type Description
fnImprovementID AutoNumber Unique record identification number
fsName Text, 50 Characters Name of the Improvements Data object
fsDescription Text, 255 Characters Object description
fsUserName Text, 50 Characters Last user to modify the object
ftLastModified Date/Time Timestamp of the last modification
tdImprovementSections00
Field Data Type Description
fwParentID Long Integer Foreign key referencing higher level table
ID AutoNumber Unique record identification number
Improvements Integer Number of improvements
State Integer State FIPS code
Cnty Integer County FIPS code
SecID Text, 14 Characters Highway section identifier
SF1_Year Integer Year of improvement
SF1_IType Integer Type of improvement
SF1_Ovrd Long Integer Override flag
SF1_ImpC Long Integer Cost of improvement
SF1_LAdd Long Integer Number of Lanes Added
SF1_CapInc Long Integer Increase in capacity
SF2_Year Integer Year of improvement
SF2_IType Integer Type of improvement
SF2_Ovrd Long Integer Override flag
SF2_ImpC Long Integer Cost of improvement
SF2_LAdd Long Integer Number of Lanes Added
SF2_CapInc Long Integer Increase in capacity
SF3_Year Integer Year of improvement
SF3_IType Integer Type of improvement
SF3_Ovrd Long Integer Override flag
SF3_ImpC Long Integer Cost of improvement
SF3_LAdd Long Integer Number of Lanes Added
SF3_CapInc Long Integer Increase in capacity
SF4_Year Integer Year of improvement
SF4_IType Integer Type of improvement
SF4_Ovrd Long Integer Override flag
SF4_ImpC Long Integer Cost of improvement
SF4_LAdd Long Integer Number of Lanes Added
SF4_CapInc Long Integer Increase in capacity
SF5_Year Integer Year of improvement
SF5_IType Integer Type of improvement
SF5_Ovrd Long Integer Override flag
SF5_ImpC Long Integer Cost of improvement
SF5_LAdd Long Integer Number of Lanes Added
SF5_CapInc Long Integer Increase in capacity
SF6_Year Integer Year of improvement
SF6_IType Integer Type of improvement
SF6_Ovrd Long Integer Override flag
SF6_ImpC Long Integer Cost of improvement
SF6_LAdd Long Integer Number of Lanes Added
SF6_CapInc Long Integer Increase in capacity
SF7_Year Integer Year of improvement
SF7_IType Integer Type of improvement
SF7_Ovrd Long Integer Override flag
SF7_ImpC Long Integer Cost of improvement
SF7_LAdd Long Integer Number of Lanes Added
SF7_CapInc Long Integer Increase in capacity
SF8_Year Integer Year of improvement
SF8_IType Integer Type of improvement
SF8_Ovrd Long Integer Override flag
SF8_ImpC Long Integer Cost of improvement
SF8_LAdd Long Integer Number of Lanes Added
SF8_CapInc Long Integer Increase in capacity
SF9_Year Integer Year of improvement
SF9_IType Integer Type of improvement
SF9_Ovrd Long Integer Override flag
SF9_ImpC Long Integer Cost of improvement
SF9_LAdd Long Integer Number of Lanes Added
SF9_CapInc Long Integer Increase in capacity
SF10_Year Integer Year of improvement
SF10_IType Integer Type of improvement
SF10_Ovrd Long Integer Override flag
SF10_ImpC Long Integer Cost of improvement
SF10_LAdd Long Integer Number of Lanes Added
SF10_CapInc Long Integer Increase in capacity
tdImpStatistics
Field Data Type Description
fnStatisticsID AutoNumber Unique record identification number
fsName Text, 50 Characters Name of the Statistics object
fsDescription Text, 255 Characters Object description
fsUserName Text, 50 Characters Last user to modify the object
ftLastModified Date/Time Timestamp of the last modification
tdImpStatisticsDetails
Field Data Type Description
fnDetailID AutoNumber Unique record identification number
fwStatisticsID Long Integer Foreign key referencing higher level table
fsFundingPeriod Text, 20 Characters Funding period indicator
fsCategory Text, 12 Characters Statistical category
ImpType Text, 100 Characters Type of improvement
RuralInt Single Rural interstates
RuralOPA Single Rural other principal arterials
RuralMA Single Rural minor arterials
RuralMajCol Single Rural major collectors
RuralTotal Single Rural total
UrbanInt Single Urban interstates
UrbanOFE Single Urban other freeways and expressways
UrbanOPA Single Urban other principal arterials
UrbanMA Single Urban minor arterials
UrbanCol Single Urban collectors
UrbanTotal Single Urban total
Total Single Overall total
tdOutputs
Field Data Type Description
fnOutputID AutoNumber Unique record identification number
fsName Text, 50 Characters Name of the Output Data object
fsDescription Text, 255 Characters Object description
fsUserName Text, 50 Characters Last user to modify the object
ftLastModified Date/Time Timestamp of the last modification
foFile Memo Encoded contents of the object
tdParameterObjects
Field Data Type Description
fnObjectID AutoNumber Unique record identification number
fwParameterID Long Integer Foreign key referencing higher level table
fsClass Text, 50 Characters Class type of object
fsDescription Text, 255 Characters Object description
fsUserName Text, 50 Characters Last user to modify the object
ftLastModified Date/Time Timestamp of the last modification
foFile Memo Encoded contents of the object
tdParameters
Field Data Type Description
fnParameterID AutoNumber Unique record identification number
fsName Text, 50 Characters Name of the Parameter Data object
fsDescription Text, 255 Characters Object description
fsUserName Text, 50 Characters Last user to modify the object
ftLastModified Date/Time Timestamp of the last modification
tdReports
Field Data Type Description
fnReportID AutoNumber Unique record identification number
fwWorksetID Long Integer Foreign key referencing higher level table
fsName Text, 50 Characters Name of the Report Data object
fsDescription Text, 255 Characters Object description
fsUserName Text, 50 Characters Last user to modify the object
ftLastModified Date/Time Timestamp of the last modification
fsRefClass Text, 50 Characters Class type of object
foReport Memo Encoded contents of the object
tdRunItems
Field Data Type Description
fnItemID AutoNumber Unique record identification number
fwRunID Long Integer Foreign key referencing higher level table
fsRefClass Text, 50 Characters Class type of object
fwRefID Long Integer Object identification number
tdRuns
Field Data Type Description
fnRunID AutoNumber Unique record identification number
fwScenarioID Long Integer Foreign key referencing higher level table
fsName Text, 50 Characters Name of the Run object
fsDescription Text, 255 Characters Object description
tdScenarioItems
Field Data Type Description
fnItemID AutoNumber Unique record identification number
fwScenarioID Long Integer Foreign key referencing higher level table
fsRefClass Text, 50 Characters Class type of object
fwRefID Long Integer Object identification number
tdScenarios
Field Data Type Description
fnScenarioID AutoNumber Unique record identification number
fwWorksetID Long Integer Foreign key referencing higher level table
fsName Text, 50 Characters Name of the Scenario object
fsDescription Text, 255 Characters Object description
fsUserName Text, 50 Characters Last user to modify the object
ftLastModified Date/Time Timestamp of the last modification
tdSecConditions
Field Data Type Description
fnConditionsID AutoNumber Unique record identification number
fsName Text, 50 Characters Name of the Section Conditions object
fsDescription Text, 255 Characters Object description
fsUserName Text, 50 Characters Last user to modify the object
ftLastModified Date/Time Timestamp of the last modification
tdSecConditionsDetails
Field Data Type Description
fnDetailID AutoNumber Unique record identification number
fwConditionsID Long Integer Foreign key referencing higher level table
fwFundingPeriod Integer Funding period that the data applies too
RECNO Long Integer Funding period unique record number
FIPS Long Integer State FIPS Code
CNTY Long Integer County FIPS Code
SECID Text, 14 Characters HPMS highway section identifier
SAMPID Text, 14 Characters Sample identifier
LRSID Text, 34 Characters LRS Identifier
BEGMP Single LRS Beginning milepost
ENDMP Single LRS Ending milepost
PSR0 Single Initial PSR at beginning of funding period
VCR0 Single Unimproved volume/capacity ratio
LW0 Long Integer Unimproved lane width
SHLT0 Long Integer Unimproved shoulder type
RSHLW0 Long Integer Unimproved right shoulder width
HORA0 Long Integer Unimproved horizontal alignment
VERA0 Long Integer Unimproved vertical alignment
ITYPE Integer Improvement type
LADD Integer Lanes added
CAPINC Single Increase in capacity
TYPSEL Integer Type of selection
BCR Single Benefit / cost ratio
IMPC Single Improvement cost
ACCESS Long Integer Access control
LWID Integer Lane width
SHLT Integer Shoulder type
RSHLW Integer Right shoulder width
MEDT Integer Median type
MEDW Integer Median width
WFEAS Integer Widening feasibility
HORA Long Integer Horizontal alignment adequacy
VERA Long Integer Vertical alignment adequacy
PSR Single Pavement condition
IRI Single International Roughness Index
AADT Single Average annual daily traffic
TLAN Integer Total lanes
PLAN Integer Peak lanes, peak direction
CPLAN Integer Peak lanes, opposite direction
PCAP Single Peak capacity, peak direction
CPCAP Single Peak capacity, opposite direction
OPCAP Single Off-peak capacity
VCR Single Volume / capacity ratio
PKSPD Single Peak Speed
CPSPD Single Counter Peak Speed
OPSPD Single Off Peak Speed
ASPD Single Average Effective Speed
PKDEL Single Peak delay, peak direction
CPDEL Single Peak delay, opposite direction
OPDEL Single Off-peak delay
DEL Single Average delay
TTC4T Single Travel time cost, 4-tire vehicles
TTCTK Single Travel time costs, trucks
TTC Single Average travel time costs
VOC4T Single Operating costs, 4-tire vehicles
VOCTK Single Operating costs, trucks
VOC Single Average operating costs
TUC Single Total user costs
CRAC Single Crash costs
EMIC Single Emission costs
MNTC Single Average annual maintenance costs
SCF Text, 102 Characters State Control Field
LCF Single Local Cost Factor
UDF1 Text, 50 Characters User defined field 1
UDF2 Text, 50 Characters User defined field 2
UDF3 Text, 50 Characters User defined field 3
UDF4 Text, 50 Characters User defined field 4
tdSysConditions
Field Data Type Description
fnConditionsID AutoNumber Unique record identification number
fsName Text, 50 Characters Name of the System Conditions object
fsDescription Text, 255 Characters Object description
fsUserName Text, 50 Characters Last user to modify the object
ftLastModified Date/Time Timestamp of the last modification
tdSysConditionsDetails
Field Data Type Description
fnDetailID AutoNumber Unique record identification number
fwConditionsID Long Integer Foreign key referencing higher level table
fsFundingPeriod Text, 40 Characters Funding period indicator
fsLabel Text, 30 Characters Record label
RuralInt Single Rural interstates
RuralOPA Single Rural other principal arterials
RuralMA Single Rural minor arterials
RuralMajCol Single Rural major collectors
RuralTotal Single Rural total
UrbanInt Single Urban interstates
UrbanOFE Single Urban other freeways and expressways
UrbanOPA Single Urban other principal arterials
UrbanMA Single Urban minor arterials
UrbanCol Single Urban collectors
UrbanTotal Single Urban total
Total Single Overall total
tdWorksetItems
Field Data Type Description
fnItemID AutoNumber Unique record identification number
fwWorksetID Long Integer Foreign key referencing higher level table
fsRefClass Text, 50 Characters Class type of object
fwRefID Long Integer Object identification number
tdWorksets
Field Data Type Description
fnWorksetID AutoNumber Unique record identification number
fsName Text, 50 Characters Name of the Workset object
fsDescription Text, 255 Characters Object description
fsUserName Text, 50 Characters Last user to modify the object
ftLastModified Date/Time Timestamp of the last modification
tlCounties
Field Data Type Description
fwState Integer State FIPS code
fwCounty Integer County FIPS code
fsName Text, 50 Characters County name
tlErrorMessages
Field Data Type Description
fwMessageID Long Integer Unique message identification number
fwField Integer Applicable HPMS data field
fsCode Text, 10 Characters Message code
fsDescription Text, 255 Characters Message description
tlLayouts
Field Data Type Description
fsName Text, 50 Characters Name of the layout
fsRefClass Text, 50 Characters Applicable object class type
foLayout Memo Encoded contents of the layout
tlQueries
Field Data Type Description
fsName Text, 50 Characters Name of the query
fsQuery Text, 250 Characters SQL for the query
tsVersion
Field Data Type Description
fwVersion Single Version of the Database

Database Relational Schema

Database relational schema, page 1


Database relational schema, page 2

PDF files can be viewed with the Acrobat® Reader®
Updated: 02/14/2013