V_US_COUNTY column definitions . Pennant Student Records Home . Data Warehouse Home

V_US_COUNTY table

(dwngss.v_us_county)

Explanation

This is a validation table, containing the codes and descriptions for counties in the United Status. In the description column of this table, the first two characters of the county description is the two-character alpha code for the US State in which that county can be found.

Source

The warehouse V_US_COUNTY table is refreshed in batch mode from the Operational Data Store (ODS), which gets its data from the Banner database. The UPENN_ODS source table is SATURN_STVCNTY

Cautions and notes

V_TERM column definitions . Pennant Student Records Home . Data Warehouse Home