| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | Last date the record was entered or updated in the source. Source field: STVMAJR_ACTIVITY_DATE. |
| Cipc_Code Indexed - no
Format - Varchar2(6)
May be Null? Y | The Federal Department of Education's Classification of Instructional Programs Code (CIPC) for the major or minor. Source field: STVMAJR_CIPC_CODE. |
| Custom_Id Indexed - no
Format - Number
May be Null? Y | definition tbd |
| Finaid_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates eilgibility for aid. Source field: STVMAJR_AID_ELIGIBILITY_IND. |
| Legacy_Division_Number Indexed - no
Format - Number
May be Null? Y | The numeric code for the division, used in the previous student central database. |
| 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. |
| Major_Dept_Code Indexed - no
Format - Varchar2(6)
May be Null? Y | Code for the department that manages the major. Source field: STVMAJR_SEVIS_EQUIV. See also V_DEPARTMENT. |
| Major_Dept_Org Indexed - no
Format - Varchar2(4)
May be Null? Y | The University's Chart of Accounts Organization Code associated with the department that manages the major. |
| Major_Minor_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | Code for major, minor, or concentration that can be assigned to a student's field of study. Source field: STVMAJR_CODE. |
| Major_Minor_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text descriptive title of the major, minor, or concentration. Source field: STVMAJR_DESC. |
| Major_Minor_Desc_Long Indexed - no
Format - Varchar2(150)
May be Null? Y | Custom long descriptive text of the major, minor or concentration code. Source: UP_ST_UP_S_BANNER_LONG_DESC. LONG_DESC |
| Major_School_Code Indexed - no
Format - Varchar2(1)
May be Null? Y | The school code associated with the major. May not be populated for minors or concentrations. |
| Occupation_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Occupation-specific indicator. Source field: STVMAJR_OCCUPATION_IND. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Date this table in the warehouse was last refreshed. |
| Valid_Concen_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates whether the code is a current and valid Banner concentration code. There is no end date for codes, so "retired" codes will remain in the table, but will not have a 'Y' in this column. Source field: STVMAJR_VALID_CONCENTRATION_IND. |
| Valid_Major_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates whether the code is a current and valid Banner major code. There is no end date for codes, so "retired" codes will remain in the table, but will not have a 'Y' in this column. Source field: STVMAJR_VALID_MAJOR_IND. |
| Valid_Minor_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates whether the code is a current and valid Banner minor code. There is no end date for codes, so "retired" codes will remain in the table, but will not have a 'Y' in this column. Source field: STVMAJR_VALID_MINOR_IND. |
| V_Major_Minor_Pk Indexed - yes
Format - Varchar2(60)
May be Null? N | internal warehouse primary key |
