| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The last date any part of this record was updated in the source. Source field: STVCOLL_ACTIVITY_DATE. |
| Custom_Id Indexed - no
Format - Number
May be Null? Y | definition pending |
| Division_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Code for the academic Division. Source field: STVCOLL. |
| Division_Desc Indexed - yes
Format - Varchar2(100)
May be Null? Y | Division text description. Source field: UPENN_UP_AR_DIVISION.NGSS_DIV_DESC or STVCOLL_DESC. |
| Legacy_Division_Code Indexed - yes
Format - Char(3)
May be Null? Y | Code previously used for the academic division in the legacy system (SRS). Source field: UPENN_UP_AR_DIVISION.SRS_DIVISION. |
| 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. |
| Parent_School_Code Indexed - no
Format - Varchar2(1)
May be Null? Y | School to which the division belongs. Source field: STVCOLL_DICD_CODE. See also table V_SCHOOL. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Date of the latest refresh of this warehouse table |
| V_Division_Pk Indexed - yes
Format - Varchar2(15)
May be Null? N | internal warehouse primary key |
