ccsprofile
The cssprofile table represents a roll-up of all diagnosis data for a person from all data sources into CCSR diagnosis groups as specified by the AHRQ HCUP CCSR (Clinical Classifications Software Refined) tool.
Each row in the table summarizes one CCSR diagnosis that has been coded for a person at any time in their health history. Columns describe the first detected diagnosis for the condition and the date of the most recent diagnosis.
This table is similar to the hccprofile table in structure and intended use. However, while HCCs (which define the rows in the hccprofile table) are related to a small set of ICD diagnoses codes determined to be drivers of financial risk (the HCC RAPS score was developed to predict prospective cost), CCSR diagnosis groups cover the vast majority of diagnoses specified by ICD9/10.
A patient that does not have ICD10 or ICD9 coded diagnoses will have zero rows in this table.
See also: Condition Profiles and Risk Score
Usage
This table is useful to understand the overall disease load of a person or population. It can be used to construct disease registries, break down utilization by specified sets of conditions, or identify patients with multiple chronic conditions.
Use the personccs table for a pivoted representation of ccsprofiles. In this table, each row represents a person with a column for each CCS category.
Use the hccprofile table for a similarly structured representation of a person’s conditions using the CMS RAPS risk adjustment algorithm.
Source Concepts
- HIEBus problem (encounter)
- HIEBus claimproblem (claim)
Table Schema
| Name | Type | Description |
|---|---|---|
| personid | VARCHAR (GUID) |
Unique identifier representing a unique person that may include data from several sources that have been linked. This identifier is the person_id of a HIEBus recordgroup. |
| categoryid | INTEGER |
The number of the CCSR category. |
| category | VARCHAR |
The name of the CCSR category. |
| mostrecentevent | TIMESTAMP |
The date (in any care setting; from EHR or claims data) of the most recent ICD9 or ICD10 code related to the HCC for the personid. |
| firstevent | TIMESTAMP |
The date (in any care setting; from EHR or claims data) of the earliest ICD9 or ICD10 code related to the HCC for the personid. |
| ischronic | BOOLEAN |
TRUE if one or more of the the historical diagnoses (from any source and any date) is tagged Chronic by the HCUP Chronic Condition Indicator algorightm, described here. |
