Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Encounter_Employer_Contact
Touchworks 25.2
[dbo].[Encounter_Employer_Contact]
MS_Description
Employer Contacts for an Occupational Medicine Encounter
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
EncounterEmployerID
[dbo].[uniqueid]
9
NOT NULL
Employer. Link to Encounter_Employer.ID
EmployerContactTypeDE
[dbo].[dict_id]
5
NOT NULL
((0))
Contact Type. Link to Employer_Contact_Type_DE.ID
ContactName
varchar(40)
40
NOT NULL
Contact full name
ContactPhoneArea
smallint
2
NOT NULL
((0))
Contact phone number area code
ContactPhoneExchange
smallint
2
NOT NULL
((0))
Contact phone number exchange
ContactPhoneLast4
smallint
2
NOT NULL
((0))
Contact phone number last 4 digits
ContactPhoneExtension
varchar(10)
10
NOT NULL
('')
Contact phone number extension
ContactFaxArea
smallint
2
NOT NULL
((0))
Contact Fax number area code
ContactFaxExchange
smallint
2
NOT NULL
((0))
Contact Fax number exchange
ContactFaxLast4
smallint
2
NOT NULL
((0))
Contact Fax number last 4 digits
ContactEmail
varchar(80)
80
NOT NULL
('')
Contact Email address