Penn Computing

University of Pennsylvania
Penn Computing << go backback
ST_RACE_ETHNICITY_FLAT Table . Pennant Student Records Home . Data Warehouse Home

ST_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
May be Null? Y

African American. Parent value for all race codes starting with 'Afr_Amer'

Students can opt to have just this value, and none of the child values.

A '1' in this column indicates the student has self-identified as African American, else this column will be '0'

Afr_Amer_Africa

Indexed - no
Format - Number
May be Null? Y

African American of African origin.

Rows with a '1' in this column will also have a '1' in the Afr_Amer column.

Afr_Amer_Carribean

Indexed - no
Format - Number
May be Null? Y

African American of Carribean origin.

Rows with a '1' in this column will also have a '1' in the Afr_Amer column.

Afr_Amer_Other

Indexed - no
Format - Number
May be Null? Y

African American of origin other than African or Carribean.

Rows with a '1' in this column will also have a '1' in the Afr_Amer column.

Afr_Amer_Us

Indexed - no
Format - Number
May be Null? Y

African American identifying as origin US (United States).

Rows with a '1' in this column will also have a '1' in the Afr_Amer column.

Amer_Ind

Indexed - no
Format - Number
May be Null? Y

American Indian. Parent value for all race codes starting with 'Amer_Ind'

Students can opt to have just this value, and none of the child values.

A '1' in this column indicates the student has self-identified as American Indian, else this column will be '0'

Amer_Ind_Alaska_Native

Indexed - no
Format - Number
May be Null? Y

American Indian, of a native Alaskan nation.

Rows with a '1' in this column will also have a '1' in the Amer_Ind column.

Amer_Ind_Cherokee

Indexed - no
Format - Number
May be Null? Y

American Indian, of the Cherokee nation.

Rows with a '1' in this column will also have a '1' in the Amer_Ind column.

Amer_Ind_Chippewa

Indexed - no
Format - Number
May be Null? Y

American Indian, of the Chippewa nation.

Rows with a '1' in this column will also have a '1' in the Amer_Ind column.

Amer_Ind_Choctaw

Indexed - no
Format - Number
May be Null? Y

American Indian, of the Choctaw nation.

Rows with a '1' in this column will also have a '1' in the Amer_Ind column.

Amer_Ind_Navajo

Indexed - no
Format - Number
May be Null? Y

American Indian, of the Navajo nation.

Rows with a '1' in this column will also have a '1' in the Amer_Ind column.

Amer_Ind_Other

Indexed - no
Format - Number
May be Null? Y

American Indian, of a nation not identified in other Amer_Ind columns.

Rows with a '1' in this column will also have a '1' in the Amer_Ind column.

Amer_Ind_Sioux

Indexed - no
Format - Number
May be Null? Y

American Indian, of the Sioux nation.

Rows with a '1' in this column will also have a '1' in the Amer_Ind column.

Asian

Indexed - no
Format - Number
May be Null? Y

Asian. Parent value for all race codes starting with 'Asian'

Students can opt to have just this value, and none of the child values.

A '1' in this column indicates the student has self-identified as Asian, else this column will be '0'

Asian_China

Indexed - no
Format - Number
May be Null? Y

Asian of Chinese origin.

Rows with a '1' in this column will also have a '1' in the Asian column.

Asian_India

Indexed - no
Format - Number
May be Null? Y

Asian of Indian origin.

Rows with a '1' in this column will also have a '1' in the Asian column.

Asian_Japan

Indexed - no
Format - Number
May be Null? Y

Asian of Japanese origin.

Rows with a '1' in this column will also have a '1' in the Asian column.

Asian_Korea

Indexed - no
Format - Number
May be Null? Y

Asian of Korean origin.

Rows with a '1' in this column will also have a '1' in the Asian column.

Asian_Other_East

Indexed - no
Format - Number
May be Null? Y

East Asia origin other than nationalities identified in other Asian columns.

Rows with a '1' in this column will also have a '1' in the Asian column.

Asian_Other_Indiansubcont

Indexed - no
Format - Number
May be Null? Y

Indian Subcontinent origin other than nationalities identified in other Asian columns.

Rows with a '1' in this column will also have a '1' in the Asian column.

Asian_Other_Southeast

Indexed - no
Format - Number
May be Null? Y

South East Asia origin other than nationalities identified in other Asian columns.

Rows with a '1' in this column will also have a '1' in the Asian column.

Asian_Pakistan

Indexed - no
Format - Number
May be Null? Y

Asian of Pakistani origin.

Rows with a '1' in this column will also have a '1' in the Asian column.

Asian_Philippines

Indexed - no
Format - Number
May be Null? Y

Asian of Philippine origin.

Rows with a '1' in this column will also have a '1' in the Asian column.

Asian_Vietnam

Indexed - no
Format - Number
May be Null? Y

Asian of Vietnamese origin.

Rows with a '1' in this column will also have a '1' in the Asian column.

Calc_Rac_Ethn_Desc

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

Based on ethnicity and race data collected, a caluculated ethnic and race description. The categories are based on IPEDS categories as of October 2024.

Citizen_Code

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

Code for the citizenship category of the student. Values are

PR Permanent Resident
US US Citizen
NO Non US Citizen
DC US/Dual Citizen

Source field: SPBPERS_CITZ_CODE. Source validation table: STVCITZ. Warehouse validation table: V_CITIZENSHIP_TYPE

Citizen_Desc

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

Citizenship code description. Validation table: V_CITIZENSHIP_TYPE

Hispanic_Ind

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

Y/N indicator if the student identified as Hispanic

Hisp_Lat

Indexed - no
Format - Number
May be Null? Y

Hispanic/Latino. This category is not considered a Race Code for federal reporting. Instead, it comes from the Ethnicity Code. See Ethnicity in the STUDENT table.

Students can opt to have just this value, and none of the child values.

A '1' in this column indicates the student has self-identified as Asian, else this column will be '0'

Hisp_Lat_Central_Amer

Indexed - no
Format - Number
May be Null? Y

Hispanic/Latino of Central American origin.

Rows with a '1' in this column will also have a '1' in the Hisp_Lat column.

Hisp_Lat_Cuba

Indexed - no
Format - Number
May be Null? Y

Hispanic/Latino of Cuban origin.

Rows with a '1' in this column will also have a '1' in the Hisp_Lat column.

Hisp_Lat_Mexico

Indexed - no
Format - Number
May be Null? Y

Hispanic/Latino of Mexican origin.

Rows with a '1' in this column will also have a '1' in the Hisp_Lat column.

Hisp_Lat_Other

Indexed - no
Format - Number
May be Null? Y

Hispanic/Latino of origin not include in any of the other Hisp_Lat columns.

Rows with a '1' in this column will also have a '1' in the Hisp_Lat column.

Hisp_Lat_Puerto_Rico

Indexed - no
Format - Number
May be Null? Y

Hispanic/Latino of Puerto Rican origin.

Rows with a '1' in this column will also have a '1' in the Hisp_Lat column.

Hisp_Lat_South_Amer

Indexed - no
Format - Number
May be Null? Y

Hispanic/Latino of South American origin.

Rows with a '1' in this column will also have a '1' in the Hisp_Lat column.

Hisp_Lat_Spain

Indexed - no
Format - Number
May be Null? Y

Hispanic/Latino of Spanish origin.

Rows with a '1' in this column will also have a '1' in the Hisp_Lat column.

Not_Reported

Indexed - no
Format - Number
May be Null? Y

Race code not reported.

Pac_Isl

Indexed - no
Format - Number
May be Null? Y

Pacific Islander. Parent value for all race codes starting with 'Pac_Isl'

Students can opt to have just this value, and none of the child values.

A '1' in this column indicates the student has self-identified as Pacific Islander, else this column will be '0'

Pac_Isl_Guam

Indexed - no
Format - Number
May be Null? Y

Pacific Islander from the island of Guam.

Rows with a '1' in this column will also have a '1' in the Pac_Isl column.

Pac_Isl_Hawaii

Indexed - no
Format - Number
May be Null? Y

Pacific Islander of Hawaiian origin.

Rows with a '1' in this column will also have a '1' in the Pac_Isl column.

Pac_Isl_Other

Indexed - no
Format - Number
May be Null? Y

Pacific Islander of origin other than on identified in the other Pac_Isl columns.

Rows with a '1' in this column will also have a '1' in the Pac_Isl column.

Pac_Isl_Samoa

Indexed - no
Format - Number
May be Null? Y

Pacific Islander of Samoan origin.

Rows with a '1' in this column will also have a '1' in the Pac_Isl column.

Penn_Id

Indexed - yes
Format - Varchar2(9)
May be Null? Y

The student's Penn_ID.

Pidm

Indexed - yes
Format - Number
May be Null? N

Internal identification number.

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

The latest date this warehouse table was refreshed.

White

Indexed - no
Format - Number
May be Null? Y

Caucasian. Parent value for all race codes starting with 'White'

Students can opt to have just this value, and none of the child values.

A '1' in this column indicates the student has self-identified as Caucasian, else this column will be '0'

White_Europe

Indexed - no
Format - Number
May be Null? Y

Caucasian of European origin.

Rows with a '1' in this column will also have a '1' in the White column.

White_Middle_East

Indexed - no
Format - Number
May be Null? Y

Caucasian of Middle Eastern origin.

Rows with a '1' in this column will also have a '1' in the White column.

White_Other

Indexed - no
Format - Number
May be Null? Y

Caucasian of origin other than one identified in the other 'White_' columns.

Rows with a '1' in this column will also have a '1' in the White column.

ST_RACE_ETHNICITY_FLAT Table . Pennant Student Records 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