Penn Computing

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

ST_EMERGENCY_ADDRESS 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? 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

ST_EMERGENCY_ADDRESS 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