Tables [dbo].[Requisition]
Requisition information related to  lab orders.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Requisition_ID: IDIndexes nix_requisition, nix_requisition_ReqNumberExt_ID, TWstat_Requisition_OrderingProviderID_ID, TWstat_Requisition_PerformingLocationDE_ID, TWstat_Requisition_RequestedFuzzySpecificity_ID, TWstat_Requisition_RequestedFuzzyWhen_ID(6)IDnumeric(16,0)9NOT NULL1 - 1Key to the Requisition table
Indexes nix_requisitionEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
Indexes nix_requisition, TWstat_Requisition_PerformingLocationDE_ID(2)PerformingLocationDE[dbo].[dict_id]5NOT NULLPerforming Location. Link to Req_Perf_Location_DE.ID
Indexes nix_requisition, TWstat_Requisition_OrderingProviderID_ID(2)OrderingProviderID[dbo].[uniqueid]9NOT NULLOrdering Provider. Link to Provider.ID
Indexes nix_requisition_ReqNumberExt_IDReqNumberExtvarchar(16)16NULL allowedExternal Requisition Number
Indexes nix_requisition, TWstat_Requisition_RequestedFuzzyWhen_ID(2)RequestedFuzzyWhenvarchar(50)50NOT NULL('')Entered to be done date
Indexes nix_requisition, TWstat_Requisition_RequestedFuzzySpecificity_ID(2)RequestedFuzzySpecificityvarchar(1)1NOT NULL('D')Specificity of the to be done date:
F:FreeText,  
D:YearMonthDay,
T:YearMonthDayTime,
M:YearMonth,
Y:Year.
AuthorizingProviderID[dbo].[uniqueid]9NOT NULL((0))Authorizing Provider. Link to Provider.ID
ClinicalPriorityDE[dbo].[dict_id]5NOT NULL((0))Priority. Link to Clinical_Priority_DE.ID
SiteDE[dbo].[dict_id]5NOT NULL((0))Site. Link to Site_DE.ID
Check Constraints CK_Requisition_FrozenFLAG_Yes_Or_No : ([FrozenFLAG]='N' OR [FrozenFLAG]='Y')FrozenFLAG[dbo].[BOOL]1NOT NULL('N')Does the specimen need to be frozen (Y/N)
CollectionDTTMdatetime8NULL allowedSpecimen Collection Datetime.
SpecificItemID[dbo].[uniqueid]9NOT 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')ToBeCollectedFLAG[dbo].[BOOL]1NOT NULL('N')Specimen has not been colected yet (Y/N)
Indexes nix_Requisition_RequisitionStatusDEOrderListUpdatedDTTMForeign Keys FK_Requisition_RequisitionStatusDE_Requisition_Status_DE_ID: [dbo].[Requisition_Status_DE].RequisitionStatusDERequisitionStatusDE[dbo].[dict_id]5NOT NULL((0))Requisition Status. Link to Requisition_Status_DE.ID
Indexes nix_Requisition_RequisitionStatusDEOrderListUpdatedDTTMOrderListUpdatedDTTMdatetime8NULL allowed(NULL)Date and time when the requisition was updated