| Data element |
Definition |
| Approved_Academic_Program_Pk Indexed - yes
Format - Varchar2(34)
May be Null? N | Primary key for the table. Concactenation of Level, Campus, School, Division, Degree, Program, Major_Minor, Concentration. |
| Campus_Code Indexed - no
Format - Varchar2(3)
May be Null? Y | Code for the student Campus to which the curriculum rule applies |
| Concentration_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | Code for the student Concentration to which the curriculum rule applies |
| Conc_Rules_Term_Eff Indexed - no
Format - Varchar2(6)
May be Null? Y | The most recent term to which the Concentration rule applies |
| Curriculum_Rules_Init_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The most recent term to which the Curriculum rule applies |
| Degree_Code Indexed - no
Format - Varchar2(6)
May be Null? Y | Code for the student Degree to which the curriculum rule applies |
| Division_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Code for the student Division to which the curriculum rule applies |
| Student_Level_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Code for the student Level to which the curriculum rule applies |
| Major_Indicator Indexed - no
Format - Varchar2(1)
May be Null? Y | Y or Null. Indicates if Major_Minor_Code can be used as a Major for the curriculum defined by APPROVED_ACADEMIC_PROGRAM_PK |
| Major_Minor_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | Code for the student Major or Minor to which the curriculum rule applies |
| Major_Rules_Term_Eff Indexed - no
Format - Varchar2(6)
May be Null? Y | The most recent term to which the Major rule applies |
| Minor_Indicator Indexed - no
Format - Varchar2(1)
May be Null? Y | Y or Null. Indicates if Major_Minor_Code can be used as a Minor for the curriculum defined by APPROVED_ACADEMIC_PROGRAM_PK |
| Minor_Rules_Term_Eff Indexed - no
Format - Varchar2(6)
May be Null? Y | The most recent term to which the Minor rule applies |
| Program_Code Indexed - no
Format - Varchar2(12)
May be Null? Y | Code for the student Program to which the curriculum rule applies |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The date of the latest refresh of this warehouse table |
| School_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Code for the student School to which the curriculum rule applies |
