Information for the AnalyticsSourceAttendance
Columns
Id
(datatype: int) Required Primary Key
AttendanceId
(datatype: int) Required Primary Key
AttendanceDateKey
(datatype: int) Required Primary Key
AttendanceTypeId
(datatype: int) Required Primary Key
DaysSinceLastAttendanceOfType
(datatype: int) Required Primary Key
IsFirstAttendanceOfType
(datatype: bit) Required Primary Key
Count
(datatype: int) Required Primary Key
PersonKey
(datatype: int) Required Primary Key
CurrentPersonKey
(datatype: int) Required Primary Key
LocationId
(datatype: int) Required Primary Key
CampusId
(datatype: int) Required Primary Key
ScheduleId
(datatype: int) Required Primary Key
GroupId
(datatype: int) Required Primary Key
PersonAliasId
(datatype: int) Required Primary Key
DeviceId
(datatype: int) Required Primary Key
SearchTypeName
(datatype: nvarchar(max)) Required Primary Key
StartDateTime
(datatype: datetime) Required Primary Key
EndDateTime
(datatype: datetime) Required Primary Key
RSVP
(datatype: int) Required Primary Key
DidAttend
(datatype: bit) Required Primary Key
Note
(datatype: nvarchar(max)) Required Primary Key
SundayDate
(datatype: date) 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