PatientInsurance

Primary key - Unique identifier for the patient insurance record

Insurance carrier foreign key - Links to the insurance carrier/company providing coverage

Patient foreign key - Links to the patient who has this insurance coverage

Policy type - Type of insurance policy (Primary, Secondary, Tertiary, etc.)

Policy number - Insurance policy or member identification number

Insured first name - First name of the person who holds the insurance policy

Insured last name - Last name of the person who holds the insurance policy

Insured date of birth - Birth date of the policy holder for verification

Insured gender - Gender of the policy holder

Insured address - Primary address of the policy holder

Insured city - City where the policy holder resides

Insured state - State where the policy holder resides

Insured ZIP code - Postal code for the policy holder’s address

Insured phone - Phone number of the policy holder

Group policy name - Name of the group policy (employer, association, etc.)

Group policy number - Group policy identification number

Copayment amount - Fixed copayment amount required for services

Managed care flag - Indicates if this is a managed care plan requiring authorizations

Patient relationship - Relationship of patient to policy holder (Self, Child, Spouse, etc.)

Policy effective date - Date when insurance coverage begins

Policy expiration date - Date when insurance coverage ends

Coverage percentage - Percentage of costs covered by this insurance plan

Assignment of benefits - Flag indicating if benefits are assigned to provider

Annual deductible - Annual deductible amount for this insurance plan

Other coverage flag - Indicates if patient has other insurance coverage

Signature on file - Flag indicating if patient signature is on file for billing

Signature date - Date when patient signature was obtained

Insured address line 2 - Secondary address line for policy holder