input_layer__patient
The demographic contract for clinical source systems. A connector maps each source's patient records onto this shape, preserving the source system's own identifier in patient_id while person_id carries the stable identifier used across the warehouse. One person can appear several times here — once per source identifier — which is expected at this layer and resolved downstream.
At a glance
| Schema | dax_input_layer |
| Table | input_layer__patient |
| Layer | Input Layer |
| Object type | view |
| Columns | 24 |
| Grain | person_id, patient_id, data_source |
| Tags | input_layer |
Columns
| Column | Type | Key | Constraints | Description |
|---|---|---|---|---|
person_id | varchar | PK | — | — |
patient_id | varchar | PK | — | — |
first_name | varchar | — | — | |
middle_name | varchar | — | — | |
last_name | varchar | — | — | |
name_suffix | varchar | — | — | |
sex | varchar | — | — | |
race | varchar | — | — | |
ethnicity | varchar | — | — | |
birth_date | date | — | — | |
death_date | date | — | — | |
death_flag | integer | — | — | |
social_security_number | varchar | — | — | |
address | varchar | — | — | |
city | varchar | — | — | |
state | varchar | — | — | |
zip_code | varchar | — | — | |
county | varchar | — | — | |
latitude | float | — | — | |
longitude | float | — | — | |
phone | varchar | — | — | |
email | varchar | — | — | |
ingest_datetime | timestamp | — | — | |
data_source | varchar | PK | — | — |
Querying
select *
from dax_input_layer.input_layer__patient
limit 100;