Penn Computing

University of Pennsylvania
Penn Computing << go backback
V_US_COUNTY Table . Pennant Student Records Home . Data Warehouse Home

V_US_COUNTY Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

Data element Definition
Activity_Date

Indexed - no
Format - Date
May be Null? N

The latest date this record was updated in the source. Source field: STVCNTY_ACTIVITY_DATE

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

Date of the latest refresh of this warehouse table

Us_County_Code

Indexed - no
Format - Varchar2(5)
May be Null? N

Code for the county associated with a student's address, for US addresses. County information is sourced from Clean Address. May not contain every county in the US. Source field: STVCNTY_CODE

Us_County_Desc

Indexed - no
Format - Varchar2(30)
May be Null? Y

Text description of the county code; the description will end with the state code perceeded by a comma and space, for example: Berks, PA. Source field: STVCNTY_DESC

V_US_COUNTY Table . Pennant Student Records Home . Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania