Tables [dbo].[Finding]
Vital Signs/ Findings
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_Finding_ID: IDCluster Key CIX_Finding_ID_ArchiveState: ID\ArchiveStateIndexes TWstat_Finding_AnswerDataTypeDE_ID, TWstat_Finding_AnswerDE_ID, TWstat_Finding_ClinicalDTTM_ID, TWstat_Finding_FindingStatusDE_ID, TWstat_Finding_NormalizedUnitsDE_ID, TWstat_Finding_UnitsDE_ID, TWstat_Finding_WhoDidItID_ID, TWstat_Finding_WhoForID_ID(8)ID[dbo].[uniqueid]9NOT NULLKey to the Finding table
Indexes NIX_Finding_ItemID, NIX_Finding_RecordedDttm_INC_ItemID(2)Foreign Keys FK_Finding_ItemID_Item_Finding_ID: [dbo].[Item_Finding].ItemIDItemID[dbo].[uniqueid]9NOT NULLItem. Link to dbo.Item_Finding.ID
NoteActivityIDnumeric(16,0)9NOT NULLAudit Note. Link to Act_Hdr_Note.ID.
Indexes NIX_Finding_WhoDidItID_WhoForID_WithIncludeColumns, TWstat_Finding_AnswerDE_ID(2)AnswerDE[dbo].[dict_id]5NOT NULLAnswer if the finding value is from the dictionary. Link to Answer_DE.ID
AnswerDETvarchar(255)255NOT NULL(' ')The entered value for the finding.
Indexes TWstat_Finding_SourceDESourceDE[dbo].[dict_id]5NOT NULLSource. No longer used.
SourceDETvarchar(255)255NOT NULL(' ')Source Text. No longer used.
NumericFindingreal4NOT NULL(0)Finding value if its numeric
Indexes NIX_Finding_WhoDidItID_WhoForID_WithIncludeColumns, TWstat_Finding_UnitsDE_ID(2)UnitsDE[dbo].[dict_id]5NOT NULL(0)Finding units. Link to Unit_Code_DE.ID
UnitsDETvarchar(255)255NOT NULL(' ')Units Text. No longer used.
Indexes NIX_Finding_WhoDidItID_WhoForID_WithIncludeColumns, TWstat_Finding_NormalizedUnitsDE_ID(2)NormalizedUnitsDE[dbo].[dict_id]5NOT NULL(0)Normalized units. Link to Unit_Code_DE.ID
NormalizedUnitsDETvarchar(255)255NULL allowedNormalized Units Text. No longer used.
Indexes TWstat_Finding_NormalizedValueNormalizedValuereal4NOT NULLNormalized value for the finding.
Indexes TWstat_Finding_ClinicalDTTM_IDClinicalDTTMdatetime8NOT NULLClinical Date and Time of a Finding
Check Constraints CK_Finding_ReasonForCreateType_Reason_Create_Type : ([ReasonForCreateType]='A' OR [ReasonForCreateType]='C' OR [ReasonForCreateType]='E')ReasonForCreateTypechar(1)1NOT NULLCreation type. A - Added
Indexes NIX_Finding_WhoDidItID_WhoForID_WithIncludeColumns, TWstat_Finding_WhoForID_ID(2)WhoForID[dbo].[uniqueid]9NOT NULLWho this was this entered for. Link to IDX_User.ID
Indexes NIX_Finding_WhoDidItID_WhoForID_WithIncludeColumns, TWstat_Finding_WhoDidItID_ID(2)WhoDidItID[dbo].[uniqueid]9NOT NULLWho Entered. Link to IDX_User.ID
PerformedDTTMdatetime8NOT NULLDate and time the finding was performed
Indexes NIX_Finding_RecordedDttm_INC_ItemIDRecordedDTTMdatetime8NOT NULLRecorded date and time
Check Constraints CK_Finding_FindingTextFLAG_Yes_Or_No : ([FindingTextFLAG]='N' OR [FindingTextFLAG]='Y')FindingTextFLAG[dbo].[BOOL]1NOT NULLIs there finding text (Y/N). No longer used.
Indexes NIX_Finding_WhoDidItID_WhoForID_WithIncludeColumns, TWstat_Finding_AnswerDataTypeDE_ID(2)AnswerDataTypeDE[dbo].[dict_id]5NOT NULLAnswer data type. Link to Answer_Data_Type_DE.ID
ShortRefRangevarchar(255)255NOT NULLReference range. Reference_Range_Numeric.ReferenceText
Check Constraints CK_Finding_HasReferenceRangeFLAG_Yes_Or_No : ([HasReferenceRangeFLAG]='N' OR [HasReferenceRangeFLAG]='Y')HasReferenceRangeFLAG[dbo].[BOOL]1NOT NULLIs there a reference range (Y/N). No longer used.
Check Constraints CK_Finding_HasRefRangeTextFLAG_Yes_Or_No : ([HasRefRangeTextFLAG]='N' OR [HasRefRangeTextFLAG]='Y')HasRefRangeTextFLAG[dbo].[BOOL]1NOT NULLIs there a textual reference range (Y/N). No longer used.
Check Constraints CK_Finding_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 NULLAbnormal Flag Type. Link to Result_Flag_DE.ID
Indexes NIX_Finding_WhoDidItID_WhoForID_WithIncludeColumns, TWstat_Finding_FindingStatusDE_ID(2)FindingStatusDE[dbo].[dict_id]5NOT NULLStatus. Link to Finding_Status_DE.ID
FindingFuzzyWhenvarchar(50)50NOT NULLFuzzy Performed date. No longer used.
FindingFuzzySortAsdatetime8NULL allowedPerformed date and time
Check Constraints CK_Finding_FindingFuzzySpecificity_FuzzyDate_Types : ([FindingFuzzySpecificity]='F' OR [FindingFuzzySpecificity]='Y' OR [FindingFuzzySpecificity]='D' OR [FindingFuzzySpecificity]='M')FindingFuzzySpecificitychar(1)1NOT NULLSpecificity of FindingFuzzySortAs. D - Day, M - Month, Y - Year, F - Freetext.
Check Constraints CK_Finding_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y')IsUnverifiedFLAG[dbo].[BOOL]1NOT NULL('N')Unverified (Y/N)
VerificationTaskOwnerID[dbo].[uniqueid]9NOT NULL(0)User or Team for the Verification task. Link to IDX_User.ID or Team_DE.ID
VerificationTaskOwnerTypechar(10)10NOT NULL('')Verification Task Owner Type. User or Team.
Indexes NIX_Finding_WhoDidItID_WhoForID_WithIncludeColumnsWherePerformedDE[dbo].[dict_id]5NOT NULL(0)Where performed. Link to Where_Performed_DE.ID
Check Constraints CK_Finding_HasFindingTextFLAG_Yes_Or_No : ([HasFindingTextFLAG]='N' OR [HasFindingTextFLAG]='Y')HasFindingTextFLAG[dbo].[BOOL]1NOT NULL('N')Is the value Textual (Y/N)
WherePerformedAddressvarchar(255)255NOT NULL('')Where Performed Address. 'Performing Location' in Result Details section.
WherePerformedAdditionalTextvarchar(255)255NOT NULL('')Performing comments. 'Comments From Performing Location'  in Result Details section
FindingStagechar(2)2NOT NULL('')Stage. F - Final
Check Constraints CK_Finding_ExcludeFromNGC_Yes_Or_No : ([ExcludeFromNGC]='N' OR [ExcludeFromNGC]='Y')ExcludeFromNGC[dbo].[BOOL]1NOT NULL('N')Exclude From Normative Growth Chart (Y/N)
Check Constraints CK_Finding_DocumentLinkedFLAG_Yes_Or_No : ([DocumentLinkedFLAG]='N' OR [DocumentLinkedFLAG]='Y')DocumentLinkedFLAG[dbo].[BOOL]1NOT NULL('N')Is a document linked to the order (Y/N)
Cluster Key CIX_Finding_ID_ArchiveState: ID\ArchiveStateArchiveStatetinyint1NOT NULL((0))0 =  Record is in Main Partition
1 = record is in Archived Partition