Data element |
Definition |
Activity_Date Indexed - no Format - Date May be Null? Y | The latest date the Course Level Restriction information was updated in the source table SSRRLVL. |
Course_Id Indexed - no
Format - Varchar2(9) May be Null? Y | Concatenation of the subject area and course number |
Course_Num Indexed - no
Format - Varchar2(5) May be Null? Y | Course Number of the course section. See also Course_Id and Section _Id |
Crn Indexed - no
Format - Varchar2(5) May be Null? Y | Course Reference Number for the course section in which there is a student level restriction. Source: SSRRLVL_CRN |
Crse_Sect_Rstr_Levl_Pk Indexed - yes
Format - Varchar2(15) May be Null? N | internal primary key based on TERM_CODE, CRN, REC_TYPE, LEVL_IND, LEVL_CODE |
Incl_Excl_Ind Indexed - no
Format - Varchar2(1) May be Null? Y | Indicator for whether the student level codes entered should be included or excluded in restricting the course. Valid values are: I - Include, E - Exclude. Source: SSRRLVL_LEVL_IND |
Level_Code Indexed - no
Format - Varchar2(2) May be Null? Y | Code of a student level for which registration restrictions exist. The INCL_EXCL_IND field specifies whether the level is to be included or excluded. Source field: SSRRLVL_LEVL_CODE. Source validation table: STVLEVL. Data Warehouse validation table: V_STDNT_LEVEL. |
Level_Desc Indexed - no
Format - Varchar2(30) May be Null? Y | Description of the Level Code. Source: STVLEVL_CODE |
Record_Type Indexed - no
Format - Varchar2(1) May be Null? Y | Indicator for whether the record contains a student level indicator or a student level code. Valid values are: 1 - Student level indicator, 2 - Student level code. Source: SSRRLVL_REC_TYPE. |
Refresh_Date Indexed - no Format - Date May be Null? Y | The latest date this warehouse table was refreshed. |
Section_Id Indexed - no
Format - Varchar2(12) May be Null? Y | Concatenation of the subject area, course number and section number |
Section_Num Indexed - no
Format - Varchar2(3) May be Null? Y | Section Number of the course section. See also Section_Id |
Subject Indexed - no
Format - Varchar2(4) May be Null? Y | Subject Area of the course section. See also Course_Id and Section _Id |
Term Indexed - no
Format - Varchar2(6) May be Null? Y | Term in which the student level restriction is in effect, for the specified course section. Source: SSRRLVL_TERM_CODE |