Penn Computing

University of Pennsylvania
Penn Computing << go backback
V_CITIZENSHIP_TYPE column definitions . Tables and Data Elements . Pennant Student Records Home . Data Warehouse Home

V_CITIZENSHIP_TYPE table

(dwngss.v_citizenship_type)

Explanation

This is a validation table, containing the values and descriptions for a high-level classification of the "type" of citizenship on file for the student. Valid values are NO - Non US Citizen, PR - Permanent Resident, US -US Citizen, DC - US/Dual Citizen.

Source

The warehouse V_CITIZENSHIP_TYPE 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_STVCITZ.

Primary Key Indexed Data Elements Related Tables
CITIZENSHIP_TYPE_CODE

 

ST_CITZ_LANG, STUDENT

Cautions and notes

  • Citizenship type does not indicate the country of citizenship for non-US citizens. See instead the ST_CITZ_LANG table.
  • Citizenship type does not indicate the visa status of non-US citizens. See instead the STUDENT table. The Penn International Student and Scholar Services (ISSS) office maintains information about visas and residency status for students.
  • Dual citizenship is only tracked in the source system for students who are dual US and another country. If they are dual citizens in multiple non-US countries, that information is not available in the Pennant Student Records data collection.
V_CITIZENSHIP_TYPE column definitions . Tables and Data Elements . 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