Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | Key to the dbo.Item_Finding table |
 | ActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | Activity Header. Link to dbo.Act_Hdr_Other.ID |
 (12)![Foreign Keys FK_Item_Finding_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Item_Finding_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | Patient. Link to Patient_Member.ID |
 | OrderItemEXT | varchar(20) | 20 | NOT NULL | External Order Number |
(3) | CurrentID | numeric(16,0) | 9 | NOT NULL | This points to the ID of the current version level entry of the finding in the dbo.finding table |
(3)![Foreign Keys FK_Item_Finding_QODE_QO_DE_ID: [dbo].[QO_DE].QODE Foreign Keys FK_Item_Finding_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 entryname. QO_DE.Entryname. |
 ![Foreign Keys FK_Item_Finding_QOMod1DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod1DE Foreign Keys FK_Item_Finding_QOMod1DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod1DE](../../../../Images/fk.png) | QOMod1DE | [dbo].[dict_id] | 5 | NOT NULL | Ordable Item Modifier. Link to QO_Mod_DE.ID |
 ![Foreign Keys FK_Item_Finding_QOMod2DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod2DE Foreign Keys FK_Item_Finding_QOMod2DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod2DE](../../../../Images/fk.png) | QOMod2DE | [dbo].[dict_id] | 5 | NOT NULL | Ordable Item Modifier. Link to QO_Mod_DE.ID |
 ![Foreign Keys FK_Item_Finding_QOMod3DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod3DE Foreign Keys FK_Item_Finding_QOMod3DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod3DE](../../../../Images/fk.png) | QOMod3DE | [dbo].[dict_id] | 5 | NOT NULL | Ordable Item Modifier. Link to QO_Mod_DE.ID |
| QOModDET | varchar(255) | 255 | NOT NULL | Ordable Item Modifier entryname. Link to QO_Mod_DE.Entryname |
(3)![Foreign Keys FK_Item_Finding_QOClassificationDE_QO_Classification_DE_ID: [dbo].[QO_Classification_DE].QOClassificationDE Foreign Keys FK_Item_Finding_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 | Ordable Item entryname. Link to QO_Classification_DE.Entryname |
| DocFolderID | numeric(16,0) | 9 | NOT NULL | Not used, will default to blank |
 | EntryName | varchar(255) | 255 | NOT NULL | entryname of the finding |
(2) | CreateDTTM | datetime | 8 | NOT NULL | date Finding was added to the patient's chart |
 | LastUpdateDTTM | datetime | 8 | NOT NULL | date finding was last updated |
![Check Constraints CK_Item_Finding_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y') Check Constraints CK_Item_Finding_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')](../../../../Images/c-constraint.png) | HasSecurityFLAG | [dbo].[BOOL] | 1 | NOT NULL | Security? Y/N |
![Check Constraints CK_Item_Finding_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y') Check Constraints CK_Item_Finding_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')](../../../../Images/c-constraint.png) | HasAnnotationFLAG | [dbo].[BOOL] | 1 | NOT NULL | Annotated? Y/N |
![Check Constraints CK_Item_Finding_IsAbnormalFLAG_Yes_Or_No : ([IsAbnormalFLAG]='N' OR [IsAbnormalFLAG]='Y') Check Constraints CK_Item_Finding_IsAbnormalFLAG_Yes_Or_No : ([IsAbnormalFLAG]='N' OR [IsAbnormalFLAG]='Y')](../../../../Images/c-constraint.png) | IsAbnormalFLAG | [dbo].[BOOL] | 1 | NOT NULL | Abnormal? Y/N |
 | IsErrorFLAG | [dbo].[BOOL] | 1 | NOT NULL | Entered in Error? Y/N |
 | DetailType | char(1) | 1 | NOT NULL | Detail Type - V |
 ![Check Constraints CK_Item_Finding_ItemType : ([ItemType]='FI') Check Constraints CK_Item_Finding_ItemType : ([ItemType]='FI')](../../../../Images/c-constraint.png) | ItemType | char(2) | 2 | NOT NULL | FI for finding |
 | DecodedValue | varchar(255) | 255 | NOT NULL | Decoded value of the finding. For instance 9.072 kg for weight or 30.48 cm for height. |
 | PerformedDTTM | datetime | 8 | NOT NULL | Date Finding was performed. Typically Vital Signs taken |