| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The latest date the record was updated in the source. Source field: SGRSPRT_ACTIVITY_DATE. |
| Athl_Aid_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Sport Athletic Aid Indicator. Source field: SGRSPRT_ATHL_AID_IND. |
| Data_Origin Indexed - no
Format - Varchar2(30)
May be Null? Y | Value of the source system that inserted or updated the row. Source field: SGRSPRT_DATA_ORIGIN |
| Official_Elig_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Athletic official eligibility code. Source field: SGRSPRT_SAEL_CODE. Source validation table: STVSAEL. Warehouse validation table: V_ATHLETIC_ELIG. |
| Penn_Id Indexed - yes
Format - Varchar2(9)
May be Null? Y | Penn's identity management system identification number. Source field: SPRIDEN_ID |
| Pidm Indexed - yes
Format - Number
May be Null? Y | Banner internal identification number. Source field: SGRSPRT_PIDM. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The last date the table was refreshed in the warehouse |
| Sport_Code Indexed - yes
Format - Varchar2(8)
May be Null? Y | Activity Code. Source field: SGRSPRT_ACTC_CODE. Source validation table: STVACTC. Warehouse validation table: V_ACTIVITY. |
| Sport_Eligibility_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Eligibility Code. Source field: SGRSPT_ELIG_CODE. Source validation table: STVELIG. |
| Sport_Status_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Sport Status Code. Source field: SGRSPRT_SPST_CODE. Source validation table: STVSPST. Warehouse validation table: V_SPORT_STATUS. |
| St_Sport_Pk Indexed - yes
Format - Varchar2(22)
May be Null? N | Internal primary key, derived from PIDM, TERM, and ACTC code |
| Term Indexed - yes
Format - Varchar2(6)
May be Null? Y | Term that pertains to the student's sport/athletic information. Source field: SGRSPRT_TERM_CODE |
| User_Id Indexed - no
Format - Varchar2(30)
May be Null? Y | ID of the most recent user to create or update the row in the SGRSPRT table. Source field: SGRSPRT_USER_ID. |
