NSC Ethnic Race

Race and ethnic information is collected for reporting to various agencies including the National Student Clearinghouse (NSC). The Race/Ethnic column appears in a number of NSC report windows:

Collecting the Data

When you save the Ethnic/Race values, J1 calculates the value in the IPEDS column on the Ethnic/Race tab. These are the IPEDS Ethnic/Race definitions, and they can't be edited:

Mapping the Data to the NSC Codes

NSC has its own codes for race and ethnic information, and they're different from the IPEDS codes. Therefore, for reports to the NSC, the information in the Biograph table needs to be mapped to the NSC codes. You do the mapping on the using the NS11 Update Type.

NSC Ethnicity Race Code	Description	Mapping
"A" Nonresident Alien	A person who is not a US citizen or national, is in this country on a visa or temporary basis, and does not have the right to remain indefinitely	ETHNIC_RACE_REPORT.IPEDS_REPORT_VALUE = '1'
"AN" Asian	A person 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	ETHNIC_RACE_REPORT.IPEDS_REPORT_VALUE = '5' ('Native Asian / Pacific Islander' is a separate code.)
"B" Black, Non-Hispanic	A person having origins in any of the black racial groups of Africa (except those of Hispanic origin)	ETHNIC_RACE_REPORT.IPEDS_REPORT_VALUE = '6'
"IA" American Indian/Alaskan Native	A person having origins in any of the original peoples of North America and who maintain cultural identification through tribal affiliation or community recognition	ETHNIC_RACE_REPORT.IPEDS_REPORT_VALUE = '4'
"NP" Native Asian/Pacific Islander	A person having origins in any of the original peoples of the Far East, Southeast Asia, the Indian Subcontinent, or Pacific Islands. This includes people from China, Japan, Korea, the Philippine Islands, American Samoa, India, and Vietnam.	ETHNIC_RACE_REPORT.IPEDS_REPORT_VALUE = '5'
"H" Hispanic	A person of Mexican, Puerto Rican, Cuban, Central or South American, or other Spanish culture or origin, regardless of race.	ETHNIC_RACE_REPORT.IPEDS_REPORT_VALUE = '3'
"HP" Native Hawaiian or Other Pacific Islander	A person having origins in any of the original peoples of Hawaii, Guam, Samoa, or other Pacific Islands	ETHNIC_RACE_REPORT.IPEDS_REPORT_VALUE = '7'
"W" White, Non-Hispanic	A person having origins in any of the original peoples of Europe, North Africa, or the Middle East (except those of Hispanic origin)	ETHNIC_RACE_REPORT.IPEDS_REPORT_VALUE = '8'
"TM" Two or More Race/Ethnicity Categories	A person who claims to belong to two or more of the race/ethnicity categories	ETHNIC_RACE_REPORT.IPEDS_REPORT_VALUE = '9'
"U" Race/Ethnicity Unknown	A person whose race and ethnicity are not known If a student is not a US citizen, we report as Unknown.	ETHNIC_RACE_REPORT.IPEDS_REPORT_VALUE = '2'

Mapping the Difficult Values

The "NP" Native Asian/Pacific Island NSC value is an example of one that doesn't map cleanly to an IPEDS Ethnic/Race value. Your school must determine the data elements that you can use to associate a student with the NSC "NP" value.

In the example below, ELITE PAINT was used to display BIOGRAPH_MASTER.UDEF_2a_4 on the Student Information window to store an additional value.

How the Tables Are Populated

When you use the Create NSC Transmittal and Final Files window and click the Populate Transmittal Tables button, the data collection process runs all of the NSC Clearinghouse Data Update Rules and populates columns in the NSC Transmittal Detail window. That information is then used to populate the text file that you actually submit to the Clearinghouse.

How To

1. Open the Update Results and Rules window.

2. Select the update type.

a. In the Update Type/Code Selection group box, expand the NSC Clearinghouse Data Update Rules.

b. Select 'NS11 Clearinghouse Ethnicity and Race'.

3. Add the NSC codes.

a. On the Results Definition tab, select Add Row from the right-click options.

b. In the Resulting Code column, enter the NSC Ethnicity/Race code that applies to most students at your school.

c. Repeat steps 3.a and 3.b to add the other NSC Ethnicity/Race codes in descending order based on your student populations.
(Assigning the codes in this order saves processing time when you run the Rules Based Update process.)

4. For NSC values that map cleanly to IPEDS values, simply map the NSC values.

a. Select one of the codes you created.

b. Click the Results Rules Definition tab.

c. On Row 1, select or enter the values to retrieve the ID number of the student to process.

d. On Row 2, retrieve an IPEDS ethnic/race value.

e. On Rows 3 and 4, map to the NSC value.

Seq #	Rules Table/Column/Expression	Rules Operator	Rules Value/Expression	Logical AND/OR
1	namemaster.id_num	=	namemaster.id_num	AND
2	[the number code for one of the ethnicity codes you just defined]	=	(SELECT inv.ipeds_reort_value FROM ethnic_race_report inv WHERE inv.id_num =)	[blank]
3	namemaster.id_num	[blank]	AND inv.seq_num=(SELECT Max (seq_num) FROM ethnic_race_report	[blank]
4	[blank]	[blank]	WHERE id_num = namemaster.id_num))	[blank]

Example image

5. For NSC values (such as the "NP" value) that don't map cleanly to an IPEDS value, start with the UDEF column from the Student Information window.

Seq #	Rules Table/Column/Expression	Rules Operator	Rules Value/Expression	Logical AND/OR
1	biograph_master.udef_2a_4	=	"NP"	AND
2	namemaster.id_num	=	namemaster.id_num	AND
3	5	=	(SELECT inv.ipeds_report_value FROM ethnic_race_report inv WHERE inv.id_num =)	[blank]
4	namemaster.id_num	[blank]	AND inv.seq_num=(SELECT Max (seq_num) FROM ethnic_race_report	[blank]
5	[blank]	[blank]	WHERE id_num = namemaster.id_num))	[blank]

Example image

6. Click the Save button on the main toolbar.

Reporting Ethnic and Race Information to the NSC

Collecting the Data

Mapping the Data to the NSC Codes

Mapping the Difficult Values

How the Tables Are Populated

How To

Learn More