NAV Navbar
Logo cerner

Hierarchical Condition Categories Analytics Schema v1

Overview

The Hierarchical Condition Categories (HCC) Analytics bundle contains data used in the HealtheIntent Hierarchical Condition Categories solution.

Character Separated Values (CSV) Properties

Property Value
Header Record Yes
Field Delimiter Comma
Record Delimiter CR/LF
Character Encoding UTF-8

Files

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.

Field Definitions

PH_F_HCC_Diagnosis_Persistence

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.

PH_F_HCC_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.)
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

PH_F_HCC_Suspected_Covariate_Data

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

PH_F_HCC_Suspected_Data_Point

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

PH_F_HCC_Outcome_Change

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

PH_F_HCC_Raf_Output_Calculated_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_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

PH_F_HCC_Raf_Output_Calculated_Risk_Score_Covariate

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

PH_F_HCC_Raf_Output_Calculated_Risk_Score_Covariate_Supporting_Data

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