Table: InsightPerson

Database schema and system attributes for InsightPerson.

Age

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

AgeBracket

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

AgeClassification

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

AnniversaryDate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: date
  • Property Values:
    • MaxLength = 3

AnniversaryDateKey

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

BackgroundCheckActive

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

BackgroundCheckExpireDate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: date
  • Property Values:
    • MaxLength = 3

BackgroundCheckExpireDateKey

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

BaptismDate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: date
  • Property Values:
    • MaxLength = 3

BaptismDateKey

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

BaptizedByOrganization

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

BaptizedFlag

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

BirthDate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: date
  • Property Values:
    • MaxLength = 3

BirthDateKey

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

BirthDay

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

BirthMonth

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

BirthYear

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

Campus

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

CampusId

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

ChildCount

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

ConnectionStatus

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

Email

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

EmailPreference

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

EraCurrent

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

EraEndDate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: date
  • Property Values:
    • MaxLength = 3

EraStartDate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: date
  • Property Values:
    • MaxLength = 3

Ethnicity

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

FirstName

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

Gender

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

GenderIsFemale

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

GenderIsMale

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

GivingId

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

GraduationYear

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

GroupTypesActive

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

HasChildren

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

HomeAddressCity

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

HomeAddressCountry

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

HomeAddressGeoPoint

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

HomeAddressPostalCode

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

HomeAddressState

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

HomeAddressStreet1

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

HomeAddressStreet2

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

HouseholdCount

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

HouseholdName

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

HouseholdNameAbbreviated

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

HouseholdNameFull

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

InactiveReasonNote

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

IsDeceased

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

LastName

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

MaritalStatus

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

MaritalStatusIsMarried

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

MobilePhoneMessagingEnabled

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

MobilePhoneNumber

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

NavigationUrl

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

NickName

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

NoteRecentSummary

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

PersonId

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

PhotoAvatarUrl

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

PhotoBinaryFileId

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

PhotoUrl

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

PrayedCountLask6Weeks

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

PrayedCountLast12Months

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

PrayedCountLast12Weeks

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

PrayedCountPrevious12Months

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

PrayedCountPrevious12Weeks

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

PrayedCountPrevious6Weeks

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

PrayedCountTotal

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

PrayerRequestCountLast12Months

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

PrayerRequestCountLast12Weeks

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

PrayerRequestCountLast6Weeks

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

PrayerRequestCountPrevious12Months

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

PrayerRequestCountPrevious12Weeks

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

PrayerRequestCountPrevious6Weeks

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

PrayerRequestRecentSummary

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

PrimaryFamilyId

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

PrimaryPersonAliasId

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

Race

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

RecordCreatedDateTime

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

RecordModifiedDateTime

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

RecordSource

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

RecordStatus

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

RecordStatusReason

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

RecordType

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

RecordViewCount

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

RowCount

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

Serve12WeekCount

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

Serve12WeekPreviousCount

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

Serve52WeekCount

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

Serve52WeekPreviousCount

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

Serve6WeekCount

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

Serve6WeekPreviousCount

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

ServeFirstDate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: date
  • Property Values:
    • MaxLength = 3

ServeFirstDateKey

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

ServeFirstSundayDate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: date
  • Property Values:
    • MaxLength = 3

ServeFirstSundayDateKey

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

ServeFrequencyDeviationInDays

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

ServeFrequencyInDays

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

ServeHistoryJson

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

ServeLastDate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: date
  • Property Values:
    • MaxLength = 3

ServeLastDateKey

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

ServeLastSundayDate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: date
  • Property Values:
    • MaxLength = 3

ServeLastSundayDateKey

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

ServingCurrently

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

SmallGroupIsLeader

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

SmallGroupParticipationActive

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

SpouseName

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

SpousePersonId

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

Suffix

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

SystemNote

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

Tags

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

Title

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

WeekendAttendanceCount

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

WeekendAttendanceFirstDate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: date
  • Property Values:
    • MaxLength = 3

WeekendAttendanceFirstDateKey

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

WeekendAttendanceFirstSundayDate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: date
  • Property Values:
    • MaxLength = 3

WeekendAttendanceFirstSundayDateKey

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

WeekendAttendanceHistoryJson

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

WeekendAttendanceLast12Months

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

WeekendAttendanceLast12Weeks

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

WeekendAttendanceLast6Weeks

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

WeekendAttendanceLastDate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: date
  • Property Values:
    • MaxLength = 3

WeekendAttendanceLastDateKey

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

WeekendAttendanceLastSundayDate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: date
  • Property Values:
    • MaxLength = 3

WeekendAttendanceLastSundayDateKey

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

WeekendAttendancePrevious12Months

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

WeekendAttendancePrevious12Weeks

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

WeekendAttendancePrevious6Weeks

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

WiredForPurposeKey

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