| Data element |
Definition |
| Acad_Award_Cat_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Degree Award Category code. Source field: STVDEGC_ACAT_CODE. See also table V_ACAD_AWARD_CAT |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | Last date the record was entered or updated in the source. Source field: STVDEGC_ACTIVITY_DATE. |
| Current_Desc_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | |
| Custom_Id Indexed - no
Format - Number
May be Null? Y | |
| Degree_Code Indexed - no
Format - Varchar2(6)
May be Null? Y | Code for degree that can be granted by the University to a student who completes the prescribed course of study. Source field: STVDEGC_CODE. |
| Degree_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the degree associated with the Degree Code. Source field: STVDEGC_DESC. |
| Degree_Desc_Long Indexed - no
Format - Varchar2(150)
May be Null? Y | Custom long descriptive text of the degree code. Source: UP_ST_UP_S_BANNER_LONG_DESC. LONG_DESC |
| Degree_Level Indexed - no
Format - Varchar2(2)
May be Null? Y | Degree Level associated with the degree code. Source field: STVDEGC_DLEV_CODE. See also table V_DEGREE_LEVEL |
| Display_Web_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates whether the degree should display on web interface. 'Y' = yes, display. Source field: STVDEGC_DISP_WEB_IND. |
| Finaid_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates whether the degree counts in financial aid calcs. 'Y' = count in financial aid. Source field: STVDEGC_FA_COUNT_IND. |
| Ipeds_Award_Level Indexed - no
Format - Varchar2(2)
May be Null? Y | Code for the degree award level used in IPEDS reporting. Source field: STVDEGC_VR_MGS_NO. |
| 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. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Date this table in the warehouse was last refreshed. |
| V_Degree_Pk Indexed - yes
Format - Varchar2(60)
May be Null? N | internal warehouse primary key |
