Tables [dbo].[QO_DE]
Resultable items that could be used for a non-med order
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_QO_DE_ID: IDIndexes TWstat_QO_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_ID, TWstat_QO_DE_IsEnforcedFLAG_EntryName_IsCurrentFLAG_ID, TWstat_QO_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(3)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the QO_DE table
Indexes TWstat_QO_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_IDEnterpriseEntryID[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 NIX_QO_DE_EntryCode_WithIncludeColumns, NIX_QO_DE_EntryMnemonic_WithIncludeColumns, NIX_QO_DE_EntryName_WithIncludeColumns(3)EntryCode[dbo].[code]10NOT NULLUnique alphanumeric code. Brief but cryptic.
Indexes NIX_QO_DE_EntryCode_WithIncludeColumns, NIX_QO_DE_EntryMnemonic_WithIncludeColumns, NIX_QO_DE_EntryName_WithIncludeColumns, TWstat_QO_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_ID, TWstat_QO_DE_IsEnforcedFLAG_EntryName_IsCurrentFLAG_ID, TWstat_QO_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(6)EntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
Indexes NIX_QO_DE_EntryCode_WithIncludeColumns, NIX_QO_DE_EntryMnemonic_WithIncludeColumns, NIX_QO_DE_EntryName_WithIncludeColumns(3)EntryMnemonic[dbo].[code]10NOT NULLTypically the same as the Code value, but can be blank.  If present, it must be unique.
Indexes NIX_QO_DE_EntryCode_WithIncludeColumns, NIX_QO_DE_EntryMnemonic_WithIncludeColumns, NIX_QO_DE_EntryName_WithIncludeColumns, TWstat_QO_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(4)Check Constraints CK_QO_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_QO_DE_IsEnforcedFLAG_EntryName_IsCurrentFLAG_IDCheck Constraints CK_QO_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Indexes NIX_QO_DE_EntryCode_WithIncludeColumns, NIX_QO_DE_EntryMnemonic_WithIncludeColumns, NIX_QO_DE_EntryName_WithIncludeColumns, TWstat_QO_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_ID, TWstat_QO_DE_IsEnforcedFLAG_EntryName_IsCurrentFLAG_ID, TWstat_QO_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(6)Check Constraints CK_QO_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")
Foreign Keys FK_QO_DE_QOInstructionID_QO_Instruction_ID: [dbo].[QO_Instruction].QOInstructionIDQOInstructionIDnumeric(8,0)5NOT NULLInstruction. Link to QO_Instruction.ID
Foreign Keys FK_QO_DE_UnitsDE_Unit_Code_DE_ID: [dbo].[Unit_Code_DE].UnitsDEUnitsDE[dbo].[dict_id]5NOT NULL(0)Default Units of Measure. Link to Unit_Code_DE.ID
Foreign Keys FK_QO_DE_SecurityCodeDE_Security_Code_DE_ID: [dbo].[Security_Code_DE].SecurityCodeDESecurityCodeDE[dbo].[dict_id]5NOT NULLSecurity Code. Link to Security_Code_DE.ID
Foreign Keys FK_QO_DE_AnswerPicklistID_Picklist_ID: [dbo].[Picklist].AnswerPicklistIDAnswerPicklistID[dbo].[dict_id]5NOT NULLAnswer Picklist. Link to Picklist.ID
Indexes NIX_QO_DE_Snomed3CODESnomed3CODEvarchar(18)18NULL allowedSNOMED code
LoincLabCODE[dbo].[code]10NOT NULL(' ')LOINC Code
AnswerDictionaryID[dbo].[dict_id]5NOT NULLDictionary to use for Answers. Link to Dictionary.ID.
Foreign Keys FK_QO_DE_AnswerDataTypeDE_Answer_Data_Type_DE_ID: [dbo].[Answer_Data_Type_DE].AnswerDataTypeDEAnswerDataTypeDE[dbo].[dict_id]5NOT NULLAnswer Data Type. Link to Answer_Data_Type_DE.ID
CharInAnswersmallint2NOT NULL(0)Maximum Number of characters in the answer
DecimalInAnswersmallint2NOT NULL(0)Number of decimal places in th result
Check Constraints CK_QO_DE_ItemType_Item_Type : ([ItemType]='OT' OR [ItemType]='IM' OR [ItemType]='RS' OR [ItemType]='ME' OR [ItemType]='PL' OR [ItemType]='CH' OR [ItemType]='PM' OR [ItemType]='CO' OR [ItemType]='AL' OR [ItemType]='RE' OR [ItemType]='FI')ItemTypechar(2)2NOT NULLRS = Result
FI = Findings
OT = Other
Foreign Keys FK_QO_DE_UnitsPicklistID_Picklist_ID: [dbo].[Picklist].UnitsPicklistIDUnitsPicklistID[dbo].[dict_id]5NOT NULLUnit Picklist. Link to Picklist.ID.
NormalValuevarchar(255)255NOT NULL('')Normal Value
RCDID[dbo].[dict_id]5NOT NULL(0)Resultable Concept. Link to RCD_Header.ID
Indexes TWstat_QO_DE_ActiveQODEActiveQODE[dbo].[dict_id]5NOT NULL(0)Active or Replaced Resultable Item. Link to QO_DE.ID
Check Constraints CK_QO_DE_CognitiveStatus_Yes_Or_No : ([CognitiveStatus]='N' OR [CognitiveStatus]='Y')CognitiveStatus[dbo].[BOOL]1NULL allowed('N')Cognitive Status indicator (Y/N)
Check Constraints CK_QO_DE_FunctionalStatus_Yes_Or_No : ([FunctionalStatus]='N' OR [FunctionalStatus]='Y')FunctionalStatus[dbo].[BOOL]1NULL allowed('N')Functional Status indicator (Y/N)
ExcludeFromComparison[dbo].[BOOL]1NULL allowed('N')Exclude individual Resultable items from Result History
ExcludeDuplicateCheck[dbo].[BOOL]1NULL allowed('N')Exclude individual Resultable items from Duplicate Checking
ChartAlertCreationCriteriavarchar(2)2NOT NULL('N')Comparing operation criteria for Chart alert of resultable item.
A  - Always
N  - Never
B  - Between
E  - Equal To
G  - Greater Than
GE - Greater Than Equal To
L  - Less Than
LE -  Less Than Equal To
NE - Not Equal To
SearchResultTextvarchar(255)255NULL allowedsearch result text for Chart alert of  resultable item.
ChartAlertTextTypechar(1)1NULL allowedChart Alert Text type
R-  Result Value
F - Free text
ChartAlertFreeTextvarchar(70)70NULL allowedFree text value for Chart alert
AppendResultTextFLAGchar(1)1NOT NULL('N')Append result value when 'Y'.
AnswerPicklistIDsvarchar(4000)4000NULL allowedApplicable to resultable item having answer data type is picklist