Penn Computing

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

V_CITIZENSHIP_TYPE 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: STVCITZ_ACTIVITY_DATE

Citizenship_Type_Code

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

Code for the type of citizen or permanent resident. Source field: STVCITZ_CODE

Citizenship_Type_Desc

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

Text description of the category associated with the Citizenship Type Code. Source field: STVCITZ_DESC

Edi_Equiv

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

Electronic Data Interchange (EDI) code associated with the Citizenship Type Code. Source field: STVCITZ_EDI_EQUIV

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

Date of the latest refresh of this warehouse table

Us_Citizen_Ind

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

Citizen indicator. 'Y' = US Citizen. Source field: STVCITZ_CITIZEN_IND

V_CITIZENSHIP_TYPE 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