Tables [dbo].[Schedule_Header]
Header records for Scheduled Orders
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Primary Key PK_NIX_Schedule_Header_ID: IDCluster Key CIX_Sch_Hdr_ID_CurrentScheduleID: ID\CurrentScheduleIDID[dbo].[uniqueid]9NOT NULLKey to the Schedule_Header table
Cluster Key CIX_Sch_Hdr_ID_CurrentScheduleID: ID\CurrentScheduleIDCurrentScheduleID[dbo].[uniqueid]9NOT NULLThe Current Schedule ID. Link to Schedule.ID
ActivityHeaderID[dbo].[uniqueid]9NOT NULLThe ID for the Activity Header associated with this schedule. i.e Order_Activity_Header.ID
Check Constraints CKSchedHdrActivityType : ([ActivityType]='IM' OR [ActivityType]='Order' OR [ActivityType]='HM')ActivityTypevarchar(10)10NOT NULLThe Activity Type. IM or Order or HM
Indexes NIX_schedule_header_PatientIDForeign Keys FK_Schedule_Header_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLThe patient ID associated with the scheduled Order. Link to Person.ID
Indexes TWstat_Schedule_Header_OIDDEOIDDE[dbo].[dict_id]5NOT NULLOrderable Item ID. HM,IM,ME - Medication_DE.ID, PL - QO_Classification_DE.ID
Check Constraints CK_Schedule_Header_OIDType : ([OIDType]='M' OR [OIDType]='O' OR [OIDType]='F')OIDTypechar(1)1NOT NULLThe Order type.  M or O or F
ItemTypechar(2)2NULL allowedThe Order Item Type. HM, IM, PL,ME