Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Primary_Insurance
Touchworks 25.2
[dbo].[Primary_Insurance]
MS_Description
Current Registration Insurance for the patient
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
patientid
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to Patient_Member.ID
insurance
varchar(255)
255
NOT NULL
Insurance Name
InsuranceClassDE
[dbo].[dict_id]
5
NOT NULL
(0)
Insurance. Lin to Insurance_Class_DE.ID
Sequence
smallint
2
NOT NULL
(1)
Sequence of insurances
InsuranceContact
varchar(80)
80
NOT NULL
('')
Contact name
AddressLine1
varchar(35)
35
NOT NULL
('')
Address Line 1
AddressLine2
varchar(35)
35
NOT NULL
('')
Address Line 2
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
('')
Phone Number
Fax
varchar(21)
21
NOT NULL
('')
Fax Number
SubscriberName
varchar(80)
80
NOT NULL
('')
Subscriber Name
RelationshipDE
[dbo].[dict_id]
5
NOT NULL
(0)
Relationship to patient. Link to Relationship_DE.ID
GroupNumber
varchar(35)
35
NOT NULL
('')
Group Number
SubscriberNumber
varchar(35)
35
NOT NULL
('')
Subscriber Number
MemberID
varchar(35)
35
NOT NULL
('')
Member Identity value for an individuals health insurance
EffectiveDate
date
3
NULL allowed
Health insurance effective start date for a patient
ExpirationDate
date
3
NULL allowed
Health insurance effective start date for a patient
PaymentTypologyDE
[dbo].[dict_id]
5
NOT NULL
((0))
Insurance Payment Typology. Link to Payment_Typology_DE.ID