| Data element |
Definition |
| Cl_Course_Sector Indexed - no
Format - Varchar2(800)
May be Null? Y | The code for the Sector being assigned to the course, in CourseLeaf format |
| Course_Id Indexed - no
Format - Varchar2(800)
May be Null? Y | The Course Identification (Subject + Course number) to which the Sector is being assigned. |
| Course_Num Indexed - no
Format - Varchar2(800)
May be Null? Y | Course number is the number which, when associated with a Subject area, identifies a specific course. |
| Last_Refresh_Date Indexed - no
Format - Date
May be Null? Y | The last date on which this record in this table was refreshed from the source. |
| Latest_Action_Date Indexed - no
Format - Date
May be Null? Y | The last recorded date of an action taken on this proposal. |
| Most_Recently_Approved_Yn Indexed - no
Format - Varchar2(4)
May be Null? Y | Flag indicating whether this record is the most recently approved version of this Sector proposal. |
| Proposal_History_Id Indexed - no
Format - Number
May be Null? N | Internal Data Warehouse identification number for the proposal. Used to join this table to History key table Curriculum Management data collection. |
| Proposal_Id Indexed - no
Format - Number
May be Null? N | Internal Data Warehouse identification number for the proposal. Used to join this table to other tables in the Curriculum Management data collection. |
| Sector_Code Indexed - no
Format - Varchar2(800)
May be Null? Y | Code for the Sector being proposed. See CM_SECTOR table for valid values. |
| Sector_History_Id Indexed - yes
Format - Number
May be Null? N | Primary key to the warehouse table. System-generated; does not come from the source system. |
| Sector_Name Indexed - no
Format - Varchar2(800)
May be Null? Y | Text name of the Sector. See also CM_SECTOR table. |
| Subject Indexed - no
Format - Varchar2(800)
May be Null? Y | Code for the subject area of the course to which this Sector is being assigned. Subject area, along with course number, identifies a course. |
| Xlist_Also_Offered_As_1 Indexed - no
Format - Varchar2(800)
May be Null? Y | For courses that are cross-listed with other courses at the same level, this is the Course_ID of the first of up to 5 courses that the course can also be offered as. |
| Xlist_Also_Offered_As_2 Indexed - no
Format - Varchar2(800)
May be Null? Y | For courses that are cross-listed with other courses at the same level, this is the Course_ID of the second of up to 5 courses that the course can also be offered as. |
| Xlist_Also_Offered_As_3 Indexed - no
Format - Varchar2(800)
May be Null? Y | For courses that are cross-listed with other courses at the same level, this is the Course_ID of the third of up to 5 courses that the course can also be offered as. |
| Xlist_Also_Offered_As_4 Indexed - no
Format - Varchar2(800)
May be Null? Y | For courses that are cross-listed with other courses at the same level, this is the Course_ID of the fourth of up to 5 courses that the course can also be offered as. |
| Xlist_Also_Offered_As_5 Indexed - no
Format - Varchar2(800)
May be Null? Y | For courses that are cross-listed with other courses at the same level, this is the Course_ID of the fifth of up to 5 courses that the course can also be offered as. |
| Xlist_Primary_Course Indexed - no
Format - Varchar2(800)
May be Null? Y | For courses that are cross-listed, this will be the Course_ID of the primary course. |
| Xlist_P_Or_S Indexed - no
Format - Varchar2(800)
May be Null? Y | For courses that are cross-listed with other courses at the same level, this indicator will be 'P' if the course on this row is considered the "Primary" course, else it will be "S" for "Secondary" |
