input_layer__immunization
Immunizations as received, in the source's own vaccine coding system.
At a glance
| Schema | dax_input_layer |
| Table | input_layer__immunization |
| Layer | Input Layer |
| Object type | view |
| Columns | 18 |
| Grain | immunization_id, data_source |
| Tags | input_layer |
Columns
| Column | Type | Key | Constraints | Description |
|---|---|---|---|---|
immunization_id | varchar | PK | — | — |
person_id | varchar | — | — | |
patient_id | varchar | — | — | |
encounter_id | varchar | — | — | |
source_code_type | varchar | — | — | |
source_code | varchar | — | — | |
source_description | varchar | — | — | |
status | varchar | — | — | |
status_reason | varchar | — | — | |
occurrence_date | date | — | — | |
source_dose | varchar | — | — | |
lot_number | varchar | — | — | |
body_site | varchar | — | — | |
route | varchar | — | — | |
location_id | varchar | — | — | |
practitioner_id | varchar | — | — | |
ingest_datetime | timestamp | — | — | |
data_source | varchar | PK | — | — |
Querying
select *
from dax_input_layer.input_layer__immunization
limit 100;