Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
  | ID | [dbo].[uniqueid] | 9 | NOT NULL | Key to the Schedule table |
 ![Foreign Keys FK_Schedule_Schedule_Header: [dbo].[Schedule_Header].ScheduleHeaderID Foreign Keys FK_Schedule_Schedule_Header: [dbo].[Schedule_Header].ScheduleHeaderID](../../../../Images/fk.png) | ScheduleHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | Header. Link to Schedule_Header.ID |
 | CreateDTTM | datetime | 8 | NOT NULL | Date the Schedule was created |
 | LastUpdatedByID | [dbo].[uniqueid] | 9 | NOT NULL | The User ID that last Updated the schedule |
 | LastUpdatedDTTM | datetime | 8 | NULL allowed | The Date the schedule was last updated |
 | ScheduleDescription | varchar(255) | 255 | NULL allowed | Description of the Schedule |
 | ScheduleMode | char(1) | 1 | NOT NULL | The Mode for the schedule D - By Dates, R- Recurring, A - Age Based, P - As needed |
 | ScheduleDates | varchar(max) | max | NULL allowed | The date(s) for the schedule. Used for Mode = D |
 | AgeBasedPattern | varchar(255) | 255 | NULL allowed | Age Based Pattern. Used with Mode = A (i.e. M^12|Y^3,4 = Age Month 12 and Year 3 and 4) |
 | RecurrenceMode | char(1) | 1 | NULL allowed | Recurrence Mode - What time frame it recurs (i.e. Y - yearly, M - Monthly, W - Weekly etc) |
 | RecurrenceNumber | smallint | 2 | NULL allowed | How often the recurrence happens based on Mode (i.e M 2 - Every 2 months) |
 ![Check Constraints CK_Schedule_EveryWeekdayFLAG_Yes_Or_No : ([EveryWeekdayFLAG]='N' OR [EveryWeekdayFLAG]='Y') Check Constraints CK_Schedule_EveryWeekdayFLAG_Yes_Or_No : ([EveryWeekdayFLAG]='N' OR [EveryWeekdayFLAG]='Y')](../../../../Images/c-constraint.png) | EveryWeekdayFLAG | [dbo].[BOOL] | 1 | NOT NULL | Whether this recurrences happens Every Week Day Monday thru Friday (Y/N) |
 | DaysOfWeek | varchar(20) | 20 | NULL allowed | What days of the week for a Weekly Schedule (i.e. W - Wednesday, W,F - Wednesday and Friday etc.) |
 | DaysOfMonth | varchar(255) | 255 | NULL allowed | The Day of the Month for the recurrence to happen for a Monthly Mode |
 | DayRanking | varchar(10) | 10 | NULL allowed | Ranking used with Monthly Mode (i.e. First, Second, Third, Forth or Last Day of week selected for the number of Months) |
 | Months | varchar(255) | 255 | NULL allowed | Month name the recurrence should take place (i.e Y - Yearly on the First M - Monday of March) |
| StartDate | datetime | 8 | NULL allowed | Starting date of Occurrences |
 | EndDate | datetime | 8 | NULL allowed | Ending date of Occurrences |
 | MaxOccurrences | smallint | 2 | NULL allowed | Number of Occurences to End after instead of an End Date |