| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The last date any part of this record was updated in the source. Source field: SPREMRG_ACTIVITY_DATE |
| Emrg_Addr_Type Indexed - yes
Format - Varchar2(2)
May be Null? Y | Address type of the emergency address. Mall be null. Source field: SPREMRG_ATYP_CODE |
| Emrg_City Indexed - no
Format - Varchar2(50)
May be Null? Y | The name of the city of the address. Source field: SPREMRG_CITY |
| Emrg_Country Indexed - no
Format - Varchar2(5)
May be Null? Y | The code for the country of the address. Source field: SPREMRG_NATN_CODE |
| Emrg_Country_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the Country Code. Source field: STVNATN_NATION |
| Emrg_Email_Address Indexed - no
Format - Varchar2(100)
May be Null? Y | Email address for emergency contact record as supplied by supplemental data entered in Banner. |
| Emrg_First_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | First name of the person whose address is in this record. Source field: SPREMRG_FIRST_NAME |
| Emrg_House_Num Indexed - no
Format - Varchar2(10)
May be Null? Y | HOUSE NUMBER: Building or lot number on a street or in an area. Source field: SPREMRG_HOUSE_NUMBER |
| Emrg_Last_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | Last name of the person whose address is in this record. Source field: SPREMRG_LAST_NAME |
| Emrg_Mi Indexed - no
Format - Varchar2(60)
May be Null? Y | Middle initial or middle name of the person whose address is in this record. ource field: SPREMRG_MI |
| Emrg_Missing_Pers_Contact Indexed - no
Format - Varchar2(5)
May be Null? Y | Yes/No indicator if emergency contact is considered a missing person contact as supplied by supplemental data entered in Banner. |
| Emrg_Phone_Area Indexed - no
Format - Varchar2(6)
May be Null? Y | Area code of phone number associated with emergency address. Suorce field: SPREMRG_PHONE_AREA |
| Emrg_Phone_Ext Indexed - no
Format - Varchar2(10)
May be Null? Y | Extension of phone number associated with emergency address. Source field: SPREMRG_PHONE_EXT |
| Emrg_Phone_Num Indexed - no
Format - Varchar2(12)
May be Null? Y | Phone number associated with emergency address. Source field: SPREMRG_PHONE_NUMBER |
| Emgr_Phone_Type Indexed - no
Format - Varchar2(4)
May be Null? Y | Phone type for emergency contact record as supplied by supplemental data entered in Banner. |
| Emrg_Postal_Code Indexed - no
Format - Varchar2(30)
May be Null? Y | The US zip code or foreign postal code of the address. Source field: SPREMRG_ZIP |
| Emrg_Relation Indexed - no
Format - Varchar2(1)
May be Null? Y | This field identifies the relationship between emergency contact person and the person record. Source field: SPREMRG_RELT_CODE. Source validation table: STVRELT. Warehouse validation table: V_RELATION |
| Emrg_Relation_Desc Indexed - no
Format - Varchar2(60)
May be Null? Y | Text description of the Emergency Contact relationship. Source field: STVRELT_DESC |
| Emrg_State Indexed - no
Format - Varchar2(3)
May be Null? Y | The code for the US State or territory, or Canadian province, of the address. Source field: SPREMRG_STAT_CODE |
| Emrg_Street_1 Indexed - no
Format - Varchar2(75)
May be Null? Y | The first line of the street portion of the address. Source field: SPREMRG_STREET_LINE1 |
| Emrg_Street_2 Indexed - no
Format - Varchar2(75)
May be Null? Y | The second line of the street portion of the address. Source field: SPREMRG_STREET_LINE2 |
| Emrg_Street_3 Indexed - no
Format - Varchar2(75)
May be Null? Y | The third line of the street portion of the address. Source field: SPREMRG_STREET_LINE3 |
| Emrg_Street_4 Indexed - no
Format - Varchar2(75)
May be Null? Y | The fourth line of the street portion of the address. Source field: SPREMRG_STREET_LINE4 |
| Penn_Id Indexed - yes
Format - Varchar2(9)
May be Null? Y | Penn's identity management system identification number. Source field: SPRIDEN_ID |
| Pidm Indexed - yes
Format - Number
May be Null? Y | Banner internal identification number. Source field: SPREMRG_PIDM |
| Priority Indexed - no
Format - Varchar2(1)
May be Null? Y | Source internal sequence number, part of primary key. Source field: SPREMRG_PRIORITY |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The last date this warehouse table was refreshed. |
| St_Emergency_Address_Pk Indexed - yes
Format - Varchar2(9)
May be Null? N | internal warehouse primary key: based on PIDM and PRIORITY |
