| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | Last date any part of this record was updated in the source. Source field: GORADID_ACTIVITY_DATE. |
| Addl_Id Indexed - no
Format - Varchar2(50)
May be Null? Y | Additional identification value. Source field: GORADID_ADDITIONAL_ID. |
| Addl_Id_Type Indexed - no
Format - Varchar2(4)
May be Null? Y | Code identifying the type or source of the additional ID in this record. Additional IDs can come from admissions systems, or other systems at Penn that maintain student information. Students can have zero, one, or multiple additional IDs.
Source field GORADID_ADID_CODE. Source validation table: GTVADID. Warehouse validation table: V_ADDITIONAL_ID |
| Penn_ID Indexed - no
Format - Varchar2(9)
May be Null? Y | Penn's identity management system identification number. Source field: SPRIDEN_ID |
| Pidm Indexed - no
Format - Number
May be Null? Y | Internal unique person identifier. Source field: GORADID_PIDM. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Date the record was last refreshed in the warehouse |
| St_Addl_Id_Pk Indexed - yes
Format - Varchar2(76)
May be Null? N | Internal warehouse primary key: based on PIDM, Addl_ID_Type, and Addl_ID |
