Tables [dbo].[Visit_Insurance]
Insurance data asociated with the Patient for the Visit.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_CIX_Visit_Insurance_VisitID_Sequence: VisitID\SequenceForeign Keys FK_Visit_Insurance_Visit: [dbo].[Visit].VisitIDVisitID[dbo].[uniqueid]9NOT NULLVisit. Key to the Visit table.
Cluster Primary Key PK_CIX_Visit_Insurance_VisitID_Sequence: VisitID\SequenceSequencesmallint2NOT NULLIf 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].InsuranceClassDEInsuranceClassDE[dbo].[dict_id]5NOT NULLInsurance. Key to the Insurance_Class_DE table.
InsuranceNamevarchar(255)255NOT NULLName of the Insurance carrier
InsuranceContactvarchar(80)80NOT NULL('') Contact information for the Insurance
AddressLine1varchar(35)35NOT NULL('')first address line
AddressLine2varchar(35)35NOT NULL('')second address line
Cityvarchar(35)35NOT NULL('')City
Statevarchar(15)15NOT NULL('')State
Zipvarchar(10)10NOT NULL('')Zip Code
Phonevarchar(21)21NOT NULL('')telephone number for the Insurance
Faxvarchar(21)21NOT NULL('')Fax number for the Insurance
SubscriberNamevarchar(80)80NOT NULLSubscriber Name for the Insurance
Foreign Keys FK_Visit_Insurance_Relationship_DE: [dbo].[Relationship_DE].RelationshipDERelationshipDE[dbo].[dict_id]5NOT NULLSubscriber relationship to the Patient. Key to Relationship_DE table
GroupNumbervarchar(35)35NOT NULL('')Group number for the Insurance Policy
SubscriberNumbervarchar(35)35NOT NULL('')subscriber's Number for the Insurance Policy