Documentation/EHI_Export/docs/tables/immunizations.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
| immunization_observation.imo_im_id | Defined in XML | R |
|
| | | uuid | BINARY | 16 | √ | | NULL |
|
| | | patient_id | BIGINT | 19 | √ | | NULL |
|
| patient_data.pid | Defined in XML | R |
|
The internal patient identifier
| | administered_date | DATETIME | 19 | √ | | NULL |
|
| | | immunization_id | INT | 10 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘immunizations’ and represents common list of immunizations the EMR works with
| | cvx_code | VARCHAR | 64 | √ | | NULL |
|
| | | manufacturer | VARCHAR | 100 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘Immunization_Manufacturer’ and represents a list of immunization manufacturers
| | lot_number | VARCHAR | 50 | √ | | NULL |
|
| | | administered_by_id | BIGINT | 19 | √ | | NULL |
|
| users.id | Defined in XML | R |
|
The person that administered the immunization
| | administered_by | VARCHAR | 255 | √ | | NULL |
|
|
Alternative to administered_by_id
| | education_date | DATE | 10 | √ | | NULL |
|
| | | vis_date | DATE | 10 | √ | | NULL |
|
|
Date of VIS Statement
| | note | TEXT | 65535 | √ | | NULL |
|
| | | create_date | DATETIME | 19 | √ | | NULL |
|
| | | update_date | TIMESTAMP | 19 | | | current_timestamp() |
|
| | | created_by | BIGINT | 19 | √ | | NULL |
|
| users.id | Defined in XML | R |
|
The user that created this record
| | updated_by | BIGINT | 19 | √ | | NULL |
|
| users.id | Defined in XML | R |
|
The user that last updated this record
| | amount_administered | FLOAT | 12 | √ | | NULL |
|
| | | amount_administered_unit | VARCHAR | 50 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘drug_units’ and represents the units of drug administered
| | expiration_date | DATE | 10 | √ | | NULL |
|
| | | route | VARCHAR | 100 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘drug_route’ and represents a list of immunization manufacturers
| | administration_site | VARCHAR | 100 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘immunization_administered_site’ and represents the body sites where the immunization can be administered
| | added_erroneously | BOOLEAN | 3 | | | 0 |
|
| | | external_id | VARCHAR | 20 | √ | | NULL |
|
| | | completion_status | VARCHAR | 50 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘Immunization_Completion_Status’ and represents the status of the immunization
| | information_source | VARCHAR | 31 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘immunization_informationsource’ and represents where the source of information the immmunization is coming from originates
| | refusal_reason | VARCHAR | 31 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘immunization_refusal_reason’ and represents the reasons the individual refused immunization
| | ordering_provider | INT | 10 | √ | | NULL |
|
| users.id | Defined in XML | R |
|
The provider that issued the order to administer this immunization
| | reason_code | VARCHAR | 31 | √ | | NULL |
|
|
Medical code explaining reason of the vital observation value in form codesystem:codetype;…;
| | reason_description | TEXT | 65535 | √ | | NULL |
|
|
Human readable text description of the reason_code column
| | encounter_id | BIGINT | 19 | √ | | NULL |
|
| form_encounter.encounter | Defined in XML | R |
|
The encounter where this immunization was administered
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| patient_id | Performance | Asc | patient_id |
| uuid | Must be unique | Asc | uuid |