Tables [dbo].[Unverified_Item]
Unverified clinical items
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Unverified_Item: IDCluster Key ix_Unverified_Item_PatientID: PatientID\ItemStatusDE\IDIndexes nix_Unverified_Item_DocumentIDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Unverified_Item table.
Cluster Key ix_Unverified_Item_PatientID: PatientID\ItemStatusDE\IDIndexes nix_Unverified_Item_PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
Indexes nix_Unverified_Item_DocumentIDDocumentID[dbo].[uniqueid]9NOT NULLDocument. Link to Document.DocumentID
Indexes nix_Unverified_Item_CurrentItemId_ItemType, NIX_Unverified_Item_ItemType_ActivityHeaderID_WithIncludeColumns(2)Sourcevarchar(255)255NOT NULLSource of the item
Indexes nix_Unverified_Item_CurrentItemId_ItemType, NIX_Unverified_Item_ItemType_ActivityHeaderID_WithIncludeColumns(2)ItemTypevarchar(10)10NOT NULLItem Type. Link to Clinical_Item_Type_DE.ID
Cluster Key ix_Unverified_Item_PatientID: PatientID\ItemStatusDE\IDIndexes nix_Unverified_Item_DocumentIDForeign Keys FK_Unverified_Item_ItemStatusDE: [dbo].[Item_Status_DE].ItemStatusDEItemStatusDE[dbo].[dict_id]5NOT NULLStatus. Link to Item_Status_DE.ID
DisplayTextvarchar(255)255NOT NULLDisplay text for the item
Indexes TWstat_Unverified_Item_CodeTypeDEForeign Keys FK_Unverified_Item_CodeTypeDE: [dbo].[Code_Type_DE].CodeTypeDECodeTypeDE[dbo].[dict_id]5NOT NULLCode Type. Link to Code_Type_DE.ID
CodeValuevarchar(25)25NOT NULLCode Value. Used with CodeTypeDE
Indexes NIX_Unverified_Item_ItemType_ActivityHeaderID_WithIncludeColumnsRecordedDTTMdatetime8NOT NULLRecorded time
Indexes NIX_Unverified_Item_ItemType_ActivityHeaderID_WithIncludeColumns, TWstat_Unverified_Item_WhoDidItID(2)WhoDidItID[dbo].[uniqueid]9NOT NULLUser who entered the item. Link to IDX_User.ID
UpdatedDTTMdatetime8NOT NULLLast update time
Indexes NIX_Unverified_Item_ItemType_ActivityHeaderID_WithIncludeColumnsActivityHeaderID[dbo].[uniqueid]9NOT NULLLinked Clinical item
Indexes NIX_Unverified_Item_ItemType_ActivityHeaderID_WithIncludeColumns, TWstat_Unverified_Item_ClinicalDocumentTargetDE(2)Foreign Keys FK_Unverified_Item_ClinicalDocumentTargetDE: [dbo].[Clinical_Document_Target_DE].ClinicalDocumentTargetDEClinicalDocumentTargetDE[dbo].[dict_id]5NOT NULLSource of the document that created the item. Link to Clinical_Document_Target_DE.ID
UnverifiedItemTypeDE[dbo].[dict_id]5NOT NULL(0)Item Type. Link to Unverified_Item_Type_DE.ID
SearchTextvarchar(255)255NOT NULL('')Text to match the item
Indexes nix_Unverified_Item_CurrentItemId_ItemType, NIX_Unverified_Item_ItemType_ActivityHeaderID_WithIncludeColumns(2)CurrentItemIDnumeric(16,0)9NOT NULL((0))Linked Clinical Item
CodeFormatListvarchar(8000)8000NOT NULL('')List of Code Types and Code Values
Indexes nix_Unverified_Item_CurrentItemId_ItemType, NIX_Unverified_Item_ItemType_ActivityHeaderID_WithIncludeColumns(2)SourceItemIDsvarchar(8000)8000NOT NULL('')List of Source identifiers from foreign systems
EntryNamevarchar(255)255NOT NULL('')Name of Unverified Item
Foreign Keys fk_Unverified_Item_StatusDE: [dbo].[Order_Status_DE].StatusDEStatusDE[dbo].[dict_id]5NULL allowed((0))Status. Link to Order_Status_DE.ID
ImportTypevarchar(50)50NOT NULL('')Import medium (Ex. ADX)
DisplayNamevarchar(255)255NOT NULL('')Display name
Indexes nix_Unverified_Item_CurrentItemId_ItemType, NIX_Unverified_Item_ItemType_ActivityHeaderID_WithIncludeColumns(2)CommunityLastModifiedDTTMdatetime8NULL 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.