Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 (3) | ID | [dbo].[dict_id] | 5 | NOT NULL | 1 - 1 | | Key to the QO_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 |
(3) | EntryCode | [dbo].[code] | 10 | NOT NULL | | | Unique alphanumeric code. Brief but cryptic. |
(6) | EntryName | [dbo].[name] | 255 | NOT NULL | | | Unique alphanumeric "friendly" display name |
(3) | EntryMnemonic | [dbo].[code] | 10 | NOT NULL | | | Typically the same as the Code value, but can be blank. If present, it must be unique. |
(4)![Check Constraints CK_QO_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_QO_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y=row is not active; N=row is active. (Rows are inactivated rather than deleted for history) |
 ![Check Constraints CK_QO_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y') Check Constraints CK_QO_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')](../../../../Images/c-constraint.png) | IsEnforcedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y=row is readonly; N=row is modifiable |
(6)![Check Constraints CK_QO_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y') Check Constraints CK_QO_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')](../../../../Images/c-constraint.png) | 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") |
![Foreign Keys FK_QO_DE_QOInstructionID_QO_Instruction_ID: [dbo].[QO_Instruction].QOInstructionID Foreign Keys FK_QO_DE_QOInstructionID_QO_Instruction_ID: [dbo].[QO_Instruction].QOInstructionID](../../../../Images/fk.png) | QOInstructionID | numeric(8,0) | 5 | NOT NULL | | | Instruction. Link to QO_Instruction.ID |
![Foreign Keys FK_QO_DE_UnitsDE_Unit_Code_DE_ID: [dbo].[Unit_Code_DE].UnitsDE Foreign Keys FK_QO_DE_UnitsDE_Unit_Code_DE_ID: [dbo].[Unit_Code_DE].UnitsDE](../../../../Images/fk.png) | UnitsDE | [dbo].[dict_id] | 5 | NOT 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].SecurityCodeDE Foreign Keys FK_QO_DE_SecurityCodeDE_Security_Code_DE_ID: [dbo].[Security_Code_DE].SecurityCodeDE](../../../../Images/fk.png) | SecurityCodeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Security Code. Link to Security_Code_DE.ID |
![Foreign Keys FK_QO_DE_AnswerPicklistID_Picklist_ID: [dbo].[Picklist].AnswerPicklistID Foreign Keys FK_QO_DE_AnswerPicklistID_Picklist_ID: [dbo].[Picklist].AnswerPicklistID](../../../../Images/fk.png) | AnswerPicklistID | [dbo].[dict_id] | 5 | NOT NULL | | | Answer Picklist. Link to Picklist.ID |
 | Snomed3CODE | varchar(18) | 18 | NULL allowed | | | SNOMED code |
| LoincLabCODE | [dbo].[code] | 10 | NOT NULL | | (' ') | LOINC Code |
| AnswerDictionaryID | [dbo].[dict_id] | 5 | NOT NULL | | | Dictionary to use for Answers. Link to Dictionary.ID. |
![Foreign Keys FK_QO_DE_AnswerDataTypeDE_Answer_Data_Type_DE_ID: [dbo].[Answer_Data_Type_DE].AnswerDataTypeDE Foreign Keys FK_QO_DE_AnswerDataTypeDE_Answer_Data_Type_DE_ID: [dbo].[Answer_Data_Type_DE].AnswerDataTypeDE](../../../../Images/fk.png) | AnswerDataTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Answer Data Type. Link to Answer_Data_Type_DE.ID |
| CharInAnswer | smallint | 2 | NOT NULL | | (0) | Maximum Number of characters in the answer |
| DecimalInAnswer | smallint | 2 | NOT 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') 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')](../../../../Images/c-constraint.png) | ItemType | char(2) | 2 | NOT NULL | | | RS = Result FI = Findings OT = Other |
![Foreign Keys FK_QO_DE_UnitsPicklistID_Picklist_ID: [dbo].[Picklist].UnitsPicklistID Foreign Keys FK_QO_DE_UnitsPicklistID_Picklist_ID: [dbo].[Picklist].UnitsPicklistID](../../../../Images/fk.png) | UnitsPicklistID | [dbo].[dict_id] | 5 | NOT NULL | | | Unit Picklist. Link to Picklist.ID. |
| NormalValue | varchar(255) | 255 | NOT NULL | | ('') | Normal Value |
| RCDID | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Resultable Concept. Link to RCD_Header.ID |
 | ActiveQODE | [dbo].[dict_id] | 5 | NOT 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') Check Constraints CK_QO_DE_CognitiveStatus_Yes_Or_No : ([CognitiveStatus]='N' OR [CognitiveStatus]='Y')](../../../../Images/c-constraint.png) | CognitiveStatus | [dbo].[BOOL] | 1 | NULL allowed | | ('N') | Cognitive Status indicator (Y/N) |
![Check Constraints CK_QO_DE_FunctionalStatus_Yes_Or_No : ([FunctionalStatus]='N' OR [FunctionalStatus]='Y') Check Constraints CK_QO_DE_FunctionalStatus_Yes_Or_No : ([FunctionalStatus]='N' OR [FunctionalStatus]='Y')](../../../../Images/c-constraint.png) | FunctionalStatus | [dbo].[BOOL] | 1 | NULL allowed | | ('N') | Functional Status indicator (Y/N) |
| ExcludeFromComparison | [dbo].[BOOL] | 1 | NULL allowed | | ('N') | Exclude individual Resultable items from Result History
|
| ExcludeDuplicateCheck | [dbo].[BOOL] | 1 | NULL allowed | | ('N') | Exclude individual Resultable items from Duplicate Checking |
| ChartAlertCreationCriteria | varchar(2) | 2 | NOT 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 |
| SearchResultText | varchar(255) | 255 | NULL allowed | | | search result text for Chart alert of resultable item. |
| ChartAlertTextType | char(1) | 1 | NULL allowed | | | Chart Alert Text type R- Result Value F - Free text |
| ChartAlertFreeText | varchar(70) | 70 | NULL allowed | | | Free text value for Chart alert |
| AppendResultTextFLAG | char(1) | 1 | NOT NULL | | ('N') | Append result value when 'Y'. |
| AnswerPicklistIDs | varchar(4000) | 4000 | NULL allowed | | | Applicable to resultable item having answer data type is picklist |