Table: PatientInsurance
| Field | Size |
| PatientInsuranceRef | IDENTITY |
| PatientRef | INT |
| PayerRef | INT |
| PricingRef | INT |
| Rank | TINYINT |
| InsuredId | VARCHAR(20) |
| InsuredFirstName | VARCHAR(15) |
| InsuredLastName | VARCHAR(20) |
| InsuredAddress1 | VARCHAR(40) |
| InsuredAddress2 | VARCHAR(40) |
| InsuredCity | VARCHAR(20) |
| InsuredState | VARCHAR(2) |
| InsuredZip | VARCHAR(10) |
| InsuredPhone | VARCHAR(20) |
| InsuredDOB | DATE |
| InsuredSex | VARCHAR(1) |
| InsuredEmployer | VARCHAR(30) |
| InsuredInsurancePlan | VARCHAR(30) |
| InsuredPolicyNumber | VARCHAR(20) |
| PriorAuthorizationNumber | VARCHAR(20) |
| PriorAuthorizationFrom | DATE |
| PriorAuthorizationTo | DATE |
| RelationToInsured | TINYINT |
| EmploymentCondition | BIT |
| AutoAccidentCondition | BIT |
| OtherAccidentCondition | BIT |
| OtherInsuredLastName | VARCHAR(20) |
| OtherInsuredFirstName | VARCHAR(15) |
| OtherInsuredPolicyNumber | VARCHAR(20) |
| OtherInsuredDateOfBirth | DATE |
| OtherInsuredSex | VARCHAR(1) |
| OtherInsuredEmployer | VARCHAR(30) |
| OtherInsuredInsurancePlan | VARCHAR(30) |
| PersonCode | VARCHAR(3) |
| HomePlan | VARCHAR(3) |
| PlanId | VARCHAR(8) |
| FacilityId | VARCHAR(10) |