Table: AnalyticsSourcePersonHistorical

Database schema and system attributes for AnalyticsSourcePersonHistorical.


Age

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

AnniversaryDate

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

BackgroundCheckDate

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

BackgroundChecked

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

BaptismDate

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

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: int
  • Property Values:
    • MaxLength = 4

BirthYear

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

ConnectionStatusValueId

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

core_CurrentlyAnEra

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

core_EraFirstGave

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

core_EraLastGave

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

core_EraStartDate

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

core_EraTimesGiven52Wks

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: decimal
  • Property Values:
    • MaxLength = 17

core_EraTimesGiven6Wks

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: decimal
  • Property Values:
    • MaxLength = 17

core_TimesCheckedIn16Wks

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: decimal
  • Property Values:
    • MaxLength = 17

Count

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

CurrentRowIndicator

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

EffectiveDate

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

Email

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

EmailPreference

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

Employer

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

ExpireDate

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

FirstName

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

FirstVisit

  • 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

Gender

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

GivingGroupId

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

GivingId

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

GivingLeaderId

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

GraduationYear

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

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

InactiveReasonNote

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

IsDeceased

  • Required Property: true
  • 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

MaritalStatusValueId

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

MiddleName

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

NickName

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

PersonId

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

PhotoId

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

PrimaryFamilyId

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

RecordStatusLastModifiedDateTime

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

RecordStatusReasonValueId

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

RecordStatusValueId

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

RecordTypeValueId

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

ReviewReasonNote

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

ReviewReasonValueId

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

SecondVisit

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

SuffixValueId

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

SystemNote

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

TitleValueId

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

ViewedCount

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