Penn Computing

University of Pennsylvania
Penn Computing << go backback

GA_IPEDS_FLAT Table . Tables and Data Elements . Graduate Admissions Data Home . Data Warehouse Home

GA_IPEDS_FLAT Table - Data Element Index

Not appearing in the Graduate Admissions Reporting universe:

 

 

Data element Definition
Applicant ID

An identifying number, assigned by the Graduate Admissions system, to each applicant. This column cannot be null.

When an applicant is admitted and matriculates to Penn, the Applicant_ID is loaded to the Student Records System along with their other biographic, demographic, and academic information.

Note that to uniquely identify rows requires both the Applicant_ID and the Record Source.

Application Term The term which the applicant, if admitted, anticipates starting their studies at Penn. This column is usually in SRS format: YYYYT, where YYYY is the full calendar year, and T is the SRS Term (A = Spring, B = Summer, C = Fall).
AFR_AMER
AFR_AMER_AFRICA
AFR_AMER_CARIBBEAN
AFR_AMER_OTHER
AFR_AMER_OTHER_TEXT
AFR_AMER_US

African American columns

1 = yes, 0 = no

A 1 in any of these columns indicates the applicant has self-identified as African American, either from a specific continent category/categories, or in a non-specified category. If the "AFR_AMER_OTHER" column has the value of 1, there can be free-form text entered into the AFR_AMER_OTHER_TEXT column providing additional information.

AMER_IND
AMER_IND_ALASKA_NATIVE
AMER_IND_CHEROKEE
AMER_IND_CHIPPEWA
AMER_IND_CHOCTAW
AMER_IND_NAVAJO
AMER_IND_OTHER
AMER_IND_OTHER_TEXT
AMER_IND_SIOUX

American Indian.(Native American) columns

1 = yes, 0 = no

A 1 in any of these columns indicates the applicant has self-identified as American Indian, either in a specific nation category/categories, or in a non-specified nation category. If the "AMER_IND_OTHER" column has the value of 1, there can be free-form text entered into the AMER_IND_OTHER_TEXT column providing additional information.

ASIAN
ASIAN_CHINA
ASIAN_INDIA
ASIAN_JAPAN
ASIAN_KOREA
ASIAN_OTHER_EAST
ASIAN_OTHER_EAST_TEXT
ASIAN_OTHER_INDIAN
ASIAN_OTHER_INDIAN_TEXT
ASIAN_PAKISTAN
ASIAN_PHILIPPINES
ASIAN_SOUTHEAST
ASIAN_SOUTHEAST_TEXT
ASIAN_VIETNAM

Asian columns

1 = yes, 0 = no

A 1 in any of these columns indicates the applicant has self-identified as Asian, either from a specific country/geographic area category/categories, or in a non-specified category. If the "ASIAN_OTHER_EAST" column has the value of 1, there can be free-form text entered into the ASIAN_OTHER_EAST_TEXT column providing additional information. If the "ASIAN_OTHER_INDIAN" column has the value of 1, there can be free-form text entered into the ASIAN_OTHER_INDIAN_TEXT column providing additional information.

HISP_LAT
HISP_LAT_CENTRAL_AMERICA
HISP_LAT_CUBA
HISP_LAT_MEXICO
HISP_LAT_OTHER
HISP_LAT_OTHER_TEXT
HISP_LAT_PUERTO_RICO
HISP_LAT_SOUTH_AMERICA
HISP_LAT_SPAIN

Hispanic / Latino columns

1 = yes, 0 = no

A 1 in any of these columns indicates the applicant has self-identified as Hispanic or Latino, either from a specific country/geographic area category/categories, or in a non-specified category. If the "HISP_LAT_OTHER" column has the value of 1, there can be free-form text entered into the HISP_LAT_OTHER_TEXT column providing additional information.

PAC_ISL
PAC_ISL_GUAM
PAC_ISL_HAWAII
PAC_ISL_OTHER
PAC_ISL_OTHER_TEXT
PAC_ISL_SAMOA

Pacific Islander columns

1 = yes, 0 = no

A 1 in any of these columns indicates the applicant has self-identified as Pacific Islander, either from a specific geographic area category/categories, or in a non-specified category. If the "PAC_ISL_OTHER" column has the value of 1, there can be free-form text entered into the PAC_ISL_OTHER_TEXT column providing additional information.

WHITE
WHITE_EUROPE
WHITE_MIDDLE_EAST
WHITE_OTHER
WHITE_OTHER_TEXT

White (Caucasian) columns

1 = yes, 0 = no

A 1 in any of these columns indicates the applicant has self-identified as Pacific Islander, either from a specific geographic area category/categories, or in a non-specified category. If the "WHITE_OTHER" column has the value of 1, there can be free-form text entered into the WHITE_OTHER_TEXT column providing additional information.

Record_Source For records that come from the Apply Yourself system, Record_Source will have a value of 'AY.' Schools not participating in AY will have a record source of the school or division code.
Last_Update_Date The date the record was last updated
SRS_Ethnicity_Race

The code used in SRS for this applicant's ethnicity/race. SRS has a limited number of values for ethnicity/race, and can only hold one value per student. The IPEDs data are converted to SRS values when an applicant is admitted, according to pre-established business rules.

Values:

[Null]   Not specified
A        American Indian/Alaskan native.  A person having origins          
         in any of the original peoples of North America and who          
         maintains cultural identification through tribal affiliation          
         or community recognition.
B        Black, Non-Hispanic.  A person having origins in any of the          
         black racial groups of Africa.
C        White, Non-Hispanic.  A person having origins in any of the          
         original peoples of Europe, North Africa, or the Middle East.
O        Other
R        Asian or Pacific Islander.  A person having origins in any          
         of the original peoples of the Far East, South East Asia,          
         the Indian subcontinent or the Pacific Islands.  This area          
         includes China, Japan, Korea, The Philippine Islands and Samoa.
S        Hispanic.  A person of Mexican, Puerto Rican, Cuban, Central          
         or South American or other Spanish culture or origin,          
         regardless of race.
X        Multiple/mixed ethnicity.

:

 

GA_IPEDS_FLAT Table . Tables and Data Elements . Graduate Admissions Data 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