Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 (11) | ID | [dbo].[dict_id] | 5 | NOT NULL | 1 - 1 | | Key to the Additional_Information_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 | | | Entry Code |
(13) | EntryName | [dbo].[name] | 255 | NOT NULL | | | Entry Name |
(3) | EntryMnemonic | [dbo].[code] | 10 | NOT NULL | | | Entry Mnemonic |
(5)![Check Constraints CK_Additional_Information_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_Additional_Information_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Is the entry inactive (Y/N)? |
 ![Check Constraints CK_Additional_Information_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y') Check Constraints CK_Additional_Information_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')](../../../../Images/c-constraint.png) | IsEnforcedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Is the entry Enforced (Y/N)? Enforced entries can not be modified by the application. |
(13)![Check Constraints CK_Additional_Information_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y') Check Constraints CK_Additional_Information_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')](../../../../Images/c-constraint.png) | IsCurrentFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Is the entry Current (Y/N)? |
| EffectiveDT | datetime | 8 | NULL allowed | | | Effective Date. This is the last edited date. |
 ![Foreign Keys FK_Additional_Information_DE_Answer_Data_Type_DE: [dbo].[Answer_Data_Type_DE].answerdatatypeDE Foreign Keys FK_Additional_Information_DE_Answer_Data_Type_DE: [dbo].[Answer_Data_Type_DE].answerdatatypeDE](../../../../Images/fk.png) | answerdatatypeDE | [dbo].[dict_id] | 5 | NOT 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].answerpersistenceDE Foreign Keys FK_Additional_Information_DE_Answer_Persistence_DE: [dbo].[Answer_Persistence_DE].answerpersistenceDE](../../../../Images/fk.png) | answerpersistenceDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Answer Persistence. Link to Answer_Persistence_DE.ID |
![Foreign Keys FK_Additional_Information_DE_Mandatory_Level_DE: [dbo].[Mandatory_Level_DE].mandatorylevelDE Foreign Keys FK_Additional_Information_DE_Mandatory_Level_DE: [dbo].[Mandatory_Level_DE].mandatorylevelDE](../../../../Images/fk.png) | mandatorylevelDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Mandatory Level. Link to Mandatory_Level_DE.ID |
 | minimumapplicableage | int | 4 | NULL allowed | | | Minimum Applicable Age (in years) for the question |
 | maximumapplicableage | int | 4 | NULL allowed | | | Maximum Applicable Age (in years) for the question |
 ![Foreign Keys FK_Additional_Information_DE_Sex_DE: [dbo].[Sex_DE].gendertoexcludeSEXDE Foreign Keys FK_Additional_Information_DE_Sex_DE: [dbo].[Sex_DE].gendertoexcludeSEXDE](../../../../Images/fk.png) | gendertoexcludeSEXDE | [dbo].[dict_id] | 5 | NULL allowed | | | Gender to exclude the questions. Link to Sex_DE.ID |
 | answerpicklistID | [dbo].[uniqueid] | 9 | NULL allowed | | | Picklist for the answer. Link to Picklist.ID |
| numberoflines | int | 4 | NULL allowed | | | Maximum number of lines allowed for the answer |
| prompt | varchar(255) | 255 | NULL allowed | | | Question |
 | ItemType | varchar(50) | 50 | NOT NULL | | ('Order') | Item Type : Charge IM Order Problem |
 ![Check Constraints CK_Additional_Information_DE_AlwaysDisplayFLAG_Yes_Or_No : ([AlwaysDisplayFLAG]='N' OR [AlwaysDisplayFLAG]='Y') Check Constraints CK_Additional_Information_DE_AlwaysDisplayFLAG_Yes_Or_No : ([AlwaysDisplayFLAG]='N' OR [AlwaysDisplayFLAG]='Y')](../../../../Images/c-constraint.png) | AlwaysDisplayFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Always Display the question (Y/N) |
| Conditions | varchar(max) | max | NOT NULL | | ('') | Condition to display the Conditional question |
 | DefaultFromQoDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Default resultable item |
![Check Constraints CK_Additional_Information_DE_ClinicalApplicabilityFLAG_Yes_Or_No : ([ClinicalApplicabilityFLAG]='N' OR [ClinicalApplicabilityFLAG]='Y') Check Constraints CK_Additional_Information_DE_ClinicalApplicabilityFLAG_Yes_Or_No : ([ClinicalApplicabilityFLAG]='N' OR [ClinicalApplicabilityFLAG]='Y')](../../../../Images/c-constraint.png) | ClinicalApplicabilityFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Specifies that the question being asked is Clinically Applicable |
| PicklistDefaultDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Default answer for the question. Answer_DE.ID |
| MaxNumberOfCharacters | int | 4 | NOT NULL | | (0) | Maximum number of characters allowed for the answer |
![Foreign Keys FK_Additional_Information_DE_DateFormatDE: [dbo].[Date_Format_DE].DateFormatDE Foreign Keys FK_Additional_Information_DE_DateFormatDE: [dbo].[Date_Format_DE].DateFormatDE](../../../../Images/fk.png) | DateFormatDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Date Format. Link to Date_Format_DE.ID |
| NumericMinimumValue | int | 4 | NOT NULL | | (0) | Minimum numerical value allowed for the answer |
| NumericMaximumValue | int | 4 | NOT NULL | | (0) | Maximum numerical value allowed for the answer |
| ConditionalOperator | varchar(255) | 255 | NOT 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 ( <=) |
| ConditionalValue | varchar(255) | 255 | NOT NULL | | ('') | Answer for the Conditional question |
| PickListDictionaryID | [dbo].[dict_id] | 5 | NOT NULL | | (0) | PickList Dictionary ID |
| Increment | real | 4 | NOT NULL | | (0) | Increment Unit |
| Precision | real | 4 | NOT 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') Check Constraints CK_Additional_Information_DE_AppearInNoteTextFLAG_Yes_Or_No : ([AppearInNoteTextFLAG]='N' OR [AppearInNoteTextFLAG]='Y')](../../../../Images/c-constraint.png) | AppearInNoteTextFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('Y') | Appear in Note Text (Y/N)? |
| ConditionalQuestionsXML | varchar(max) | max | NULL allowed | | | Conditional Questions in XML format |
| OrgSharingDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Organization Sharing Pool ID. Link to Org_Sharing_DE.ID |
| DefaultValue | varchar(max) | max | NULL 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') Check Constraints CK_Additional_Information_DE_ContraindicationOrderFLAG_Yes_Or_No : ([ContraindicationOrderFLAG]='N' OR [ContraindicationOrderFLAG]='Y')](../../../../Images/c-constraint.png) | ContraindicationOrderFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Specifies that the question is regarding an absolute contraindication for a non-medication order |
| AllowMultipleAnswerFlag | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | When set, Allows Multiple Answer |
| AllowFreeTextAnswerFlag | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | When set, Allows Free text |
| CheckFinalizedNoteFLAG | [dbo].[BOOL] | 1 | NOT 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 |