Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 (6) | ID | numeric(16,0) | 9 | NOT NULL | 1 - 1 | | Key to the Requisition table |
 | EncounterID | [dbo].[uniqueid] | 9 | NOT NULL | | | Encounter. Link to Encounter.ID |
(2) | PerformingLocationDE | [dbo].[dict_id] | 5 | NOT NULL | | | Performing Location. Link to Req_Perf_Location_DE.ID |
(2) | OrderingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | | Ordering Provider. Link to Provider.ID |
 | ReqNumberExt | varchar(16) | 16 | NULL allowed | | | External Requisition Number |
(2) | RequestedFuzzyWhen | varchar(50) | 50 | NOT NULL | | ('') | Entered to be done date |
(2) | RequestedFuzzySpecificity | varchar(1) | 1 | NOT NULL | | ('D') | Specificity of the to be done date: F:FreeText, D:YearMonthDay, T:YearMonthDayTime, M:YearMonth, Y:Year. |
| AuthorizingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | ((0)) | Authorizing Provider. Link to Provider.ID |
| ClinicalPriorityDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | Priority. Link to Clinical_Priority_DE.ID |
| SiteDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | Site. Link to Site_DE.ID |
![Check Constraints CK_Requisition_FrozenFLAG_Yes_Or_No : ([FrozenFLAG]='N' OR [FrozenFLAG]='Y') Check Constraints CK_Requisition_FrozenFLAG_Yes_Or_No : ([FrozenFLAG]='N' OR [FrozenFLAG]='Y')](../../../../Images/c-constraint.png) | FrozenFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Does the specimen need to be frozen (Y/N) |
| CollectionDTTM | datetime | 8 | NULL allowed | | | Specimen Collection Datetime. |
| SpecificItemID | [dbo].[uniqueid] | 9 | NOT NULL | | ((0)) | The specimen is specific to this order. Link to Item_Plan.ID. Populated when the QO_Classification_DE.NeverCombineOnOtherReqFLAG is set to Y. |
![Check Constraints CK_Requisition_ToBeCollectedFLAG_Yes_Or_No : ([ToBeCollectedFLAG]='N' OR [ToBeCollectedFLAG]='Y') Check Constraints CK_Requisition_ToBeCollectedFLAG_Yes_Or_No : ([ToBeCollectedFLAG]='N' OR [ToBeCollectedFLAG]='Y')](../../../../Images/c-constraint.png) | ToBeCollectedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Specimen has not been colected yet (Y/N) |
 ![Foreign Keys FK_Requisition_RequisitionStatusDE_Requisition_Status_DE_ID: [dbo].[Requisition_Status_DE].RequisitionStatusDE Foreign Keys FK_Requisition_RequisitionStatusDE_Requisition_Status_DE_ID: [dbo].[Requisition_Status_DE].RequisitionStatusDE](../../../../Images/fk.png) | RequisitionStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | Requisition Status. Link to Requisition_Status_DE.ID |
 | OrderListUpdatedDTTM | datetime | 8 | NULL allowed | | (NULL) | Date and time when the requisition was updated |