Penn Computing

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

ST_CITZ_LANG 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? Y

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

Country_Of_Citizenship

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

Code for the student's country of citizenship. Source field: GOBINTL_NATN_CODE_LEGAL. Source validation table: STVNATN. Warehouse validation table: V_COUNTRY.

Native_Language

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

Code for the student's native language. Source field: GOBINTL_LANG_CODE. Source validation table: STVLANG. Warehouse validation table: V_LANGUAGE.

Penn_ID

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

Penn's identity management system's identification number. Source field: SPRIDEN_ID

Pidm

Indexed - yes
Format - Number
May be Null? N

Banner internal indentification number. Source field: GOBINTL_PIDM.

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

The latest date the record was refreshed in the warehouse

ST_CITZ_LANG 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