Patient Insurance: Standard Extract Table
The Patient Insurance data table pulls insurance information from the RevFlow database. Key fields include subscriber ID, copay/coinsurance amount, and claim numbers.
| Data Element | Type | Description |
| record_id | Integer | Unique ID for the patient insurance record |
| patient_identity_id | Integer | Joining ID for other files |
| insurance_id | Integer | ID for the Insurance provider |
| case_id | Integer | Reference to the cases file for the case_id field |
| primaryins | Integer | ID for the Insurance provider |
| insurance_company_name | String | Name of the insurance company |
| insurance_card_id | String | Insurance card ID |
| subscriber | String | Subscriber ID |
| copay | String | Copay if any |
| coinsurance | String | Co-insurance if any |
| policybegindate | Date | Policy Begin Date |
| policyenddate | Date | Policy End Date |
| clinic_id | Integer | Reference to the clinic file on the clinic_id field |
| modified_date | Date | Date the patient Insurance record was changed |
| export_flag | Integer | Export flag 1 = New, 2 = Modified, 3 = Removed |
| pntinshident_identityid | Integer | Internal ID number (should be ignored) |
| insurance_order | Integer | Insurance order 1 = Primary Insurance and 2 = Secondary Insurance |
| insurance_type_id | Integer | ID for the type of Insurance |
| insurance_alt_id | String | Alternate ID for insurance company |
| useflnotes | Integer | Internal ID number (should be ignored) |
| group_id | String | The group id for the insurance |
| workers_comp_claim_num | String | Claim number if there is a workers comp claim |
| auto_claim_num | String | Claim number if there is an auto claim |