RACE_ETHNICITY_SURVEY_FLAT Table - Data Element Index    Race/Ethnicity Home   Data Warehouse Home

RACE_ETHNICITY_SURVEY_FLAT Table

Explanation
The RACE_ETHNICITY_SURVEY_FLAT table contains detailed race and ethnicity surveys for both students and employees in compliance with the Department of Education mandated format effective for the fall of 2010.

Common Uses
Provide statistics for internal/external required as well as adhoc reporting.

SURVEY_ID

CURRENT RECORD
EMPLOYEE_ORG
ENTERED_ON
PENN_ID
STUDENT_FLAG
SURVEY_ID

      

EMPLOYEE_ETHNICITY_V
PERSON_ALL_V

      

Cautions

• The RACE_ETHNICITY_SURVEY_FLAT table is stored in the DWIPEDS schema in the Data Warehouse.
• This information is only visible to those who have ethnicity/race access in the Data Warehouse.
• Snapshots of this data can be found in the RACE_ETHNICITY_SURVEY_SNAP table stored in the DWIPEDS schema in the Data Warehouse.

RACE_ETHNICITY_SURVEY_FLAT Table - Data Element Index    Race/Ethnicity Home   Data Warehouse Home