Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Encounter_Insurance
Touchworks 25.2
[dbo].[Encounter_Insurance]
MS_Description
Registration Level insurance at the time of the encounter.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Encounter.ID
Sequence
smallint
2
NOT NULL
(1)
Sequence of insurances
InsuranceClassDE
[dbo].[dict_id]
5
NOT NULL
Insurance. Link to Insurance_Class_DE.ID
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