Data element |
Definition |
Acad_Prog_Type Indexed - no
Format - Varchar2(15) May be Null? Y | Defines the Type of Program for reporting purposes, used in the "Count Students As..." reports in the Data Warehouse. Source field: SORXREF_BANNER_VALUE |
Acad_Prog_Type_Desc Indexed - no
Format - Varchar2(60) May be Null? Y | Text description of the Academic Program Type. Source field: SORXREF_DESC. |
Activity_Date Indexed - no Format - Date May be Null? Y | Last date the record was entered or updated in the source. Source field: SMRPRLE_ACTIVITY_DATE. |
Campus Indexed - no
Format - Varchar2(3) May be Null? Y | Campus associated with this program. Source field: SMRPRLE_CAMP_CODE. |
Course_Level Indexed - no
Format - Varchar2(2) May be Null? Y | Level associated with courses in this program. Source field: SMRPRLE_LEVL_CODE. |
Credential_Ind Indexed - no
Format - Varchar2(8) May be Null? Y | Indicates whether the program leads to the award of a credential or not. Values are 'CRDNTIAL' (Credential-granting program) or NON_CRED (not a credential-granting program). Source field: SORXREF_EDI_QLFR. |
Curriculum_Ind Indexed - no
Format - Varchar2(1) May be Null? Y | Curriculum indicator. Source field: SMRPRLE_CURR_IND. |
Curr_Rule_Ind Indexed - no
Format - Varchar2(1) May be Null? Y | Curriculum rule indicator. Source field: SMRPRLE_CURR_RULE_IND. |
Custom_Id Indexed - no Format - Number May be Null? Y | description tbd |
Degree Indexed - no
Format - Varchar2(6) May be Null? Y | Degree associated with this program. Source field: SMRPRLE_DEGC_CODE. |
Degree_Seeking_Ind Indexed - no
Format - Varchar2(1) May be Null? Y | Indicates whether students in the program are seeking a degree. A degree is a type of credential, but not all credentials are degrees. Derived from multiple fields in SORXREF, where the program has a credential indication of "CRDNTIAL' and the program type is in 'Prof-Oth Degree','PhD-ResearchMas', or 'Traditional UG'. |
Division Indexed - no
Format - Varchar2(2) May be Null? Y | Division associated with this program. Source field: SMRPRLE_COLL_CODE. |
Locked_Ind Indexed - no
Format - Varchar2(1) May be Null? Y | Source field: SMRPRLE_LOCKED_IND. |
Long_Desc_End_Term Indexed - no
Format - Varchar2(6) May be Null? Y | The latest term the long description for the code is in effect. Source field: UP_ST_UP_S_BANNER_LONG_DESC.END_TERM |
Long_Desc_Start_Term Indexed - no
Format - Varchar2(6) May be Null? Y | The earliest term the long description for the code was in effect. Source field: UP_ST_UP_S_BANNER_LONG_DESC.START_TERM. |
Program_Code Indexed - no
Format - Varchar2(12) May be Null? Y | Code for the Program. Source field: SMRPRLE_PROGRAM. |
Program_Desc Indexed - no
Format - Varchar2(30) May be Null? Y | Descriptive text title of the Program. Source field: SMRPRLE_PROGRAM_DESC. |
Program_Desc_Long Indexed - no
Format - Varchar2(150) May be Null? Y | Custom long descriptive text of the program code. Source field: UP_ST_UP_S_BANNER_LONG_DESC. LONG_DESC |
Refresh_Date Indexed - no Format - Date May be Null? Y | Date this table in the warehouse was last refreshed. |
Student_Level Indexed - no
Format - Varchar2(2) May be Null? Y | Level associated with students in this program. Source field: SMRPRLE_LEVL_CODE_STU. |
V_Program_Pk Indexed - yes
Format - Varchar2(70) May be Null? N | internal warehouse primary key |
Web_Ind Indexed - no
Format - Varchar2(1) May be Null? Y | Source field: SMRPRLE_WEB_IND. |