| imrp_id | int(11) | NO | | PRI | auto_increment | |
| imrp_cus_id | int(11) | NO | | MUL | | |
| imrp_cli_id | int(11) | NO | | MUL | | |
| imrp_ir_id | int(11) | NO | | MUL | | |
| imrp_pim_id | int(11) | NO | | MUL | | ID of patient immunization record |
| imrp_status | char(1) | NO | 0 | | | 0: Unreported, 1: Unable to reach registry. 2: Registry returned error. 3: Reported successfully. |
| imrp_error_message | text | NO | | | | Explains why an immunization was not sent or was rejected |
| imrp_placer_code | varchar(50) | YES | | | | Human readable ID in place of DB id for interfaces that need it |
| imrp_reported_dt | datetime | YES | | | | |
| imrp_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| imrp_create | timestamp | YES | CURRENT_TIMESTAMP | | | |