| Data element |
Definition |
| Cl_Course_Fnd_Apr Indexed - no
Format - Varchar2(800)
May be Null? Y | The code for the Foundational Approach 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 Foundational Approach 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. |
| Fnd_Apr_Code Indexed - no
Format - Varchar2(800)
May be Null? Y | The code for the Foundational Approach. See CM_FOUNDATIONAPPROACH for valid values. |
| Fnd_Apr_Curr_Prop_Id Indexed - yes
Format - Number
May be Null? N | Primary key to the warehouse table. System-generated; does not come from the source system. |
| Fnd_Apr_Name Indexed - no
Format - Varchar2(800)
May be Null? Y | Decoded name associated with the Foundational Approach code. See CM_FOUNDATIONAPPROACCH table for full list. |
| 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. |
| Path_Id_Number Indexed - no
Format - Varchar2(800)
May be Null? Y | Internal CourseLeaf identifying number, for locating the record in the source system.
|
| Proposal_Id Indexed - no
Format - Number
May be Null? Y | Internal Data Warehouse identification number for the proposal. Used to join this table to other tables in the Curriculum Management data collection.
|
| Subject Indexed - no
Format - Varchar2(800)
May be Null? Y | Code for the subject area of the course to which this Foundational Approach 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" |
