Penn Computing

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

V_RESIDENCY 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 any part of this record was updated in the source. Source field: STVRESD_ACTIVITY_DATE

In_State_Ind

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

indicates whether residency is in or out of state. This column is not currently used at Penn. Source field: STVRESD_IN_STATE_IND

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

Date of the latest refresh of this warehouse table

Residency_Code

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

The code for state residency status, used by the School of Veterinary Medicine. Source field: STVRESD_CODE

Residency_Desc

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

Text description of the Vet residency code. Source field: STVRESD_DESC

V_RESIDENCY 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