Tables [dbo].[Additional_Information_DE]
Additional Information Questions Dictionary
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Additional_Information_DE_ID: IDIndexes IX_Additional_Info_DE, TWstat_Additional_Information_DE_AlwaysDisplayFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_answerdatatypeDE_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_answerpicklistID_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_DefaultFromQoDE_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_gendertoexcludeSEXDE_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_IsCurrentFLAG_EntryName_ID, TWstat_Additional_Information_DE_IsEnforcedFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_maximumapplicableage_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_minimumapplicableage_EntryName_IsCurrentFLAG_ID(11)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the Additional_Information_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 NIX_Additional_Information_DE_EntryCode_WithIncludeColumns, NIX_Additional_Information_DE_EntryMnemonic_WithIncludeColumns, NIX_Additional_Information_DE_EntryName_WithIncludeColumns(3)EntryCode[dbo].[code]10NOT NULLEntry Code
Indexes NIX_Additional_Information_DE_EntryCode_WithIncludeColumns, NIX_Additional_Information_DE_EntryMnemonic_WithIncludeColumns, NIX_Additional_Information_DE_EntryName_WithIncludeColumns, TWstat_Additional_Information_DE_AlwaysDisplayFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_answerdatatypeDE_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_answerpicklistID_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_DefaultFromQoDE_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_gendertoexcludeSEXDE_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_IsCurrentFLAG_EntryName_ID, TWstat_Additional_Information_DE_IsEnforcedFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_maximumapplicableage_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_minimumapplicableage_EntryName_IsCurrentFLAG_ID(13)EntryName[dbo].[name]255NOT NULLEntry Name
Indexes NIX_Additional_Information_DE_EntryCode_WithIncludeColumns, NIX_Additional_Information_DE_EntryMnemonic_WithIncludeColumns, NIX_Additional_Information_DE_EntryName_WithIncludeColumns(3)EntryMnemonic[dbo].[code]10NOT NULLEntry Mnemonic
Indexes NIX_Additional_Information_DE_EntryCode_WithIncludeColumns, NIX_Additional_Information_DE_EntryMnemonic_WithIncludeColumns, NIX_Additional_Information_DE_EntryName_WithIncludeColumns, IX_Additional_Info_DE, TWstat_Additional_Information_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(5)Check Constraints CK_Additional_Information_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLIs the entry inactive (Y/N)?
Indexes TWstat_Additional_Information_DE_IsEnforcedFLAG_EntryName_IsCurrentFLAG_IDCheck Constraints CK_Additional_Information_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLIs the entry Enforced (Y/N)? Enforced entries can not be modified by the application.
Indexes NIX_Additional_Information_DE_EntryCode_WithIncludeColumns, NIX_Additional_Information_DE_EntryMnemonic_WithIncludeColumns, NIX_Additional_Information_DE_EntryName_WithIncludeColumns, TWstat_Additional_Information_DE_AlwaysDisplayFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_answerdatatypeDE_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_answerpicklistID_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_DefaultFromQoDE_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_gendertoexcludeSEXDE_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_IsCurrentFLAG_EntryName_ID, TWstat_Additional_Information_DE_IsEnforcedFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_maximumapplicableage_EntryName_IsCurrentFLAG_ID, TWstat_Additional_Information_DE_minimumapplicableage_EntryName_IsCurrentFLAG_ID(13)Check Constraints CK_Additional_Information_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')IsCurrentFLAG[dbo].[BOOL]1NOT NULLIs the entry Current (Y/N)?
EffectiveDTdatetime8NULL allowedEffective Date. This is the last edited date.
Indexes TWstat_Additional_Information_DE_answerdatatypeDE_EntryName_IsCurrentFLAG_IDForeign Keys FK_Additional_Information_DE_Answer_Data_Type_DE: [dbo].[Answer_Data_Type_DE].answerdatatypeDEanswerdatatypeDE[dbo].[dict_id]5NOT NULL(0)Answer Data Type. Link to Answer_Data_Type_DE.ID
Foreign Keys FK_Additional_Information_DE_Answer_Persistence_DE: [dbo].[Answer_Persistence_DE].answerpersistenceDEanswerpersistenceDE[dbo].[dict_id]5NOT NULL(0)Answer Persistence. Link to Answer_Persistence_DE.ID
Foreign Keys FK_Additional_Information_DE_Mandatory_Level_DE: [dbo].[Mandatory_Level_DE].mandatorylevelDEmandatorylevelDE[dbo].[dict_id]5NOT NULL(0)Mandatory Level. Link to Mandatory_Level_DE.ID
Indexes TWstat_Additional_Information_DE_minimumapplicableage_EntryName_IsCurrentFLAG_IDminimumapplicableageint4NULL allowedMinimum Applicable Age (in years) for the question
Indexes TWstat_Additional_Information_DE_maximumapplicableage_EntryName_IsCurrentFLAG_IDmaximumapplicableageint4NULL allowedMaximum Applicable Age (in years) for the question
Indexes TWstat_Additional_Information_DE_gendertoexcludeSEXDE_EntryName_IsCurrentFLAG_IDForeign Keys FK_Additional_Information_DE_Sex_DE: [dbo].[Sex_DE].gendertoexcludeSEXDEgendertoexcludeSEXDE[dbo].[dict_id]5NULL allowedGender to exclude the questions. Link to Sex_DE.ID
Indexes TWstat_Additional_Information_DE_answerpicklistID_EntryName_IsCurrentFLAG_IDanswerpicklistID[dbo].[uniqueid]9NULL allowedPicklist for the answer. Link to Picklist.ID
numberoflinesint4NULL allowedMaximum number of lines allowed for the answer
promptvarchar(255)255NULL allowedQuestion
Indexes IX_Additional_Info_DEItemTypevarchar(50)50NOT NULL('Order')Item Type :
   Charge
   IM
   Order
   Problem
Indexes TWstat_Additional_Information_DE_AlwaysDisplayFLAG_EntryName_IsCurrentFLAG_IDCheck Constraints CK_Additional_Information_DE_AlwaysDisplayFLAG_Yes_Or_No : ([AlwaysDisplayFLAG]='N' OR [AlwaysDisplayFLAG]='Y')AlwaysDisplayFLAG[dbo].[BOOL]1NOT NULL('N')Always Display the question (Y/N)
Conditionsvarchar(max)maxNOT NULL('')Condition to display the Conditional question
Indexes TWstat_Additional_Information_DE_DefaultFromQoDE_EntryName_IsCurrentFLAG_IDDefaultFromQoDE[dbo].[dict_id]5NOT NULL(0)Default resultable item
Check Constraints CK_Additional_Information_DE_ClinicalApplicabilityFLAG_Yes_Or_No : ([ClinicalApplicabilityFLAG]='N' OR [ClinicalApplicabilityFLAG]='Y')ClinicalApplicabilityFLAG[dbo].[BOOL]1NOT NULL('N')Specifies that the question being asked is Clinically Applicable
PicklistDefaultDE[dbo].[dict_id]5NOT NULL(0)Default answer for the question. Answer_DE.ID
MaxNumberOfCharactersint4NOT NULL(0)Maximum number of characters allowed for the answer
Foreign Keys FK_Additional_Information_DE_DateFormatDE: [dbo].[Date_Format_DE].DateFormatDEDateFormatDE[dbo].[dict_id]5NOT NULL(0)Date Format. Link to Date_Format_DE.ID
NumericMinimumValueint4NOT NULL(0)Minimum numerical value allowed for the answer
NumericMaximumValueint4NOT NULL(0)Maximum numerical value allowed for the answer
ConditionalOperatorvarchar(255)255NOT NULL('')Conditional Operator :
  1 - Equal to (=)
  2 - Less-than ( < )
  3 - Greater-than ( >)
  4 - Not equal to  (!=)
  5 - Greater-than or equal to ( >=)
  6 - Less-than or equal to ( <=)  
ConditionalValuevarchar(255)255NOT NULL('')Answer for the Conditional question
PickListDictionaryID[dbo].[dict_id]5NOT NULL(0)PickList Dictionary ID
Incrementreal4NOT NULL(0)Increment Unit
Precisionreal4NOT NULL(0)Number of decimal places allowed for an answer
Check Constraints CK_Additional_Information_DE_AppearInNoteTextFLAG_Yes_Or_No : ([AppearInNoteTextFLAG]='N' OR [AppearInNoteTextFLAG]='Y')AppearInNoteTextFLAG[dbo].[BOOL]1NOT NULL('Y')Appear in Note Text (Y/N)?
ConditionalQuestionsXMLvarchar(max)maxNULL allowedConditional Questions in XML format
OrgSharingDE[dbo].[dict_id]5NOT NULL(0)Organization Sharing Pool ID. Link to Org_Sharing_DE.ID
DefaultValuevarchar(max)maxNULL allowed('')Gender based default value for the answer ( in XML format)
Check Constraints CK_Additional_Information_DE_ContraindicationOrderFLAG_Yes_Or_No : ([ContraindicationOrderFLAG]='N' OR [ContraindicationOrderFLAG]='Y')ContraindicationOrderFLAG[dbo].[BOOL]1NOT NULL('N')Specifies that the question is regarding an absolute contraindication for a non-medication order
AllowMultipleAnswerFlag[dbo].[BOOL]1NOT NULL('N')When set, Allows Multiple Answer
AllowFreeTextAnswerFlag[dbo].[BOOL]1NOT NULL('N')When set, Allows Free text
CheckFinalizedNoteFLAG[dbo].[BOOL]1NOT NULL('N')Filter additional information question if any one of the notes are not finalized for the Encounter

Y - Question will be filtered based on the Note status
N  - Question will not be filtered based on the Note status