| Data element |
Definition |
| Activity_Code Indexed - no
Format - Varchar2(8)
May be Null? Y | The code for the activity in which the student is participating. Source field: SGRSACT_ACTC_CODE. Source validation table: STVACTC. Warehouse validation table: V_ACTIVITY |
| Activity_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Description of the Activity Code. Source field: STVACTC_DESC. |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The last date any part of this record was updated in the source |
| Penn_Id Indexed - no
Format - Varchar2(9)
May be Null? Y | Penn's identity management system identification number. Source field: SPRIDEN_ID. |
| Pidm Indexed - no
Format - Number
May be Null? Y | Internal identification number. Source field: SGRSACT_PIDM. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The last date the table was refreshed in the warehouse |
| St_Activity_Pk Indexed - yes
Format - Varchar2(36)
May be Null? N | internal warehouse primary key: based on PIDM, TERM, and ACTC_CODE |
| Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The term in which the student participated in the activity. Source field: SGRSACT_TERM. |
