VA Ethnicity Race Code Updater

Contents

Report Description

This report updates the Virginia Ethnicity and Race Code field based on the student's values in the StudentRace table.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records

The report selects records to the [S_VA_STU_X]Virginia_Ethnicity_Race_Code table based on the following criteria:

Changes to the Ethnicity and Race Code field will be denoted by a green cell on the pdf output.
Student cannot be excluded from state reporting.
School cannot be excluded from state reporting.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Output File Name	VA_EthnicityAndRaceCode_Status.pdf
Category	Local Division Reporting
Select Schools	If run at the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report All Schools – Run the report for the entire district. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Students to Include	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria.

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Tablefor a definition of each column in the table.

Item	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	Student	The student's legal name. If the student's legal last and first names are unavailable then the student's name from the Student Demographics section is printed.	[StudentCoreFields]PSCore_Legal_Last_Name [StudentCoreFields]PSCore_Legal_First_Name [StudentCoreFields]PSCore_Legal_Middle_Name [Students]lastfirst	Alpha-numeric	135
2	Grade Level	Grade Level for the students current Enrollment.	[Students]Grade_level	Numeric	2
3	Ethnicity and Race Code (Existing)		[S_VA_STU_X]Virginia_Ethnicity_Race_Code	Numeric	10
4	Ethnicity and Race Code (Updated)	This data is located in [StudentRace]racecd and will auto update the Virginia_Ethnicity_Race_Code if there is a difference between the current data and the data in the student race table.	Derived from the [StudentRace]racecd auto updates the Virginia_Ethnicity_Race_Code	Numeric	3