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.