Information for the AnalyticsSourcePersonHistorical

Columns

• Id (datatype: int) Required Primary Key
• PersonId (datatype: int) Required Primary Key
• CurrentRowIndicator (datatype: bit) Required Primary Key
• EffectiveDate (datatype: date) Required Primary Key
• ExpireDate (datatype: date) Required Primary Key
• PrimaryFamilyId (datatype: int) Required Primary Key
• RecordTypeValueId (datatype: int) Required Primary Key
• RecordStatusValueId (datatype: int) Required Primary Key
• RecordStatusLastModifiedDateTime (datatype: datetime) Required Primary Key
• RecordStatusReasonValueId (datatype: int) Required Primary Key
• ConnectionStatusValueId (datatype: int) Required Primary Key
• ReviewReasonValueId (datatype: int) Required Primary Key
• IsDeceased (datatype: bit) Required Primary Key
• TitleValueId (datatype: int) Required Primary Key
• FirstName (datatype: nvarchar(50)) Required Primary Key
• NickName (datatype: nvarchar(50)) Required Primary Key
• MiddleName (datatype: nvarchar(50)) Required Primary Key
• LastName (datatype: nvarchar(50)) Required Primary Key
• SuffixValueId (datatype: int) Required Primary Key
• PhotoId (datatype: int) Required Primary Key
• BirthDay (datatype: int) Required Primary Key
• BirthMonth (datatype: int) Required Primary Key
• BirthYear (datatype: int) Required Primary Key
• BirthDateKey (datatype: int) Required Primary Key
• Age (datatype: int) Required Primary Key
• Gender (datatype: int) Required Primary Key
• MaritalStatusValueId (datatype: int) Required Primary Key
• AnniversaryDate (datatype: date) Required Primary Key
• GraduationYear (datatype: int) Required Primary Key
• GivingGroupId (datatype: int) Required Primary Key
• GivingId (datatype: nvarchar(max)) Required Primary Key
• GivingLeaderId (datatype: int) Required Primary Key
• Email (datatype: nvarchar(75)) Required Primary Key
• EmailPreference (datatype: int) Required Primary Key
• ReviewReasonNote (datatype: nvarchar(1000)) Required Primary Key
• InactiveReasonNote (datatype: nvarchar(1000)) Required Primary Key
• SystemNote (datatype: nvarchar(1000)) Required Primary Key
• ViewedCount (datatype: int) 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
• Count (datatype: int) Required Primary Key