Penn Computing

University of Pennsylvania
Penn Computing << go backback
RACE_ETHNICITY_SURVEY_FLAT Table     Race/Ethnicity Home    Data Warehouse Home

RACE_ETHNICITY_SURVEY_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 - integer
May be null? Yes

Indicates the primary race category of “Black or African American (including Africa and Caribbean)” and denotes an individual having origins in any of the black racial groups of Africa. This is represented with a “1” for yes or “0” for no.
AFR_AMER_AFRICA

Indexed - no
Format – integer
May be null? Yes

Indicates the subcategory of “Africa” found within the race category of “Black or African American (including Africa and Caribbean)”. This is represented with a “1” for yes or “0” for no.
AFR_AMER_CARIBBEAN

Indexed - no
Format – integer
May be null? Yes

Indicates the subcategory of “Caribbean” found within the race category of “Black or African American (including Africa and Caribbean)”. This is represented with a “1” for yes or “0” for no.
AFR_AMER_OTHER

Indexed - no
Format – varchar2 (100 char)
May be null? Yes

Indicates the subcategory of “Other” found within the race category of “Black or African American (including Africa and Caribbean)”. This is represented with a “1” for yes or “0” for no.

AFR_AMER_US

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “U.S. / African American” found within the race category of “Black or African American (including Africa and Caribbean)”. This is represented with a “1” for yes or “0” for no.

AMER_IND

Indexed - no
Format – integer
May be null? Yes

Indicates the primary race category of “American Indian or Alaska Native (including all Original Peoples of the Americas)” and denotes an individual having origins in any of the original peoples of North and South America (including Central America) who maintains cultural identification through tribal affiliation or community attachment. This is represented with a “1” for yes or “0” for no.
AMER_IND_ALASKA_NATIVE

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Alaska Native” found within the race category of “American Indian or Alaska Native (including all Original Peoples of the Americas)”. This is represented with a “1” for yes or “0” for no.
AMER_IND_CHEROKEE

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Cherokee” found within the race category of “American Indian or Alaska Native (including all Original Peoples of the Americas)”. This is represented with a “1” for yes or “0” for no.

AMER_IND_CHIPPEWA

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Chippewa” found within the race category of “American Indian or Alaska Native (including all Original Peoples of the Americas)”. This is represented with a “1” for yes or “0” for no.

AMER_IND_CHOCTAW

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Choctaw” found within the race category of “American Indian or Alaska Native (including all Original Peoples of the Americas)”. This is represented with a “1” for yes or “0” for no.

AMER_IND_NAVAJO

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Navajo” found within the race category of “American Indian or Alaska Native (including all Original Peoples of the Americas)”. This is represented with a “1” for yes or “0” for no.

 

AMER_IND_OTHER

Indexed - no
Format – varchar2 (100 char)
May be null? Yes

Represents the subcategory of “Other” found within the race category of “American Indian or Alaska Native (including all Original Peoples of the Americas)”. This is represented with a “1” for yes or “0” for no.

AMER_IND_SIOUX

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Sioux” found within the race category of “American Indian or Alaska Native (including all Original Peoples of the Americas)”. This is represented with a “1” for yes or “0” for no.

ASIAN

Indexed - no
Format – integer
May be null? Yes

Indicates the primary race category of “Asian (including Indian subcontinent and Philippines)” and denotes an individual having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian Subcontinent, including, for example, Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam. This is represented with a “1” for yes or “0” for no.

ASIAN_CHINA

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “China” found within the race category of “Asian (including Indian subcontinent and Philippines)”. This is represented with a “1” for yes or “0” for no.

ASIAN_INDIA

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “India” found within the race category of “Asian (including Indian subcontinent and Philippines)”. This is represented with a “1” for yes or “0” for no.

ASIAN_JAPAN

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Japan” found within the race category of “Asian (including Indian subcontinent and Philippines)”. This is represented with a “1” for yes or “0” for no.

ASIAN_KOREA

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Korea” found within the race category of “Asian (including Indian subcontinent and Philippines)”. This is represented with a “1” for yes or “0” for no.

ASIAN_OTHER_EAST

Indexed - no
Format – varchar2(100 char)
May be null? Yes

Represents the subcategory of “Other East Asia” found within the race category of “Asian (including Indian subcontinent and Philippines)”. This is represented with a “1” for yes or “0” for no.

ASIAN_OTHER_INDIAN

Indexed - no
Format – varchar2(100 char)
May be null? Yes

Represents the subcategory of “Other Indian Subcontinent” found within the race category of “Asian (including Indian subcontinent and Philippines)”. This is represented with a “1” for yes or “0” for no.

ASIAN_PAKISTAN

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Pakistan” found within the race category of “Asian (including Indian subcontinent and Philippines)”. This is represented with a “1” for yes or “0” for no.

ASIAN_PHILIPPINES

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Philippines” found within the race category of “Asian (including Indian subcontinent and Philippines)”. This is represented with a “1” for yes or “0” for no.

ASIAN_SOUTHEAST

Indexed - no
Format – varchar2(100 char)
May be null? Yes

Represents the subcategory of “Other Southeast Asia” found within the race category of “Asian (including Indian subcontinent and Philippines)”. This is represented with a “1” for yes or “0” for no.

ASIAN_VIETNAM

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Vietnam” found within the race category of “Asian (including Indian subcontinent and Philippines)”. This is represented with a “1” for yes or “0” for no.

CURRENT_RECORD

Indexed - yes
Format – varchar2( 1byte)
May be null? Yes

Denotes whether the record is the current ethnicity/race survey of an individual or a historical survey with “T” for true and “F” for false.

EMPLOYEE_MAPPED_VALUE

Indexed - no
Format – varchar2( 1byte)
May be null? Yes

For employees, denotes the single mapped value that is derived from the Penn People ethnicity/race categories and fed to the Employee_Ethnicity.Ethnicity table in the DWADMIN schema.

Values:

A - Native American / Alaskan Native
B - Black / African American
C - White / Caucasian
P - Native Hawaiian / Other Pacific Islander
R - Asian
S - Hispanic / Latino
Z - Multiple ethnicity/race (this does not represent the methodology used for Federal reporting purposes)

EMPLOYEE_ORG

Indexed - yes
Format – varchar2( 1byte)
May be null? Yes

Denotes the employee’s home ORG as it existed in the Employee_General.Home_Dept_Org table in the DWADMIN schema at the time the record was loaded to the Warehouse.

ENTERED_ON

Indexed - yes
Format – date
May be null? Yes

Denotes the date an individual’s ethnicity/race survey was entered into the Penn People application.

 

HISP_LAT

Indexed - no
Format – integer
May be null? Yes

Indicates a response of yes to the primary ethnicity category of “Hispanic or Latino (including Spain)” and denotes an individual of Cuban, Mexican, Puerto Rican, South or Central American, or other Spanish culture or origin, regardless of race. This is represented with a “1” for yes or “0” for no.

HISP_LAT_CENTRAL_AMERICA

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Central America” found within the ethnicity category of “Hispanic or Latino (including Spain)”. This is represented with a “1” for yes or “0” for no.

HISP_LAT_CUBA

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Cuba” found within the ethnicity category of “Hispanic or Latino (including Spain)”. This is represented with a “1” for yes or “0” for no.

HISP_LAT_MEXICO

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Mexico” found within the ethnicity category of “Hispanic or Latino (including Spain)”. This is represented with a “1” for yes or “0” for no.

HISP_LAT_NO

Indexed - no
Format – integer
May be null? Yes

Indicates a response of no to the primary ethnicity category of “Hispanic or Latino (including Spain)” which denotes an individual of Cuban, Mexican, Puerto Rican, South or Central American, or other Spanish culture or origin, regardless of race. This is represented with a “1” for yes or “0” for no.

HISP_LAT_OTHER

Indexed - no
Format – varchar2( 100 char)
May be null? Yes

Represents the subcategory of “Other” found within the ethnicity category of “Hispanic or Latino (including Spain)”. This is represented with a “1” for yes or “0” for no.

HISP_LAT_PUERTO_RICO

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Puerto Rico” found within the ethnicity category of “Hispanic or Latino (including Spain)”. This is represented with a “1” for yes or “0” for no.

HISP_LAT_SOUTH_AMERICA

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “South America (excluding Brazil)” found within the ethnicity category of “Hispanic or Latino (including Spain)”. This is represented with a “1” for yes or “0” for no.

HISP_LAT_SPAIN

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Spain” found within the ethnicity category of “Hispanic or Latino (including Spain)”. This is represented with a “1” for yes or “0” for no.

PAC_ISL

Indexed - no
Format – integer
May be null? Yes

Indicates the primary race category of “Native Hawaiian or Other Pacific Islander (Original Peoples)” and denotes an individual having origins in any of the original peoples of Hawaii, Guam, Samoa, or other Pacific Islands. This is represented with a “1” for yes or “0” for no.

PAC_ISL_GUAM

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Guam” found within the race category of “Native Hawaiian or Other Pacific Islander (Original Peoples)”. This is represented with a “1” for yes or “0” for no.

 

PAC_ISL_HAWAII

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Hawaii” found within the race category of “Native Hawaiian or Other Pacific Islander (Original Peoples)”. This is represented with a “1” for yes or “0” for no.

PAC_ISL_OTHER

Indexed - no
Format – varchar2( 100 char)
May be null? Yes

Represents the subcategory of “Other Pacific Islands (excluding Philippines)” found within the race category of “Native Hawaiian or Other Pacific Islander (Original Peoples)”. This is represented with a “1” for yes or “0” for no.

PAC_ISL_SAMOA

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Samoa” found within the race category of “Native Hawaiian or Other Pacific Islander (Original Peoples)”. This is represented with a “1” for yes or “0” for no.

PENN_ID

Indexed - yes
Format – char (8 byte)
May be null? Yes

Denotes the 8-digit identification number assigned to an individual by the Penn Community system. For example: 77777777. No two persons have the same Penn ID. Note that Penn IDs created in and assigned by Penn Community begin at 10000000.

SRS_MAPPED_VALUE

Indexed - no
Format – varchar2( 1byte)
May be null? Yes

Denotes the single mapped value that is derived from the Penn People ethnicity/race categories and fed to SRS and subsequently to the Person_All_V.SRS_Ethnicity table in DWADMIN.


Values:

A - American Indian / Alaskan Native
B - Black, Non-Hispanic
C - White, Non-Hispanic
P - Native Hawaiian / Other Pacific Islander
R – Asian or Pacific Islander
S - Hispanic
Z - Multiple ethnicity/race (this does not represent the methodology used for Federal reporting purposes)

STUDENT_FLAG

Indexed - yes
Format – char (1 char)
May be null? Yes

Denotes an individual who can be found in the Person_All_V table in DWADMIN and is represented by a “1” for yes and “0” for no.

WHITE

Indexed - no
Format – integer
May be null? Yes

Indicates the primary race category of “White (including Middle Eastern)” and denotes an individual having origins in any of the original peoples of Europe, the Middle East, or North Africa. This is represented with a “1” for yes or “0” for no.

WHITE_EUROPE

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Europe” found within the race category of “White (including Middle Eastern)”. This is represented with a “1” for yes or “0” for no.

WHITE_MIDDLE_EAST

Indexed - no
Format – integer
May be null? Yes

Represents the subcategory of “Middle East” found within the race category of “White (including Middle Eastern)”. This is represented with a “1” for yes or “0” for no.

WHITE_OTHER

Indexed - no
Format – varchar2 (100 char)
May be null? Yes

Represents the subcategory of “Other” found within the race category of “White (including Middle Eastern)”. This is represented with a “1” for yes or “0” for no.


RACE_ETHNICITY_SURVEY_FLAT Table     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