Penn Computing

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

ST_CURRENT_CONTACT_FLAT_MV - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

Data element Definition
Current_Address_Type

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

Address type listed in DWNGSS_PS.ST_ADDRESS where CURRENT_INDICATOR='Y' for the student. The CURRENT_INDICATOR is calculated to determine an active local address or provide a student's permanent address.

Current_Addr_End

Indexed - no
Format - Date (7)
May be Null? Y

The end date for the address listed in DWNGSS_PS.ST_ADDRESS where CURRENT_INDICATOR='Y'.

Current_Addr_Seqno

Indexed - no
Format - Number (22)
May be Null? Y

Address sequence number for the address in DWNGSS_PS.ST_ADDRESS where CURRENT_INDICATOR='Y'.

Current_Addr_Start

Indexed - no
Format - Date (7)
May be Null? Y

The start date for the address listed in DWNGSS_PS.ST_ADDRESS where CURRENT_INDICATOR='Y'.

Current_City

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

City for the address listed in DWNGSS_PS.ST_ADDRESS where CURRENT_INDICATOR='Y'.

Current_Country

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

Country code for the address listed in DWNGSS_PS.ST_ADDRESS where CURRENT_INDICATOR='Y'.

Current_Country_Name

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

Country name for the address listed in DWNGSS_PS.ST_ADDRESS where CURRENT_INDICATOR='Y'.

Current_Postal_Code

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

Zip code for the address listed in DWNGSS_PS.ST_ADDRESS where CURRENT_INDICATOR='Y'.

Current_State

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

State for the address listed in DWNGSS_PS.ST_ADDRESS where CURRENT_INDICATOR='Y'.

Current_Street_1

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

Street line 1 for the address listed in DWNGSS_PS.ST_ADDRESS where CURRENT_INDICATOR='Y'.

Current_Street_2

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

Street line 2 for the address listed in DWNGSS_PS.ST_ADDRESS where CURRENT_INDICATOR='Y'.

Current_Street_3

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

Street line 3 for the address listed in DWNGSS_PS.ST_ADDRESS where CURRENT_INDICATOR='Y'.

Current_Street_4

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

Street line 4 for the address listed in DWNGSS_PS.ST_ADDRESS where CURRENT_INDICATOR='Y'.

Current_Us_County

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

County listed in DWNGSS_PS.ST_ADDRESS where CURRENT_INDICATOR='Y'.

Mo_Intl_Access

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

If applicable, international access code for active phone number listed as 'MO'.

Mo_Phone_Number

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

Active phone number listed as 'MO'.

Mo_Phone_Primary_Ind

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

If phone number listed as 'MO' is listed as the student primary number.

Mo_Phone_Seqnum

Indexed - no
Format - Number (22)
May be Null? Y

Sequence number for active phone number listed as 'MO' which is known as cell or mobile phone.

Mo_Unlist_Ind

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

If phone number listed as 'MO' is indicatd as being unlisted.

Mv_Refresh_Date

Indexed - no
Format - Date (7)
May be Null? Y

Date and time that ST_CURRENT_CONTACT_FLAT_MV was refreshed.

Penn_Email

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

Calculated field to get the penn email to return. The email type may be listed as PEN, DIR, BUS, etc.

Penn_Id

Indexed - yes
Format - Varchar2 (36)
May be Null? Y

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

Pidm

Indexed - yes
Format - Number (22)
May be Null? Y

Banner internal Identification Number of Person. Source field: SPRIDEN_PIDM

Preferred_Email_Addr

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

The email address listed in DWNGSS_PS.ST_EMAIL where the PREFERRED_INDICATOR='Y'. This indicates the calculated preferred email for the student.

Preferred_Email_Type

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

The email type listed in DWNGSS_PS.ST_EMAIL where the PREFERRED_INDICATOR='Y'. This indicates the calculated preferred email for the student.

Pr_Address_Type

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

Address type listed in DWNGSS_PS.ST_ADDRESS where ADDRESS_TYPE='PR' for the student. The 'PR' address is the permanent address listed.

Pr_Addr_End

Indexed - no
Format - Date (7)
May be Null? Y

The end date for the address listed in DWNGSS_PS.ST_ADDRESS where ADDRESS_TYPE='PR'.

Pr_Addr_Seqno

Indexed - no
Format - Number (22)
May be Null? Y

Address sequence number for the address in DWNGSS_PS.ST_ADDRESS where ADDRESS_TYPE='PR'.

Pr_Addr_Start

Indexed - no
Format - Date (7)
May be Null? Y

The start date for the address listed in DWNGSS_PS.ST_ADDRESS where ADDRESS_TYPE='PR'.

Pr_City

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

City for the address listed in DWNGSS_PS.ST_ADDRESS where ADDRESS_TYPE='PR'.

Pr_Country

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

Country code for the address listed in DWNGSS_PS.ST_ADDRESS where ADDRESS_TYPE='PR'.

Pr_Country_Name

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

Country name for the address listed in DWNGSS_PS.ST_ADDRESS where ADDRESS_TYPE='PR'.

Pr_Intl_Access

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

If applicable, international access code for active phone number listed as 'PR'.

Pr_Phone_Number

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

Active phone number listed as 'PR'.

Pr_Phone_Primary_Ind

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

If phone number listed as 'PR' is listed as the student primary number.

Pr_Phone_Seqnum

Indexed - no
Format - Number (22)
May be Null? Y

Sequence number for active phone number listed as 'PR' which is listed as the permanent phone.

Pr_Postal_Code

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

Zip code for the address listed in DWNGSS_PS.ST_ADDRESS where ADDRESS_TYPE='PR'.

Pr_State

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

State for the address listed in DWNGSS_PS.ST_ADDRESS where ADDRESS_TYPE='PR'.

Pr_Street_1

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

Street line 1 for the address listed in DWNGSS_PS.ST_ADDRESS where ADDRESS_TYPE='PR'.

Pr_Street_2

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

Street line 2 for the address listed in DWNGSS_PS.ST_ADDRESS where ADDRESS_TYPE='PR'.

Pr_Street_3

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

Street line 3 for the address listed in DWNGSS_PS.ST_ADDRESS where ADDRESS_TYPE='PR'.

Pr_Street_4

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

Street line 4 for the address listed in DWNGSS_PS.ST_ADDRESS where ADDRESS_TYPE='PR'.

Pr_Unlist_Ind

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

If phone number listed as 'PR' is indicatd as being unlisted.

Pr_Us_County

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

County listed in DWNGSS_PS.ST_ADDRESS where ADDRESS_TYPE='PR'.

ST_CURRENT_CONTACT_FLAT_MV . 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