Tables [dbo].[Order_Activity]
Activity level table for Orders (Medication and Non-Medication orders)
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Indexes NIX_Order_Activity_CreateDTTM_INC_OrderActivityHeaderID_OrderType, NIX_Order_Activity_OrderActivityHeaderID, TWstat_Order_Activity_ApprovingProviderID_OrderActivityHeaderID, TWstat_Order_Activity_ClinicalDTTM_OrderActivityHeaderID, TWstat_Order_Activity_ClinicalSourceDE_OrderActivityHeaderID, TWstat_Order_Activity_CommunicationModeDE_OrderActivityHeaderID, TWstat_Order_Activity_financialAuthStatusDE_OrderActivityHeaderID, TWstat_Order_Activity_OnHoldStatusDE_OrderActivityHeaderID, TWstat_Order_Activity_OrderingProviderID_OrderActivityHeaderID, TWstat_Order_Activity_OrderMNStatus_OrderActivityHeaderID, TWstat_Order_Activity_OrderPriorityDE_OrderActivityHeaderID, TWstat_Order_Activity_OrderSourceDE_OrderActivityHeaderID, TWstat_Order_Activity_OrderStatusDE_OrderActivityHeaderID, TWstat_Order_Activity_OrderType_OrderActivityHeaderID, TWstat_Order_Activity_OrganizationID_OrderActivityHeaderID, TWstat_Order_Activity_WherePerformedDE_OrderActivityHeaderID, TWstat_Order_Activity_WhoDidItID_OrderActivityHeaderID(17)Foreign Keys FK_Order_Activity_OrderActivityHeaderID_Order_Activity_Header_ID: [dbo].[Order_Activity_Header].OrderActivityHeaderIDOrderActivityHeaderID[dbo].[uniqueid]9NOT NULLHeader. Link to Order_Activity_Header.ID
Indexes NIX_Order_Activity_OrderStatusDE_OrderActivityID_WithIncludes, TWstat_Order_Activity_OrganizationID_OrderActivityHeaderID(2)OrganizationIDnumeric(8,0)5NOT NULLOrganization. Link to Organization.ID
NoteTypeDE[dbo].[dict_id]5NOT NULLNote Type. Link to Note_Type_DE.ID. Always 0.
TemplateVersionsmallint2NOT NULLNote template version. Link to Note_Template_Version.TemplateVersion. Always 0.
Indexes TWstat_Order_Activity_OrderSourceDE_OrderActivityHeaderIDOrderSourceDE[dbo].[dict_id]5NOT NULL(0)Order Source. Link to order_source_de.ID
Indexes NIX_Order_Activity_OrderNumberEXT_OrderActivityID_INC_CreatedDTTMOrderNumberEXTvarchar(20)20NOT NULL(' ')External Order Number. This will be same as in Item_Result.OrderItemEXT.
Indexes XOrder_Activity_AccNumAccessionNumbervarchar(255)255NOT NULL(' ')Accession Number
WhoForID[dbo].[uniqueid]9NOT NULLWho it was entered for. Link to Provider.ID.
Indexes TWstat_Order_Activity_WhoDidItID_OrderActivityHeaderIDWhoDidItID[dbo].[uniqueid]9NOT NULLUser who entered. Link to IDX_User.ID
Indexes NIX_Order_Activity_CreateDTTM_INC_OrderActivityHeaderID_OrderType, NIX_Order_Activity_OrderNumberEXT_OrderActivityID_INC_CreatedDTTM(2)CreatedDTTMdatetime8NOT NULLDate and time when entry was created.
Check Constraints CK_Order_Activity_HasClinicalWarningFLAG_Yes_Or_No : ([HasClinicalWarningFLAG]='N' OR [HasClinicalWarningFLAG]='Y')HasClinicalWarningFLAG[dbo].[BOOL]1NOT NULL('N')No longer Used.
Indexes TWstat_Order_Activity_ClinicalDTTM_OrderActivityHeaderIDClinicalDTTMdatetime8NOT NULLClinical Date and Time
Indexes TWstat_Order_Activity_ClinicalSourceDE_OrderActivityHeaderIDClinicalSourceDE[dbo].[dict_id]5NOT NULLClinical Source. Link to Source_DE.ID
Indexes NIX_Order_Activity_OrderStatusDE_OrderActivityID_WithIncludes, TWstat_Order_Activity_OrderingProviderID_OrderActivityHeaderID(2)OrderingProviderID[dbo].[uniqueid]9NOT NULLOrdering Provider. Link to Provider.ID
Indexes NIX_Order_Activity_OrderStatusDE_OrderActivityID_WithIncludes, TWstat_Order_Activity_OrderStatusDE_OrderActivityHeaderID(2)OrderStatusDE[dbo].[dict_id]5NOT NULLStatus. Link to Order_Status_DE.ID
Indexes NIX_Order_Activity_OrderStatusDE_OrderActivityID_WithIncludes, TWstat_Order_Activity_OrderPriorityDE_OrderActivityHeaderID(2)OrderPriorityDE[dbo].[dict_id]5NULL allowedPriority. Link to Clinical_Priority_DE.ID
Indexes TWstat_Order_Activity_CommunicationModeDE_OrderActivityHeaderIDCommunicationModeDE[dbo].[dict_id]5NULL allowedCommunication Method. Link to Communication_Method_DE.ID
Indexes TWstat_Order_Activity_WherePerformedDE_OrderActivityHeaderIDWherePerformedDE[dbo].[dict_id]5NULL allowedRequested Performing Location. Link to Req_Perf_Location_DE.ID. This is not where it was performed but where it was requested to be performed.
Indexes NIX_Order_Activity_OrderStatusDE_OrderActivityID_WithIncludes, TWstat_Order_Activity_ApprovingProviderID_OrderActivityHeaderID(2)ApprovingProviderID[dbo].[uniqueid]9NULL allowedSupervising (approving) provider. Link to Provider.ID
OrderCommentvarchar(255)255NULL allowedOrder Comment.
Provider1toNotifyID[dbo].[uniqueid]9NULL allowedProvider to Notify. No longer used.
Provider2toNotifyID[dbo].[uniqueid]9NULL allowedProvider to Notify. No longer used.
Provider3toNotifyID[dbo].[uniqueid]9NULL allowedProvider to Notify. No longer used.
RequestedFuzzyWhenvarchar(50)50NULL allowedTo be done date
RequestedFuzzySpecificityvarchar(1)1NULL allowedSpecificity of the to be done date:
D - Day
M - Month
Y - Year
F - Freetext
RequestedFuzzySortAsvarchar(50)50NULL allowedSpecific date and time for the to be done date.
Indexes NIX_Order_Activity_CreateDTTM_INC_OrderActivityHeaderID_OrderType, TWstat_Order_Activity_OrderType_OrderActivityHeaderID(2)OrderTypevarchar(1)1NOT NULLType of order(Lab -L , Imageing -X, Diagnostic - D, FollowUp - U, Referral -R, Finding -F, Precaution -P, Instruction -I)
ContactNamevarchar(50)50NULL allowedNo longer used.
ContactPhonevarchar(50)50NULL allowedNo longer used.
Historyvarchar(250)250NULL allowedNo longer used.
ExternalStatusvarchar(255)255NULL allowedNo longer used.
ScheduledForPart1varchar(255)255NULL allowedNo longer used.
ScheduledForPart2varchar(255)255NULL allowedNo longer used.
Resourcesvarchar(255)255NULL allowedNo longer used.
Indexes TWstat_Order_Activity_ManualStatusChangeFLAGCheck Constraints CK_Order_Activity_ManualStatusChangeFLAG_Yes_Or_No : ([ManualStatusChangeFLAG]='N' OR [ManualStatusChangeFLAG]='Y')ManualStatusChangeFLAG[dbo].[BOOL]1NULL allowedThe user manually set the status (Y/N)
NoteHeaderID[dbo].[uniqueid]9NOT NULL(0)Audit note header. Link to Act_hdr_note.ID
NoteActivityID[dbo].[uniqueid]9NOT NULL(0)Audit note version. Link to Act_Note.ID
Indexes TWstat_Order_Activity_financialAuthStatusDE_OrderActivityHeaderIDfinancialAuthStatusDE[dbo].[dict_id]5NOT NULL(0)Financial authorization status. Link to financial_Auth_Status_DE.ID.
Indexes TWstat_Order_Activity_OnHoldStatusDE_OrderActivityHeaderIDForeign Keys FK_OA_OnHold_Status_DE: [dbo].[OnHold_Status_DE].OnHoldStatusDEOnHoldStatusDE[dbo].[dict_id]5NOT NULL(0)On hole status, Link to OnHold_Status_DE.ID
Indexes TWstat_Order_Activity_OrderMNStatus_OrderActivityHeaderIDForeign Keys FK_OA_Charge_Status_DE: [dbo].[Charge_Status_DE].OrderMNStatusOrderMNStatus[dbo].[dict_id]5NOT NULL(0)Medical Necessity status. Link to Charge_Status_DE.ID
Cluster Primary Key PK_Order_Activity_OrderActivityID: OrderActivityIDIndexes NIX_Order_Activity_OrderNumberEXT_OrderActivityID_INC_CreatedDTTM, NIX_Order_Activity_OrderStatusDE_OrderActivityID_WithIncludes(2)OrderActivityID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Order_Activity table