Information for the AttendanceOccurrence
Columns
Id
(datatype: int) Required Primary Key
GroupId
(datatype: int) Required Primary Key
LocationId
(datatype: int) Required Primary Key
ScheduleId
(datatype: int) Required Primary Key
OccurrenceDate
(datatype: date) Required Primary Key
DidNotOccur
(datatype: bit) Required Primary Key
CreatedDateTime
(datatype: datetime) Required Primary Key
ModifiedDateTime
(datatype: datetime) Required Primary Key
CreatedByPersonAliasId
(datatype: int) Required Primary Key
ModifiedByPersonAliasId
(datatype: int) Required Primary Key
Guid
(datatype: uniqueidentifier) Required Primary Key
ForeignId
(datatype: int) Required Primary Key
ForeignGuid
(datatype: uniqueidentifier) Required Primary Key
ForeignKey
(datatype: nvarchar(100)) Required Primary Key
Notes
(datatype: nvarchar(max)) Required Primary Key
AnonymousAttendanceCount
(datatype: int) Required Primary Key
StepTypeId
(datatype: int) Required Primary Key
AcceptConfirmationMessage
(datatype: nvarchar(max)) Required Primary Key
DeclineConfirmationMessage
(datatype: nvarchar(max)) Required Primary Key
ShowDeclineReasons
(datatype: bit) Required Primary Key
DeclineReasonValueIds
(datatype: nvarchar(250)) Required Primary Key
SundayDate
(datatype: date) Required Primary Key
Name
(datatype: nvarchar(250)) Required Primary Key
OccurrenceDateKey
(datatype: int) Required Primary Key
AttendanceTypeValueId
(datatype: int) Required Primary Key
AttendanceReminderLastSentDateTime
(datatype: datetime) Required Primary Key