Issue

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

"Error Processing Totals for OFFN-2

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

Cause

The errors are related to the OFFN-2 category, which pertains to firearms or explosive device incidents. The setup in the Codes tab under the Student Discipline section may be incomplete, specifically regarding the CRDC Code Type Use of a firearm or explosive device. If the CRDC Code Type Use of a firearm or explosive device 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 Use of a firearm or explosive device 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.