| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The latest date this record was updated in the source. Source field: SORPCOL_ACTIVITY_DATE. |
| Data_Origin Indexed - no
Format - Varchar2(30)
May be Null? Y | Source system that created or updated the row. Source field: SORPCOL_DATA_ORIGIN |
| Institution_Code Indexed - yes
Format - Varchar2(6)
May be Null? Y | The code for an institution that the student previously attended. Source field: SORPCOL_SBGI_CODE. Source validation table: STVSBGI. Data warehouse validation table: V_INSTITUTION. |
| Institution_Name Indexed - no
Format - Varchar2(30)
May be Null? Y | The name of the institution, from the source validation table STVSBGI. |
| Institution_Type Indexed - no
Format - Varchar2(1)
May be Null? Y | Code that identifies the source/background institution type (e.g. H = high school), C = college) Source field: STVSBGI_TYPE_IND |
| Penn_Id Indexed - yes
Format - Varchar2(9)
May be Null? Y | The Penn_ID of the student. Source field: SPRIDEN_ID. |
| Pidm Indexed - yes
Format - Number
May be Null? Y | Banner internal identification number. Source: SORPCOL_PIDM. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The latest date this record was refreshed in the warehouse. |
| St_Prev_Inst_Pk Indexed - yes
Format - Varchar2(46)
May be Null? N | warehouse primary key, based on PIDM, and SBGI code |
