Tables [dbo].[Order_Item_Common]
General Order Instance Data
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Indexes NIX_Order_Item_Common_ActivityID_ActivityTypeActivityID[dbo].[uniqueid]9NOT NULLActivity Identifier - Linked table depends on type
Indexes NIX_Order_Item_Common_ActivityID_ActivityTypeActivityTypevarchar(10)10NOT NULLActivity Type (ex. Order, IM)
Cluster Key CIX_Order_Item_Common_ItemChildID_ItemType: ItemChildID\ItemTypeIndexes NIX_Order_Item_Common_Expdttm_Itemchildid_Itemtype, NIX_Order_Item_Common_ItemType_ItemChildID, NIX_Order_Item_Common_ItemType_Rptordflg_Poahderid_Oddttm, NIX_Order_Item_Common_ItemType_ScheduleHeaderID_ScheduledOrderParentID_ItemChildID, Nix_ScheduledOrderParentID(5)ItemChildID[dbo].[uniqueid]9NOT NULLOrder Item Identifier - Links to Plan_Item.ID, Medication.ID or Immunization.ID
Cluster Key CIX_Order_Item_Common_ItemChildID_ItemType: ItemChildID\ItemTypeIndexes NIX_Order_Item_Common_Expdttm_Itemchildid_Itemtype, NIX_Order_Item_Common_ItemType_ItemChildID, NIX_Order_Item_Common_ItemType_Rptordflg_Poahderid_Oddttm, NIX_Order_Item_Common_ItemType_ScheduleHeaderID_ScheduledOrderParentID_ItemChildID(4)ItemTypechar(2)2NOT NULLItem Type (IM,PL,ME)
Indexes TWstat_Order_Item_Common_ContainedInNoteIDContainedInNoteID[dbo].[uniqueid]9NOT NULL(0)Linked Note Identifier - Links to Document.DocumentID
EffectiveDTTMdatetime8NOT NULL('')Order Effective Datetime
Indexes NIX_Order_Item_Common_Expdttm_Itemchildid_Itemtype, NIX_Order_Item_Common_ItemType_ItemChildID(2)ExpirationDTTMdatetime8NOT NULL('')Order Expiration Datetime
AuthorizationModechar(1)1NOT NULL('')Order Authorization Mode (A,N,P,R) Retrospective, Prospective, None
Indexes TWstat_Order_Item_Common_ByProtocolFLAGByProtocolFLAGchar(1)1NOT NULL('N')Verbal order vs By Protocol FLAG (Y/N)
Indexes TWstat_Order_Item_Common_ManagedByIDManagedByID[dbo].[uniqueid]9NOT NULL(0)Managing Provider ID - Links to dbo.Provider.ID
Indexes NIX_Order_Item_Common_ItemType_Rptordflg_Poahderid_OddttmOrderStatusReasonDEListvarchar(255)255NOT NULL('')Justification of current status - Links to Order_Status_Reason_DE.ID
Indexes NIX_Order_Item_Common_ItemType_Rptordflg_Poahderid_OddttmCheck Constraints CK_Order_Item_Common_ReportedOrderFLAG_Yes_Or_No : ([ReportedOrderFLAG]='N' OR [ReportedOrderFLAG]='Y')ReportedOrderFLAG[dbo].[BOOL]1NOT NULL('N')Indicates an item that was recorded as history
Indexes TWstat_Order_Item_Common_DeferredFLAGCheck Constraints CK_Order_Item_Common_DeferredFLAG_Yes_Or_No : ([DeferredFLAG]='N' OR [DeferredFLAG]='Y')DeferredFLAG[dbo].[BOOL]1NOT NULL('N')Indicates a deferred Order
Indexes TWstat_Order_Item_Common_DeferralReasonDEDeferralReasonDE[dbo].[dict_id]5NOT NULL(0)Reason for Deferral - Links to Deferral_Reason_DE.ID
Indexes TWstat_Order_Item_Common_DeferralTypeDeferralTypechar(1)1NOT NULL('')Temporary/Permanent Indicator (T or P)
Indexes TWstat_Order_Item_Common_DeferralTimeIntervalDeferralTimeIntervalsmallint2NOT NULL(0)Deferral Time Value
Indexes TWstat_Order_Item_Common_DeferralTimeUnitsDeferralTimeUnitschar(1)1NOT NULL('')Deferrral Time Unit Type
Indexes TWstat_Order_Item_Common_NeedToSchedApptFLAGCheck Constraints CK_Order_Item_Common_NeedToSchedApptFLAG_Yes_Or_No : ([NeedToSchedApptFLAG]='N' OR [NeedToSchedApptFLAG]='Y')NeedToSchedApptFLAG[dbo].[BOOL]1NOT NULL('N')Indicates an appointment needs to be scheduled
Indexes TWstat_Order_Item_Common_AuthorizedDTTMAuthorizedDTTMdatetime8NOT NULL('')Datetime of Authorization
Indexes NIX_Order_Item_Common_ItemType_ItemChildID, TWstat_Order_Item_Common_OrderedDTTM(2)OrderedDTTMdatetime8NOT NULL('')Datetime Order was placed
Indexes NIX_Order_Item_Common_ItemType_ItemChildID, NIX_Order_Item_Common_ItemType_Rptordflg_Poahderid_Oddttm, TWstat_Order_Item_Common_OverdueImportantFLAG(3)Check Constraints CK_Order_Item_Common_OverdueImportantFLAG_Yes_Or_No : ([OverdueImportantFLAG]='N' OR [OverdueImportantFLAG]='Y')OverdueImportantFLAG[dbo].[BOOL]1NOT NULL('N')Overdue Important Indicator - Time sensitive order
Indexes NIX_Order_Item_Common_ItemType_ItemChildID, NIX_Order_Item_Common_ItemType_Rptordflg_Poahderid_Oddttm, NIX_Order_Item_Common_OverdueDTTM(3)OverdueDTTMdatetime8NOT NULL('')Overdue Datetime
Indexes TWstat_Order_Item_Common_OrderingEncounterIDOrderingEncounterID[dbo].[uniqueid]9NOT NULL(0)Encounter where order was placed - links to Encounter.ID
Indexes TWstat_Order_Item_Common_CollectionEncounterIDCollectionEncounterID[dbo].[uniqueid]9NOT NULL(0)Encounter where specimen was collected - links to Encounter.ID
Indexes TWstat_Order_Item_Common_ToBeDoneBeforeEncounterIDToBeDoneBeforeEncounterID[dbo].[uniqueid]9NOT NULL(0)Encounter which order must be completed before - links to Encounter.ID
Indexes TWstat_Order_Item_Common_ScheduledForEncounterIDScheduledForEncounterID[dbo].[uniqueid]9NOT NULL(0)Encounter item is scheduled against - links to Encounter.ID
Indexes TWstat_Order_Item_Common_PerformingEncounterIDPerformingEncounterID[dbo].[uniqueid]9NOT NULL(0)Encounter where item was performed - links to Encounter.ID
Indexes TWstat_Order_Item_Common_ReportedEncounterIDReportedEncounterID[dbo].[uniqueid]9NOT NULL(0)Encounter where item was reported - links to Encounter.ID
Indexes TWstat_Order_Item_Common_ChargeEncounterIDChargeEncounterID[dbo].[uniqueid]9NOT NULL(0)Charge EncounterID for this item - links to Encounter.ID
Indexes TWstat_Order_Item_Common_BillingProviderIDBillingProviderID[dbo].[uniqueid]9NOT NULL(0)Billing Provider - Links to IDX_User.ID
Indexes TWstat_Order_Item_Common_BillingLocationDEBillingLocationDE[dbo].[dict_id]5NOT NULL(0)Billing Location - Links to Billing_Location_DE.ID
Indexes TWstat_Order_Item_Common_PerformingProviderIDPerformingProviderID[dbo].[uniqueid]9NOT NULL(0)Performing Provider - Links to IDX_User.ID
TransitionedFromID[dbo].[uniqueid]9NOT NULL(0)Transitioned From Parent ItemID - links to Item.ID
TransitionedToID[dbo].[uniqueid]9NOT NULL(0)Transitioned To Parent ItemID - links to Item.ID
MissingAdditionalInfoFLAGchar(1)1NOT NULL('N')Additional Information Missing Indicator
Indexes NIX_Order_Item_Common_ItemType_ScheduleHeaderID_ScheduledOrderParentID_ItemChildIDScheduleHeaderID[dbo].[uniqueid]9NOT NULL(0)Schedule Header Identifier - links to Schedule_Header.ID
Indexes NIX_Order_Item_Common_ItemType_ScheduleHeaderID_ScheduledOrderParentID_ItemChildID, Nix_ScheduledOrderParentID(2)ScheduledOrderParentID[dbo].[uniqueid]9NOT NULL(0)Present if this is child order of a scheduled parent - links to Item_Plan.ID
Indexes Nix_Order_Item_Common_ScheduleID ScheduleID[dbo].[uniqueid]9NOT NULL(0)Schedule Identifier - Links to Schedule.ID
Indexes TWstat_Order_Item_Common_CreatedByIDCreatedByID[dbo].[uniqueid]9NOT NULL(0)User that created the record - links to IDX_User.ID
Indexes NIX_Order_Item_Common_ItemType_ItemChildID, TWstat_Order_Item_Common_SiteDE(2)SiteDE[dbo].[dict_id]5NOT NULL(0)Site Dictionary - Links to Site_DE.ID
WhenToChargeDE[dbo].[dict_id]5NOT NULL(0)WhenToCharge Dictionary - Links to When_To_Charge_DE.ID
CPT4Codevarchar(10)10NOT NULL('')CPT4 Code for this item when it will not be billed
Indexes TWstat_Order_Item_Common_OrderInstructionsOrderInstructionsvarchar(2000)2000NOT NULL('')Order Insturctions text as input by the user
Indexes NIX_Order_Item_Common_ItemType_ItemChildIDReqPerfLocationDE[dbo].[dict_id]5NOT NULL(0)Requested Performing Location - Links to Req_Perf_Location_DE.ID
ChargeCodeDEListvarchar(255)255NOT NULL('')List of applicable charge codes - links to Charge_Code_DE.ID
RequestedFuzzyWhenvarchar(50)50NOT NULL('')Requested Date (Fuzzy)
RequestedFuzzySpecificityvarchar(1)1NOT NULL('')RequestedFuzzyWhen Date type Indicator (Fuzzy vs Actual Date)
RequestedFuzzySortAsdatetime8NOT NULL('')Literal datetime to use when sorting this entry by FuzzyDate
Indexes TWstat_Order_Item_Common_InjuryTypeDEForeign Keys FK_Order_Item_Common_InjuryTypeDE_Injury_Type_DE_ID: [dbo].[Injury_Type_DE].InjuryTypeDEInjuryTypeDE[dbo].[dict_id]5NOT NULL(0)Special Billing reference - links to Injury_Type_DE.ID
Indexes TWstat_Order_Item_Common_InjuryDTTMInjuryDTTMdatetime8NULL allowedDatetime of Injury
Indexes TWstat_Order_Item_Common_InjuryAccountNumberInjuryAccountNumbervarchar(20)20NOT NULL('')Injury Account Number (ex. For Worker's Compensation identifier)
Indexes TWstat_Order_Item_Common_InjuryAccountDescriptionInjuryAccountDescriptionvarchar(255)255NOT NULL('')Injury Account Description
Check Constraints CK_Order_Item_Common_HasBeenVerifiedOrAuthorizedFLAG_Yes_Or_No : ([HasBeenVerifiedOrAuthorizedFLAG]='N' OR [HasBeenVerifiedOrAuthorizedFLAG]='Y')HasBeenVerifiedOrAuthorizedFLAG[dbo].[BOOL]1NOT NULL('N')Flag indicating that the item has been Verified or Authorized
Check Constraints CK_Order_Item_Common_ProceedDespiteDenialFLAG_Yes_Or_No : ([ProceedDespiteDenialFLAG]='N' OR [ProceedDespiteDenialFLAG]='Y')ProceedDespiteDenialFLAG[dbo].[BOOL]1NOT NULL('N')Denial Override Flag (Y/N)
Check Constraints CK_Order_Item_Common_HoldForActivationFLAG_Yes_Or_No : ([HoldForActivationFLAG]='N' OR [HoldForActivationFLAG]='Y')HoldForActivationFLAG[dbo].[BOOL]1NOT NULL('N')Hold Order for Activation by user (Y/N)
Check Constraints CK_Order_Item_Common_HasBeenSentToRPLFLAG_Yes_Or_No : ([HasBeenSentToRPLFLAG]='N' OR [HasBeenSentToRPLFLAG]='Y')HasBeenSentToRPLFLAG[dbo].[BOOL]1NOT NULL('N')Order has been sent to the Requested Performing Location FLAG (Y/N)
Check Constraints CK_Order_Item_Common_HasHadInboundInterfaceTrafficFLAG_Yes_Or_No : ([HasHadInboundInterfaceTrafficFLAG]='N' OR [HasHadInboundInterfaceTrafficFLAG]='Y')HasHadInboundInterfaceTrafficFLAG[dbo].[BOOL]1NOT NULL('N')Flag indicating this order was updated via Interface
Indexes TWstat_Order_Item_Common_CarePlanTemplateIDCarePlanTemplateID[dbo].[dict_id]5NOT NULL(0)Order is assocaited with a Care Guide - Links to Careplan_Template.ID
OrderApptStatusDE[dbo].[dict_id]5NOT NULL(0)Status indicator for the need for an appointment for this order - links to Order_Appt_Status_De.ID
Indexes TWstat_Order_Item_Common_ManualOrderStatusReasonDECompletedListManualOrderStatusReasonDECompletedListvarchar(255)255NOT NULL('')List of completed actions on this order - Links to Order_Status_Reason_DE.ID
Indexes TWstat_Order_Item_Common_ManualOrderStatusReasonDEIncompleteListManualOrderStatusReasonDEIncompleteListvarchar(255)255NOT NULL('')List of actions to be completed on this order - Links to Order_Status_Reason_DE.ID
Indexes NIX_Order_Item_Common_ItemType_Rptordflg_Poahderid_OddttmParentOrderActivityHeaderID[dbo].[uniqueid]9NOT NULL(0)ActivityHeaderID for Parent Order - links to Order_Activity_Header.ID
OrderPriorityDE[dbo].[dict_id]5NOT NULL(0)Order Priority Level - links to Order_Priority_DE.ID
Indexes TWstat_Order_Item_Common_ContainedInNAWHeaderIDContainedInNAWHeaderID[dbo].[uniqueid]9NOT NULL(0)Containing Note HeaderID - Links to Noteform_NAW_Instanace_Header.HeaderID
Indexes TWstat_Order_Item_Common_ContainedInNAWInstanceIDContainedInNAWInstanceID[dbo].[uniqueid]9NOT NULL(0)Containing Note InstanceID - Links to Noteform_NAW_Instanace.InstanceID
Check Constraints CK_Order_Item_Common_PrintReqFLAG_Yes_Or_No : ([PrintReqFLAG]='N' OR [PrintReqFLAG]='Y')PrintReqFLAG[dbo].[BOOL]1NOT NULL('N')Print Requisition FLAG - Used in Printing/AutoPrint default processing
OverdueIntervalsmallint2NOT NULL((0))Numeric Overdue Interval value
Foreign Keys FK_Order_Item_Common_OverdueUnitsDE: [dbo].[HMP_Freq_Unit_DE].OverdueUnitsDEOverdueUnitsDE[dbo].[dict_id]5NOT NULL((0))Overdue Interval value unit - links to HMP_Freq_Unit_DE.ID
Indexes NIX_Order_Item_Common_VerificationEncounterIDForeign Keys FK_Order_Item_Common_VerificationEncounterID: [dbo].[Encounter].VerificationEncounterIDVerificationEncounterID[dbo].[uniqueid]9NOT NULL((0))EncounterID where verification occurred - links to Encounter.ID
Check Constraints CK_Order_Item_Common_GenerateNextInstance_Yes_Or_No : ([GenerateNextInstance]='N' OR [GenerateNextInstance]='Y')GenerateNextInstance[dbo].[BOOL]1NULL allowed('N')Y/N flag to trigger new instance generation
Indexes NIX_Order_Item_Common_DeferredUntilDTTMDeferredUntilDTTMdatetime8NULL allowedDatetime order is deferred until
DoneFuzzySortASdatetime8NOT NULL('1/1/1900')Datetime to use for sorting based on DoneFuzzyWhen
DoneFuzzySpecificitychar(1)1NOT NULL('D')Idicates if the done datetime is a specific value or fuzzy
DoneFuzzyWhenvarchar(50)50NOT NULL('')Fuzzy Order Done Datetime
OriginatingSiteDE[dbo].[dict_id]5NULL allowedSite that order originated from  - links to Site_De.ID
ABNDiagnosisCodesvarchar(255)255NULL allowedAdvanced Benificiary Notice Diagnosis Codes
ABNICDCodeTypechar(10)10NULL allowedICD Code type name
OrderStatusReasonFreeTextvarchar(50)50NOT NULL('')Order Status Reason Free Text Field
OrderingProviderFreeTextvarchar(255)255NULL allowed('')Ordering Provider Free Text Field