Tables [dbo].[Primary_Insurance]
Current Registration Insurance for the patient
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_CIX_Primary_Insurance_PatientID_Sequence: patientid\SequenceIndexes TWstat_Primary_Insurance_InsuranceClassDE_patientidForeign Keys FK_Primary_Insurance_PatientID_Patient_Member_ID: [dbo].[Patient_Member].patientidpatientid[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID
insurancevarchar(255)255NOT NULLInsurance Name
Indexes TWstat_Primary_Insurance_InsuranceClassDE_patientidForeign Keys FK_Primary_Insurance_InsuranceClassDE_Insurance_Class_DE_ID: [dbo].[Insurance_Class_DE].InsuranceClassDEInsuranceClassDE[dbo].[dict_id]5NOT NULL(0)Insurance. Lin to Insurance_Class_DE.ID
Cluster Primary Key PK_CIX_Primary_Insurance_PatientID_Sequence: patientid\SequenceIndexes TWstat_Primary_Insurance_SequenceSequencesmallint2NOT NULL(1)Sequence of insurances
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
Indexes TWstat_Primary_Insurance_RelationshipDEForeign Keys FK_Primary_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
MemberIDvarchar(35)35NOT NULL('')Member Identity value for an individuals health insurance
EffectiveDatedate3NULL allowedHealth insurance effective start date for a patient
ExpirationDatedate3NULL allowedHealth insurance effective start date for a patient
Foreign Keys FK_Primary_Insurance_PaymentTypologyDE: [dbo].[Payment_Typology_DE].PaymentTypologyDEPaymentTypologyDE[dbo].[dict_id]5NOT NULL((0))Insurance Payment Typology. Link to Payment_Typology_DE.ID