Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Order_Status_Reason_DE
Touchworks 25.2
[dbo].[Order_Status_Reason_DE]
MS_Description
Reasons to state why an order is in a particular state. For instance hold for specimen collection where order is in hold status and the reason for hold being to collect the specimen.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[dict_id]
5
NOT NULL
1 - 1
Key to the Order_Status_Reason_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
(2)
EntryCode
[dbo].[code]
10
NOT NULL
Unique alphanumeric code. Brief but cryptic.
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
(2)
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")
SnomedCode
varchar(18)
18
NOT NULL
('')
SNOMED Code
RegistryRefusalReasonDE
[dbo].[dict_id]
5
NOT NULL
((0))
Registry Refusal Reason. Link to Registry_Refusal_Reason_DE.ID
NoImmunizationReasonDE
[dbo].[dict_id]
5
NOT NULL
((0))
HL7 Stanadrd Reason an Immunization was not given. Link to No_Immunization_Reason_DE.ID