Penn Computing

University of Pennsylvania
Penn Computing << go backback
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.

Primary Key Indexed Data Elements Related Tables
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

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania