Skip to main content
Skip table of contents

Staff Ethnicity/Race Code Update


This report calculates and updates the proprietary Massachusetts Ethnicity and Race Code (MA ER Code) for staff members based on each staff member's Federal race and ethnicity settings. This functionality was previously part of the SIMS Student Data Update Report but is now incorporated into a new staff only standalone report. The MA ER Code calculation for students remains in the SIMS Student Data Update Report. The report outputs a tab delimited file that indicates which staff records were updated with a recalculated value and displays the previous and new values when applicable.

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.

Staff Selection

  • The report includes all staff members in the district or only those staff members included in the current selection depending upon the value set for the Select Staff parameter on the report run page.

Report Input

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



Selected Staff

Indicate which staff records to include in the report by selecting one of the following options:

  • The Selected (N) Staff Only – Run the report for only the staff in the current selection.
  • All Staff – Run the report for all staff in the district.

Note: If running the report for a single staff, or group of staff, select the records prior to running report.

Report Output

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

Item #

Data Element



Field Type

Field Length


School Staff ID

The ID of the staff member's home school record in the SchoolStaff table.





User Last First

The staff member's first and last name in Last, First order.





Original ER Code

The original value of the Massachusetts ER Code prior to recalculation.





Field Updated?

Indicates whether or not the ER Code was recalculated and the database field updated. (Yes or No)

Derived as Yes or No based on the value of the recalculated ER Code when compared to the original value.




Update ER Code

The recalculated value of the Massachusetts ER Code based on the updated Federal race and ethnicity settings.

Calculated. Blank if the recalculated value is the same as the original value or becomes the new value for [S_MA_USR_X]EthnicityRaceCode



Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.