CCSR
The CCSR data mart implements the HCUP Clinical Classification Software Refined diagnosis and procedure groupers. You can read more about this grouper here. HCUP provides a distribution of the algorithm in SAS. This is an exact copy of the that version that runs using dbt.
long_condition_category
This model contains a mapping of individual condition ICD-10-CM diagnosis codes to the CCSR's clinically meaningful diagnosis categories. Each row represents a mapping of an ICD-10 code to a CCSR category. As each ICD-10 code may be mapped to up to 6 categories, it's expected that this table will output as many or more rows than the Tuva condition model. The model is equivalent to the CCSR's Output Option 1 - Vertical File Output.
Primary Keys:
- patient_id
- normalized_code
- ccsr_category
Foreign Keys:
- encounter_id
- claim_id
| Column | Data Type | Description | Terminology |
|---|
long_procedure_category
This model contains a mapping of individual condition ICD-10-PCS procedure codes to the CCSR's clinically meaningful procedure categories. Each row represents a mapping of an ICD-10 code to a CCSR category. The model is equivalent to the CCSR's Output Option 1 - Vertical File Output.
Primary Keys:
- patient_id
- normalized_code
- ccsr_category
Foreign Keys:
- encounter_id
| Column | Data Type | Description | Terminology |
|---|
singular_condition_category
This model contains only the CCSR's default category assignment for the
ICD-10 code, and only for the first-listed ICD-10 code (diagnosis_code = 1).
Primary Keys:
- patient_id
- ccsr_category
Foreign Keys:
- encounter_id
- claim_id
| Column | Data Type | Description | Terminology |
|---|
value sets
See the value set data dictionaries here.