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