Tables [dbo].[Item_Result]
Item level table for Results.
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Primary Key PK_Item_Result_ID: IDIndexes NIX_Item_Result_ActivityHeaderIDIDCurrentIDIsAbnormalFlagPerformedDTTM, XAK5_ItemResult, Portal_Item_Result_LastUpdateDTTM_ActivityHeaderID_ID_OrderItemExt(3)ID[dbo].[uniqueid]9NOT NULLKey to the Item_Resilt table.
Indexes xak2_itemresult_acthdr, NIX_Item_Result_ActivityHeaderIDIDCurrentIDIsAbnormalFlagPerformedDTTM, XAK5_ItemResult, Portal_Item_Result_LastUpdateDTTM_ActivityHeaderID_ID_OrderItemExt(4)ActivityHeaderID[dbo].[uniqueid]9NOT NULLActivity Header. Link to Act_Hdr_Result.ID.
Cluster Key XAK1ItemResult: PatientIDIndexes XAK5_ItemResult, TWstat_Item_Result_CreateDTTM_PatientID, TWstat_Item_Result_CurrentID_PatientID, TWstat_Item_Result_DecodedValue_PatientID, TWstat_Item_Result_EntryName_PatientID, TWstat_Item_Result_IsAbnormalFLAG_PatientID, TWstat_Item_Result_IsErrorFLAG_PatientID, TWstat_Item_Result_ItemType_PatientID, TWstat_Item_Result_LastUpdateDTTM_PatientID, TWstat_Item_Result_OrderItemEXT_PatientID, TWstat_Item_Result_PerformedDTTM_PatientID, TWstat_Item_Result_QOClassificationDE_PatientID, TWstat_Item_Result_QODE_PatientID, TWstat_Item_Result_QOMod1DE_PatientID, TWstat_Item_Result_QOMod2DE_PatientID, TWstat_Item_Result_QOMod3DE_PatientID(16)Foreign Keys FK_Item_Result_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
Indexes NIX_Item_Result_ActivityHeaderIDIDCurrentIDIsAbnormalFlagPerformedDTTM, XAK5_ItemResult, Portal_Item_Result_LastUpdateDTTM_ActivityHeaderID_ID_OrderItemExt, xak3_itemresult_orditmext, TWstat_Item_Result_OrderItemEXT_PatientID(5)OrderItemEXTvarchar(20)20NOT NULLExternal Order Number
Indexes NIX_Item_Result_ActivityHeaderIDIDCurrentIDIsAbnormalFlagPerformedDTTM, XAK5_ItemResult, NIX_Item_Result_CurrentID, TWstat_Item_Result_CurrentID_PatientID(4)CurrentIDnumeric(16,0)9NOT NULLCurrent detail row. Link to Result.ID.
Indexes XAK5_ItemResult, XAK2_QODE_QOCLASSIFICATIONDE_ITEM_RESULT, TWstat_Item_Result_QODE_PatientID(3)Foreign Keys FK_Item_Result_QODE_QO_DE_ID: [dbo].[QO_DE].QODEQODE[dbo].[dict_id]5NOT NULLResultable Item. Link to QO_DE.ID.
QODETvarchar(255)255NOT NULLResultable Item text. no longer used.
Indexes TWstat_Item_Result_QOMod1DE_PatientIDForeign Keys FK_Item_Result_QOMod1DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod1DEQOMod1DE[dbo].[dict_id]5NOT NULLFirst Orderable Item Modifier. Link to QO_Mod_DE.ID
Indexes TWstat_Item_Result_QOMod2DE_PatientIDForeign Keys FK_Item_Result_QOMod2DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod2DEQOMod2DE[dbo].[dict_id]5NOT NULLSecond Orderable Item Modifier. Link to QO_Mod_DE.ID
Indexes TWstat_Item_Result_QOMod3DE_PatientIDForeign Keys FK_Item_Result_QOMod3DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod3DEQOMod3DE[dbo].[dict_id]5NOT NULLThird Orderable Item Modifier. Link to QO_Mod_DE.ID
QOModDETvarchar(255)255NOT NULLOrderable item modifier text. No longer used.
Indexes XAK5_ItemResult, XAK2_QODE_QOCLASSIFICATIONDE_ITEM_RESULT, TWstat_Item_Result_QOClassificationDE_PatientID(3)Foreign Keys FK_Item_Result_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 NULLOrderable Item Text. No longer Used.
DocFolderIDnumeric(16,0)9NOT NULLDocument Folder Identifier. No longer used.
Indexes TWstat_Item_Result_EntryName_PatientIDEntryNamevarchar(255)255NOT NULLResultable Item name.
Indexes TWstat_Item_Result_CreateDTTM_PatientIDCreateDTTMdatetime8NOT NULLDateTime the Result was created
Indexes Portal_Item_Result_LastUpdateDTTM_ActivityHeaderID_ID_OrderItemExt, TWstat_Item_Result_LastUpdateDTTM_PatientID(2)LastUpdateDTTMdatetime8NOT NULLLast time the Result was updated
Check Constraints CK_Item_Result_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')HasSecurityFLAG[dbo].[BOOL]1NOT NULLHas Security (Y/N)
Check Constraints CK_Item_Result_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')HasAnnotationFLAG[dbo].[BOOL]1NOT NULLHas an Annotation (Y/N)
Indexes NIX_Item_Result_ActivityHeaderIDIDCurrentIDIsAbnormalFlagPerformedDTTM, XAK5_ItemResult, TWstat_Item_Result_IsAbnormalFLAG_PatientID(3)Check Constraints CK_Item_Result_IsAbnormalFLAG_Yes_Or_No : ([IsAbnormalFLAG]='N' OR [IsAbnormalFLAG]='Y')IsAbnormalFLAG[dbo].[BOOL]1NOT NULLIs Abnormal (Y/N)
Indexes XAK5_ItemResult, TWstat_Item_Result_IsErrorFLAG_PatientID(2)IsErrorFLAG[dbo].[BOOL]1NOT NULLEntered In Error (Y/N)
DetailTypechar(1)1NOT NULLDetail Type. (R, L)
Indexes TWstat_Item_Result_ItemType_PatientIDCheck Constraints CK_Item_Result_ItemType : ([ItemType]='RS')ItemTypechar(2)2NOT NULLItem Type. RS - Result
Indexes TWstat_Item_Result_DecodedValue_PatientIDDecodedValuevarchar(255)255NOT NULLValue including units.
Indexes NIX_Item_Result_ActivityHeaderIDIDCurrentIDIsAbnormalFlagPerformedDTTM, TWstat_Item_Result_PerformedDTTM_PatientID(2)PerformedDTTMdatetime8NOT NULLWhen the values were recorded