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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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)

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.

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.

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.

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.

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.

Indexed - no
Format – integer
May be null? Yes

Indicates (with a value of "1") that the individual did not respond at all (neither yes nor no) to the primary ethnicity category of “Hispanic or Latino (including Spain)”.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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)

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.

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.

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.

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.

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.