The Hierarchical Condition Categories (HCC) Analytics bundle contains data used in the Oracle Health Data Intelligence Hierarchical Condition Categories solution.
| Property | Value |
|---|---|
| Header Record | Yes |
| Field Delimiter | Comma |
| Record Delimiter | CR/LF |
| Character Encoding | UTF-8 |
| File Name | File Description |
|---|---|
| PH_F_HCC_Diagnosis_Persistence | This table contains information about the people, conditions, and states of those who qualify for HCC calculations. The table provides the HCC grouper, state, and when the person qualified (and satisfied, if applicable) for people who have past, or persisted, conditions documented. |
| PH_F_HCC_Suspected_Covariate_Data | This table contains information about the covariate data. |
| PH_F_HCC_Suspected_Data_Point | This table contains information about the suspected data points. |
| PH_F_HCC_Suspected_Outcome | This table contains information about the suspected HCC outcomes. |
| PH_F_HCC_Outcome_Change | This table contains the changes in the HCC outcomes. |
| PH_F_HCC_Raf_Output_Calculated_Risk_Score | This table contains the calculated risk score. |
| PH_F_HCC_Raf_Output_Calculated_Risk_Score_Covariate | This table contains the calculated covariate risk score. |
| PH_F_HCC_Raf_Output_Calculated_Risk_Score_Covariate_Supporting_Data | This table contains the calculated covariate risk score and supporting facts. |
| Fields | Data Type | Description |
|---|---|---|
| administratively_validated | boolean | Indicates if the condition has been validated through the use of the appropriate CPT code. |
| claim_service_line_number | int | Claim line number related to the condition |
| claim_uid | varchar(200) | A unique ID of the claim, that typically consists of the partition ID of the data source, the person source ID, and the data source provided claim. |
| clinically_validated | boolean | This gives information on if the HCC diagnosis has been clinically validated. |
| condition_alias | varchar(200) | Alias representing the HCC that is persisted. |
| condition_effective_date_id | int | Numeric representation of the date of the condition that satisfies or qualifies the patient for the respective persisted HCC. |
| condition_effective_dt_tm | timestamptz | Date of the condition that satisfies or qualifies the patient for the respective persisted HCC. |
| condition_encounter_id | varchar(200) | The raw source encounter ID for the satisfying or qualifying condition. |
| condition_most_recent_visit_date_id | int | Numeric representation of the most recent date and time visit for the respective condition |
| condition_most_recent_visit_dt_tm | timestamptz | The most recent date and time visit for the respective condition |
| condition_raw_person_id | varchar(200) | The raw source person ID for the satisfying or qualifying condition |
| condition_type | varchar(30) | Used to determine whether the condition was qualifying or satisfying. |
| condition_uid | varchar(200) | The unique identifier of the condition, as represented on the ph_f_condition table. Typically a concatenation of the raw source id and the source partition identifier. |
| cpt_procedure_uid | varchar(200) | Procedure id related to the condition |
| empi_id | varchar(200) | A Cerner-derived unique member identifier that is used across all data sources. |
| is_trumped | boolean | Indicates if the HCC is trumped by another HCC. |
| part_key | int | This column is null and will not be of use. |
| persistence_status | varchar(200) | Used to determine whether the condition is fully validated or needs attention. |
| population_id | varchar(200) | The unique identifier of the populations for a client (ex: registries population, EDW population, etc.) |
| population_version | varchar(200) | The version of the population |
| qualifying_condition_period_end_date_id | int | The numeric representation of the end date of the qualifying period to identify a condition as being persisted. Typically at the end of the last calendar year. |
| qualifying_condition_period_end_dt_tm | timestamptz | The end date of the qualifying period to identify a condition as being persisted. Typically at the end of the last calendar year. |
| qualifying_condition_period_start_date_id | int | The numeric representation of the start date of the qualifying period to identify a condition as being persisted. Typically at the beginning of the last (or 2 years ago) calendar year. |
| qualifying_condition_period_start_dt_tm | timestamptz | The start date of the qualifying period to identify a condition as being persisted. Typically at the beginning of the last (or 2 years ago) calendar year. |
| satisfying_condition_period_end_date_id | int | The numeric representation of the end date of the satisfying period to identify a condition as being persisted. Typically at the end of the current calendar year. |
| satisfying_condition_period_end_dt_tm | timestamptz | The end date of the satisfying period to identify a condition as being persisted. Typically at the end of the current calendar year. |
| satisfying_condition_period_start_date_id | int | The numeric representation of the start date of the satisfying period to identify a condition as being persisted. Typically at the beginning of the current calendar year. |
| satisfying_condition_period_start_dt_tm | timestamptz | The start date of the satisfying period to identify a condition as being persisted. Typically at the beginning of the current calendar year. |
| source_type | varchar(200) | Source type from which the data came. |
| Fields | Data Type | Description |
|---|---|---|
| empi_id | varchar(200) | A Cerner-derived unique member identifier that is used across all data sources. |
| population_id | varchar(200) | The unique identifier of the populations for a client (ex: registries population, EDW population, etc.) |
| suspected_outcome_type | varchar(30) | The suspected outcome type |
| condition_name | varchar(200) | The name of the suspected outcome |
| model_number | int | The model number |
| concept_alias | varchar(200) | The concept alias |
| supporting_suspected_covariate_data_id | varchar(200) | The ID for the supporting data |
| competing_suspected_covariate_data_id | varchar(200) | The ID for the competing data |
| stratification | varchar(200) | Indicates whether the person is Not Suspected, Suspected, Highly Suspected for the HCC. |
| condition_status | varchar(200) | The condition status of the suspected outcome |
| Fields | Data Type | Description |
|---|---|---|
| empi_id | varchar(200) | A Cerner-derived unique member identifier that is used across all data sources. |
| population_id | varchar(200) | The unique identifier of the populations for a client (ex: registries population, EDW population, etc.) |
| covariate_data_id | varchar(200) | The ID for the covariate data |
| covariate_name | varchar(200) | Name for the Covariate Risk score |
| numeric_value | float | Not applicable |
| supporting_data_point_model_type | varchar(200) | The model type of the supporting data point |
| supporting_data_point_model_uid | varchar(200) | The unique ID for the supporting data |
| supporting_data_point_claim_service_line_number | int | The service line on the claim for the supporting data point |
| supporting_data_point_numeric_value | float | Not applicable |
| additional_supporting_data_point_id | varchar(200) | The unique ID for the supporting data |
| numeric_value_modifier | varchar(200) | Not applicable |
| supporting_data_point_numeric_value_modifier | varchar(200) | The modifier to the numeric value |
| Fields | Data Type | Description |
|---|---|---|
| empi_id | varchar(200) | A Cerner-derived unique member identifier that is used across all data sources. |
| population_id | varchar(200) | The unique identifier of the populations for a client (ex: registries population, EDW population, etc.) |
| data_point_id | varchar(200) | The unique ID for the data point |
| model_type | varchar(30) | The suspected model type |
| model_uid | varchar(200) | The unique ID for the suspected model |
| claim_service_line_number | int | Claim line number related to the condition |
| numeric_value | float | Not applicable |
| numeric_value_modifier | varchar(200) | The modifier to the numeric value |
| Fields | Data Type | Description |
|---|---|---|
| population_id | varchar(200) | The unique identifier of the populations for a client (ex: registries population, EDW population, etc.) |
| empi_id | varchar(200) | A Cerner-derived unique member identifier that is used across all data sources. |
| processing_version | varchar(200) | The versioning number |
| update_dt_tm | timestamptz | The time the record was updated. |
| update_date_id | int | The ID for the updated date |
| Fields | Data Type | Description |
|---|---|---|
| population_id | varchar(200) | The unique identifier of the populations for a client (ex: registries population, EDW population, etc.) |
| empi_id | varchar(200) | A Cerner-derived unique member identifier that is used across all data sources. |
| risk_score_type | varchar(200) | The type of risk score that was calculated |
| risk_score_uid | varchar(200) | Unique ID for the Risk Score |
| risk_score_value | float | Value of the risk score |
| Fields | Data Type | Description |
|---|---|---|
| population_id | varchar(200) | The unique identifier of the populations for a client (ex: registries population, EDW population, etc.) |
| empi_id | varchar(200) | A Cerner-derived unique member identifier that is used across all data sources. |
| risk_score_uid | varchar(200) | Unique ID for the Risk Score |
| covariate_sequence | int | Sequence for the Risk Score |
| covariate_name | varchar(200) | Name for the Covariate Risk score |
| covariate_value | varchar(200) | Value of the risk score |
| Fields | Data Type | Description |
|---|---|---|
| population_id | varchar(200) | The unique identifier of the populations for a client (ex: registries population, EDW population, etc.) |
| empi_id | varchar(200) | A Cerner-derived unique member identifier that is used across all data sources. |
| supporting_data_uid | varchar(200) | The unique ID for the supporting data |
| covariate_sequence | int | Sequence for the Risk Score |
| covariate_name | varchar(200) | Name for the Covariate Risk score |
| type | varchar(200) | The type of risk score that was calculated |
| concept_aliases | varchar(200) | The concept alias |
| standard_coding_system_id | varchar(200) | ID of the standard coding system |
| standard_code_id | varchar(200) | Unique ID for the supporting fact code |
| primary_display | varchar(200) | Display of the supporting fact |
| raw_display | varchar(200) | Display of the supporting data received from the source. |
| risk_score_uid | varchar(200) | Unique ID for the Risk Score |