| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date (7)
May be Null? Y | The latest date the Course Division Restriction information was updated in the source table SSRRDEP. |
| Course_Id Indexed - no
Format - Varchar2 (36)
May be Null? Y | Concatenation of the subject area and course number |
| Course_Num Indexed - no
Format - Varchar2 (20)
May be Null? Y | Course Number of the course section. See also Course_Id and Section _Id |
| Crn Indexed - yes
Format - Varchar2 (20)
May be Null? Y | Course Reference Number for the course section on which there is a student division restriction. Source: SSRRDEP_CRN |
| Crse_Sect_Rstr_Dept_Pk Indexed - yes
Format - Varchar2 (60)
May be Null? N | internal primary key based on TERM_CODE, CRN, REC_TYPE, COLL_IND, DEPT_CODE |
| Department_Code Indexed - yes
Format - Varchar2 (16)
May be Null? Y | Code of a indicating department restriction. |
| Department_Desc Indexed - no
Format - Varchar2 (120)
May be Null? Y | Description of the departmetn restrction code Code. Source: STVDEPT_DESC |
| Incl_Excl_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | Indicator for whether the student division codes entered should be included or excluded in restricting the course. Valid values are: I - Include, E - Exclude. Source: SSRRDEP_DEPT_IE_CDE |
| Refresh_Date Indexed - no
Format - Date (7)
May be Null? Y | The latest date this warehouse table was refreshed. |
| Section_Id Indexed - yes
Format - Varchar2 (48)
May be Null? Y | Concatenation of the subject area, course number and section number |
| Section_Num Indexed - no
Format - Varchar2 (12)
May be Null? Y | Section Number of the course section. See also Section_Id |
| Subject Indexed - no
Format - Varchar2 (16)
May be Null? Y | Subject Area of the course section. See also Course_Id and Section _Id |
| Term Indexed - yes
Format - Varchar2 (24)
May be Null? Y | Term in which the student division restriction is in effect, for the specified CRN. Source: SSRRDEP_TERM_CODE |
