In the past, the extended field RACE was not working. This is a workaround for the field to create one column that shows the Ethnicity/Race

For a Query that uses just the STU table:

LIST STU ID NM GN ETH (( IIF ( ETH = "Y", "HISPANIC",  IIF ( RC1 = 100 AND RC2 = " ", "100 - AMERICAN INDIAN", IIF ( RC1 >= 200 AND RC1 < 300 AND RC2 = " ", "200 - ASIAN", IIF ( RC1 >= 300 AND RC1 < 400 AND RC2 = " ", "300 - PACIFIC ISLANDER", IIF ( RC1 = 400 AND RC2 = " ", "400 - FILIPINO", IIF ( RC1 = 600 AND RC2 = " ", "600 - BLACK",  IIF ( RC1 = 700 AND RC2 = " ", "700 - WHITE", IIF ( RC1 = 999 AND RC2 = " ", "Intentionally Left Blank", IIF ( RC1 = " " AND RC2 = " ", "Unknown", "MULTI-ETHNIC" ) ) ) ) ) ) ) ) ) )) RC1  RC2 

For a Query that uses multiple tables:

LIST STU CSE STU.ID STU.NM STU.GR STU.GN (( IIF ( STU.ETH = "Y", "HISPANIC",  IIF ( STU.RC1 = 100 AND STU.RC2 = " ", "100 - AMERICAN INDIAN", IIF ( STU.RC1 >= 200 AND STU.RC1 < 300 AND STU.RC2 = " ", "200 - ASIAN", IIF ( STU.RC1 >= 300 AND STU.RC1 < 400 AND STU.RC2 = " ", "300 - PACIFIC ISLANDER", IIF ( STU.RC1 = 400 AND STU.RC2 = " ", "400 - FILIPINO", IIF ( STU.RC1 = 600 AND STU.RC2 = " ", "600 - BLACK",  IIF ( STU.RC1 = 700 AND STU.RC2 = " ", "700 - WHITE", IIF ( STU.RC1 = 999 AND STU.RC2 = " ", "Intentionally Left Blank", IIF ( STU.RC1 = " " AND STU.RC2 = " ", "Unknown", "MULTI-ETHNIC" )  ) ) ) ) ) ) ) ) )) STU.RC1  STU.RC2 CSE.DI CSE.XD  

Ethnic/Race Codes 

HISPANIC OR LATINO 

700 - WHITE (NON-HISPANIC) 

100 - AMERICAN INDIAN - ALASKAN NATIVE (NON-HISPANIC) 

200 - ASIAN (NON-HISPANIC)

300 - PACIFIC ISLANDER (NON-HISPANIC) 

400 - FILIPINO (NON-HISPANIC) 

600 - BLACK (NON-HISPANIC) 

MULTI-ETHNIC (NON-HISPANIC) 

If RC1 and RC2 Are blank - Unknown (NON-HISPANIC)