| Data element |
Definition |
| Allowable_Grades_Pk Indexed - yes
Format - Varchar2(9)
May be Null? N | Internal warehouse primary key. |
| Grade_Codes_Allowable Indexed - no
Format - Varchar2(4000)
May be Null? Y | A comma-separated array of grade codes allowed for the specified level and grade mode, in the specified term. Source: SHRGRDO_GRDE_CODE |
| Grade_Codes_For_Display Indexed - no
Format - Varchar2(4000)
May be Null? Y | A comma-separated array of grade codes that can be used for display. Derived from the Grade_Codes_Allowable, this column removes extraneous text strings, such as the '%_MBA%' used for someWharton Graduate grading. |
| Grade_Mode Indexed - yes
Format - Varchar2(1)
May be Null? Y | The Grade Mode associated with the grades in the array, for the specified term and level. Source: SHRGRDO_GMOD_CODE |
| Grade_Mode_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Description of the grade mode code. Source: STVGMOD_DESC |
| Level_Code Indexed - yes
Format - Varchar2(2)
May be Null? Y | The level associated with the array of grades, for the specified term and grade mode. Source: SHRGRDO_LEVL_CODE |
| Level_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Description of the level code. Source: STVLEVL |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The latest date this warehouse table was refreshed |
| Term Indexed - yes
Format - Varchar2(6)
May be Null? Y | A term-by-term representation of the term-effective in the source. |
| Term_Effective Indexed - no
Format - Varchar2(6)
May be Null? Y | The term associated with the array of grades, for the level and grade mode. |
