input_layer__condition

Conditions as received, from both claim diagnoses and clinical problem lists, in the source's own coding system. Terminology normalization happens downstream.

At a glance

Schema	dax_input_layer
Table	input_layer__condition
Layer	Input Layer
Object type	view
Columns	16
Grain	source_condition_id, data_source
Tags	input_layer

Columns

Column	Type	Key	Constraints	Description
source_condition_id	varchar	PK	—	—
person_id	varchar		—	—
patient_id	varchar		—	—
encounter_id	varchar		—	—
recorded_date	date		—	—
onset_date	date		—	—
resolved_date	date		—	—
status	varchar		—	—
condition_type	varchar		—	—
code_system	varchar		—	—
source_code	varchar		—	—
source_description	varchar		—	—
condition_rank	integer		—	—
present_on_admit_code	varchar		—	—
ingest_datetime	timestamp		—	—
data_source	varchar	PK	—	—

Querying

select *
from dax_input_layer.input_layer__condition
limit 100;