Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
  (8) | ID | [dbo].[uniqueid] | 9 | NOT NULL | | Key to the Finding table |
(2)![Foreign Keys FK_Finding_ItemID_Item_Finding_ID: [dbo].[Item_Finding].ItemID Foreign Keys FK_Finding_ItemID_Item_Finding_ID: [dbo].[Item_Finding].ItemID](../../../../Images/fk.png) | ItemID | [dbo].[uniqueid] | 9 | NOT NULL | | Item. Link to dbo.Item_Finding.ID |
| NoteActivityID | numeric(16,0) | 9 | NOT NULL | | Audit Note. Link to Act_Hdr_Note.ID. |
(2) | AnswerDE | [dbo].[dict_id] | 5 | NOT NULL | | Answer if the finding value is from the dictionary. Link to Answer_DE.ID |
| AnswerDET | varchar(255) | 255 | NOT NULL | (' ') | The entered value for the finding. |
 | SourceDE | [dbo].[dict_id] | 5 | NOT NULL | | Source. No longer used. |
| SourceDET | varchar(255) | 255 | NOT NULL | (' ') | Source Text. No longer used. |
| NumericFinding | real | 4 | NOT NULL | (0) | Finding value if its numeric |
(2) | UnitsDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Finding units. Link to Unit_Code_DE.ID |
| UnitsDET | varchar(255) | 255 | NOT NULL | (' ') | Units Text. No longer used. |
(2) | NormalizedUnitsDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Normalized units. Link to Unit_Code_DE.ID |
| NormalizedUnitsDET | varchar(255) | 255 | NULL allowed | | Normalized Units Text. No longer used. |
 | NormalizedValue | real | 4 | NOT NULL | | Normalized value for the finding. |
 | ClinicalDTTM | datetime | 8 | NOT NULL | | Clinical Date and Time of a Finding |
![Check Constraints CK_Finding_ReasonForCreateType_Reason_Create_Type : ([ReasonForCreateType]='A' OR [ReasonForCreateType]='C' OR [ReasonForCreateType]='E') Check Constraints CK_Finding_ReasonForCreateType_Reason_Create_Type : ([ReasonForCreateType]='A' OR [ReasonForCreateType]='C' OR [ReasonForCreateType]='E')](../../../../Images/c-constraint.png) | ReasonForCreateType | char(1) | 1 | NOT NULL | | Creation type. A - Added |
(2) | WhoForID | [dbo].[uniqueid] | 9 | NOT NULL | | Who this was this entered for. Link to IDX_User.ID |
(2) | WhoDidItID | [dbo].[uniqueid] | 9 | NOT NULL | | Who Entered. Link to IDX_User.ID |
| PerformedDTTM | datetime | 8 | NOT NULL | | Date and time the finding was performed |
 | RecordedDTTM | datetime | 8 | NOT NULL | | Recorded date and time |
![Check Constraints CK_Finding_FindingTextFLAG_Yes_Or_No : ([FindingTextFLAG]='N' OR [FindingTextFLAG]='Y') Check Constraints CK_Finding_FindingTextFLAG_Yes_Or_No : ([FindingTextFLAG]='N' OR [FindingTextFLAG]='Y')](../../../../Images/c-constraint.png) | FindingTextFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Is there finding text (Y/N). No longer used. |
(2) | AnswerDataTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | Answer data type. Link to Answer_Data_Type_DE.ID |
| ShortRefRange | varchar(255) | 255 | NOT NULL | | Reference range. Reference_Range_Numeric.ReferenceText |
![Check Constraints CK_Finding_HasReferenceRangeFLAG_Yes_Or_No : ([HasReferenceRangeFLAG]='N' OR [HasReferenceRangeFLAG]='Y') Check Constraints CK_Finding_HasReferenceRangeFLAG_Yes_Or_No : ([HasReferenceRangeFLAG]='N' OR [HasReferenceRangeFLAG]='Y')](../../../../Images/c-constraint.png) | HasReferenceRangeFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Is there a reference range (Y/N). No longer used. |
![Check Constraints CK_Finding_HasRefRangeTextFLAG_Yes_Or_No : ([HasRefRangeTextFLAG]='N' OR [HasRefRangeTextFLAG]='Y') Check Constraints CK_Finding_HasRefRangeTextFLAG_Yes_Or_No : ([HasRefRangeTextFLAG]='N' OR [HasRefRangeTextFLAG]='Y')](../../../../Images/c-constraint.png) | HasRefRangeTextFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Is 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') 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')](../../../../Images/c-constraint.png) | AbnormalFlagType | char(2) | 2 | NOT NULL | | Abnormal Flag Type. Link to Result_Flag_DE.ID |
(2) | FindingStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | Status. Link to Finding_Status_DE.ID |
| FindingFuzzyWhen | varchar(50) | 50 | NOT NULL | | Fuzzy Performed date. No longer used. |
| FindingFuzzySortAs | datetime | 8 | NULL allowed | | Performed date and time |
![Check Constraints CK_Finding_FindingFuzzySpecificity_FuzzyDate_Types : ([FindingFuzzySpecificity]='F' OR [FindingFuzzySpecificity]='Y' OR [FindingFuzzySpecificity]='D' OR [FindingFuzzySpecificity]='M') Check Constraints CK_Finding_FindingFuzzySpecificity_FuzzyDate_Types : ([FindingFuzzySpecificity]='F' OR [FindingFuzzySpecificity]='Y' OR [FindingFuzzySpecificity]='D' OR [FindingFuzzySpecificity]='M')](../../../../Images/c-constraint.png) | FindingFuzzySpecificity | char(1) | 1 | NOT NULL | | Specificity of FindingFuzzySortAs. D - Day, M - Month, Y - Year, F - Freetext. |
![Check Constraints CK_Finding_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y') Check Constraints CK_Finding_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y')](../../../../Images/c-constraint.png) | IsUnverifiedFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Unverified (Y/N) |
| VerificationTaskOwnerID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | User or Team for the Verification task. Link to IDX_User.ID or Team_DE.ID |
| VerificationTaskOwnerType | char(10) | 10 | NOT NULL | ('') | Verification Task Owner Type. User or Team. |
 | WherePerformedDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Where performed. Link to Where_Performed_DE.ID |
![Check Constraints CK_Finding_HasFindingTextFLAG_Yes_Or_No : ([HasFindingTextFLAG]='N' OR [HasFindingTextFLAG]='Y') Check Constraints CK_Finding_HasFindingTextFLAG_Yes_Or_No : ([HasFindingTextFLAG]='N' OR [HasFindingTextFLAG]='Y')](../../../../Images/c-constraint.png) | HasFindingTextFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Is the value Textual (Y/N) |
| WherePerformedAddress | varchar(255) | 255 | NOT NULL | ('') | Where Performed Address. 'Performing Location' in Result Details section. |
| WherePerformedAdditionalText | varchar(255) | 255 | NOT NULL | ('') | Performing comments. 'Comments From Performing Location' in Result Details section |
| FindingStage | char(2) | 2 | NOT NULL | ('') | Stage. F - Final |
![Check Constraints CK_Finding_ExcludeFromNGC_Yes_Or_No : ([ExcludeFromNGC]='N' OR [ExcludeFromNGC]='Y') Check Constraints CK_Finding_ExcludeFromNGC_Yes_Or_No : ([ExcludeFromNGC]='N' OR [ExcludeFromNGC]='Y')](../../../../Images/c-constraint.png) | ExcludeFromNGC | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Exclude From Normative Growth Chart (Y/N) |
![Check Constraints CK_Finding_DocumentLinkedFLAG_Yes_Or_No : ([DocumentLinkedFLAG]='N' OR [DocumentLinkedFLAG]='Y') Check Constraints CK_Finding_DocumentLinkedFLAG_Yes_Or_No : ([DocumentLinkedFLAG]='N' OR [DocumentLinkedFLAG]='Y')](../../../../Images/c-constraint.png) | DocumentLinkedFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Is a document linked to the order (Y/N) |
 | ArchiveState | tinyint | 1 | NOT NULL | ((0)) | 0 = Record is in Main Partition 1 = record is in Archived Partition |