| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | Last date the record was created or updated in the source. Source field: SPRTELE_ACTIVITY_DATE. |
| Penn_ID Indexed - no
Format - Varchar2(9)
May be Null? Y | Penn's identity management system identification number. Source field: SPRIDEN_ID. |
| Phone_Area Indexed - no
Format - Varchar2(6)
May be Null? Y | Area code for US phone numbers. Source field: SPRTELE_PHONE_AREA. |
| Phone_Comment Indexed - no
Format - Varchar2(60)
May be Null? Y | Comment related to the phone number, usually used to further define the phone type. Source field: SPRTELE_COMMENT |
| Phone_Extension Indexed - no
Format - Varchar2(10)
May be Null? Y | Extension number, for business phone numbers. Source field: SPRTELE_PHONE_EXT |
| Phone_Intl_Access Indexed - no
Format - Varchar2(16)
May be Null? Y | Free format International access code for telephone number including country and city code. Source field: SPRTELE_INTL_ACCESS. |
| Phone_Number Indexed - no
Format - Varchar2(12)
May be Null? Y | Exchange and number of the telephone number. Source field: SPRTELE_PHONE_NUMBER |
| Phone_Type Indexed - no
Format - Varchar2(4)
May be Null? Y | Code for the type of telephone number stored in each record. Students can have more than one phone number of the same type. To use the most recent phone number of a specified type, look for the max sequence number within type for the student. See also Status, Primary_Ind, and Unlist_Ind.
Source field: SPRTELE_TELE_CODE. Source validation table: STVTELE. Warehouse validation table: V_PHONE_TYPE |
| Pidm Indexed - no
Format - Number
May be Null? Y | Internal identifical number. Source field: SPRTELE_PIDM. |
| Primary_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates the primary telephone. Source field: SPRTELE_PRIMARY_IND |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The latest date this warehouse table was refreshed. |
| Seqnum Indexed - no
Format - Number
May be Null? Y | Internal sequence number in source, part of source system unique key. Source field: SPRTELE_SEQNO. |
| Status Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates an inactive status where applicable:If the telephone number record has been superceded by another record of the same type, or has been retired, this column will have the value of 'I'. Source field: SPRTELE_STATUS_IND. |
| St_Phone_Pk Indexed - yes
Format - Varchar2(29)
May be Null? N | internal warehouse primary key, based on PIDM, PHONE_TYPE and SEQNO |
| Unlist_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates the student does not want the telephone number made available in any public listing. Source field: SPRTELE_UNLIST_IND |
