Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ENABLED bit   Default = 1
 TYPECODE tinyint   Default = 1
 TYPE nvarchar(16) (Computed) CASE [TYPECODE] WHEN 1 THEN N'Once' WHEN 4 THEN N'Daily' WHEN 8 THEN N'Weekly' WHEN 16 THEN N'Monthly' WHEN 32 THEN N'MonthlyRelative' WHEN 64 THEN N'Annually' WHEN 128 THEN N'AnnuallyRelative' END
 FREQUENCY tinyint   Default = 0
 SUBDAYFREQUENCYTYPECODE tinyint   Default = 0
 SUBDAYFREQUENCYTYPE nvarchar(8) (Computed) CASE [SUBDAYFREQUENCYTYPECODE] WHEN 0 THEN N'None' WHEN 2 THEN N'Secondly' WHEN 4 THEN N'Minutely' WHEN 8 THEN N'Hourly' END
 TIME time
 SUBDAYFREQUENCY tinyint   Default = 0
 SUBDAYSTARTINGTIME time
 SUBDAYENDINGTIME time
 DAYSOFWEEK tinyint   Default = 0
 DAYOFMONTH tinyint   Default = 0
 WEEKCODE tinyint   Default = 0
 WEEK nvarchar(6) (Computed) CASE [WEEKCODE] WHEN 0 THEN N'None' WHEN 1 THEN N'First' WHEN 2 THEN N'Second' WHEN 3 THEN N'Third' WHEN 4 THEN N'Fourth' WHEN 5 THEN N'Last' END
 DAYOFWEEKCODE tinyint   Default = 0
 DAYOFWEEK nvarchar(11) (Computed) CASE [DAYOFWEEKCODE] WHEN 0 THEN N'None' WHEN 1 THEN N'Sunday' WHEN 2 THEN N'Monday' WHEN 3 THEN N'Tuesday' WHEN 4 THEN N'Wednesday' WHEN 5 THEN N'Thursday' WHEN 6 THEN N'Friday' WHEN 7 THEN N'Saturday' WHEN 8 THEN N'Day' WHEN 9 THEN N'Weekday' WHEN 10 THEN N'Weekend day' END
 MONTHCODE tinyint   Default = 0
 MONTH nvarchar(9) (Computed) CASE [MONTHCODE] WHEN 0 THEN N'None' WHEN 1 THEN N'January' WHEN 2 THEN N'February' WHEN 3 THEN N'March' WHEN 4 THEN N'April' WHEN 5 THEN N'May' WHEN 6 THEN N'June' WHEN 7 THEN N'July' WHEN 8 THEN N'August' WHEN 9 THEN N'September' WHEN 10 THEN N'October' WHEN 11 THEN N'November' WHEN 12 THEN N'December' END
 STARTDATE date  
 ENDDATE date
 LASTRUNTIME datetime

Index Name Field(s) Unique Primary Clustered
 IX_SCHEDULE_ENABLED_ENDDATE_STARTDATE ENABLED, ENDDATE, STARTDATE      
 PK_SCHEDULE ID  

Referenced by Field
 BUSINESSPROCESSSCHEDULE SCHEDULEID

Entity-Relationship diagram of this table