| 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. |
