immunization_observation


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of immunization_observation.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Individual observations for a specific immunization

Columns

Column Type Size Nulls Auto Default Children Parents Comments
imo_id INT 10 √ null
imo_im_id INT 10 null
immunizations.id Defined in XML R

The immunization record this observation is part of
imo_pid INT 10 √ null
patient_data.pid Defined in XML R

The internal patient identifier
imo_criteria VARCHAR 255 √ null
imo_criteria_value VARCHAR 255 √ null
imo_user INT 10 √ null
users.id Defined in XML R

The user that is recording the observation for this immunization
imo_code VARCHAR 255 √ null
imo_codetext VARCHAR 255 √ null
imo_codetype VARCHAR 255 √ null
imo_vis_date_published DATE 10 √ null
imo_vis_date_presented DATE 10 √ null
imo_date_observation TIMESTAMP 19 current_timestamp()

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc imo_id

Relationships

Close relationships within degrees of separation