Table: OrderInsurance
OrderInsurance holds relevant insurance information when eligibility is used on an order.
| Name | Type | Description | Remarks |
|---|---|---|---|
| AuthDate |
datetime |
||
| AuthExpireDate |
datetime |
||
| AuthNumber |
varchar(20) |
||
| CarrierAddress1 |
varchar(50) |
||
| CarrierAddress2 |
varchar(50) |
||
| CarrierCity |
varchar(50) |
||
| CarrierName |
varchar(50) |
||
| CarrierState |
varchar(50) |
||
| CarrierZip |
varchar(50) |
||
| ContactInformation |
varchar(100) |
The Contact Information on file for the patient's insurance subscriber Carrier Contact info. |
|
| EligEmployeeID |
int |
||
| EmployerName |
varchar(100) |
The Employer Name on file for the patient's insurance subscriber info. |
|
| FaxNumber |
varchar(15) |
The Fax number on file for the patient's insurance subscriber Carrier Contact info. |
|
| InsCarrierCode |
varchar(50) |
InsCarrierCode is a nullable foreign key to the InsCarrier table. |
|
| InsPlanID |
int |
InsPlanId is a nullable foreign key to the InsPlan table. |
|
| InsuredAddress1 |
varchar(100) |
||
| InsuredAddress2 |
varchar(100) |
||
| InsuredBirthDate |
varchar(100) |
||
| InsuredCity |
varchar(100) |
||
| InsuredFirstName |
varchar(50) |
||
| InsuredId |
varchar(100) |
The subscriber id. |
|
| InsuredLastName |
varchar(50) |
||
| InsuredMiddle |
varchar(1) |
||
| InsuredPhone |
varchar(100) |
||
| InsuredSex |
varchar(50) |
||
| InsuredSSN |
varchar(100) |
||
| InsuredState |
varchar(50) |
||
| InsuredZip |
varchar(100) |
||
| IsCLElig |
bit |
Indicates if contact lenses are covered under the authorization. |
|
| IsExamElig |
bit |
Indicates if an exam is covered under the authorization. |
|
| IsFrameElig |
bit |
Indicates if a frame is covered under the authorization. |
|
| IsLensElig |
bit |
Indicates if lenses are covered under the authorization. |
|
|
OrderId |
int |
OrderId is a nullable foreign key to the Orders table. |
|
| PatientAddress1 |
varchar(100) |
||
| PatientAddress2 |
varchar(100) |
||
| PatientBirthDate |
varchar(100) |
||
| PatientCity |
varchar(100) |
||
| PatientFirstName |
varchar(50) |
||
| PatientLastName |
varchar(50) |
||
| PatientMaritalStatus |
int |
Indicates patient's marital status. |
See GenLookup PatientMaritalStatus is a nullable foreign key reference to the CatElementLU table of type 13. |
| PatientMiddle |
varchar(1) |
||
| PatientPhone |
varchar(100) |
||
|
InsuredRelationshipId |
int |
Indicates patient relationship to the insured. |
See GenLookup InsuredRelationshipId is a nullable foreign key reference to the CatElementLU table of type 12. |
| PatientSex |
varchar(50) |
||
| PatientState |
varchar(50) |
||
| PatientZip |
varchar(100) |
||
| PhoneNumber |
varchar(15) |
The Phone number on file for the patient's insurance subscriber Carrier Contact info. |
|
| PlanName |
varchar(200) |
||
| SignatureDate |
datetime |
Date of patient HIPAA signature on file. |