condition

One row per recorded condition, from both claims diagnoses and clinical problem lists. Source codes are preserved alongside normalized codes and a condition_family/condition_name grouping, so you can query at whichever level of specificity your measure needs.

At a glance

Schema	dax_core
Table	condition
Layer	Core Data Model
Object type	table
Columns	26
Grain	condition_id
Tags	core

Columns

Column	Type	Key	Terminology	Constraints	Description
condition_id	varchar	PK	—	not null	Dax identifier for the condition record.
source_condition_id	varchar		—	—	—
person_id	varchar		—	not null	The individual the condition was recorded for.
member_id	varchar		—	—	—
patient_id	varchar		—	—	—
encounter_id	varchar		—	—	Encounter during which the condition was recorded, where known.
claim_id	varchar		—	—	Claim the diagnosis came from, for claims-derived conditions.
payer	varchar		—	—	—
recorded_date	date		—	—	Date the condition was recorded.
onset_date	date		—	—	Date of onset where reported.
resolved_date	date		—	—	Date the condition was resolved where reported.
status	varchar		—	—	Status of the condition, for example active or resolved.
condition_type	varchar		—	—	Whether the record came from a claim diagnosis or a problem list.
code_system	varchar		Code type	—	Coding system of source_code.
source_code	varchar		ICD-10-CM	—	Condition code exactly as it arrived from the source.
source_description	varchar		—	—	—
normalized_code	varchar		ICD-10-CM	—	Condition code after terminology normalization.
normalized_description	varchar		—	—	—
condition_family	varchar		—	—	Broad grouping of the normalized condition.
condition_name	varchar		—	—	Human-readable name of the normalized condition.
condition_rank	integer		—	—	Ordering of diagnoses on a claim. Rank 1 is the principal diagnosis.
present_on_admit_code	varchar		Present on admission	—	Whether the condition was present on admission.
present_on_admit_description	varchar		—	—	—
ingest_datetime	timestamp		—	—	—
dax_last_run	timestamp		—	—	Timestamp of the warehouse build that produced this row.
data_source	varchar		—	not null	Label for the contributing system.

Querying

select *
from dax_core.condition
limit 100;