Touchworks 25.3
[dbo].[Order_Item_Common]
General Order Instance Data
| Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | 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')](../../../../Images/c-constraint.png "Check Constraints CK_Order_Item_Common_ReportedOrderFLAG_Yes_Or_No : ([ReportedOrderFLAG]='N' OR [ReportedOrderFLAG]='Y')") | ReportedOrderFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Indicates an item that was recorded as history | |
| 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 | ||
| NeedToSchedApptFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Indicates an appointment needs to be scheduled | |
| AuthorizedDTTM | datetime | 8 | NOT NULL | ('') | Datetime of Authorization | ||
| OrderedDTTM | datetime | 8 | NOT NULL | ('') | Datetime Order was placed | |
| (2) | 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 | ||
| 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](../../../../Images/fk.png "Foreign Keys FK_Order_Item_Common_InjuryTypeDE_Injury_Type_DE_ID: [dbo].[Injury_Type_DE].InjuryTypeDE") | 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 | ||
| HasBeenVerifiedOrAuthorizedFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Flag indicating that the item has been Verified or Authorized | |
| ProceedDespiteDenialFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Denial Override Flag (Y/N) | |
| HoldForActivationFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Hold Order for Activation by user (Y/N) | |
| HasBeenSentToRPLFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Order has been sent to the Requested Performing Location FLAG (Y/N) | |
| 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 | ||
| 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 | ||
| OverdueUnitsDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Overdue Interval value unit - links to HMP_Freq_Unit_DE.ID | |
| VerificationEncounterID | [dbo].[uniqueid] | 9 | NOT NULL | ((0)) | EncounterID where verification occurred - links to Encounter.ID | |
| 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 | ||
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | Key to the Order_Item_Common table |