ohim VTRIS Documentation: TVT Database Structures - VTRIS

VTRIS Documentation: TVT Database Structures

MASTRSTN

Master Station DB contains the latest Station records received from each state.

Field	Field Name	Type	Width	Description
1	STATECODE	Character	2	FIPS State code
2	FCLASS	Character	2	Functional Classification
3	STATIONID	Character	6	Station Identification number
4	DIRECTION	Character	1	Direction of Travel
5	LANE	Character	1	Lane of Travel
6	POSTRTCAT	Character	1	Posted Route Category code
7	POSTRTNUM	Character	6	Posted Route Number
8	CONCRTCAT	Character	1	Concurrent Route Category code
9	CONCRTNUM	Character	6	Concurrent Route Number
10	COUNTYCODE	Character	3	County code
11	HPMSSAMPLE	Character	12	HPMS Sample Number
12	HPMSSUBNR	Character	1	HPMS Subdivision Number
13	YEARESTABL	Character	4	Year Station Established
14	YEARDISC	Character	4	Year Station Discontinued
15	SITETYPE	Character	1	Type of Site code
16	METHRETRV	Character	1	Data Retrieval Method
17	MFGRCODE	Character	2	ATR Equipment Manufacturer
18	STNLOCATION	Character	50	Location of Station
19	NRLANES	Character	2	Number of Lanes
20	LASTUPDATE	Date	8	Date of last Update
21	NEWFLAG	Character	1	New Flag

STNPARM

Designed to hold special default values. By adding the flags to be set for the control of processing.

Field	Field Name	Type	Width	Description
1	STATECODE	Character	2	FIPS State code
2	FCLASS	Character	2	Functional Classification
3	STATIONID	Character	6	ATR Station Identification Number
4	DIRECTION	Character	1	Direction of Travel
5	LANE	Character	1	Lane of Travel
6	DATAYEAR	Character	2	Year of the data
7	DATAMONTH	Character	2	Month of the Data
8	PROCDATE	Character	4	Date of the processing
9	MINHOURS	Numeric	2	MIN # of hours per day required for valid Calculation
10	MINDAYS	Numeric	2	MIN # of days per day required for valid Calculation
11	PRECTOL	Numeric	3	Tolerance value of hourly count preceding a count = 0
12	SUCCTOL	Numeric	3	Tolerance value of hourly count following a count = 0
13	CONSZERO	Numeric	2	# of Consecutive ZERO hourly counts which are acceptable in a 24 hour period
14	HDATAYEAR	Character	1	Flag Y/N if hourly record field is Edited
15	HDATAMON	Character	1	Flag Y/N if hourly record field is Edited
16	HDATADOM	Character	1	Flag Y/N if hourly record field is Edited
17	HDATADOW	Character	1	Flag Y/N if hourly record field is Edited
18	HHOURDATA	Character	1	Flag Y/N if hourly record field is Edited
19	HFOOTNOTE	Character	1	Flag Y/N if hourly record field is Edited
20	SPRTCAT	Character	1	Flag Y/N if hourly record field is Edited
21	SPRTNUM	Character	1	Flag Y/N if hourly record field is Edited
22	SCRTCAT	Character	1	Flag Y/N if hourly record field is Edited
23	SCRTNUM	Character	1	Flag Y/N if hourly record field is Edited
24	SCOUNTYCD	Character	1	Flag Y/N if hourly record field is Edited
25	SHMMSSAMP	Character	1	Flag Y/N if hourly record field is Edited
26	SHPMSSUB	Character	1	Flag Y/N if hourly record field is Edited
27	SYEARREST	Character	1	Flag Y/N if hourly record field is Edited
28	SYEARDIS	Character	1	Flag Y/N if hourly record field is Edited
29	SSITETYPE	Character	1	Flag Y/N if hourly record field is Edited
30	SMETHRET	Character	1	Flag Y/N if hourly record field is Edited
31	SMFGCODE	Character	1	Flag Y/N if hourly record field is Edited
32	SSTNLOC	Character	1	Flag Y/N if hourly record field is Edited

VMT

Vehicle Miles Travel DB contains values calculated from the Monthly files containing evaluated data

Field	Field Name	Type	Width	Description
1	VMTYEAR	Character	2	Year of data for VMT Calculations
2	VMTMONTH	Character	2	Month of data for VMT Calculations
3	STATECODE	Character	2	FIPS State code
4	FCLASS	Character	2	Functional Classification
5	FCMULT	Numeric	5.3	Functional Classification Multiplier (% change in VMT)
6	VMT	Numeric	8	Vehicle Miles Traveled (in thousands of miles)
7	ESTFLAG	Character	1	Flag of Estimation

STATE

State contains the FIPS State code, Postal abbreviation and full state name for each state.

Field	Field Name	Type	Width	Description
1	STATECODE	Character	2	FIPS State code
2	ABBREV	Character	2	Postal Abbreviation for state
3	CENSUS	Character	2	Census code for state
4	NAME	Character	30	State name

Census field was added for user convenience.

STSSYYMM

Station DB to receive the Monthly State Station input data SS - State code, YY - Year, MM - Month

Field	Field Name	Type	Width	Description
1	RECID	Character	1	Identifies type of file upon Input
2	STATECODE	Character	2	FIPS State code
3	FCLASS	Character	2	Functional Classification
4	STATIONID	Character	6	Station Identification number
5	DIRECTION	Character	1	Direction of Travel
6	LANE	Character	1	Lane of Travel
7	POSTRTCAT	Character	1	Posted Route Category code
8	POSTRTNUM	Character	6	Posted Route Number
9	CONCRTCAT	Character	1	Concurrent Route Category code
10	CONCRTNUM	Character	6	Concurrent Route Number
11	COUNTYCODE	Character	3	County code
12	HPMSSAMPLE	Character	12	HPMS Sample Number
13	HPMSSUBNR	Character	1	HPMS Subdivision Number
14	YEARESTABL	Character	4	Year Station Established
15	YEARDISC	Character	4	Year Station Discontinued
16	SITETYPE	Character	1	Type of Site code
17	METHRETRV	Character	1	Data Retrieval Method
18	MFGRCODE	Character	2	ATR Equipment Manufacturer
19	STNLOCATION	Character	50	Location of Station
20	NRLANES	Character	2	Number of Lanes

MOSSYYMM

SS - State code, YY Year, MM - Month. The data and calculated values are processed from the SSYYMM DB into Monthly MOSSYYMM DB

Field	Field Name	Type	Width	Description
1	STATECODE	Character	2	FIPS State code
2	FCLASS	Character	2	Functional Classification
3	STATIONID	Character	6	ATR Station Identification Number
4	DIRECTION	Character	1	Direction of Travel
5	LANE	Character	1	Lane of Travel
6	DATAYEAR	Character	2	Year of the data
7	DATAMONTH	Character	2	Month of the Data
8	TVCALCS	Character	217	Traffic Volume Calculated
9	AVGDAY	Numeric	7	Average day of the month
10	AVGSUN	Numeric	7	Average Sunday
11	AVGMON	Numeric	7	Average Monday
12	AVGTUE	Numeric	7	Average Tuesday
13	AVGWED	Numeric	7	Average Wednesday
14	AVGTHU	Numeric	7	Average Thursday
15	AVGFRI	Numeric	7	Average Friday
16	AVGSAT	Numeric	7	Average Saturday
17	JAVDAY	Numeric	7	Adjusted average day
18	JAVWDAY	Numeric	7	Adjusted average weekday
19	WAVGDAY	Numeric	7	Weighted average day
20	ESTFLAG	Character	1	Estimated data flag

Updated: 10/12/2022