| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The latest date the record was updated in Banner. Source: SCRLEVL_ACTIVITY_DATE |
| Course_Id Indexed - no
Format - Varchar2(9)
May be Null? Y | The subject area and course number stored together. Source: SCRLEVL_SUBJ_CODE, SCRLEVL_CRSE_NUMB |
| Course_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | The course number. Source: SCRLEVL_CRSE_NUMB |
| Crse_Level_Pk Indexed - yes
Format - Varchar2(17)
May be Null? N | Internal primary key for this table, based on the subject area, course number, term and level code |
| Effective_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The effective term in which the level was assigned to the course. Source: SCRLEVL_TERM_CODE |
| Level_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | The code for the level at which the course can be offered. During course section registration, the level on the student's record must match one of the levels a course is offered at. The level is also used for populating student transcripts; if a student is in multiple levels, the courses taken at a specified level will appear together on that level's transcript. Note that this "level" does not indicate undegraduate vs. graduate courses; it is used to map to student levels. See Cautions and Notes on the Course table page.
Example of course levels:
UG Undergraduate
GR Graduate/Research
PR Professional
DM Dental
MD Medical
VT Vet
LW Law
CE Continuing Education
Source: SCRLEVL_LEVL_CODE. Warehouse validation table: V_STDNT_LEVEL. |
| Level_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Description of the course level code. Source: STVLEVL_DESC |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The latest date this record was refreshed in the warehouse. |
| Subject Indexed - no
Format - Varchar2(4)
May be Null? Y | Subject area of the course. Source: SCRLEVL_SUBJ_CODE |
| Term Indexed - no
Format - Varchar2(6)
May be Null? Y | Data are stored in SCRLEVL as term-effective. In the warhouse CRSE_LEVEL table, we store the data as term-by-term, to facilitate reporting with other course and course section tables. |
