Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
   | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the Unverified_Item table. |
  | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | | Patient. Link to Person.ID |
 | DocumentID | [dbo].[uniqueid] | 9 | NOT NULL | | | Document. Link to Document.DocumentID |
(2) | Source | varchar(255) | 255 | NOT NULL | | | Source of the item |
(2) | ItemType | varchar(10) | 10 | NOT NULL | | | Item Type. Link to Clinical_Item_Type_DE.ID |
  ![Foreign Keys FK_Unverified_Item_ItemStatusDE: [dbo].[Item_Status_DE].ItemStatusDE Foreign Keys FK_Unverified_Item_ItemStatusDE: [dbo].[Item_Status_DE].ItemStatusDE](../../../../Images/fk.png) | ItemStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | | Status. Link to Item_Status_DE.ID |
| DisplayText | varchar(255) | 255 | NOT NULL | | | Display text for the item |
 ![Foreign Keys FK_Unverified_Item_CodeTypeDE: [dbo].[Code_Type_DE].CodeTypeDE Foreign Keys FK_Unverified_Item_CodeTypeDE: [dbo].[Code_Type_DE].CodeTypeDE](../../../../Images/fk.png) | CodeTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Code Type. Link to Code_Type_DE.ID |
| CodeValue | varchar(25) | 25 | NOT NULL | | | Code Value. Used with CodeTypeDE |
 | RecordedDTTM | datetime | 8 | NOT NULL | | | Recorded time |
(2) | WhoDidItID | [dbo].[uniqueid] | 9 | NOT NULL | | | User who entered the item. Link to IDX_User.ID |
| UpdatedDTTM | datetime | 8 | NOT NULL | | | Last update time |
 | ActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | | | Linked Clinical item |
(2)![Foreign Keys FK_Unverified_Item_ClinicalDocumentTargetDE: [dbo].[Clinical_Document_Target_DE].ClinicalDocumentTargetDE Foreign Keys FK_Unverified_Item_ClinicalDocumentTargetDE: [dbo].[Clinical_Document_Target_DE].ClinicalDocumentTargetDE](../../../../Images/fk.png) | ClinicalDocumentTargetDE | [dbo].[dict_id] | 5 | NOT NULL | | | Source of the document that created the item. Link to Clinical_Document_Target_DE.ID |
| UnverifiedItemTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Item Type. Link to Unverified_Item_Type_DE.ID |
| SearchText | varchar(255) | 255 | NOT NULL | | ('') | Text to match the item |
(2) | CurrentItemID | numeric(16,0) | 9 | NOT NULL | | ((0)) | Linked Clinical Item |
| CodeFormatList | varchar(8000) | 8000 | NOT NULL | | ('') | List of Code Types and Code Values |
(2) | SourceItemIDs | varchar(8000) | 8000 | NOT NULL | | ('') | List of Source identifiers from foreign systems |
| EntryName | varchar(255) | 255 | NOT NULL | | ('') | Name of Unverified Item |
![Foreign Keys fk_Unverified_Item_StatusDE: [dbo].[Order_Status_DE].StatusDE Foreign Keys fk_Unverified_Item_StatusDE: [dbo].[Order_Status_DE].StatusDE](../../../../Images/fk.png) | StatusDE | [dbo].[dict_id] | 5 | NULL allowed | | ((0)) | Status. Link to Order_Status_DE.ID |
| ImportType | varchar(50) | 50 | NOT NULL | | ('') | Import medium (Ex. ADX) |
| DisplayName | varchar(255) | 255 | NOT NULL | | ('') | Display name |
(2) | CommunityLastModifiedDTTM | datetime | 8 | NULL allowed | | (NULL) | Last modified date time of any imported clinical item. If specified, this will be equal to the specific item last modified date time, and will fall back on the CED document creation date if the item specific last modified date is not provided. |