Skip to main content

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
ColumnData TypeDescriptionTerminology

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
ColumnData TypeDescriptionTerminology

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
ColumnData TypeDescriptionTerminology

value sets

See the value set data dictionaries here.