Core 5.2 Model | Unified | condition

condition

The condition table is related to the Condition resource that is available via the CareEvolution FHIR API.
Conditions are diagnoses, problems, or diseases recorded by a clinician or documented to support the payment information managed by a claim.
The condition table combines all diagnoses data from all HIEBus data sources (clinical and claims-based) for a HIEBus person (recordgroup) into a consolidated structure.
Conditions are not reconciled in this table. If an event is documented by two data sources (i.e. related clinical and claims systems), the diagnoses for this event will be duplicated in this table. This table includes columns to trace rows to their underlying data source.
Conditions are annotated with computed columns that can be used to roll up the detailed codes (commonly ICD-10) into higher order representations of conditions such as: Hierarchical Condition Categories (HCCs) and Condition Categories (HCUP CCSR).

Additional References:

Overview of the Unified Model
Using Terminology Concepts Mapped By Rosetta for columns represented with Rosetta-mapped terms.
Galileo Encounter Reconciliation for computed columns related to primary care setting.
Refer to the associated encounter or the claim on which the diagnosis was documented.

Table Schema

Name	Type	Description
personid	VARCHAR	GUID. An internal 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.
conditionid	VARCHAR	GUID. An internal identifier representing a unique `condition`. This identifier is the id of the row in the HIEBus source tables.
code	VARCHAR	Mapped by Rosetta. The prioritized mapped terminology code determined to represent the diagnosis. The default prioritization is by code system: ICD-10-CM, SNOMED, ICD-9-CM. The code sent by data source will be used if no mappings are available.
display	VARCHAR	Mapped by Rosetta. The description associated with the code column.
codesystem	VARCHAR	Mapped by Rosetta. The terminology namespace of the code column.
termid	INTEGER	A HIEBus terminology id. Reference to the original primary term (usually from a data source namespace) received by HIEBus that can be used to show the original code or relate to alternative mappings.
alternatetermids	VARCHAR	A comma delimited list of termids (usually from a data source namespace) that provides supplemental terms received from the data source to represent the diagnosis.
icd10code	VARCHAR	Mapped by Rosetta. If available, the ICD10 code mapped from the original primary term or alternate terms.
icd10display	VARCHAR	Mapped by Rosetta. If available, the ICD10 description associated with the icd10code column.
snomedcode	VARCHAR	Mapped by Rosetta. If available, the SNOMED code mapped from the original primary term or alternate terms.
snomeddisplay	VARCHAR	Mapped by Rosetta. If available, the SNOMED description associated with the snomedcode column.
icd9code	VARCHAR	Mapped by Rosetta. If available, the ICD9 code mapped from the original primary term or alternate terms.
icd9display	VARCHAR	Mapped by Rosetta. If available, the ICD9 description associated with the icd9code column.
asserteddate	TIMESTAMP	The date the diagnosis was documented.
stopdate	TIMESTAMP	The date the diagnosis was no longer active.
encounterid	VARCHAR	GUID. Source `encounter`, if determined from an encounter-based data source.
claimid	VARCHAR	GUID. Source `claim`, if determined from an claim-based data source.
datasource	VARCHAR	The name of the data source. Commonly determined from the HIEBus record authority name of the source patient record.
sourcecodesystem	VARCHAR	The terminology namespace of the original primary term that was sent by the data source.
itemsequence	INTEGER	The sequence assigned by to the condition by the source system. Used to compute the `isprimary` column.
type	VARCHAR	Mapped by Rosetta. Type of diagnosis. This is the preferred mapped concept determined by the Rosetta Terminology Service.
typecode	VARCHAR	Mapped by Rosetta. Coded Value. Type of diagnosis. Used to compute the isprimary column. This is the preferred mapped concept determined by the Rosetta Terminology Service.
typetermid	INTEGER	Reference to HIEBus terminology id that specifies the type of diagnosis.
primarycaresetting	VARCHAR	Computed. A normalized description of the place of service in which the diagnoses was recorded. This property is copied from the related `encounter` or `claim`.
hcc	INTEGER	Computed. The number of the related Hierarchical Condition Category.
hccdescription	VARCHAR	Computed. The description of the related Hierarchical Condition Category.
ccscategory	VARCHAR	Computed. The identifier of the related CCSR condition category.
ccsdescription	VARCHAR	Computed. The description of the related CCSR condition category.
ischronic	BOOLEAN	Computed. TRUE if the condition is tagged Chronic by the HCUP Chronic Condition Indicator algorithm, described here.
isprimary	BOOLEAN	Computed. TRUE if the condition is the primary diagnosis for the related encounter or claim. Computed using the itemsequence and typecode columns. Exactly one condition will be set isprimary=TRUE for a given `encounterid` or `claimid`.
annotations	VARCHAR	Computed. A comma delimited set of strings that represent computed features of the condition.
lastupdated	TIMESTAMP	System generated timestamp indicating the most recent change to this data row. Used for differential operations. Managed in UTC.

Back to Tables