• Elements

  • Element: IPEDS_RACE_ETHNIC_CD - 02080

Page Name

IPEDS Race Ethnicity Code



The IPEDS race ethincity code is program generated based on the following:

    -IF NON_RES_ALIEN_FLG = 'Y' THEN IPEDS_RACE_ETHNIC_CD = '1'
    -IF HISPANIC_FLG = 'Y' THEN IPEDS_RACE_ETHNIC_CD = '2'
    -IF NO_RACE_REPORT_FLG = 'Y' THEN IPEDS_RACE_ETHNIC_CD = '9'

ONLY if NONE of the above is set to 'Y':
    -IF AM_IND_ALASKAN_FLG = 'Y' THEN IPEDS_RACE_ETHNIC_CD = '3'
    -IF ASIAN_FLG = 'Y' THEN IPEDS_RACE_ETHNIC_CD = '4'
    -IF BLACK_AFRICAN_AM_FLG = 'Y' THEN IPEDS_RACE_ETHNIC_CD = '5'
    -IF NAT_HAWAII_PAC_IS_FLG = 'Y' THEN IPDEDS_RACE_ETHNIC_CD = '6'
    -IF WHITE_FLG = 'Y' THEN IPEDS_RACE_ETHNIC_CD = '7'
    -IF 2 OR MORE OF THE RACE FLAGS = 'Y' THEN IPEDS_RACE_ETHNIC_CD = '8'

ELEMENT

201005

28-MAY-2013


Associated Submissions, Tables, and Columns

SubmissionAscendingTable NameColumn nameElement IDTab column idTable idSubmission name
Admissions (ADM)PERSON_DEMO (DEMO)IPEDS_RACE_ETHNIC_CD57529591Admissions
College Prep (CP)PERSON_DEMO (DEMO)IPEDS_RACE_ETHNIC_CD57529591College Prep
College Prep Completions (CPC)PERSON_DEMO (DEMO)IPEDS_RACE_ETHNIC_CD57529591College Prep Completions
Degrees Awarded (SIFD)PERSON_DEMO (DEMO)IPEDS_RACE_ETHNIC_CD57529591Degrees Awarded
Hours to Degree (HTD)PERSON_DEMO (DEMO)IPEDS_RACE_ETHNIC_CD57529591Hours to Degree
Instruction & Research (IRD)PERSON_DEMO (DEMO)IPEDS_RACE_ETHNIC_CD57529591Instruction & Research
Instruction & Research (IRD)WORKLOAD_PERSON_FUNDING (WKPF)IPEDS_RACE_ETHNIC_CD575547326Instruction & Research
Limited Access Programs (LAP)PERSON_DEMO (DEMO)IPEDS_RACE_ETHNIC_CD57529591Limited Access Programs
Retention (RET)PERSON_DEMO (DEMO)IPEDS_RACE_ETHNIC_CD57529591Retention
Salary Category Detail (SCD)EMPLOYEE_DEMO (EDEM)IPEDS_RACE_ETHNIC_CD575544429Salary Category Detail
  • 1 - 10

Allowed Values

Excel code
Code
Description
Grouping
'11Nonresident alien
Nonresident alien		-
'22Hispanic/Latino
Hispanic/Latino		-
'33American Indian or Alaska Native
American Indian or Alaska Native		-
'44Asian
Asian		-
'55Black or African American
Black or African American		-
'66Native Hawaiian or Other Pacific Islander
Native Hawaiian or Other Pacific Islander		-
'77White
White		-
'88Two or more races
Two or more races		-
'99Race and ethnicity unknown
Race and ethnicity unknown		-
Download

Edit Values

Submission CodeAscendingTable nameDiagnostic CodeDiagnostic MessageError LevelError Description
ADMPERSON_DEMO4293Frequency of Values for PERSON_DEMO.IPEDS_RACE_ETHNIC_CD0Frequency Distribution: not an indication of an error
ADMPERSON_DEMO6347Generates the IPDES Race Ethnicity Code1Generated or Modified during SUDS Edit Process
HTDPERSON_DEMO4293Frequency of Values for PERSON_DEMO.IPEDS_RACE_ETHNIC_CD0Frequency Distribution: not an indication of an error
HTDPERSON_DEMO6347Generates the IPDES Race Ethnicity Code1Generated or Modified during SUDS Edit Process
IRDWORKLOAD_PERSON_FUNDING4293Frequency of Values for PERSON_DEMO.IPEDS_RACE_ETHNIC_CD0Frequency Distribution: not an indication of an error
RETPERSON_DEMO4293Frequency of Values for PERSON_DEMO.IPEDS_RACE_ETHNIC_CD0Frequency Distribution: not an indication of an error
RETPERSON_DEMO6353Generates the IPDES Race Ethnicity Code1Generated or Modified during SUDS Edit Process
SFAPERSON_DEMO4293Frequency of Values for PERSON_DEMO.IPEDS_RACE_ETHNIC_CD0Frequency Distribution: not an indication of an error
SFAPERSON_DEMO6347Generates the IPDES Race Ethnicity Code1Generated or Modified during SUDS Edit Process
SIFPERSON_DEMO4293Frequency of Values for PERSON_DEMO.IPEDS_RACE_ETHNIC_CD0Frequency Distribution: not an indication of an error
SIFPERSON_DEMO6347Generates the IPDES Race Ethnicity Code1Generated or Modified during SUDS Edit Process
SIFDPERSON_DEMO4293Frequency of Values for PERSON_DEMO.IPEDS_RACE_ETHNIC_CD0Frequency Distribution: not an indication of an error
SIFDPERSON_DEMO6347Generates the IPDES Race Ethnicity Code1Generated or Modified during SUDS Edit Process
SIFPPERSON_DEMO4293Frequency of Values for PERSON_DEMO.IPEDS_RACE_ETHNIC_CD0Frequency Distribution: not an indication of an error
SIFPPERSON_DEMO6347Generates the IPDES Race Ethnicity Code1Generated or Modified during SUDS Edit Process
TEIPERSON_DEMO4293Frequency of Values for PERSON_DEMO.IPEDS_RACE_ETHNIC_CD0Frequency Distribution: not an indication of an error
TEIPERSON_DEMO6347Generates the IPDES Race Ethnicity Code1Generated or Modified during SUDS Edit Process
  • 1 - 17

Prior Database Information:

VARCHAR2(1)
IPEDS_CD
IPEDS_RACE_ETH_CD
Release 2.0