_1.patients_immunizations

Field Type Null Default Key Extra Comment
pim_id int(11) NO PRI auto_increment
pim_cus_id int(11) NO MUL
pim_cli_id int(11) NO MUL
pim_pat_id int(11) NO MUL
pim_vac_id int(11) NO MUL
pim_mvx_id int(11) NO
pim_enc_id int(11) NO MUL
pim_imzs_id int(11) NO
pim_inv_id int(11) NO
pim_inv_name text NO
pim_brand_name varchar(50) NO Brand name for immunizations
pim_administered_date varchar(12) NO
pim_admin_phy_id int(11) NO
pim_vis varchar(60) NO
pim_vis_administered_ts varchar(12) NO
pim_expiration_date varchar(45) YES
pim_administered_amount varchar(10) NO
pim_administered_units varchar(10) NO
pim_vaccine_lot_num varchar(32) NO Vaccine lot #
pim_admin_route varchar(45) YES
pim_admin_route_id int(11) NO
pim_admin_usr_id int(11) NO
pim_entered_by_usr_id int(11) NO 0 id of user who entered the immunization
pim_location varchar(45) YES
pim_location_id int(11) NO
pim_admin_notes text YES
pim_deleted char(1) NO 0
pim_sno_code bigint(20) NO
pim_refused char(1) NO
pim_refused_id int(11) NO
pim_funding_source int(11) NO 0 Maps to a funding source for an immunization
pim_modified datetime YES CURRENT_TIMESTAMP
pim_created datetime YES CURRENT_TIMESTAMP

References

Local Column References
pim_id
TableColumn
_1.auditsaud_pim_id
_1.audits_archiveaud_pim_id
_1.immunization_reportedimrp_pim_id
_1.patients_immunizations_vis_mappivm_pim_id
_1.patients_inventorypinv_pim_id
_1188.auditsaud_pim_id
_1188.audits_archiveaud_pim_id
_1188.immunization_reportedimrp_pim_id
_1188.patients_immunizations_vis_mappivm_pim_id
_1188.patients_inventorypinv_pim_id
_1218.auditsaud_pim_id
_1218.audits_archiveaud_pim_id
_1218.immunization_reportedimrp_pim_id
_1218.patients_immunizations_vis_mappivm_pim_id
_1218.patients_inventorypinv_pim_id
_1548.auditsaud_pim_id
_1548.audits_archiveaud_pim_id
_1548.immunization_reportedimrp_pim_id
_1548.patients_immunizations_vis_mappivm_pim_id
_1548.patients_inventorypinv_pim_id
_435.auditsaud_pim_id
_435.audits_archiveaud_pim_id
_435.immunization_reportedimrp_pim_id
_435.patients_immunizations_vis_mappivm_pim_id
_435.patients_inventorypinv_pim_id
_436.auditsaud_pim_id
_436.audits_archiveaud_pim_id
_436.immunization_reportedimrp_pim_id
_436.patients_immunizations_vis_mappivm_pim_id
_436.patients_inventorypinv_pim_id
_436_archive_testing.auditsaud_pim_id
_436_archive_testing.audits_archiveaud_pim_id
_436_archive_testing.immunization_reportedimrp_pim_id
_436_archive_testing.patients_immunizations_vis_mappivm_pim_id
_436_archive_testing.patients_inventorypinv_pim_id
_437.auditsaud_pim_id
_437.audits_archiveaud_pim_id
_437.immunization_reportedimrp_pim_id
_437.patients_immunizations_vis_mappivm_pim_id
_437.patients_inventorypinv_pim_id
_8.auditsaud_pim_id
_8.audits_archiveaud_pim_id
_8.immunization_reportedimrp_pim_id
_8.patients_immunizations_vis_mappivm_pim_id
_8.patients_inventorypinv_pim_id
_81.auditsaud_pim_id
_81.audits_archiveaud_pim_id
_81.immunization_reportedimrp_pim_id
_81.patients_immunizations_vis_mappivm_pim_id
_81.patients_inventorypinv_pim_id
_999.auditsaud_pim_id
_999.audits_archiveaud_pim_id
_999.immunization_reportedimrp_pim_id
_999.patients_immunizations_vis_mappivm_pim_id
_999.patients_inventorypinv_pim_id