Issue

When running the Civil Rights Data Collection, the following error message was reported:

"Error Processing Totals for OFFN-3

Error Details: GetDataReader error - The multi-part identifier ‘STU.ID’ could not be bound.” 

Cause

The errors are related to the OFFN-3 category, which pertains to homicide incidents. The setup in the Codes tab under the Student Discipline section may be incomplete, specifically regarding the CRDC Code Type Homicide. If the CRDC Code Type Homicide does not have an Aeries Table, Field, and Code mapped, no data will be pulled for those offenses, leading to repeated errors across all schools in the district.

Resolution

Verify that the CRDC Code Type Homicide has an Aeries Table, Field, and Code mapped in the Codes tab under the Student Discipline section. If the Aeries Table, Field, and Code are blank, the field needs to be mapped to pull the necessary data.