Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 ![Foreign Keys FK_Visit_Insurance_Visit: [dbo].[Visit].VisitID Foreign Keys FK_Visit_Insurance_Visit: [dbo].[Visit].VisitID](../../../../Images/fk.png) | VisitID | [dbo].[uniqueid] | 9 | NOT NULL | | Visit. Key to the Visit table. |
 | Sequence | smallint | 2 | NOT NULL | | If multiple insurance are billable for the Visit this holds the sequence to bill. |
![Foreign Keys FK_Visit_Insurance_Insurance_Class_DE: [dbo].[Insurance_Class_DE].InsuranceClassDE Foreign Keys FK_Visit_Insurance_Insurance_Class_DE: [dbo].[Insurance_Class_DE].InsuranceClassDE](../../../../Images/fk.png) | InsuranceClassDE | [dbo].[dict_id] | 5 | NOT NULL | | Insurance. Key to the Insurance_Class_DE table. |
| InsuranceName | varchar(255) | 255 | NOT NULL | | Name of the Insurance carrier |
| InsuranceContact | varchar(80) | 80 | NOT NULL | ('') | Contact information for the Insurance |
| AddressLine1 | varchar(35) | 35 | NOT NULL | ('') | first address line |
| AddressLine2 | varchar(35) | 35 | NOT NULL | ('') | second address line |
| City | varchar(35) | 35 | NOT NULL | ('') | City |
| State | varchar(15) | 15 | NOT NULL | ('') | State |
| Zip | varchar(10) | 10 | NOT NULL | ('') | Zip Code |
| Phone | varchar(21) | 21 | NOT NULL | ('') | telephone number for the Insurance |
| Fax | varchar(21) | 21 | NOT NULL | ('') | Fax number for the Insurance |
| SubscriberName | varchar(80) | 80 | NOT NULL | | Subscriber Name for the Insurance |
![Foreign Keys FK_Visit_Insurance_Relationship_DE: [dbo].[Relationship_DE].RelationshipDE Foreign Keys FK_Visit_Insurance_Relationship_DE: [dbo].[Relationship_DE].RelationshipDE](../../../../Images/fk.png) | RelationshipDE | [dbo].[dict_id] | 5 | NOT NULL | | Subscriber relationship to the Patient. Key to Relationship_DE table |
| GroupNumber | varchar(35) | 35 | NOT NULL | ('') | Group number for the Insurance Policy |
| SubscriberNumber | varchar(35) | 35 | NOT NULL | ('') | subscriber's Number for the Insurance Policy |