Tables [dbo].[Additional_Information]
Additional Information Questions instance data
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Key PK_Additional_Info: patientid\AdditionalInformationDE\ItemID\ItemTypeIndexes NIX_Additional_Information_AdditionalInformationDE_EncounterID_ItemType_ItemID_INC_thisvalue, IX_Additional_Info_Encounter2, IX_Additional_Info_Item, IX_Additional_Info_Encounter, TWstat_Additional_Information_ItemID_patientid_AdditionalInformationDE_ItemType, TWstat_Additional_Information_ItemType_patientid_AdditionalInformationDE_ItemID, TWstat_Additional_Information_providerid_patientid_AdditionalInformationDE_ItemID_ItemType, TWstat_Additional_Information_recordedDTTM_patientid_AdditionalInformationDE_ItemID_ItemType(8)ItemID[dbo].[uniqueid]9NOT NULLOrder Header ID. Link to Item_plan.ID, Item_Immunization.ID, etc.
Cluster Key PK_Additional_Info: patientid\AdditionalInformationDE\ItemID\ItemTypeIndexes NIX_Additional_Information_AdditionalInformationDE_EncounterID_ItemType_ItemID_INC_thisvalue, TWstat_Additional_Information_ItemID_patientid_AdditionalInformationDE_ItemType, TWstat_Additional_Information_ItemType_patientid_AdditionalInformationDE_ItemID, TWstat_Additional_Information_providerid_patientid_AdditionalInformationDE_ItemID_ItemType, TWstat_Additional_Information_recordedDTTM_patientid_AdditionalInformationDE_ItemID_ItemType(5)Check Constraints ck_Additional_Information_ItemType : ([ItemType]='Charge' OR [ItemType]='Order' OR [ItemType]='IM')ItemTypevarchar(50)50NULL allowed('order')Item Type. Allowed values 'Order', 'Charge', 'IM'
Cluster Key PK_Additional_Info: patientid\AdditionalInformationDE\ItemID\ItemTypeIndexes NIX_Additional_Information_AdditionalInformationDE_EncounterID_ItemType_ItemID_INC_thisvalue, NIX_Additional_Info_Provider, NIX_Additional_Info_RPL, IX_Additional_Info_Encounter2, NIX_Additional_Info_encounter3, IX_Additional_Info_Item, IX_Additional_Info_Encounter, NIX_Additional_Info_Patient, TWstat_Additional_Information_ItemID_patientid_AdditionalInformationDE_ItemType, TWstat_Additional_Information_ItemType_patientid_AdditionalInformationDE_ItemID, TWstat_Additional_Information_providerid_patientid_AdditionalInformationDE_ItemID_ItemType, TWstat_Additional_Information_recordedDTTM_patientid_AdditionalInformationDE_ItemID_ItemType(12)AdditionalInformationDE[dbo].[dict_id]5NOT NULLAdditional Information Dictionary ID. Link to Additional_Information_DE.ID
Cluster Key PK_Additional_Info: patientid\AdditionalInformationDE\ItemID\ItemTypeIndexes NIX_Additional_Info_encounter3, IX_Additional_Info_Encounter, NIX_Additional_Info_Patient, TWstat_Additional_Information_ItemID_patientid_AdditionalInformationDE_ItemType, TWstat_Additional_Information_ItemType_patientid_AdditionalInformationDE_ItemID, TWstat_Additional_Information_providerid_patientid_AdditionalInformationDE_ItemID_ItemType, TWstat_Additional_Information_recordedDTTM_patientid_AdditionalInformationDE_ItemID_ItemType(7)Foreign Keys FK_Additional_Information_PatientID_Patient_Member_ID: [dbo].[Patient_Member].patientidpatientid[dbo].[uniqueid]9NOT NULLPatient Identifier. Link toPatient_Member.ID
Indexes NIX_Additional_Info_Provider, TWstat_Additional_Information_providerid_patientid_AdditionalInformationDE_ItemID_ItemType(2)providerid[dbo].[uniqueid]9NOT NULLProvider Identifier. Link to Provider.ID
Indexes NIX_Additional_Information_AdditionalInformationDE_EncounterID_ItemType_ItemID_INC_thisvalue, IX_Additional_Info_Encounter2, NIX_Additional_Info_encounter3, IX_Additional_Info_Encounter(4)encounterid[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID.
datatypevarchar(50)50NULL allowed('text')Answer value Data Type
Example : DateTime
                  Numeric
                  Picklist
                  Text
                  USZipCode
Indexes NIX_Additional_Information_AdditionalInformationDE_EncounterID_ItemType_ItemID_INC_thisvaluethisvaluevarchar(7000)7000NULL allowedSelected Answer for the Question
Indexes NIX_Additional_Info_Provider, NIX_Additional_Info_RPL, NIX_Additional_Info_encounter3, NIX_Additional_Info_Patient, TWstat_Additional_Information_recordedDTTM_patientid_AdditionalInformationDE_ItemID_ItemType(5)recordedDTTMdatetime8NOT NULL(getdate())Date and time the question was answered.
Check Constraints CK_Additional_Information_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULL('N')Is this entry inactive (Y/N)? Always N.
Sequenceint4NOT NULL(0)Answer sequence
Check Constraints CK_Additional_Information_IsParentFLAG_Yes_Or_No : ([IsParentFLAG]='N' OR [IsParentFLAG]='Y')IsParentFLAG[dbo].[BOOL]1NOT NULL('N')Is this question a parent question(Y/N)?
Indexes TWstat_Additional_Information_ParentAdditionalInformationIDForeign Keys FK_ParentAdditionalInformationID: [dbo].[Additional_Information_DE].ParentAdditionalInformationIDParentAdditionalInformationID[dbo].[dict_id]5NOT NULL(0)Parent Additional Information Identifier. Link to Additional_Information_DE.ID.
ConditionalQuestionsXMLvarchar(max)maxNULL allowedConditional questions in XML format
Indexes NIX_Additional_Info_RPL, TWstat_Additional_Information_ReqPerfLocationDE(2)Foreign Keys FK_ReqPerfLocationDE: [dbo].[Req_Perf_Location_DE].ReqPerfLocationDEReqPerfLocationDE[dbo].[dict_id]5NOT NULL(0)Requested Performing Location. Link to Req_Perf_Location_DE.ID
Indexes TWstat_Additional_Information_OIDDEOIDDE[dbo].[dict_id]5NOT NULL(0)Orderable item. Qo_Classification_DE.ID
Indexes TWstat_Additional_Information_OIDTypeCheck Constraints CK_Additional_Information_OIDType : ([OIDType]='M' OR [OIDType]='O')OIDTypechar(1)1NOT NULL('O')Orderable item type. Allowed values 'O' or 'M'
ChildAdditionalInformationDEListvarchar(255)255NOT NULL('')List of Child additional information Dictionary ID's separated by comma.