Table: Attendance

Database schema and system attributes for Attendance.

---

AttendanceCheckInSessionId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

AttendanceCodeId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

CampusId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

CheckedInByPersonAliasId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

CheckedOutByPersonAliasId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

CheckInStatus

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

CreatedByPersonAliasId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

CreatedDateTime

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: datetime
• Property Values:
  • MaxLength = 8

DeclineReasonValueId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

DeviceId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

DidAttend

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: bit
• Property Values:
  • MaxLength = 1

EndDateTime

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: datetime
• Property Values:
  • MaxLength = 8

ForeignGuid

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: uniqueidentifier
• Property Values:
  • MaxLength = 16

ForeignId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

ForeignKey

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = 200

Guid

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: uniqueidentifier
• Property Values:
  • MaxLength = 16

Id

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

IsFirstTime

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: bit
• Property Values:
  • MaxLength = 1

ModifiedByPersonAliasId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

ModifiedDateTime

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: datetime
• Property Values:
  • MaxLength = 8

Note

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = -1

OccurrenceId

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

PersonAliasId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

PresentByPersonAliasId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

PresentDateTime

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: datetime
• Property Values:
  • MaxLength = 8

Processed

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: bit
• Property Values:
  • MaxLength = 1

QualifierValueId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

RequestedToAttend

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: bit
• Property Values:
  • MaxLength = 1

RSVP

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

RSVPDateTime

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: datetime
• Property Values:
  • MaxLength = 8

ScheduleConfirmationSent

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: bit
• Property Values:
  • MaxLength = 1

ScheduledByPersonAliasId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

ScheduledToAttend

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: bit
• Property Values:
  • MaxLength = 1

ScheduleReminderSent

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: bit
• Property Values:
  • MaxLength = 1

SearchResultGroupId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

SearchTypeValueId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

SearchValue

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = -1

SourceValueId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

StartDateTime

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: datetime
• Property Values:
  • MaxLength = 8