Tables [dbo].[Plan_Item_Order]
Order Comminication and Identifier properties
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_Plan_Item_Order_PlanItemID: PlanItemIDCluster Key CIX_Plan_Item_Order_PlanItemID_ArchiveState: PlanItemID\ArchiveStateIndexes NIX_Plan_Item_Order_RequisitionID, TWstat_Plan_Item_Order_OrderingProviderID_PlanItemID(2)Foreign Keys FK_Plan_Item_Order_PlanItemID: [dbo].[Plan_Item].PlanItemIDPlanItemID[dbo].[uniqueid]9NOT NULLKey to the Plan_Item table.
CommunicationModeDE[dbo].[dict_id]5NULL allowedCommunication Method. link to Communication_Method_DE.ID.
Indexes TWstat_Plan_Item_Order_OrderingProviderID_PlanItemIDOrderingProviderID[dbo].[uniqueid]9NOT NULLOrdering Provider. Link to Provider.ID.
RequestedFuzzyWhenvarchar(50)50NULL allowedRequested Fuzzy Date Field
RequestedFuzzySpecificityvarchar(1)1NULL allowedIndicates if the RequestedFuzzyWhen field is a real date or fuzzy value
RequestedFuzzySortAsvarchar(50)50NULL allowedDate value to use for sorting based on RequestedFuzzyWhen
Indexes NIX_Plan_Item_Order_RequisitionIDRequisitionID[dbo].[uniqueid]9NOT NULL(0)Order Requisition Identifier
Indexes TWstat_Plan_Item_Order_SpecimenIDSpecimenID[dbo].[uniqueid]9NOT NULL(0)Specimen Identifier
ManifestID[dbo].[uniqueid]9NOT NULL(0)Manifest Identifier
Indexes TWstat_Plan_Item_Order_SpecimenCollectedDTTMSpecimenCollectedDTTMdatetime8NOT NULL('')DTTM of the collection for the Specimen
Indexes TWstat_Plan_Item_Order_SpecimenCollectedByIDSpecimenCollectedByID[dbo].[uniqueid]9NOT NULL(0)User who collected the Specimen
Cluster Key CIX_Plan_Item_Order_PlanItemID_ArchiveState: PlanItemID\ArchiveStateArchiveStatetinyint1NOT NULL((0))0 =  Record is in Main Partition
1 = Record is in Archived Partition