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