immunization

One row per immunization recorded by a clinical source, with source and normalized vaccine codes.

At a glance

Schema	dax_core
Table	immunization
Layer	Core Data Model
Object type	table
Columns	23
Grain	immunization_id, data_source
Tags	core

Columns

Column	Type	Key	Terminology	Constraints	Description
immunization_id	varchar	PK	—	not null	—
person_id	varchar		—	not null	—
patient_id	varchar		—	—	—
encounter_id	varchar		—	—	—
source_code_type	varchar		Code type	—	—
source_code	varchar		Cvx	—	—
source_description	varchar		—	—	—
normalized_code_type	varchar		Code type	—	—
normalized_code	varchar		Cvx	—	—
normalized_description	varchar		—	—	—
status	varchar		—	—	—
status_reason	varchar		—	—	—
occurrence_date	date		—	—	—
source_dose	varchar		—	—	—
normalized_dose	varchar		—	—	—
lot_number	varchar		—	—	—
body_site	varchar		—	—	—
route	varchar		—	—	—
location_id	varchar		—	—	—
practitioner_id	varchar		—	—	—
ingest_datetime	timestamp		—	—	—
dax_last_run	timestamp		—	—	—
data_source	varchar	PK	—	not null	—

Querying

select *
from dax_core.immunization
limit 100;