01Relates to the patient
reference data (no patient link)
Single-patient export: not included (not referenced by patient records).
02References
DIAG_CLASS→DIAG_CLASSES.DIAG_CLASSDIAG_CODE_ICD9→DIAGNOSIS_CODES.DIAG_CODE
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | DIAG_CODE PK | string | varchar(8) | no | |
| 2 | DIAG_DESCRIPTION | string | varchar(80) | yes | |
| 3 | DIAG_ACTIVE | string | char(1) | yes | |
| 4 | DIAG_SENSITIVE | string | char(1) | yes | |
| 5 | DSM_AXIS_1 | boolean | bit | yes | |
| 6 | DSM_AXIS_2 | boolean | bit | yes | |
| 7 | DSM_AXIS_3 | boolean | bit | yes | |
| 8 | DSM_DESCRIPTION | string | varchar(200) | yes | |
| 9 | DIAG_CLASS | string | varchar(15) | yes | |
| 10 | ICD10 | boolean | bit | no | |
| 11 | LONG_DESCRIPTION | string | varchar(500) | yes | |
| 12 | DIAG_CODE_ICD9 | string | varchar(8) | yes |