Tables [dbo].[Item_Finding]
This is an item level table for findings. Findings are defined as anything under the Clinical Findings category in the OID such as vital signs. For every finding on a patient's chart there will only be 1 entry in this table as it's an item level table.
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Primary Key PK_Item_Finding_ID: IDID[dbo].[uniqueid]9NOT NULLKey to the dbo.Item_Finding table
Indexes NIX_Item_Finding_ActivityHeaderID_WithIncludeColumnsActivityHeaderID[dbo].[uniqueid]9NOT NULLActivity Header. Link to dbo.Act_Hdr_Other.ID
Cluster Key XAK1ItemFinding: PatientIDIndexes TWstat_Item_Finding_CurrentID_PatientID, TWstat_Item_Finding_DetailType_PatientID, TWstat_Item_Finding_EntryName_PatientID, TWstat_Item_Finding_IsErrorFLAG_PatientID, TWstat_Item_Finding_ItemType_PatientID, TWstat_Item_Finding_OrderItemEXT_PatientID, TWstat_Item_Finding_PerformedDTTM_PatientID, TWstat_Item_Finding_QOClassificationDE_PatientID, TWstat_Item_Finding_QODE_PatientID, TWstat_Item_Finding_QOMod1DE_PatientID, TWstat_Item_Finding_QOMod2DE_PatientID, TWstat_Item_Finding_QOMod3DE_PatientID(12)Foreign Keys FK_Item_Finding_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID
Indexes TWstat_Item_Finding_OrderItemEXT_PatientIDOrderItemEXTvarchar(20)20NOT NULLExternal Order Number
Indexes NIX_Item_Finding_ActivityHeaderID_WithIncludeColumns, NIX_Item_Finding_CurrentID, TWstat_Item_Finding_CurrentID_PatientID(3)CurrentIDnumeric(16,0)9NOT NULLThis points to the ID of the current version level entry of the finding in the dbo.finding table
Indexes NIX_Item_Finding_ActivityHeaderID_WithIncludeColumns, XAK2_QODE_QOCLASSIFICATIONDE_ITEM_FINDING, TWstat_Item_Finding_QODE_PatientID(3)Foreign Keys FK_Item_Finding_QODE_QO_DE_ID: [dbo].[QO_DE].QODEQODE[dbo].[dict_id]5NOT NULLResultable Item. Link to QO_DE.ID.
QODETvarchar(255)255NOT NULLResultable Item entryname. QO_DE.Entryname.
Indexes TWstat_Item_Finding_QOMod1DE_PatientIDForeign Keys FK_Item_Finding_QOMod1DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod1DEQOMod1DE[dbo].[dict_id]5NOT NULLOrdable Item Modifier. Link to QO_Mod_DE.ID
Indexes TWstat_Item_Finding_QOMod2DE_PatientIDForeign Keys FK_Item_Finding_QOMod2DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod2DEQOMod2DE[dbo].[dict_id]5NOT NULLOrdable Item Modifier. Link to QO_Mod_DE.ID
Indexes TWstat_Item_Finding_QOMod3DE_PatientIDForeign Keys FK_Item_Finding_QOMod3DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod3DEQOMod3DE[dbo].[dict_id]5NOT NULLOrdable Item Modifier. Link to QO_Mod_DE.ID
QOModDETvarchar(255)255NOT NULLOrdable Item Modifier entryname. Link to QO_Mod_DE.Entryname
Indexes NIX_Item_Finding_ActivityHeaderID_WithIncludeColumns, XAK2_QODE_QOCLASSIFICATIONDE_ITEM_FINDING, TWstat_Item_Finding_QOClassificationDE_PatientID(3)Foreign Keys FK_Item_Finding_QOClassificationDE_QO_Classification_DE_ID: [dbo].[QO_Classification_DE].QOClassificationDEQOClassificationDE[dbo].[dict_id]5NOT NULLOrderable Item. Link to QO_Classification_DE.ID.
QOClassificationDETvarchar(255)255NOT NULLOrdable Item entryname. Link to QO_Classification_DE.Entryname
DocFolderIDnumeric(16,0)9NOT NULLNot used, will default to blank
Indexes TWstat_Item_Finding_EntryName_PatientIDEntryNamevarchar(255)255NOT NULLentryname of the finding
Indexes NIX_Item_Finding_CreateDTTM, TWstat_Item_Finding_CreateDTTM(2)CreateDTTMdatetime8NOT NULLdate Finding was added to the patient's chart
Indexes Portal_Item_FindingLastUpdateDTTMdatetime8NOT NULLdate finding was last updated
Check Constraints CK_Item_Finding_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')HasSecurityFLAG[dbo].[BOOL]1NOT NULLSecurity? Y/N
Check Constraints CK_Item_Finding_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')HasAnnotationFLAG[dbo].[BOOL]1NOT NULLAnnotated? Y/N
Check Constraints CK_Item_Finding_IsAbnormalFLAG_Yes_Or_No : ([IsAbnormalFLAG]='N' OR [IsAbnormalFLAG]='Y')IsAbnormalFLAG[dbo].[BOOL]1NOT NULLAbnormal? Y/N
Indexes TWstat_Item_Finding_IsErrorFLAG_PatientIDIsErrorFLAG[dbo].[BOOL]1NOT NULLEntered in Error? Y/N
Indexes TWstat_Item_Finding_DetailType_PatientIDDetailTypechar(1)1NOT NULLDetail Type - V
Indexes TWstat_Item_Finding_ItemType_PatientIDCheck Constraints CK_Item_Finding_ItemType : ([ItemType]='FI')ItemTypechar(2)2NOT NULLFI for finding
Indexes TWstat_Item_Finding_DecodedValueDecodedValuevarchar(255)255NOT NULLDecoded value of the finding. For instance 9.072 kg for weight or 30.48 cm for height.
Indexes TWstat_Item_Finding_PerformedDTTM_PatientIDPerformedDTTMdatetime8NOT NULLDate Finding was performed. Typically Vital Signs taken