Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
 (3) | ID | [dbo].[uniqueid] | 9 | NOT NULL | Key to the Item_Resilt table. |
(4) | ActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | Activity Header. Link to Act_Hdr_Result.ID. |
 (16)![Foreign Keys FK_Item_Result_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Item_Result_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | Patient. Link to Person.ID |
(5) | OrderItemEXT | varchar(20) | 20 | NOT NULL | External Order Number |
(4) | CurrentID | numeric(16,0) | 9 | NOT NULL | Current detail row. Link to Result.ID. |
(3)![Foreign Keys FK_Item_Result_QODE_QO_DE_ID: [dbo].[QO_DE].QODE Foreign Keys FK_Item_Result_QODE_QO_DE_ID: [dbo].[QO_DE].QODE](../../../../Images/fk.png) | QODE | [dbo].[dict_id] | 5 | NOT NULL | Resultable Item. Link to QO_DE.ID. |
| QODET | varchar(255) | 255 | NOT NULL | Resultable Item text. no longer used. |
 ![Foreign Keys FK_Item_Result_QOMod1DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod1DE Foreign Keys FK_Item_Result_QOMod1DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod1DE](../../../../Images/fk.png) | QOMod1DE | [dbo].[dict_id] | 5 | NOT NULL | First Orderable Item Modifier. Link to QO_Mod_DE.ID |
 ![Foreign Keys FK_Item_Result_QOMod2DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod2DE Foreign Keys FK_Item_Result_QOMod2DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod2DE](../../../../Images/fk.png) | QOMod2DE | [dbo].[dict_id] | 5 | NOT NULL | Second Orderable Item Modifier. Link to QO_Mod_DE.ID |
 ![Foreign Keys FK_Item_Result_QOMod3DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod3DE Foreign Keys FK_Item_Result_QOMod3DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod3DE](../../../../Images/fk.png) | QOMod3DE | [dbo].[dict_id] | 5 | NOT NULL | Third Orderable Item Modifier. Link to QO_Mod_DE.ID |
| QOModDET | varchar(255) | 255 | NOT NULL | Orderable item modifier text. No longer used. |
(3)![Foreign Keys FK_Item_Result_QOClassificationDE_QO_Classification_DE_ID: [dbo].[QO_Classification_DE].QOClassificationDE Foreign Keys FK_Item_Result_QOClassificationDE_QO_Classification_DE_ID: [dbo].[QO_Classification_DE].QOClassificationDE](../../../../Images/fk.png) | QOClassificationDE | [dbo].[dict_id] | 5 | NOT NULL | Orderable Item. Link to QO_Classification_DE.ID |
| QOClassificationDET | varchar(255) | 255 | NOT NULL | Orderable Item Text. No longer Used. |
| DocFolderID | numeric(16,0) | 9 | NOT NULL | Document Folder Identifier. No longer used. |
 | EntryName | varchar(255) | 255 | NOT NULL | Resultable Item name. |
 | CreateDTTM | datetime | 8 | NOT NULL | DateTime the Result was created |
(2) | LastUpdateDTTM | datetime | 8 | NOT NULL | Last time the Result was updated |
![Check Constraints CK_Item_Result_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y') Check Constraints CK_Item_Result_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')](../../../../Images/c-constraint.png) | HasSecurityFLAG | [dbo].[BOOL] | 1 | NOT NULL | Has Security (Y/N) |
![Check Constraints CK_Item_Result_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y') Check Constraints CK_Item_Result_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')](../../../../Images/c-constraint.png) | HasAnnotationFLAG | [dbo].[BOOL] | 1 | NOT NULL | Has an Annotation (Y/N) |
(3)![Check Constraints CK_Item_Result_IsAbnormalFLAG_Yes_Or_No : ([IsAbnormalFLAG]='N' OR [IsAbnormalFLAG]='Y') Check Constraints CK_Item_Result_IsAbnormalFLAG_Yes_Or_No : ([IsAbnormalFLAG]='N' OR [IsAbnormalFLAG]='Y')](../../../../Images/c-constraint.png) | IsAbnormalFLAG | [dbo].[BOOL] | 1 | NOT NULL | Is Abnormal (Y/N) |
(2) | IsErrorFLAG | [dbo].[BOOL] | 1 | NOT NULL | Entered In Error (Y/N) |
| DetailType | char(1) | 1 | NOT NULL | Detail Type. (R, L) |
 ![Check Constraints CK_Item_Result_ItemType : ([ItemType]='RS') Check Constraints CK_Item_Result_ItemType : ([ItemType]='RS')](../../../../Images/c-constraint.png) | ItemType | char(2) | 2 | NOT NULL | Item Type. RS - Result |
 | DecodedValue | varchar(255) | 255 | NOT NULL | Value including units. |
(2) | PerformedDTTM | datetime | 8 | NOT NULL | When the values were recorded |