| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The latest date the record was updated in the source. Source field: SFRATTR_ACTIVITY_DATE for current registration, SHRATTR_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 internal course reference number associated with the class section. Source field: SFRATTR_CRN for current registration, SHRTCKN_CRN for academic history. |
| Enrlmnt_Attr Indexed - no
Format - Varchar2(4)
May be Null? Y | Attribute code of the course section in which the student is enrolled. An enrollment record can have multiple attributes. Source field: SFRATTR_ATTR_CODE for current registration, SHRATTR_ATTR_CODE for academic history. Source validation table: STVATTR. Warehouse validation table: V_CRSE_PROG_ATTR |
| Enrlmnt_Attr_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Description of the code found in Enrlmnt_Attr. Source field: STVATTR_DESC |
| Penn_Id Indexed - yes
Format - Varchar2(9)
May be Null? Y | Penn identity management system's identification number. Source field: SPRIDEN_ID. |
| Pidm Indexed - yes
Format - Number
May be Null? Y | Banner internal identification number of the person registered. Source field: SFRATTR_PIDM for current registration, SHRATTR_PIDM for adacmic history |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The latest date the 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_Attr_Pk Indexed - yes
Format - Varchar2(37)
May be Null? N | internal warehouse primary key, based on to_char(PIDM), TERM_CODE, CRN, ATTR_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 | The registration term code. Source field: SFRATTR_TERM_CODE for current registration, SHRATTR_TERM_CODE for academic history |
