The insurance_data table contains information about a patient's insurance coverage.
| Field Name | Description |
|---|---|
| type | Describes the type of the insurance, i.e. primary or secondary. |
| provider | Insurance provider. |
| plan_name | Name of the insurance plan. |
| policy_number | Unique insurance policy number. |
| subscriber_fname | Patient's first name. |
| subscriber_mname | Patient's middle name. |
| subscriber_lname | Patient's last name. |
| subscriber_relationship | Patients relationship with the insurance holder. |
| date | Start date of the insurance policy. |
| pid | Patient identification number. |
| date1 | End date of the insurance policy. |
| facility | Name of the facility to which the policy applies. |
| created_on | Date when the policy was created. |
| created_by | Identification number of the user that created the insurance record. |
| modified_on | Date when the insurance record was last modified. |
| modified_by | Identifier for the user that modified the record. |
Overview
Content Tools
Activity