Tables [dbo].[Encounter_Insurance]
Registration Level insurance at the time of the encounter.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_CIX_Encounter_Insurance_EncounterID_Sequence: EncounterID\SequenceForeign Keys FK_Encounter_Insurance_EncounterID_Encounter_ID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
Cluster Primary Key PK_CIX_Encounter_Insurance_EncounterID_Sequence: EncounterID\SequenceSequencesmallint2NOT NULL(1)Sequence of insurances
Foreign Keys FK_Encounter_Insurance_Insurance_Class_DE: [dbo].[Insurance_Class_DE].InsuranceClassDEInsuranceClassDE[dbo].[dict_id]5NOT NULLInsurance. Link to Insurance_Class_DE.ID
InsuranceContactvarchar(80)80NOT NULL('')Contact name
AddressLine1varchar(35)35NOT NULL('')Address Line 1
AddressLine2varchar(35)35NOT NULL('')Address Line 2
Cityvarchar(35)35NOT NULL('')City
Statevarchar(15)15NOT NULL('')State
Zipvarchar(10)10NOT NULL('')ZIP Code
Phonevarchar(21)21NOT NULL('')Phone Number
Faxvarchar(21)21NOT NULL('')Fax Number
SubscriberNamevarchar(80)80NOT NULL('')Subscriber Name
Foreign Keys FK_Encounter_Insurance_Relationship_DE: [dbo].[Relationship_DE].RelationshipDERelationshipDE[dbo].[dict_id]5NOT NULL(0)Relationship to patient. Link to Relationship_DE.ID
GroupNumbervarchar(35)35NOT NULL('')Group Number
SubscriberNumbervarchar(35)35NOT NULL('')Subscriber Number