Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
  (15) | ID | [dbo].[uniqueid] | 9 | NOT NULL | | Key to the Result table |
(2)![Foreign Keys FK_Result_ItemID_Item_Result_ID: [dbo].[Item_Result].ItemID Foreign Keys FK_Result_ItemID_Item_Result_ID: [dbo].[Item_Result].ItemID](../../../../Images/fk.png) | ItemID | [dbo].[uniqueid] | 9 | NOT NULL | | Item. Link to Item_Result.ID. |
 | NoteActivityID | numeric(16,0) | 9 | NOT NULL | | Audit Note. Link to Act_Hdr_Note.ID. |
(2)![Foreign Keys FK_Result_AnswerDE_Answer_DE_ID: [dbo].[Answer_DE].AnswerDE Foreign Keys FK_Result_AnswerDE_Answer_DE_ID: [dbo].[Answer_DE].AnswerDE](../../../../Images/fk.png) | AnswerDE | [dbo].[dict_id] | 5 | NOT NULL | | Result if from a dictionary. Answer_DE.ID |
 | AnswerDET | varchar(255) | 255 | NOT NULL | (' ') | Entered Result |
(2)![Foreign Keys FK_Result_AnswerDataTypeDE_Answer_Data_Type_DE_ID: [dbo].[Answer_Data_Type_DE].AnswerDataTypeDE Foreign Keys FK_Result_AnswerDataTypeDE_Answer_Data_Type_DE_ID: [dbo].[Answer_Data_Type_DE].AnswerDataTypeDE](../../../../Images/fk.png) | AnswerDataTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | Result data type. Link to Answer_Data_Type_DE.ID |
(2)![Foreign Keys FK_Result_SourceDE_Source_DE_ID: [dbo].[Source_DE].SourceDE Foreign Keys FK_Result_SourceDE_Source_DE_ID: [dbo].[Source_DE].SourceDE](../../../../Images/fk.png) | SourceDE | [dbo].[dict_id] | 5 | NULL allowed | | Source. Limk to Source_DE.ID |
| SourceDET | varchar(255) | 255 | NOT NULL | (' ') | Source text. No longer used. |
(2)![Foreign Keys FK_Result_UnitsDE_Unit_Code_DE_ID: [dbo].[Unit_Code_DE].UnitsDE Foreign Keys FK_Result_UnitsDE_Unit_Code_DE_ID: [dbo].[Unit_Code_DE].UnitsDE](../../../../Images/fk.png) | UnitsDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Units. Link to Unit_Code_DE.ID |
| UnitsDET | varchar(255) | 255 | NOT NULL | (' ') | Units text |
(2) | ClinicalDTTM | datetime | 8 | NOT NULL | | Clinical Date and Time of the Result |
(2)![Foreign Keys FK_Result_WherePerformedDE_Where_Performed_DE_ID: [dbo].[Where_Performed_DE].WherePerformedDE Foreign Keys FK_Result_WherePerformedDE_Where_Performed_DE_ID: [dbo].[Where_Performed_DE].WherePerformedDE](../../../../Images/fk.png) | WherePerformedDE | [dbo].[dict_id] | 5 | NOT NULL | | Where performed. Link to Where_Performed_DE.ID |
| WherePerformedDET | varchar(35) | 35 | NOT NULL | (' ') | Where performed free text. No longer used. |
 | AccessionNumber | varchar(255) | 255 | NOT NULL | (' ') | Accession Number |
 | VerifyDTTM | datetime | 8 | NULL allowed | | Verified Date and Time of the Results |
(2)![Foreign Keys FK_Result_ResultStatusDE_Result_Status_DE_ID: [dbo].[Result_Status_DE].ResultStatusDE Foreign Keys FK_Result_ResultStatusDE_Result_Status_DE_ID: [dbo].[Result_Status_DE].ResultStatusDE](../../../../Images/fk.png) | ResultStatusDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Status. link to Result_Status_DE.ID |
 | ResultDTTM | datetime | 8 | NOT NULL | | Resulted Date and Time |
| NumericResult | real | 4 | NOT NULL | | Result numeric value |
| ShortRefRange | varchar(255) | 255 | NOT NULL | (' ') | Reference range |
(2)![Foreign Keys FK_Result_NormalizedUnitsDE_Unit_Code_DE_ID: [dbo].[Unit_Code_DE].NormalizedUnitsDE Foreign Keys FK_Result_NormalizedUnitsDE_Unit_Code_DE_ID: [dbo].[Unit_Code_DE].NormalizedUnitsDE](../../../../Images/fk.png) | NormalizedUnitsDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Normalized units. Link to Unit_Code_DE.ID |
| NormalizedUnitsDET | varchar(255) | 255 | NOT NULL | | Normanized Units text |
| NormalizedValue | real | 4 | NOT NULL | | Value in normalized units |
![Check Constraints CK_Result_ReasonForCreateType_Reason_Create_Type : ([ReasonForCreateType]='A' OR [ReasonForCreateType]='C' OR [ReasonForCreateType]='E') Check Constraints CK_Result_ReasonForCreateType_Reason_Create_Type : ([ReasonForCreateType]='A' OR [ReasonForCreateType]='C' OR [ReasonForCreateType]='E')](../../../../Images/c-constraint.png) | ReasonForCreateType | char(1) | 1 | NOT NULL | | Creation reason. A - Added |
(2) | WhoForID | [dbo].[uniqueid] | 9 | NOT NULL | | Who was this entred for. Link to Provider.ID |
(3)![Foreign Keys FK_Result_WhoDidItID_IDX_User_ID: [dbo].[IDX_User].WhoDidItID Foreign Keys FK_Result_WhoDidItID_IDX_User_ID: [dbo].[IDX_User].WhoDidItID](../../../../Images/fk.png) | WhoDidItID | [dbo].[uniqueid] | 9 | NOT NULL | | Who entered the result. Link to IDX_User.ID |
 | PerformedDTTM | datetime | 8 | NOT NULL | | Performed Date and Time |
(2) | RecordedDTTM | datetime | 8 | NOT NULL | | Recorded Date and Time |
 ![Check Constraints CK_Result_HasResultTextFLAG_Yes_Or_No : ([HasResultTextFLAG]='N' OR [HasResultTextFLAG]='Y') Check Constraints CK_Result_HasResultTextFLAG_Yes_Or_No : ([HasResultTextFLAG]='N' OR [HasResultTextFLAG]='Y')](../../../../Images/c-constraint.png) | HasResultTextFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Indicates whether the resultable item has result text or not (Y/N) |
![Check Constraints CK_Result_HasReferenceRangeFLAG_Yes_Or_No : ([HasReferenceRangeFLAG]='N' OR [HasReferenceRangeFLAG]='Y') Check Constraints CK_Result_HasReferenceRangeFLAG_Yes_Or_No : ([HasReferenceRangeFLAG]='N' OR [HasReferenceRangeFLAG]='Y')](../../../../Images/c-constraint.png) | HasReferenceRangeFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Has a reference range (Y/N). No longer used. |
![Check Constraints CK_Result_HasRefRangeTextFLAG_Yes_Or_No : ([HasRefRangeTextFLAG]='N' OR [HasRefRangeTextFLAG]='Y') Check Constraints CK_Result_HasRefRangeTextFLAG_Yes_Or_No : ([HasRefRangeTextFLAG]='N' OR [HasRefRangeTextFLAG]='Y')](../../../../Images/c-constraint.png) | HasRefRangeTextFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Has a textual reference range (Y/N). No longer used. |
(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') 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')](../../../../Images/c-constraint.png) | AbnormalFlagType | char(2) | 2 | NOT NULL | | Abnormanl flag. |
![Check Constraints CK_Result_ResultStage_Result_Stage : ([ResultStage]='' OR [ResultStage]='C' OR [ResultStage]='A' OR [ResultStage]='F' OR [ResultStage]='I' OR [ResultStage]='P') Check Constraints CK_Result_ResultStage_Result_Stage : ([ResultStage]='' OR [ResultStage]='C' OR [ResultStage]='A' OR [ResultStage]='F' OR [ResultStage]='I' OR [ResultStage]='P')](../../../../Images/c-constraint.png) | ResultStage | char(2) | 2 | NOT NULL | | Stage of the Result Valid Values : 'C'=Corrected 'F'=Final 'P'=Pending 'A'=Ammended 'I'= Premilinary |
| ResultFuzzyWhen | varchar(50) | 50 | NOT NULL | | Requested date text |
| ResultFuzzySortAs | datetime | 8 | NULL allowed | | Requested date and time |
![Check Constraints CK_Result_ResultFuzzySpecificity_FuzzyDate_Types : ([ResultFuzzySpecificity]='F' OR [ResultFuzzySpecificity]='Y' OR [ResultFuzzySpecificity]='D' OR [ResultFuzzySpecificity]='M') Check Constraints CK_Result_ResultFuzzySpecificity_FuzzyDate_Types : ([ResultFuzzySpecificity]='F' OR [ResultFuzzySpecificity]='Y' OR [ResultFuzzySpecificity]='D' OR [ResultFuzzySpecificity]='M')](../../../../Images/c-constraint.png) | ResultFuzzySpecificity | char(1) | 1 | NOT NULL | | Specificity 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') Check Constraints CK_Result_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) | Task owner for verification tasks. Link to IDX_User.ID or Team_DE.ID. |
| VerificationTaskOwnerType | char(10) | 10 | NOT NULL | ('') | Type of task verification owner (User or Team) |
| WherePerformedAddress | varchar(255) | 255 | NOT NULL | ('') | Performing location |
| WherePerformedAdditionalText | varchar(255) | 255 | NOT NULL | ('') | Additional comments from the performing location |
| PerformingComment | varchar(2000) | 2000 | NOT NULL | ('') | Performing location comments |
![Check Constraints CK_Result_DocumentLinkedFLAG_Yes_Or_No : ([DocumentLinkedFLAG]='N' OR [DocumentLinkedFLAG]='Y') Check Constraints CK_Result_DocumentLinkedFLAG_Yes_Or_No : ([DocumentLinkedFLAG]='N' OR [DocumentLinkedFLAG]='Y')](../../../../Images/c-constraint.png) | DocumentLinkedFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Inidcates whether any documents are attached (Y/N) |
 | ArchiveState | tinyint | 1 | NOT NULL | ((0)) | 0 = Record is in Main Partition 1 = Record is in Archived Partition |
| RIDSnomedCodeList | varchar(255) | 255 | NOT NULL | ('') | SNOMED term codes of the Resultable item |
| RIDLOINCCodeList | varchar(255) | 255 | NOT NULL | ('') | LOINC codes of the Resultable item |
| AnswerSnomedCodeList | varchar(255) | 255 | NOT NULL | ('') | SNOMED term codes of the Answer |
| AnswerLOINCCodeList | varchar(255) | 255 | NOT NULL | ('') | LOINC codes of the Answer |
| PicklistSnomedCodeList | varchar(255) | 255 | NOT NULL | ('') | SNOMED term codes of the Picklist entry |
| PicklistLOINCCodeList | varchar(255) | 255 | NOT NULL | ('') | LOINC codes of the Picklist entry |