Tables [dbo].[Result]
Versioned detail table for Results
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_Result_ID: IDCluster Key CIX_Result_ID_ArchiveState: ID\ArchiveStateIndexes TWstat_Result_AbnormalFlagType_ID, TWstat_Result_AccessionNumber_ID, TWstat_Result_AnswerDataTypeDE_ID, TWstat_Result_AnswerDE_ID, TWstat_Result_ClinicalDTTM_ID, TWstat_Result_NormalizedUnitsDE_ID, TWstat_Result_NoteActivityID_ID, TWstat_Result_PerformedDTTM_ID, TWstat_Result_ResultDTTM_ID, TWstat_Result_ResultStatusDE_ID, TWstat_Result_SourceDE_ID, TWstat_Result_UnitsDE_ID, TWstat_Result_WherePerformedDE_ID, TWstat_Result_WhoDidItID_ID, TWstat_Result_WhoForID_ID(15)ID[dbo].[uniqueid]9NOT NULLKey to the Result table
Indexes NIX_Result_ItemID_INC_ClinicalDTTM_RecordedDTTM, NIX_Result_RecordedDttm_INC_ItemID(2)Foreign Keys FK_Result_ItemID_Item_Result_ID: [dbo].[Item_Result].ItemIDItemID[dbo].[uniqueid]9NOT NULLItem. Link to Item_Result.ID.
Indexes TWstat_Result_NoteActivityID_IDNoteActivityIDnumeric(16,0)9NOT NULLAudit Note. Link to Act_Hdr_Note.ID.
Indexes NIX_Result_NormalizedUnitsDE_ResultStatusDE_WithIncludeColumns, TWstat_Result_AnswerDE_ID(2)Foreign Keys FK_Result_AnswerDE_Answer_DE_ID: [dbo].[Answer_DE].AnswerDEAnswerDE[dbo].[dict_id]5NOT NULLResult if from a dictionary. Answer_DE.ID
Indexes TWstat_Result_AnswerDETAnswerDETvarchar(255)255NOT NULL(' ')Entered Result
Indexes NIX_Result_NormalizedUnitsDE_ResultStatusDE_WithIncludeColumns, TWstat_Result_AnswerDataTypeDE_ID(2)Foreign Keys FK_Result_AnswerDataTypeDE_Answer_Data_Type_DE_ID: [dbo].[Answer_Data_Type_DE].AnswerDataTypeDEAnswerDataTypeDE[dbo].[dict_id]5NOT NULLResult data type. Link to Answer_Data_Type_DE.ID
Indexes NIX_Result_NormalizedUnitsDE_ResultStatusDE_WithIncludeColumns, TWstat_Result_SourceDE_ID(2)Foreign Keys FK_Result_SourceDE_Source_DE_ID: [dbo].[Source_DE].SourceDESourceDE[dbo].[dict_id]5NULL allowedSource. Limk to Source_DE.ID
SourceDETvarchar(255)255NOT NULL(' ')Source text. No longer used.
Indexes NIX_Result_NormalizedUnitsDE_ResultStatusDE_WithIncludeColumns, TWstat_Result_UnitsDE_ID(2)Foreign Keys FK_Result_UnitsDE_Unit_Code_DE_ID: [dbo].[Unit_Code_DE].UnitsDEUnitsDE[dbo].[dict_id]5NOT NULL(0)Units. Link to Unit_Code_DE.ID
UnitsDETvarchar(255)255NOT NULL(' ')Units text
Indexes NIX_Result_ItemID_INC_ClinicalDTTM_RecordedDTTM, TWstat_Result_ClinicalDTTM_ID(2)ClinicalDTTMdatetime8NOT NULLClinical Date and Time of the Result
Indexes NIX_Result_NormalizedUnitsDE_ResultStatusDE_WithIncludeColumns, TWstat_Result_WherePerformedDE_ID(2)Foreign Keys FK_Result_WherePerformedDE_Where_Performed_DE_ID: [dbo].[Where_Performed_DE].WherePerformedDEWherePerformedDE[dbo].[dict_id]5NOT NULLWhere performed. Link to Where_Performed_DE.ID
WherePerformedDETvarchar(35)35NOT NULL(' ')Where performed free text. No longer used.
Indexes TWstat_Result_AccessionNumber_IDAccessionNumbervarchar(255)255NOT NULL(' ')Accession Number
Indexes NIX_Result_VerifyDTTMVerifyDTTMdatetime8NULL allowedVerified Date and Time of the Results
Indexes NIX_Result_NormalizedUnitsDE_ResultStatusDE_WithIncludeColumns, TWstat_Result_ResultStatusDE_ID(2)Foreign Keys FK_Result_ResultStatusDE_Result_Status_DE_ID: [dbo].[Result_Status_DE].ResultStatusDEResultStatusDE[dbo].[dict_id]5NOT NULL(0)Status. link to Result_Status_DE.ID
Indexes TWstat_Result_ResultDTTM_IDResultDTTMdatetime8NOT NULLResulted Date and Time
NumericResultreal4NOT NULLResult numeric value
ShortRefRangevarchar(255)255NOT NULL(' ')Reference range
Indexes NIX_Result_NormalizedUnitsDE_ResultStatusDE_WithIncludeColumns, TWstat_Result_NormalizedUnitsDE_ID(2)Foreign Keys FK_Result_NormalizedUnitsDE_Unit_Code_DE_ID: [dbo].[Unit_Code_DE].NormalizedUnitsDENormalizedUnitsDE[dbo].[dict_id]5NOT NULL(0)Normalized units. Link to Unit_Code_DE.ID
NormalizedUnitsDETvarchar(255)255NOT NULLNormanized Units text
NormalizedValuereal4NOT NULLValue in normalized units
Check Constraints CK_Result_ReasonForCreateType_Reason_Create_Type : ([ReasonForCreateType]='A' OR [ReasonForCreateType]='C' OR [ReasonForCreateType]='E')ReasonForCreateTypechar(1)1NOT NULLCreation reason. A - Added
Indexes NIX_Result_NormalizedUnitsDE_ResultStatusDE_WithIncludeColumns, TWstat_Result_WhoForID_ID(2)WhoForID[dbo].[uniqueid]9NOT NULLWho was this entred for. Link to Provider.ID
Indexes NIX_Result_NormalizedUnitsDE_ResultStatusDE_WithIncludeColumns, NIX_Result_WhoDidItID, TWstat_Result_WhoDidItID_ID(3)Foreign Keys FK_Result_WhoDidItID_IDX_User_ID: [dbo].[IDX_User].WhoDidItIDWhoDidItID[dbo].[uniqueid]9NOT NULLWho entered the result. Link to IDX_User.ID
Indexes TWstat_Result_PerformedDTTM_IDPerformedDTTMdatetime8NOT NULLPerformed Date and Time
Indexes NIX_Result_ItemID_INC_ClinicalDTTM_RecordedDTTM, NIX_Result_RecordedDttm_INC_ItemID(2)RecordedDTTMdatetime8NOT NULLRecorded Date and Time
Indexes TWstat_Result_HasResultTextFLAGCheck Constraints CK_Result_HasResultTextFLAG_Yes_Or_No : ([HasResultTextFLAG]='N' OR [HasResultTextFLAG]='Y')HasResultTextFLAG[dbo].[BOOL]1NOT NULLIndicates whether the resultable item has result text or not (Y/N)
Check Constraints CK_Result_HasReferenceRangeFLAG_Yes_Or_No : ([HasReferenceRangeFLAG]='N' OR [HasReferenceRangeFLAG]='Y')HasReferenceRangeFLAG[dbo].[BOOL]1NOT NULLHas a reference range (Y/N). No longer used.
Check Constraints CK_Result_HasRefRangeTextFLAG_Yes_Or_No : ([HasRefRangeTextFLAG]='N' OR [HasRefRangeTextFLAG]='Y')HasRefRangeTextFLAG[dbo].[BOOL]1NOT NULLHas a textual reference range (Y/N). No longer used.
Indexes NIX_Result_ItemID_INC_ClinicalDTTM_RecordedDTTM, TWstat_Result_AbnormalFlagType_ID(2)Check Constraints CK_Result_AbnormalFlagType_Result_Abnormal_Flag : ([AbnormalFlagType]='C' OR [AbnormalFlagType]='VS' OR [AbnormalFlagType]='MS' OR [AbnormalFlagType]='R' OR [AbnormalFlagType]='I' OR [AbnormalFlagType]='S' OR [AbnormalFlagType]='O' OR [AbnormalFlagType]='W' OR [AbnormalFlagType]='B' OR [AbnormalFlagType]='D' OR [AbnormalFlagType]='U' OR [AbnormalFlagType]='' OR [AbnormalFlagType]='AA' OR [AbnormalFlagType]='A' OR [AbnormalFlagType]='N' OR [AbnormalFlagType]='>' OR [AbnormalFlagType]='<' OR [AbnormalFlagType]='HH' OR [AbnormalFlagType]='LL' OR [AbnormalFlagType]='H' OR [AbnormalFlagType]='L')AbnormalFlagTypechar(2)2NOT NULLAbnormanl flag.
Check Constraints CK_Result_ResultStage_Result_Stage : ([ResultStage]='' OR [ResultStage]='C' OR [ResultStage]='A' OR [ResultStage]='F' OR [ResultStage]='I' OR [ResultStage]='P')ResultStagechar(2)2NOT NULLStage of the Result
Valid Values :                                                                                                               
'C'=Corrected                                                                                                                                                                                 
'F'=Final                                                                                                                                                                                              
'P'=Pending
'A'=Ammended    
'I'= Premilinary
ResultFuzzyWhenvarchar(50)50NOT NULLRequested date text
ResultFuzzySortAsdatetime8NULL allowedRequested date and time
Check Constraints CK_Result_ResultFuzzySpecificity_FuzzyDate_Types : ([ResultFuzzySpecificity]='F' OR [ResultFuzzySpecificity]='Y' OR [ResultFuzzySpecificity]='D' OR [ResultFuzzySpecificity]='M')ResultFuzzySpecificitychar(1)1NOT NULLSpecificity of the requested date:
D - Date
M - Month
Y - Year
F - Freetext
Check Constraints CK_Result_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y')IsUnverifiedFLAG[dbo].[BOOL]1NOT NULL('N')Unverified (Y/N)
VerificationTaskOwnerID[dbo].[uniqueid]9NOT NULL(0)Task owner for verification tasks. Link to IDX_User.ID or Team_DE.ID.
VerificationTaskOwnerTypechar(10)10NOT NULL('')Type of task verification owner (User or Team)
WherePerformedAddressvarchar(255)255NOT NULL('')Performing location
WherePerformedAdditionalTextvarchar(255)255NOT NULL('')Additional comments from the performing location
PerformingCommentvarchar(2000)2000NOT NULL('')Performing location comments
Check Constraints CK_Result_DocumentLinkedFLAG_Yes_Or_No : ([DocumentLinkedFLAG]='N' OR [DocumentLinkedFLAG]='Y')DocumentLinkedFLAG[dbo].[BOOL]1NOT NULL('N')Inidcates whether any documents are attached (Y/N)
Cluster Key CIX_Result_ID_ArchiveState: ID\ArchiveStateArchiveStatetinyint1NOT NULL((0))0 =  Record is in Main Partition
1 = Record is in Archived Partition
RIDSnomedCodeListvarchar(255)255NOT NULL('')SNOMED term codes of the Resultable item
RIDLOINCCodeListvarchar(255)255NOT NULL('')LOINC codes of the Resultable item
AnswerSnomedCodeListvarchar(255)255NOT NULL('')SNOMED term codes of the Answer
AnswerLOINCCodeListvarchar(255)255NOT NULL('')LOINC codes of the Answer
PicklistSnomedCodeListvarchar(255)255NOT NULL('')SNOMED term codes of the Picklist entry
PicklistLOINCCodeListvarchar(255)255NOT NULL('')LOINC codes of the Picklist entry