| irep_id | int(11) | NO | | PRI | auto_increment | |
| irep_cus_id | int(11) | NO | | MUL | | |
| irep_cli_id | int(11) | NO | | MUL | | |
| irep_ins_id | int(11) | NO | | MUL | | |
| irep_pat_id | int(11) | NO | | MUL | | |
| irep_primary_secondary | char(1) | NO | | MUL | | |
| irep_linked_pat_id | int(11) | NO | | | | |
| irep_ins_policy_num | varchar(40) | NO | | | | |
| irep_ins_group_num | varchar(40) | NO | | | | |
| irep_ins_copay | varchar(10) | NO | | | | |
| irep_ins_start_date | varchar(8) | NO | | | | |
| irep_ins_end_date | varchar(8) | NO | | | | |
| irep_ins_insured | varchar(40) | NO | | | | |
| irep_ins_insured_relation | varchar(20) | NO | | | | |
| irep_ins_insured_dob | varchar(8) | NO | | | | |
| irep_ins_insured_ssn | varchar(11) | NO | | | | |
| irep_ins_insured_sex | varchar(7) | NO | | | | |
| irep_ins_employer_name | varchar(40) | NO | | | | |
| irep_ins_employer_address | varchar(40) | NO | | | | |
| irep_ins_employer_city | varchar(30) | NO | | | | |
| irep_ins_employer_state | varchar(2) | NO | | | | |
| irep_ins_employer_zip | varchar(12) | YES | | | | |
| irep_ins_employer_zip_plus4 | varchar(4) | NO | | | | |
| irep_ins_employer_ctry_id | int(11) | YES | | | | Insurance Repository Employer Country ID |
| irep_ins_referral_num | varchar(40) | NO | | | | |
| irep_ins_referral_start_date | varchar(8) | NO | | | | |
| irep_ins_referral_end_date | varchar(8) | NO | | | | |
| irep_ins_referral_num_visits | varchar(3) | NO | | | | |
| irep_ins_vaccines | char(1) | NO | | | | |
| irep_msrc_id | int(11) | NO | | | | |
| irep_pc_num | varchar(50) | YES | | | | Property and casualty payer-assigned claim number received during eligibility determinations with the payer |
| irep_id_ext | int(11) | NO | 0 | | | External insurance id for patient insurances |
| irep_disabled | char(1) | NO | | | | |
| irep_note | text | NO | | | | Note attached to patient insurance |
| irep_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| irep_created | timestamp | YES | CURRENT_TIMESTAMP | | | |
| irep_ins_ext_id | varchar(18) | NO | | | | Used as an external id for interfaces and imports |