Tables [dbo].[Order_Activity_Header]
Activity Header table for Medication and Non-Medication orders
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_Order_Activity_Header_ID: IDIndexes NIX_Order_Activity_Header_ID_CurrentOrderActivityIDID[dbo].[uniqueid]9NOT NULLKey to the Order_Activity_Header table
Cluster Key XAK1Order_Activity_Header: PatientID\EncounterIDIndexes TWstat_Order_Activity_Header_ActivityTypeDE_PatientID_EncounterIDForeign Keys FK_Order_Activity_Header_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
Indexes NIX_Order_Activity_Header_ID_CurrentOrderActivityID, TWstat_Order_Activity_Header_VisitID(2)VisitID[dbo].[uniqueid]9NOT NULLVisit. Link to Visit.ID.
CreateDTTMdatetime8NOT NULLDate/Time that the entry was added/created
Check Constraints CK_Order_Activity_Header_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')HasSecurityFLAG[dbo].[BOOL]1NOT NULLSecurity (Y/N). No longer used.
Indexes TWstat_Order_Activity_Header_ActivityTypeActivityTypevarchar(10)10NOT NULLActivity Type (Order)
Cluster Key XAK1Order_Activity_Header: PatientID\EncounterIDIndexes XOrd_Act_Hdr_EncID, TWstat_Order_Activity_Header_ActivityTypeDE_PatientID_EncounterID(2)EncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
ParentID[dbo].[uniqueid]9NOT NULLParent. No longer used.
Indexes TWstat_Order_Activity_Header_ActivityTypeDE_PatientID_EncounterIDActivityTypeDE[dbo].[dict_id]5NOT NULLActivity Type. Link to Activity_Type_DE.ID
CMSVersionsmallint2NOT NULLCMS Version. Currently 4.
Indexes NIX_Order_Activity_Header_CurrentOrderActivityID, NIX_Order_Activity_Header_ID_CurrentOrderActivityID(2)CurrentOrderActivityID[dbo].[uniqueid]9NOT NULL(0)Current Activity row. Link to Order_Activity.OrderActivityID.