Penn Computing

University of Pennsylvania
Penn Computing << go backback
FA RACE ETHNICITY FLAT Table . Pennant Financial Aid Home . Data Warehouse Home

FA_RACE_ETHNICITY_FLAT Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

Data element Definition
Afr_Amer

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as Black or African American. Rolls up to the Federal Reporting category '2 - Asian' Source table: GENERAL_GORPRAC.

Afr_Amer_Africa

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as African. This is a sub-group of the BLACK_OR_AFR_AMER category. Rolls up to the Federal Reporting category '3 - Black or African American' Source table: GENERAL_GORPRAC.

Afr_Amer_Carribean

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as Carribean. This is a sub-group of the BLACK_OR_AFR_AMER category. Rolls up to the Federal Reporting category '3 - Black or African American' Source table: GENERAL_GORPRAC.

Afr_Amer_Other

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as another category of Black or African American not specified in the list of choices presented in the user interface. Rolls up to the Federal Reporting category '3 - Black or African American' Source table: GENERAL_GORPRAC.

Afr_Amer_Us

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as African American. This is a sub-group of the BLACK_OR_AFR_AMER category. Rolls up to the Federal Reporting category '3 - Black or African American' Source table: GENERAL_GORPRAC.

Amer_Ind

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as Native American. Rolls up to the Federal Reporting category '1 - American Indian or Alaska Native' Source table: GENERAL_GORPRAC.

Amer_Ind_Alaska_Native

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as an Alaskan Native. This is a sub-group of the AMER_IND category. Rolls up to the Federal Reporting category '1 - American Indian or Alaska Native' Source table: GENERAL_GORPRAC.

Amer_Ind_Cherokee

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as Cherokee. This is a sub-group of the AMER_IND category. Rolls up to the Federal Reporting category '1 - American Indian or Alaska Native' Source table: GENERAL_GORPRAC.

Amer_Ind_Chippewa

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as Chippewa. This is a sub-group of the AMER_IND category. Rolls up to the Federal Reporting category '1 - American Indian or Alaska Native' Source table: GENERAL_GORPRAC.

Amer_Ind_Choctaw

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as Choctaw. This is a sub-group of the AMER_IND category. Rolls up to the Federal Reporting category '1 - American Indian or Alaska Native' Source table: GENERAL_GORPRAC.

Amer_Ind_Navajo

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as Navajo. This is a sub-group of the AMER_IND category. Rolls up to the Federal Reporting category '1 - American Indian or Alaska Native' Source table: GENERAL_GORPRAC.

Amer_Ind_Other

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as another category of Native American not specified in the list of choices presented in the user interface. This is a sub-group of the AMER_IND category. Rolls up to the Federal Reporting category '1 - American Indian or Alaska Native' Source table: GENERAL_GORPRAC.

Amer_Ind_Sioux

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as Sioux. This is a sub-group of the AMER_IND category. Rolls up to the Federal Reporting category '1 - American Indian or Alaska Native' Source table: GENERAL_GORPRAC.

Asian

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as Asian. Rolls up to the Federal Reporting category '2 - Asian' Source table: GENERAL_GORPRAC.

Asian_China

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as Chinese. This is a sub-group of the ASIAN category. Rolls up to the Federal Reporting category '2 - Asian' Source table: GENERAL_GORPRAC.

Asian_India

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as Indian. This is a sub-group of the ASIAN category. Rolls up to the Federal Reporting category '2 - Asian' Source table: GENERAL_GORPRAC.

Asian_Japan

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as Japanese. This is a sub-group of the ASIAN category. Rolls up to the Federal Reporting category '2 - Asian' Source table: GENERAL_GORPRAC.

Asian_Korea

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as Korean. This is a sub-group of the ASIAN category. Rolls up to the Federal Reporting category '2 - Asian' Source table: GENERAL_GORPRAC.

Asian_Other_East

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as another category of East Asian not specified in the list of choices presented in the user interface. Rolls up to the Federal Reporting category '2 - Asian' Source table: GENERAL_GORPRAC.

Asian_Other_Indiansubcont

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as another category of Asian from the Indian sub-continent that is not specified in the list of choices presented in the user interface. Rolls up to the Federal Reporting category '2 - Asian' Source table: GENERAL_GORPRAC.

Asian_Other_Southeast

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as another category of Southeast Asian not specified in the list of choices presented in the user interface. Rolls up to the Federal Reporting category '2 - Asian' Source table: GENERAL_GORPRAC.

Asian_Pakistan

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as Pakistani. This is a sub-group of the ASIAN category. Rolls up to the Federal Reporting category '2 - Asian' Source table: GENERAL_GORPRAC.

Asian_Phillipines

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as Philippino. This is a sub-group of the ASIAN category. Rolls up to the Federal Reporting category '2 - Asian' Source table: GENERAL_GORPRAC.

Asian_Vietnam

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as Vietnamese. This is a sub-group of the ASIAN category. Rolls up to the Federal Reporting category '2 - Asian' Source table: GENERAL_GORPRAC.

Hisp_Lat

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as being of Hispanic or Latino ethnicity. NOTE: this is not considered a race code by the US Federal Government; it is an indication of the individual's ethnicity, not race. Source table: GENERAL_GORPRAC.

Hisp_Lat_Central_Amer

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as being of Hispanic or Latino ethnicity, specifically from Central America. NOTE: this is not considered a race code by the US Federal Government; it is an indication of the individual's ethnicity, not race. Source table: GENERAL_GORPRAC.

Hisp_Lat_Cuba

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as being of Hispanic or Latino ethnicity, specifically from Cuba. NOTE: this is not considered a race code by the US Federal Government; it is an indication of the individual's ethnicity, not race. Source table: GENERAL_GORPRAC.

Hisp_Lat_Mexico

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as being of Hispanic or Latino ethnicity, specifically from Mexico. NOTE: this is not considered a race code by the US Federal Government; it is an indication of the individual's ethnicity, not race. Source table: GENERAL_GORPRAC.

Hisp_Lat_Other

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as being of Hispanic or Latino ethnicity, from a country not identified in the choices presented to the students in the user interface. NOTE: this is not considered a race code by the US Federal Government; it is an indication of the individual's ethnicity, not race. Source table: GENERAL_GORPRAC.

Hisp_Lat_Puerto_Rico

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as being of Hispanic or Latino ethnicity, specifically from Puerto Rico. NOTE: this is not considered a race code by the US Federal Government; it is an indication of the individual's ethnicity, not race. Source table: GENERAL_GORPRAC.

Hisp_Lat_South_Amer

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as being of Hispanic or Latino ethnicity, specifically from South America. NOTE: this is not considered a race code by the US Federal Government; it is an indication of the individual's ethnicity, not race. Source table: GENERAL_GORPRAC.

Hisp_Lat_Spain

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as being of Hispanic or Latino ethnicity, specifically from Spain. NOTE: this is not considered a race code by the US Federal Government; it is an indication of the individual's ethnicity, not race. Source table: GENERAL_GORPRAC.

Not_Reported

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student opted to not answer the question about their racial origin.

Pac_Isl

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as Pacific Islander (excluding Philippines). Rolls up to the Federal Reporting category '4 - Native Hawaiian or Other Pacific Islander' Source table: GENERAL_GORPRAC.

Pac_Isl_Guam

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as being a native to the Island of Guam. This is a sub-group of the PAC_ISL category. Rolls up to the Federal Reporting category '4 - Native Hawaiian or Other Pacific Islander' Source table: GENERAL_GORPRAC.

Pac_Isl_Hawaii

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as being Hawaiian. This is a sub-group of the PAC_ISL category. Rolls up to the Federal Reporting category '4 - Native Hawaiian or Other Pacific Islander' Source table: GENERAL_GORPRAC.

Pac_Isl_Other

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as another category of Pacific Islander not specified in the list of choices presented in the user interface. Rolls up to the Federal Reporting category '4 - Native Hawaiian or Other Pacific Islander' Source table: GENERAL_GORPRAC.

Pac_Isl_Samoa

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as being Samoan. This is a sub-group of the PAC_ISL category. Rolls up to the Federal Reporting category '4 - Native Hawaiian or Other Pacific Islander' Source table: GENERAL_GORPRAC.

Penn_Id

Indexed - no
Format - Varchar2 (32)
May be Null? Y

Penn's unique id for the person.

Pidm

Indexed - yes
Format - Number (22)
May be Null? N

Source system internal identifier for the person.

Refresh_Date

Indexed - no
Format - Date (7)
May be Null? Y

The date this warehouse table was last refreshed.

White

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as White. Rolls up to the Federal Reporting category '5 - White' Source table: GENERAL_GORPRAC.

White_Europe

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as European. This is a sub-group of the WHITE category. Rolls up to the Federal Reporting category '5 - White' Source table: GENERAL_GORPRAC.

White_Middle_East

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as being from the Middle East. This is a sub-group of the WHITE category. Rolls up to the Federal Reporting category '5 - White' Source table: GENERAL_GORPRAC.

White_Other

Indexed - no
Format - Number (22)
May be Null? Y

Values are 0 or 1: a 1 in this column indicates the student has self-identified as another category of White not specified in the list of choices presented in the user interface. Rolls up to the Federal Reporting category '5 - White' Source table: GENERAL_GORPRAC.

FA RACE ETHNICITY FLAT Table . Pennant Financial Aid 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