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 RACE (( 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" OR RC1 = "ZZZ" ) AND RC2 = " ", "Intentionally Left Blank", IIF ( RC1 = " " AND RC2 = " ", "Unknown", "MULTI-ETHNIC" )  ) ) ) ) ) ) ) ) )) RC1  RC2 


For a Query that uses multiple tables: ( This query includes Enrollment. Change the X to the current year.)

LIST STU ENR STU.ID STU.NM STU.GN STU.ETH RACE (( IIF ( 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" OR STU.RC1 = "ZZZ" ) AND STU.RC2 = " ", "Intentionally Left Blank", IIF ( STU.RC1 = " " AND STU.RC2 = " ", "Unknown", "MULTI-ETHNIC" )  ) ) ) ) ) ) ) ) )) STU.RC1  STU.RC2 ENR.YR ENR.ED ENR.LD IF ENR.YR = 202X



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) 

900 or ZZZ - Intentionally Left Blank

MULTI-ETHNIC (NON-HISPANIC) 

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



NOTE: Change the 999 or ZZZ to the district's Intentionally Left Blank if using something other than 999 or ZZZ.