Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Encounter_Employer
Touchworks 25.2
[dbo].[Encounter_Employer]
MS_Description
Occupational Medicine Employer information for the encounter
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Encounter_Employer table
OriginalEncounterId
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Encounter.ID
EmployerName
varchar(40)
40
NOT NULL
Patient employer
EmployerLocationName
varchar(40)
40
NOT NULL
('')
Employer Location
EmployerNumberExt
varchar(40)
40
NOT NULL
Employer external identifier
OccMedEmployerDE
[dbo].[dict_id]
5
NOT NULL
((0))
Employer. Link to OccMed_Employer_DE.ID
LocationAddress
varchar(35)
35
NOT NULL
('')
Employer Location address line 1
LocationAddress2
varchar(35)
35
NOT NULL
('')
Employer Location address line 2
LocationCity
varchar(35)
35
NOT NULL
('')
Employer Location City
LocationState
varchar(35)
35
NOT NULL
('')
Employer Location State
LocationZip
char(10)
10
NOT NULL
('')
Employer Location Zip Code
SpecialtyNetwork
varchar(60)
60
NOT NULL
('')
Specialty or referral network associated with the Employer. This corresponds to the 'Network' field of the ZCS segment of the HL7 message. This value is displayed on the Encounter Summary for encounters that have employer data associated with them