Tables [dbo].[Schedule]
Data associated with the schedules for Scheduled Orders.
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Primary Key PK_NIX_Schedule_ID: IDCluster Key CIX_Schedule_SchHdrID_ID: ScheduleHeaderID\IDID[dbo].[uniqueid]9NOT NULLKey to the Schedule table
Cluster Key CIX_Schedule_SchHdrID_ID: ScheduleHeaderID\IDForeign Keys FK_Schedule_Schedule_Header: [dbo].[Schedule_Header].ScheduleHeaderIDScheduleHeaderID[dbo].[uniqueid]9NOT NULLHeader. Link to Schedule_Header.ID
Indexes TWstat_Schedule_CreateDTTMCreateDTTMdatetime8NOT NULLDate the Schedule was created
Indexes TWstat_Schedule_LastUpdatedByIDLastUpdatedByID[dbo].[uniqueid]9NOT NULLThe User ID that last Updated the schedule
Indexes TWstat_Schedule_LastUpdatedDTTMLastUpdatedDTTMdatetime8NULL allowedThe Date the schedule was last updated
Indexes TWstat_Schedule_ScheduleDescriptionScheduleDescriptionvarchar(255)255NULL allowedDescription of the Schedule
Indexes TWstat_Schedule_ScheduleModeScheduleModechar(1)1NOT NULLThe Mode for the schedule D - By Dates, R- Recurring, A - Age Based, P - As needed
Indexes TWstat_Schedule_ScheduleDatesScheduleDatesvarchar(max)maxNULL allowedThe date(s) for the schedule. Used for Mode = D
Indexes TWstat_Schedule_AgeBasedPatternAgeBasedPatternvarchar(255)255NULL allowedAge Based Pattern. Used with Mode = A (i.e. M^12|Y^3,4 = Age Month 12 and Year 3 and 4)
Indexes TWstat_Schedule_RecurrenceModeRecurrenceModechar(1)1NULL allowedRecurrence Mode - What time frame it recurs (i.e. Y - yearly, M - Monthly, W - Weekly etc)
Indexes TWstat_Schedule_RecurrenceNumberRecurrenceNumbersmallint2NULL allowedHow often the recurrence happens based on Mode (i.e M 2 - Every 2 months)
Indexes TWstat_Schedule_EveryWeekdayFLAGCheck Constraints CK_Schedule_EveryWeekdayFLAG_Yes_Or_No : ([EveryWeekdayFLAG]='N' OR [EveryWeekdayFLAG]='Y')EveryWeekdayFLAG[dbo].[BOOL]1NOT NULLWhether this recurrences happens Every Week Day Monday thru Friday (Y/N)
Indexes TWstat_Schedule_DaysOfWeekDaysOfWeekvarchar(20)20NULL allowedWhat days of the week for a Weekly Schedule (i.e. W - Wednesday, W,F - Wednesday and Friday etc.)
Indexes TWstat_Schedule_DaysOfMonthDaysOfMonthvarchar(255)255NULL allowedThe Day of the Month for the recurrence to happen for a Monthly Mode
Indexes TWstat_Schedule_DayRankingDayRankingvarchar(10)10NULL allowedRanking used with Monthly Mode (i.e. First, Second, Third, Forth or Last Day of week selected for the number of Months)
Indexes TWstat_Schedule_MonthsMonthsvarchar(255)255NULL allowedMonth name the recurrence should take place (i.e Y - Yearly on the First M - Monday of March)
StartDatedatetime8NULL allowedStarting date of Occurrences
Indexes TWstat_Schedule_EndDateEndDatedatetime8NULL allowedEnding date of Occurrences
Indexes TWstat_Schedule_MaxOccurrencesMaxOccurrencessmallint2NULL allowedNumber of Occurences to End after instead of an End Date