| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The latest date this record was updated in the source. Source field: STVSUBJ_ACTIVITY_DATE. |
| Custom_Id Indexed - no
Format - Number
May be Null? Y | |
| 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 of the latest refresh of this warehouse table |
| Subject_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | Code for the Subject Area used on courses. Source field: STVSUBJ_CODE |
| Subject_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Subject Area text descriptive title. Source field: STVSUBJ_DESC. |
| Subject_Desc_Long Indexed - no
Format - Varchar2(150)
May be Null? Y | Custom long descriptive text of the subject code. Source field: UP_ST_UP_S_BANNER_LONG_DESC. LONG_DESC |
| School_Code Indexed - yes
Format - Varchar2(1)
May be Null? Y | One-character code for the School that primarily administers courses in this subject area. Derived from SCBCRSE_COLL_CODE. |
| Org_Code Indexed - yes
Format - Varchar2(4)
May be Null? N | 4-digit number stored as text (may have leading zeros) for the Penn Organization Code associated with the subject area. Source: STVSUBJ_VR_MSG_NO (converted to a character field). May be validated using the warehouse table DWADMIN.ORG_CODE |
| V_Subject_Pk Indexed - yes
Format - Varchar2(60)
May be Null? N | internal warehouse primary key |
