Tables [dbo].[Order_Status_Reason_DE]
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.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Order_Status_Reason_DE_ID: IDIndexes NIX_Order_Status_Reason_DE_ID_EntrynameID[dbo].[dict_id]5NOT NULL1 - 1Key to the Order_Status_Reason_DE table
EnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
DefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Entry[dbo].[dict_id]5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Indexes XAK2OrderStatusReasonDE, NIX_Order_Status_Reason_DE_ID_Entryname(2)EntryCode[dbo].[code]10NOT NULLUnique alphanumeric code. Brief but cryptic.
Cluster Key XAK1OrderStatusReasonDE: EntryName\IsCurrentFLAGIndexes NIX_Order_Status_Reason_DE_ID_EntrynameEntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
Indexes XAK3OrderStatusReasonDE, NIX_Order_Status_Reason_DE_ID_Entryname(2)EntryMnemonic[dbo].[code]10NOT NULLTypically the same as the Code value, but can be blank.  If present, it must be unique.
Check Constraints CK_Order_Status_Reason_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLY=row is not active; N=row is active.  (Rows are inactivated rather than deleted for history)
Indexes TWstat_Order_Status_Reason_DE_IsEnforcedFLAGCheck Constraints CK_Order_Status_Reason_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Cluster Key XAK1OrderStatusReasonDE: EntryName\IsCurrentFLAGIndexes XAK2OrderStatusReasonDE, XAK3OrderStatusReasonDE(2)Check Constraints CK_Order_Status_Reason_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')IsCurrentFLAG[dbo].[BOOL]1NOT NULLUsually 'Y' but occasionally used to subordinate rows.  Not exposed to the end user.
EffectiveDTdatetime8NULL allowedTime of last modification  (not "when this row goes into effect")
SnomedCodevarchar(18)18NOT NULL('')SNOMED Code
Foreign Keys FK_Order_Status_Reason_DE_RegistryRefusalReasonDE_Registry_Refusal_Reason_DE_ID: [dbo].[Registry_Refusal_Reason_DE].RegistryRefusalReasonDERegistryRefusalReasonDE[dbo].[dict_id]5NOT NULL((0))Registry Refusal Reason. Link to Registry_Refusal_Reason_DE.ID
Foreign Keys FK_Order_Status_Reason_DE_NoImmunizationReasonDE: [dbo].[No_Immunization_Reason_DE].NoImmunizationReasonDENoImmunizationReasonDE[dbo].[dict_id]5NOT NULL((0))HL7 Stanadrd Reason an Immunization was not given. Link to No_Immunization_Reason_DE.ID