Information for the Attendance

Columns

• Id (datatype: int) Required Primary Key
• DeviceId (datatype: int) Required Primary Key
• SearchTypeValueId (datatype: int) Required Primary Key
• AttendanceCodeId (datatype: int) Required Primary Key
• QualifierValueId (datatype: int) Required Primary Key
• StartDateTime (datatype: datetime) Required Primary Key
• EndDateTime (datatype: datetime) Required Primary Key
• DidAttend (datatype: bit) Required Primary Key
• Note (datatype: nvarchar(max)) Required Primary Key
• Guid (datatype: uniqueidentifier) 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
• ForeignKey (datatype: nvarchar(100)) Required Primary Key
• CampusId (datatype: int) Required Primary Key
• PersonAliasId (datatype: int) Required Primary Key
• RSVP (datatype: int) Required Primary Key
• Processed (datatype: bit) Required Primary Key
• ForeignGuid (datatype: uniqueidentifier) Required Primary Key
• ForeignId (datatype: int) Required Primary Key
• SearchValue (datatype: nvarchar(max)) Required Primary Key
• SearchResultGroupId (datatype: int) Required Primary Key
• OccurrenceId (datatype: int) Required Primary Key
• CheckedInByPersonAliasId (datatype: int) Required Primary Key
• ScheduledToAttend (datatype: bit) Required Primary Key
• RequestedToAttend (datatype: bit) Required Primary Key
• ScheduleConfirmationSent (datatype: bit) Required Primary Key
• ScheduleReminderSent (datatype: bit) Required Primary Key
• RSVPDateTime (datatype: datetime) Required Primary Key
• DeclineReasonValueId (datatype: int) Required Primary Key
• ScheduledByPersonAliasId (datatype: int) Required Primary Key
• AttendanceCheckInSessionId (datatype: int) Required Primary Key
• PresentDateTime (datatype: datetime) Required Primary Key
• PresentByPersonAliasId (datatype: int) Required Primary Key
• CheckedOutByPersonAliasId (datatype: int) Required Primary Key
• IsFirstTime (datatype: bit) Required Primary Key
• CheckInStatus (datatype: int) Required Primary Key