Tables [dbo].[Plan_Item]
Versioned Detail table for non-medication orders.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_Plan_Item_ID: IDCluster Key CIX_Plan_Item_ID_ArchiveState: ID\ArchiveStateIndexes TWstat_Plan_Item_HasChargeInfoFLAG_ID, TWstat_Plan_Item_OrderStatusDE_ID, TWstat_Plan_Item_SourceDE_ID, TWstat_Plan_Item_UseOrderAuthTasking_ID, TWstat_Plan_Item_WhenPerformedDTTM_ID, TWstat_Plan_Item_WhenRecordedDTTM_ID, TWstat_Plan_Item_WherePerformedDE_ID, TWstat_Plan_Item_WhoDidItID_ID, TWstat_Plan_Item_WhoForID_ID(9)ID[dbo].[uniqueid]9NOT NULLKey to the Plan_Item table.
Indexes NIX_Plan_Item_ItemID_WithIncludeColumns, NIX_Plan_Item_OrderNumberEXT_INC_ItemID_WherePerformedDE, NIX_Plan_Item_WhenRecordedDttm_INC_ItemID(3)Foreign Keys FK_Plan_Item_ItemID_Item_Plan_ID: [dbo].[Item_Plan].ItemIDItemID[dbo].[uniqueid]9NOT NULLItem. Link to Item_Plan.ID
NoteActivityIDnumeric(16,0)9NOT NULLAudit Note. Link to Act_Hdr_Note.ID
Indexes TWstat_Plan_Item_SourceDE_IDSourceDE[dbo].[dict_id]5NOT NULLSource for the specimen. Link to Source_DE.ID
Indexes NIX_Plan_Item_OrderNumberEXT_INC_ItemID_WherePerformedDE, TWstat_Plan_Item_WherePerformedDE_ID(2)WherePerformedDE[dbo].[dict_id]5NOT NULLWhere Performed. Link  to Where_Performed_DE.ID.
Indexes TWstat_Plan_Item_ClinicalPriorityDEClinicalPriorityDE[dbo].[dict_id]5NOT NULLPriority. Link to Clinical_Priority_DE.ID. Possible values are ASAP, Pre-Op, Routine, Stat, Today
Indexes NIX_Plan_Item_ItemID_WithIncludeColumns, TWstat_Plan_Item_OrderStatusDE_ID(2)OrderStatusDE[dbo].[dict_id]5NOT NULLStatus. Link to Order_Status_DE.ID
Indexes NIX_Plan_Item_OrderNumberEXT_INC_ItemID_WherePerformedDEOrderNumberEXTvarchar(30)30NOT NULL(' ')External Order Number
PlanTextvarchar(255)255NOT NULL(' ')Order Text. No longer used.
PlanReasonvarchar(255)255NOT NULL(' ')Order Reason Text. No longer used.
Indexes TWstat_Plan_Item_WhoForID_IDWhoForID[dbo].[uniqueid]9NOT NULLWho this was entered for. The Ordering Provider. Link to Provider.ID.
Indexes NIX_Plan_Item_ItemID_WithIncludeColumns, TWstat_Plan_Item_WhoDidItID_ID(2)WhoDidItID[dbo].[uniqueid]9NOT NULLWho entered the order. Link to IDX_User.ID
FuzzyDatevarchar(50)50NOT NULL(' ')Requested order's Date and Time in string format.
Indexes TWstat_Plan_Item_RequestedDTTMRequestedDTTMdatetime8NULL allowedRequested Date and time in proper Date time format
OverDueDTTMdatetime8NULL allowedoverdue date and time
Check Constraints CK_Plan_Item_ReasonForCreateType_Reason_Create_Type : ([ReasonForCreateType]='A' OR [ReasonForCreateType]='C' OR [ReasonForCreateType]='E')ReasonForCreateTypechar(1)1NOT NULLCreation reason. A -Added
Indexes NIX_Plan_Item_ItemID_WithIncludeColumns, NIX_Plan_Item_WhenRecordedDttm_INC_ItemID, TWstat_Plan_Item_WhenRecordedDTTM_ID(3)WhenRecordedDTTMdatetime8NOT NULLRecorded Date and Time
Indexes TWstat_Plan_Item_WhenPerformedDTTM_IDWhenPerformedDTTMdatetime8NOT NULLPerformed Date and Time
Indexes TWstat_Plan_Item_HasChargeInfoFLAG_IDCheck Constraints CK_Plan_Item_HasChargeInfoFLAG_Yes_Or_No : ([HasChargeInfoFLAG]='N' OR [HasChargeInfoFLAG]='Y')HasChargeInfoFLAG[dbo].[BOOL]1NOT NULLIndicates whether any Charge is assosciated to the Order (Y/N)
QOMOD1DESnapshot[dbo].[dict_id]5NOT NULL('0')First Order Modifier. Link to QO_Mod_DE.ID
QOMOD2DESnapshot[dbo].[dict_id]5NOT NULL('0')Second Order Modifier. Link to QO_Mod_DE.ID
QOMOD3DESnapshot[dbo].[dict_id]5NOT NULL('0')Third Order Modifier. Link to QO_Mod_DE.ID
QOMOD1PicklistSnapshotvarchar(300)300NULL allowed('')First Order Modifier Picklist ID and Name. Link to Picklist.ID and Picklist.Entryname
QOMOD2PicklistSnapshotvarchar(300)300NULL allowed('')Second Order Modifier Picklist ID and Name. Link to Picklist.ID and Picklist.Entryname
QOMOD3PicklistSnapshotvarchar(300)300NULL allowed('')Third Order Modifier Picklist ID and Name. Link to Picklist.ID and Picklist.Entryname
Indexes TWstat_Plan_Item_FuzyPreOpDateFuzyPreOpDatevarchar(50)50NOT NULL('')Pre-Operation date.
Indexes TWstat_Plan_Item_AuthorizationNumberAuthorizationNumbervarchar(20)20NOT NULL('')Authorization Number
Indexes TWstat_Plan_Item_NonGeneratedExtIDNonGeneratedExtIDvarchar(255)255NOT NULL('')External Identifier
Indexes TWstat_Plan_Item_LabelTypeDELabelTypeDE[dbo].[dict_id]5NOT NULL(0)Label Type. Link to Label_Type_DE.ID
Indexes TWstat_Plan_Item_PatientInstructionsPatientInstructionsvarchar(1000)1000NOT NULL('')Patient Instructions
Indexes TWstat_Plan_Item_UseOrderAuthTasking_IDUseOrderAuthTaskingchar(1)1NOT NULL('N')Create order authorization tasks (Y/N)
Indexes TWstat_Plan_Item_ReferralTypeDEReferralTypeDE[dbo].[dict_id]5NOT NULL(0)Referral Type. Link to Referral_Type_DE.ID
Indexes TWstat_Plan_Item_SpecialtyDESpecialtyDE[dbo].[dict_id]5NOT NULL(0)Specialty. Link to Specialty_DE.ID
Indexes TWstat_Plan_Item_InternalExternalInternalExternalchar(1)1NOT NULL('')I - Internal referral, E - External Referral
Indexes TWstat_Plan_Item_ReferredToVendOrgDEReferredToVendOrgDE[dbo].[dict_id]5NOT NULL(0)Referred to Verdor (External) or Organization. Link to Vendor_DE.ID or Organization.ID.
Indexes TWstat_Plan_Item_ReferredToRPLSiteDEReferredToRPLSiteDE[dbo].[dict_id]5NOT NULL(0)Referred to Reqested Performig Location (External) or Site (Internal). Link to Req_Perf_Location_DE.ID or Site_DE.ID.
Indexes TWstat_Plan_Item_ReferredToProviderDEReferredToProviderDE[dbo].[dict_id]5NOT NULL(0)Referred to Referring Provider (External) or Provider (Internal). Link to Referring_Provider_DE.ID or Provider.ID.
Indexes TWstat_Plan_Item_FirstAvailableFLAGCheck Constraints CK_Plan_Item_FirstAvailableFLAG_Yes_Or_No : ([FirstAvailableFLAG]='N' OR [FirstAvailableFLAG]='Y')FirstAvailableFLAG[dbo].[BOOL]1NOT NULL('N')First available Provider (Y/N)
Indexes TWstat_Plan_Item_SpecimenTypeDESpecimenTypeDE[dbo].[dict_id]5NOT NULL(0)Specimen type. Link to Specimen_Type_DE.ID
Indexes TWstat_Plan_Item_FirstStringFirstStringnvarchar(1024)2048NULL allowed('')First String for Instructions or Precautions.
Indexes TWstat_Plan_Item_ChronicFLAGCheck Constraints CK_Plan_Item_ChronicFLAG_Yes_Or_No : ([ChronicFLAG]='N' OR [ChronicFLAG]='Y')ChronicFLAG[dbo].[BOOL]1NOT NULL('N')Show on Orders List field in Order Detail window for Instruction/Precaution Order
Indexes TWstat_Plan_Item_CallPhoneNumberCallPhoneNumbervarchar(25)25NOT NULL('')Phone number to call for Instruction/Precautions orders.
Indexes TWstat_Plan_Item_ProblemLinkListProblemLinkListvarchar(500)500NULL allowed('')Linked Problems. Links to Problem_Header.ID
Indexes TWstat_Plan_Item_PerformingCommentsPerformingCommentsvarchar(1000)1000NULL allowed('')Performing Comments
Indexes TWstat_Plan_Item_IsUnverifiedFLAGCheck Constraints CK_Plan_Item_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y')IsUnverifiedFLAG[dbo].[BOOL]1NOT NULL('N')Unverified Order (Y/N)
Indexes TWstat_Plan_Item_QOModPicklistIDQOModPicklistID[dbo].[dict_id]5NOT NULL(0)First Modifier Picklist. Link to Picklist.ID.
Indexes TWstat_Plan_Item_QOModPicklist2IDQOModPicklist2ID[dbo].[dict_id]5NOT NULL(0)Second Modifier Picklist. Link to Picklist.ID.
Indexes TWstat_Plan_Item_QOModPicklist3IDQOModPicklist3ID[dbo].[dict_id]5NOT NULL(0)Third Modifier Picklist. Link to Picklist.ID.
Indexes TWstat_Plan_Item_QOModPicklistReqCheck Constraints CK_Plan_Item_QOModPicklistReq_Yes_Or_No : ([QOModPicklistReq]='N' OR [QOModPicklistReq]='Y')QOModPicklistReq[dbo].[BOOL]1NOT NULL('N')First Modifier Picklist is required to save the order (Y/N).
Indexes TWstat_Plan_Item_QOModPicklist2ReqCheck Constraints CK_Plan_Item_QOModPicklist2Req_Yes_Or_No : ([QOModPicklist2Req]='N' OR [QOModPicklist2Req]='Y')QOModPicklist2Req[dbo].[BOOL]1NOT NULL('N')Second Modifier Picklist is required to save the order (Y/N).
Indexes TWstat_Plan_Item_QOModPicklist3ReqCheck Constraints CK_Plan_Item_QOModPicklist3Req_Yes_Or_No : ([QOModPicklist3Req]='N' OR [QOModPicklist3Req]='Y')QOModPicklist3Req[dbo].[BOOL]1NOT NULL('N')Third Modifier Picklist is required to save the order (Y/N).
Indexes TWstat_Plan_Item_SourceSingleOrDefaultSourceSingleOrDefaultvarchar(1)1NOT NULL('')S - Default the Source and it can not be changed. D - Default the source and allow it to be changed.
Indexes TWstat_Plan_Item_ReqV4OrderingAuthorityReqV4OrderingAuthorityint4NOT NULL(0)Required Ordering Authority
Indexes TWstat_Plan_Item_VerificationTaskOwnerIDVerificationTaskOwnerID[dbo].[uniqueid]9NOT NULL(0)Task owner for verification tasks. Link to either IDX_User.ID or Team_DE.ID.
Indexes TWstat_Plan_Item_VerificationTaskOwnerTypeVerificationTaskOwnerTypechar(10)10NOT NULL('')Verification Task Owner Type. User or Team.
Indexes TWstat_Plan_Item_OrderReasonDEOrderReasonDE[dbo].[dict_id]5NOT NULL(0)Reason for order. Link to Order_Reason_DE.ID.
Indexes TWstat_Plan_Item_QuantityQuantitysmallint2NOT NULL(0)Quantity. For supplies orders
Indexes TWstat_Plan_Item_DAWFLAGCheck Constraints CK_Plan_Item_DAWFLAG_Yes_Or_No : ([DAWFLAG]='N' OR [DAWFLAG]='Y')DAWFLAG[dbo].[BOOL]1NOT NULL('N')Dispense as Written (Y/N)
Indexes TWstat_Plan_Item_UrgencyUrgencyvarchar(10)10NOT NULL('')Urgency for precaution orders (Call, Urgent, Emergent)
Indexes TWstat_Plan_Item_OrderReasonOrderReasonvarchar(2000)2000NULL allowed('')Textual order reason
Check Constraints CK_Plan_Item_ToBeCollectedFLAG_Yes_Or_No : ([ToBeCollectedFLAG]='N' OR [ToBeCollectedFLAG]='Y')ToBeCollectedFLAG[dbo].[BOOL]1NOT NULL('N')Specimen Needs to be collected (Y/N)
Check Constraints CK_Plan_Item_DoNotReleaseFLAG_Yes_Or_No : ([DoNotReleaseFLAG]='N' OR [DoNotReleaseFLAG]='Y')DoNotReleaseFLAG[dbo].[BOOL]1NOT NULL('N')Do not release (Y/N)
Check Constraints CK_Plan_Item_UserCanOverrideFLAG_Yes_Or_No : ([UserCanOverrideFLAG]='N' OR [UserCanOverrideFLAG]='Y')UserCanOverrideFLAG[dbo].[BOOL]1NOT NULL('N')User can override the do not release flag (Y/N)
Summaryvarchar(2000)2000NULL allowedSummary text
OrderInstructionReviewedBy[dbo].[uniqueid]9NULL allowedProvider who Reviewed the Instruction. Link to IDX_User.ID.
OrderInstructionReviewedDTTMdatetime8NULL allowedReviewed Date and time of the instruction order.
RecipientProviderID[dbo].[uniqueid]9NULL allowedRecipient Provider. Link to provider.ID.
HPDProviderIDvarchar(50)50NULL allowedHealthcare Provider Directory Provider Identifier
HPDProviderNamevarchar(255)255NULL allowedHealthcare Provider Directory provider name
HPDDirectIDvarchar(255)255NULL allowedHealthcare Provider Directory Direct Identifier for the provider
Check Constraints CK_Plan_Item_SpecialistResponseReceivedFLAG_Yes_Or_No : ([SpecialistResponseReceivedFLAG]='N' OR [SpecialistResponseReceivedFLAG]='Y')SpecialistResponseReceivedFLAG[dbo].[BOOL]1NULL allowedResponce received from the specialist (Y/N)
CommunityID[dbo].[uniqueid]9NOT NULL((0))Community. Link to CED_Endpoints.ID
Check Constraints CK_Plan_Item_FreeTextOrderFLAG_Yes_Or_No : ([FreeTextOrderFLAG]='N' OR [FreeTextOrderFLAG]='Y')FreeTextOrderFLAG[dbo].[BOOL]1NOT NULL('N')Free Text Order (Y/N)
FreeTextDescriptionvarchar(255)255NOT NULL('')Free text description
Cluster Key CIX_Plan_Item_ID_ArchiveState: ID\ArchiveStateArchiveStatetinyint1NOT NULL((0))0 =  Record is in Main Partition
1 = Record is in Archived Partition
LinkedItemsvarchar(max)maxNULL allowedList of linked Goals/Interventions
SnomedCodeListvarchar(255)255NOT NULL('')SNOMED term codes of the Orderable item
LOINCCodeListvarchar(255)255NOT NULL('')LOINC codes of the Orderable item
CPT4CodeListvarchar(255)255NOT NULL('')CPT4 Codes of the Orderable item