| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | Last date the record was created or updated in the source. |
| Fed_Rept_Race_Code Indexed - no
Format - Varchar2(1)
May be Null? Y | This code indicates the broader race categorization used for reporting to the Federal Government. Used in the "Rollup-Race" field in the STUDENT table. |
| Fed_Rept_Race_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Descriptive text name for the code in the FED_REPT_RACE column. |
| Penn_ID Indexed - no
Format - Varchar2(9)
May be Null? Y | The student's Penn_ID. Penn's identity management system identification number. |
| Pidm Indexed - no
Format - Number
May be Null? Y | internal identification number in source |
| Race_Code Indexed - no
Format - Varchar2(3)
May be Null? Y | Penn's code for the student's race. Race codes can be for the detail categories within a federal race reporting group. The ST_RACE table also includes detail categories for ethnicity. |
| Race_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Descriptive text name for the code in the RACE column. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Date the warehouse record in ST_RACE was last refreshed |
| St_Race_Pk Indexed - yes
Format - Varchar2(25)
May be Null? N | internal warehouse primary key, based on to_char(PIDM), RACE_CODE |
