| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date (7)
May be Null? Y | Last date the record was created or updated in the source. |
| Fed_Rept_Race_Code Indexed - no
Format - Varchar2 (4)
May be Null? Y | For rows representing a detail category, this indicates the broader race categorization used for reporting to the Federal Government. |
| Fed_Rept_Race_Desc Indexed - no
Format - Varchar2 (240)
May be Null? Y | Descriptive text name for the code in the FED_REPT_RACE column. |
| Penn_Id Indexed - yes
Format - Varchar2 (36)
May be Null? Y | Penn's identitiy management system identification number |
| Pidm Indexed - no
Format - Number (22)
May be Null? Y | internal identification number in source |
| Race_Code Indexed - no
Format - Varchar2 (12)
May be Null? Y | Penn's code for the student's race. Includes the detail categories, and also includes detail categories for ethnicity. |
| Race_Desc Indexed - no
Format - Varchar2 (240)
May be Null? Y | Descriptive text name for the code in the RACE column. |
| Refresh_Date Indexed - no
Format - Date (7)
May be Null? Y | date DW record in STDT_RACE was last refreshed |
| St_Race_Pk Indexed - yes
Format - Varchar2 (44)
May be Null? N | internal warehouse primary key, based on to_char(PIDM), RACE_CODE |
