Penn Computing

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

V_COUNTRY 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 last date any part of this record was updated in the source. Source field: STVNATN_ACTIVITY_DATE

Country_Code

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

Code for the country (also sometimes referred to as nation) using ISO Alpha 2 standard codes. Source field: STVNATN_CODE

Country_Desc

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

Text description of the country code. Source field: STVNATN_NATION

Edi_Equiv

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

Source field: STVNATN_EDI_EQIV

Lms_Equiv

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

Source field: STVNATN_LMS_EQIV

Postal_Mask

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

Source field: STVNATN_POSTAL_MASK

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

Date of the latest refresh of this warehouse table

Scod_Code_Iso

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

Source field: STVNATN_SCOD_CODE_ISO

Sevis_Eqiv

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

Source field: STVNATN_SEVIS_EQIV

Ssa_Reporting_Eqiv

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

Source field: STVNATN_SSA_REPORTING_EQIV

Tele_Mask

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

Source field: STVNATN_TELE_MASK

V_COUNTRY 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