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 |