Issue

When printing the Suspendable Offense Codes report, it indicates that code XX is not in the code table.

Cause

The code in the Suspendable Offense Code (SOC.CD) table was entered as ‘xx’ (lowercase), while the code in the Code (COD) table for Assertive Discipline (ADS.CD) table is ‘XX’ (uppercase).

Resolution

Run the following SQL query to identify the code in the Suspendable Offense Code (SOC) table:

SELECT *FROM SOC

WHERE CD = 'xx'

Run the following SQL query to update the code from lowercase ‘xx’ to uppercase ‘XX’:

UPDATE SOC SET CD = UPPER(CD)

WHERE CD = 'XX'