Tables [dbo].[Clinical_Priority_DE]
Clinical Priority dictionary
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Clinical_Priority_DE_ID: IDIndexes TWstat_Clinical_Priority_DE_DefinitionSetID_EntryName_IsCurrentFLAG_IDID[dbo].[dict_id]5NOT NULL1 - 1Key to the Clinical_Priority_DE table
Indexes TWstat_Clinical_Priority_DE_EnterpriseEntryIDEnterpriseEntryID[dbo].[uniqueid]9NULL allowedMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
Indexes TWstat_Clinical_Priority_DE_DefinitionSetID_EntryName_IsCurrentFLAG_IDDefinitionSetID[dbo].[dict_id]5NULL allowedPoints 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 NIX_Clinical_Priority_DE_EntryCode_WithIncludeColumns, NIX_Clinical_Priority_DE_EntryMnemonic_WithIncludeColumns, NIX_Clinical_Priority_DE_EntryName_WithIncludeColumns(3)EntryCode[dbo].[code]10NOT NULLUnique alphanumeric code. Brief but cryptic.
Indexes NIX_Clinical_Priority_DE_EntryCode_WithIncludeColumns, NIX_Clinical_Priority_DE_EntryMnemonic_WithIncludeColumns, NIX_Clinical_Priority_DE_EntryName_WithIncludeColumns, TWstat_Clinical_Priority_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID(4)EntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
Indexes NIX_Clinical_Priority_DE_EntryCode_WithIncludeColumns, NIX_Clinical_Priority_DE_EntryMnemonic_WithIncludeColumns, NIX_Clinical_Priority_DE_EntryName_WithIncludeColumns(3)EntryMnemonicchar(10)10NOT NULL(' ')Typically the same as the Code value, but can be blank.  If present, it must be unique
Indexes NIX_Clinical_Priority_DE_EntryCode_WithIncludeColumns, NIX_Clinical_Priority_DE_EntryMnemonic_WithIncludeColumns, NIX_Clinical_Priority_DE_EntryName_WithIncludeColumns(3)Check Constraints CK_Clinical_Priority_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)
Check Constraints CK_Clinical_Priority_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Indexes NIX_Clinical_Priority_DE_EntryCode_WithIncludeColumns, NIX_Clinical_Priority_DE_EntryMnemonic_WithIncludeColumns, NIX_Clinical_Priority_DE_EntryName_WithIncludeColumns, TWstat_Clinical_Priority_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID(4)Check Constraints CK_Clinical_Priority_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")
DueDateDefaultsmallint2NOT NULL(0)Default number of days until due.
DueTimeDefaultsmallint2NOT NULL(0)Default number of minutes until due.