Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
  | ID | [dbo].[uniqueid] | 9 | NOT NULL | Key to the Schedule_Header table |
 | CurrentScheduleID | [dbo].[uniqueid] | 9 | NOT NULL | The Current Schedule ID. Link to Schedule.ID |
| ActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | The 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') Check Constraints CKSchedHdrActivityType : ([ActivityType]='IM' OR [ActivityType]='Order' OR [ActivityType]='HM')](../../../../Images/c-constraint.png) | ActivityType | varchar(10) | 10 | NOT NULL | The Activity Type. IM or Order or HM |
 ![Foreign Keys FK_Schedule_Header_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Schedule_Header_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | The patient ID associated with the scheduled Order. Link to Person.ID |
 | OIDDE | [dbo].[dict_id] | 5 | NOT NULL | Orderable 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') Check Constraints CK_Schedule_Header_OIDType : ([OIDType]='M' OR [OIDType]='O' OR [OIDType]='F')](../../../../Images/c-constraint.png) | OIDType | char(1) | 1 | NOT NULL | The Order type. M or O or F |
| ItemType | char(2) | 2 | NULL allowed | The Order Item Type. HM, IM, PL,ME |