| 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: SFRSTCR_ACTIVITY_DATE for current registration, SHRTCKL_ACTIVITY_DATE for academic history. |
| Course_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | Number (stored as char) associated with the Subject, that identifies the course. Source field: SSBSECT_CRSE_NUMB for current registration, SHRTCKN_CRSE_NUMB for academic history. |
| Crse_Ref_Num Indexed - yes
Format - Varchar2(5)
May be Null? Y | The course reference number associated with the class section. Source field: SFRSTCR_CRN for current registration, SHRTCKN_CRN for academic history. |
| Enrlmnt_Level Indexed - no
Format - Varchar2(2)
May be Null? Y | The level code for which the student enrolled in this CRN. Source field: SFRSTCR_LEVL_CODE for current registration, SHRTCKL_LEVL_CODE for academic history. Source validation table: STVLEVL. Warehouse validation table: V_STDNT_LEVEL |
| Penn_Id Indexed - yes
Format - Varchar2(9)
May be Null? Y | The student's Penn_ID. Source field: SPRIDEN_ID. |
| Pidm Indexed - yes
Format - Number
May be Null? Y | Banner internal identification number of the person registered. Source field: SFRSTCR_PIDM for current registration, SHRCTCKL_PIDM for academic history. |
| Pri_Level_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates which level is the primary level. Values are Y - Yes, Primary level, and Null - not primary level. One level must have a Y. Source field: for current registrations, there can only be one level, so that is by default the primary. For academic history, the source is SHRCTKL_PRIMARY_LEVL_IND. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The latest date this warehouse table was refreshed. |
| Section_Num Indexed - no
Format - Varchar2(3)
May be Null? Y | Number (stored as char) associated with the Subject and the Course Number, that identifies the Section. Source field: SSBSECT_SEQ_NUMB. |
| St_Enrlmnt_Level_Pk Indexed - yes
Format - Varchar2(35)
May be Null? N | internal warehouse primary key based on PIDM, TERM_CODE, CRN and LEVL_CODE |
| Subject_Area Indexed - no
Format - Varchar2(4)
May be Null? Y | Subject area of the course section. Source field: SSBSECT_SUBJ_CODE for current registration, SHRTCKN_SUBJ_CODE for academic history. Source validation table: STVSUBJ. Warehouse validation table: V_SUBJECT. |
| Term Indexed - yes
Format - Varchar2(6)
May be Null? Y | This field identifies the registration term code. Source field: SFRSTCR_TERM_CODE for current registration, SFRCTCKL_TERM_CODE for academic history. |
