| 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: GTVDICD_ACTIVITY_DATE |
| Custom_Id Indexed - no
Format - Number
May be Null? Y | |
| Legacy_School_Code Indexed - no
Format - Char(2)
May be Null? Y | Old school code from SRS. Sourced from the warehouse DWNGSS.SCHOOL table. |
| 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. |
| School_Code Indexed - no
Format - Varchar2(1)
May be Null? Y | Code for one of the 12 Penn Schools. Source field: GTVDICD_CODE. |
| School_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | text descriptive title of the school. Source field: GTVDICD_DESC. |
| School_Desc_Long Indexed - no
Format - Varchar2(150)
May be Null? Y | Custom long descriptive text of the school code. Note that school codes are stored in the Banner lookup table STVCOLL as well as GTVDICD. In STVCOLL, the school codes are 1 character in length. The STVCOLL codes are used to maintain the long descriptions in the custom table. Source field: UP_ST_UP_S_BANNER_LONG_DESC. LONG_DESC |
| V_School_Pk Indexed - yes
Format - Varchar2(60)
May be Null? N | internal warehouse primary key |
