int_patient_remove_duplicates
:::caution Internal model This is an intermediate/staging model used to build the query surface. It is documented for lineage and debugging. Its shape may change between releases, so avoid building reports directly on it. :::
At a glance
| Schema | dax_core |
| Table | int_patient_remove_duplicates |
| Layer | Core Data Model |
| Object type | table |
| Columns | 25 |
| Grain | person_id, data_source |
| Tags | core, core_stage_clinical |
Columns
| Column | Type | Key | Constraints | Description |
|---|---|---|---|---|
person_id | — | PK | — | — |
patient_id | — | — | — | |
first_name | — | — | — | |
middle_name | — | — | — | |
last_name | — | — | — | |
name_suffix | — | — | — | |
sex | — | — | — | |
race | — | — | — | |
ethnicity | — | — | — | |
birth_date | — | — | — | |
death_date | — | — | — | |
death_flag | — | — | — | |
social_security_number | — | — | — | |
address | — | — | — | |
city | — | — | — | |
state | — | — | — | |
zip_code | — | — | — | |
county | — | — | — | |
latitude | — | — | — | |
longitude | — | — | — | |
phone | — | — | — | |
email | — | — | — | |
ingest_datetime | — | — | — | |
dax_last_run | — | — | — | |
data_source | — | PK | — | — |
Querying
select *
from dax_core.int_patient_remove_duplicates
limit 100;