Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 | ActivityID | [dbo].[uniqueid] | 9 | NOT NULL | | Activity Identifier - Linked table depends on type |
 | ActivityType | varchar(10) | 10 | NOT NULL | | Activity Type (ex. Order, IM) |
 (5) | ItemChildID | [dbo].[uniqueid] | 9 | NOT NULL | | Order Item Identifier - Links to Plan_Item.ID, Medication.ID or Immunization.ID |
 (4) | ItemType | char(2) | 2 | NOT NULL | | Item Type (IM,PL,ME) |
 | ContainedInNoteID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Linked Note Identifier - Links to Document.DocumentID |
| EffectiveDTTM | datetime | 8 | NOT NULL | ('') | Order Effective Datetime |
(2) | ExpirationDTTM | datetime | 8 | NOT NULL | ('') | Order Expiration Datetime |
| AuthorizationMode | char(1) | 1 | NOT NULL | ('') | Order Authorization Mode (A,N,P,R) Retrospective, Prospective, None |
 | ByProtocolFLAG | char(1) | 1 | NOT NULL | ('N') | Verbal order vs By Protocol FLAG (Y/N) |
 | ManagedByID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Managing Provider ID - Links to dbo.Provider.ID |
 | OrderStatusReasonDEList | varchar(255) | 255 | NOT NULL | ('') | Justification of current status - Links to Order_Status_Reason_DE.ID |
 ![Check Constraints CK_Order_Item_Common_ReportedOrderFLAG_Yes_Or_No : ([ReportedOrderFLAG]='N' OR [ReportedOrderFLAG]='Y') Check Constraints CK_Order_Item_Common_ReportedOrderFLAG_Yes_Or_No : ([ReportedOrderFLAG]='N' OR [ReportedOrderFLAG]='Y')](../../../../Images/c-constraint.png) | ReportedOrderFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Indicates an item that was recorded as history |
 ![Check Constraints CK_Order_Item_Common_DeferredFLAG_Yes_Or_No : ([DeferredFLAG]='N' OR [DeferredFLAG]='Y') Check Constraints CK_Order_Item_Common_DeferredFLAG_Yes_Or_No : ([DeferredFLAG]='N' OR [DeferredFLAG]='Y')](../../../../Images/c-constraint.png) | DeferredFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Indicates a deferred Order |
 | DeferralReasonDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Reason for Deferral - Links to Deferral_Reason_DE.ID |
 | DeferralType | char(1) | 1 | NOT NULL | ('') | Temporary/Permanent Indicator (T or P) |
 | DeferralTimeInterval | smallint | 2 | NOT NULL | (0) | Deferral Time Value |
 | DeferralTimeUnits | char(1) | 1 | NOT NULL | ('') | Deferrral Time Unit Type |
 ![Check Constraints CK_Order_Item_Common_NeedToSchedApptFLAG_Yes_Or_No : ([NeedToSchedApptFLAG]='N' OR [NeedToSchedApptFLAG]='Y') Check Constraints CK_Order_Item_Common_NeedToSchedApptFLAG_Yes_Or_No : ([NeedToSchedApptFLAG]='N' OR [NeedToSchedApptFLAG]='Y')](../../../../Images/c-constraint.png) | NeedToSchedApptFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Indicates an appointment needs to be scheduled |
 | AuthorizedDTTM | datetime | 8 | NOT NULL | ('') | Datetime of Authorization |
(2) | OrderedDTTM | datetime | 8 | NOT NULL | ('') | Datetime Order was placed |
(3)![Check Constraints CK_Order_Item_Common_OverdueImportantFLAG_Yes_Or_No : ([OverdueImportantFLAG]='N' OR [OverdueImportantFLAG]='Y') Check Constraints CK_Order_Item_Common_OverdueImportantFLAG_Yes_Or_No : ([OverdueImportantFLAG]='N' OR [OverdueImportantFLAG]='Y')](../../../../Images/c-constraint.png) | OverdueImportantFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Overdue Important Indicator - Time sensitive order |
(3) | OverdueDTTM | datetime | 8 | NOT NULL | ('') | Overdue Datetime |
 | OrderingEncounterID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Encounter where order was placed - links to Encounter.ID |
 | CollectionEncounterID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Encounter where specimen was collected - links to Encounter.ID |
 | ToBeDoneBeforeEncounterID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Encounter which order must be completed before - links to Encounter.ID |
 | ScheduledForEncounterID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Encounter item is scheduled against - links to Encounter.ID |
 | PerformingEncounterID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Encounter where item was performed - links to Encounter.ID |
 | ReportedEncounterID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Encounter where item was reported - links to Encounter.ID |
 | ChargeEncounterID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Charge EncounterID for this item - links to Encounter.ID |
 | BillingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Billing Provider - Links to IDX_User.ID |
 | BillingLocationDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Billing Location - Links to Billing_Location_DE.ID |
 | PerformingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Performing Provider - Links to IDX_User.ID |
| TransitionedFromID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Transitioned From Parent ItemID - links to Item.ID |
| TransitionedToID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Transitioned To Parent ItemID - links to Item.ID |
| MissingAdditionalInfoFLAG | char(1) | 1 | NOT NULL | ('N') | Additional Information Missing Indicator |
 | ScheduleHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Schedule Header Identifier - links to Schedule_Header.ID |
(2) | ScheduledOrderParentID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Present if this is child order of a scheduled parent - links to Item_Plan.ID |
 | ScheduleID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Schedule Identifier - Links to Schedule.ID |
 | CreatedByID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | User that created the record - links to IDX_User.ID |
(2) | SiteDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Site Dictionary - Links to Site_DE.ID |
| WhenToChargeDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | WhenToCharge Dictionary - Links to When_To_Charge_DE.ID |
| CPT4Code | varchar(10) | 10 | NOT NULL | ('') | CPT4 Code for this item when it will not be billed |
 | OrderInstructions | varchar(2000) | 2000 | NOT NULL | ('') | Order Insturctions text as input by the user |
 | ReqPerfLocationDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Requested Performing Location - Links to Req_Perf_Location_DE.ID |
| ChargeCodeDEList | varchar(255) | 255 | NOT NULL | ('') | List of applicable charge codes - links to Charge_Code_DE.ID |
| RequestedFuzzyWhen | varchar(50) | 50 | NOT NULL | ('') | Requested Date (Fuzzy) |
| RequestedFuzzySpecificity | varchar(1) | 1 | NOT NULL | ('') | RequestedFuzzyWhen Date type Indicator (Fuzzy vs Actual Date) |
| RequestedFuzzySortAs | datetime | 8 | NOT NULL | ('') | Literal datetime to use when sorting this entry by FuzzyDate |
 ![Foreign Keys FK_Order_Item_Common_InjuryTypeDE_Injury_Type_DE_ID: [dbo].[Injury_Type_DE].InjuryTypeDE Foreign Keys FK_Order_Item_Common_InjuryTypeDE_Injury_Type_DE_ID: [dbo].[Injury_Type_DE].InjuryTypeDE](../../../../Images/fk.png) | InjuryTypeDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Special Billing reference - links to Injury_Type_DE.ID |
 | InjuryDTTM | datetime | 8 | NULL allowed | | Datetime of Injury |
 | InjuryAccountNumber | varchar(20) | 20 | NOT NULL | ('') | Injury Account Number (ex. For Worker's Compensation identifier) |
 | InjuryAccountDescription | varchar(255) | 255 | NOT NULL | ('') | Injury Account Description |
![Check Constraints CK_Order_Item_Common_HasBeenVerifiedOrAuthorizedFLAG_Yes_Or_No : ([HasBeenVerifiedOrAuthorizedFLAG]='N' OR [HasBeenVerifiedOrAuthorizedFLAG]='Y') Check Constraints CK_Order_Item_Common_HasBeenVerifiedOrAuthorizedFLAG_Yes_Or_No : ([HasBeenVerifiedOrAuthorizedFLAG]='N' OR [HasBeenVerifiedOrAuthorizedFLAG]='Y')](../../../../Images/c-constraint.png) | HasBeenVerifiedOrAuthorizedFLAG | [dbo].[BOOL] | 1 | NOT 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') Check Constraints CK_Order_Item_Common_ProceedDespiteDenialFLAG_Yes_Or_No : ([ProceedDespiteDenialFLAG]='N' OR [ProceedDespiteDenialFLAG]='Y')](../../../../Images/c-constraint.png) | ProceedDespiteDenialFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Denial Override Flag (Y/N) |
![Check Constraints CK_Order_Item_Common_HoldForActivationFLAG_Yes_Or_No : ([HoldForActivationFLAG]='N' OR [HoldForActivationFLAG]='Y') Check Constraints CK_Order_Item_Common_HoldForActivationFLAG_Yes_Or_No : ([HoldForActivationFLAG]='N' OR [HoldForActivationFLAG]='Y')](../../../../Images/c-constraint.png) | HoldForActivationFLAG | [dbo].[BOOL] | 1 | NOT 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') Check Constraints CK_Order_Item_Common_HasBeenSentToRPLFLAG_Yes_Or_No : ([HasBeenSentToRPLFLAG]='N' OR [HasBeenSentToRPLFLAG]='Y')](../../../../Images/c-constraint.png) | HasBeenSentToRPLFLAG | [dbo].[BOOL] | 1 | NOT 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') Check Constraints CK_Order_Item_Common_HasHadInboundInterfaceTrafficFLAG_Yes_Or_No : ([HasHadInboundInterfaceTrafficFLAG]='N' OR [HasHadInboundInterfaceTrafficFLAG]='Y')](../../../../Images/c-constraint.png) | HasHadInboundInterfaceTrafficFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Flag indicating this order was updated via Interface |
 | CarePlanTemplateID | [dbo].[dict_id] | 5 | NOT NULL | (0) | Order is assocaited with a Care Guide - Links to Careplan_Template.ID |
| OrderApptStatusDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Status indicator for the need for an appointment for this order - links to Order_Appt_Status_De.ID |
 | ManualOrderStatusReasonDECompletedList | varchar(255) | 255 | NOT NULL | ('') | List of completed actions on this order - Links to Order_Status_Reason_DE.ID |
 | ManualOrderStatusReasonDEIncompleteList | varchar(255) | 255 | NOT NULL | ('') | List of actions to be completed on this order - Links to Order_Status_Reason_DE.ID |
 | ParentOrderActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | ActivityHeaderID for Parent Order - links to Order_Activity_Header.ID |
| OrderPriorityDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Order Priority Level - links to Order_Priority_DE.ID |
 | ContainedInNAWHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Containing Note HeaderID - Links to Noteform_NAW_Instanace_Header.HeaderID |
 | ContainedInNAWInstanceID | [dbo].[uniqueid] | 9 | NOT 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') Check Constraints CK_Order_Item_Common_PrintReqFLAG_Yes_Or_No : ([PrintReqFLAG]='N' OR [PrintReqFLAG]='Y')](../../../../Images/c-constraint.png) | PrintReqFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Print Requisition FLAG - Used in Printing/AutoPrint default processing |
| OverdueInterval | smallint | 2 | NOT NULL | ((0)) | Numeric Overdue Interval value |
![Foreign Keys FK_Order_Item_Common_OverdueUnitsDE: [dbo].[HMP_Freq_Unit_DE].OverdueUnitsDE Foreign Keys FK_Order_Item_Common_OverdueUnitsDE: [dbo].[HMP_Freq_Unit_DE].OverdueUnitsDE](../../../../Images/fk.png) | OverdueUnitsDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Overdue Interval value unit - links to HMP_Freq_Unit_DE.ID |
 ![Foreign Keys FK_Order_Item_Common_VerificationEncounterID: [dbo].[Encounter].VerificationEncounterID Foreign Keys FK_Order_Item_Common_VerificationEncounterID: [dbo].[Encounter].VerificationEncounterID](../../../../Images/fk.png) | VerificationEncounterID | [dbo].[uniqueid] | 9 | NOT 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') Check Constraints CK_Order_Item_Common_GenerateNextInstance_Yes_Or_No : ([GenerateNextInstance]='N' OR [GenerateNextInstance]='Y')](../../../../Images/c-constraint.png) | GenerateNextInstance | [dbo].[BOOL] | 1 | NULL allowed | ('N') | Y/N flag to trigger new instance generation |
 | DeferredUntilDTTM | datetime | 8 | NULL allowed | | Datetime order is deferred until |
| DoneFuzzySortAS | datetime | 8 | NOT NULL | ('1/1/1900') | Datetime to use for sorting based on DoneFuzzyWhen |
| DoneFuzzySpecificity | char(1) | 1 | NOT NULL | ('D') | Idicates if the done datetime is a specific value or fuzzy |
| DoneFuzzyWhen | varchar(50) | 50 | NOT NULL | ('') | Fuzzy Order Done Datetime |
| OriginatingSiteDE | [dbo].[dict_id] | 5 | NULL allowed | | Site that order originated from - links to Site_De.ID |
| ABNDiagnosisCodes | varchar(255) | 255 | NULL allowed | | Advanced Benificiary Notice Diagnosis Codes |
| ABNICDCodeType | char(10) | 10 | NULL allowed | | ICD Code type name |
| OrderStatusReasonFreeText | varchar(50) | 50 | NOT NULL | ('') | Order Status Reason Free Text Field |
| OrderingProviderFreeText | varchar(255) | 255 | NULL allowed | ('') | Ordering Provider Free Text Field |