Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Encounter_Type_DE
Touchworks 25.2
[dbo].[Encounter_Type_DE]
MS_Description
Encounter Types
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
(5)
ID
[dbo].[dict_id]
5
NOT NULL
1 - 1
Key to the Encounter_Type_DE table
EnterpriseEntryID
[dbo].[uniqueid]
9
NOT NULL
Master (enterprise) dictionary surrogate key. Points to Dictionary_Entry.EnterpriseEntryID
DefinitionSetID
[dbo].[dict_id]
5
NOT NULL
Points to Dict_Definition_Set.DefinitionSetID but is typically zero.
Entry
[dbo].[dict_id]
5
NOT NULL
Calculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
EntryCode
[dbo].[code]
10
NOT NULL
Unique alphanumeric code. Brief but cryptic.
(2)
EntryName
[dbo].[name]
255
NOT NULL
Unique alphanumeric "friendly" display name
(2)
EntryMnemonic
[dbo].[code]
10
NOT NULL
Typically the same as the Code value, but can be blank. If present, it must be unique.
IsInactiveFLAG
[dbo].[BOOL]
1
NOT NULL
Y=row is not active; N=row is active. (Rows are inactivated rather than deleted for history)
IsEnforcedFLAG
[dbo].[BOOL]
1
NOT NULL
Y=row is readonly; N=row is modifiable
(3)
IsCurrentFLAG
[dbo].[BOOL]
1
NOT NULL
Usually 'Y' but occasionally used to subordinate rows. Not exposed to the end user.
EffectiveDT
datetime
8
NULL allowed
Time of last modification (not "when this row goes into effect")
IsChargeableFLAG
[dbo].[BOOL]
1
NOT NULL
('N')
Is the Encounter Chargeable (Y/N)?
LinkedAppointmentFLAG
[dbo].[BOOL]
1
NOT NULL
('N')
Can an Appointment be linked to an Appointment (Y/N)?
ReconcileAlertFLAG
[dbo].[BOOL]
1
NOT NULL
('N')
Alert is Clinical Items were not reconciled on the encounter (Y/N)
IsTransitionofCareFLAG
[dbo].[BOOL]
1
NOT NULL
('N')
Can this encounter type be used for transisition of care (Y/N)?
ManualCreationFLAG
[dbo].[BOOL]
1
NOT NULL
('Y')
Can this encounter type be manually created (Y/N)?
ExcludeFromMUReportFLAG
[dbo].[BOOL]
1
NOT NULL
('N')
Exclude from Meaningful Use calculations (Y/N)?
AllowCaseAssociation
[dbo].[BOOL]
1
NOT NULL
('N')
Y/N - set to 'Y' indicates the encounter can be linked to a Patient Case