Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
  (2)![Foreign Keys FK_Plan_Item_Order_PlanItemID: [dbo].[Plan_Item].PlanItemID Foreign Keys FK_Plan_Item_Order_PlanItemID: [dbo].[Plan_Item].PlanItemID](../../../../Images/fk.png) | PlanItemID | [dbo].[uniqueid] | 9 | NOT NULL | | Key to the Plan_Item table. |
| CommunicationModeDE | [dbo].[dict_id] | 5 | NULL allowed | | Communication Method. link to Communication_Method_DE.ID. |
 | OrderingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | Ordering Provider. Link to Provider.ID. |
| RequestedFuzzyWhen | varchar(50) | 50 | NULL allowed | | Requested Fuzzy Date Field |
| RequestedFuzzySpecificity | varchar(1) | 1 | NULL allowed | | Indicates if the RequestedFuzzyWhen field is a real date or fuzzy value |
| RequestedFuzzySortAs | varchar(50) | 50 | NULL allowed | | Date value to use for sorting based on RequestedFuzzyWhen |
 | RequisitionID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Order Requisition Identifier |
 | SpecimenID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Specimen Identifier |
| ManifestID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Manifest Identifier |
 | SpecimenCollectedDTTM | datetime | 8 | NOT NULL | ('') | DTTM of the collection for the Specimen |
 | SpecimenCollectedByID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | User who collected the Specimen |
 | ArchiveState | tinyint | 1 | NOT NULL | ((0)) | 0 = Record is in Main Partition 1 = Record is in Archived Partition |