practitioner
One row per practitioner, keyed by NPI where available, with specialty and name attributes. Join from the provider identifier columns on encounter, procedure and the claim tables.
At a glance
| Schema | dax_core |
| Table | practitioner |
| Layer | Core Data Model |
| Object type | table |
| Columns | 10 |
| Grain | practitioner_id, data_source |
| Tags | core |
Columns
| Column | Type | Key | Terminology | Constraints | Description |
|---|---|---|---|---|---|
practitioner_id | varchar | PK | — | not null | — |
npi | varchar | Provider | — | — | |
first_name | varchar | — | — | — | |
last_name | varchar | — | — | — | |
practice_affiliation | varchar | — | — | — | |
specialty | varchar | — | — | — | |
sub_specialty | varchar | — | — | — | |
ingest_datetime | timestamp | — | — | — | |
dax_last_run | timestamp | — | — | — | |
data_source | varchar | PK | — | not null | — |
Querying
select *
from dax_core.practitioner
limit 100;