| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The latest date the Course Major Restriction information was updated in the source table SSRRMAJ. |
| 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. Source: SSBSECT_CRSE_NUMB. 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 major (or minor) restriction. Source: SSRRMAJ_CRN |
| Crse_Sect_Rstr_Maj_Pk Indexed - yes
Format - Varchar2(32)
May be Null? N | internal primary key based on TERM_CODE, CRN, REC_TYPE, MAJOR_IND, MAJR_CODE, LFST_CODE |
| Incl_Excl_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicator for whether the student major/minor codes entered should be included or excluded in restricting the course. Valid values are: I - Include, E - Exclude. Source: SSRRMAJ_MAJR_IND |
| Maj_Min_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | Code of a student major or minor for which registration restrictions exist. The INCL_EXCL_IND field specifies whether the major/minor is to be included or excluded. Source field: SSRRMAJ_MAJR_CODE. Source validation table: STVMAJR. Data Warehouse validation table: V_MAJOR. |
| Maj_Min_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Description of the major or minor Code. Source: STVMAJR_CODE |
| Maj_Min_Type Indexed - no
Format - Varchar2(15)
May be Null? Y | Indicates whether the restriction is for a major or a minor. Source: SSRRMAJ_LFST_CODE |
| Record_Type Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicator for whether the record contains a student major/minor indicator or a student major/minor code. Valid values are: 1 - Student major/minor indicator, 2 - Student major/minor code. Source: SSRRMAJ_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. Source: SSBSECT_SEQ_NUMB. See also Section_Id |
| Subject Indexed - no
Format - Varchar2(4)
May be Null? Y | Subject Area of the course section. Source: SSBSECT_SUBJ_CODE. See also Course_Id and Section _Id |
| Term Indexed - no
Format - Varchar2(6)
May be Null? Y | Term in which the student major/minor restriction is in effect, for the specified course section. Source: SSRRMAJ_TERM_CODE |
