There's a list of these codes here on the T10.org website under the page titled: SCSI ASC/ASCQ Assignments.
This page also describes their purpose, titled: SCSI Additional Sense Data.
SCSI Additional Sense Data takes the form of two value encoded bytes in the sense data, typically returned by the REQUEST SENSE command. The additional sense code (ASC) byte indicates information about the error exception reported in the sense key field. The additional sense code qualifier (ASCQ) indicates detailed information related to the additional sense code. See the clause describing the REQUEST SENSE command in the SCSI Primary Commands - 4 (SPC-4) draft standard (or later) for more information about sense data.
Descriptions of the assigned ASC and ASCQ values and their coded meanings are organized in tables that are sorted numerically based on the ASC/ASCQ values or alphabetically based on the text describing the error or exception indicated by the ASC/ASCQ pair. An explanation of the ASC/ASCQ table format is available if you are unfamiliar with these tables.
Additionally I'd take a look at the Wikipedia page topic titled: Key Code Qualifier, which had this to say about these codes.
Key Code Qualifier is an error-code returned by a SCSI device.
When a SCSI target device returns a check condition in response to a command, the initiator usually then issues a SCSI Request Sense command. This process is part of a SCSI protocol called Contingent Allegiance Condition. The target will respond to the Request Sense command with a set of SCSI sense data which includes three fields giving increasing levels of detail about the error:
- K - sense key - 4 bits, (byte 2 of Fixed sense data format)
- C - additional sense code (ASC) - 8 bits, (byte 12 of Fixed sense data format)
- Q - additional sense code qualifier (ASCQ) - 8 bits, (byte 13 of Fixed sense data format)
The initiator can take action based on just the K field which indicates if the error is minor or major. However all three fields are usually logically combined into a 20 bit field called Key Code Qualifier or KCQ. The specification for the target device will define the list of possible KCQ values. In practice there are many KCQ values which are common between different SCSI device types and different SCSI device vendors. Common values are listed below, you should consult your hardware specific documentation as well.