Schedule

Data Element	Data Type	What is it	Mandatory
Id	Integer	The unique identifier of the record	No
Name	VarChar	Human readable name for a repeating period that can be used to identify it	Yes
StartDate	Date	The date the repeating period starts	Yes
StartTime	Time	The time the repeating period starts	Yes
EndTime	Time	The time the repeating period ends	Yes
RepeatType	Integer	0: none 1: daily 2: weekly 3: monthly 4: yearly	No
RepeatEvery	Integer	Number of times this schedule repeats	No
WeeklyOnDays	VarChar	Indicates which days of the week to repeat on	No
MonthlyOnDates	VarChar	Indicates which date of the month to repeat on	No
MonthlyOnDays	VarChar	Indicates which day of the month to repeat on	No
EndDate	Date	The date the repeating period ends	No
Exception	VarChar	Where the repeating period does not apply - only public holidays supported as exceptions currently	No
Saved	Bit		No
Orm	VarChar	The related object	No
Template	Bit	Is a saved template being used	No
Creator	Integer	The identifier of the user who created the record	No
Created	DateTime	When the record was originally created	No
Modified	DateTime	The last time the record was modified	No