Information for the Person

Columns

• Id (datatype: int) Required Primary Key
• IsSystem (datatype: bit) Required Primary Key
• RecordTypeValueId (datatype: int) Required Primary Key
• RecordStatusValueId (datatype: int) Required Primary Key
• RecordStatusReasonValueId (datatype: int) Required Primary Key
• ConnectionStatusValueId (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
• Gender (datatype: int) Required Primary Key
• MaritalStatusValueId (datatype: int) Required Primary Key
• AnniversaryDate (datatype: date) Required Primary Key
• GivingGroupId (datatype: int) Required Primary Key
• Email (datatype: nvarchar(75)) Required Primary Key
• IsEmailActive (datatype: bit) Required Primary Key
• EmailNote (datatype: nvarchar(250)) Required Primary Key
• SystemNote (datatype: nvarchar(1000)) Required Primary Key
• ViewedCount (datatype: int) 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
• EmailPreference (datatype: int) Required Primary Key
• InactiveReasonNote (datatype: nvarchar(1000)) Required Primary Key
• ForeignKey (datatype: nvarchar(100)) Required Primary Key
• ReviewReasonValueId (datatype: int) Required Primary Key
• ReviewReasonNote (datatype: nvarchar(1000)) Required Primary Key
• GraduationYear (datatype: int) Required Primary Key
• ForeignGuid (datatype: uniqueidentifier) Required Primary Key
• ForeignId (datatype: int) Required Primary Key
• RecordStatusLastModifiedDateTime (datatype: datetime) Required Primary Key
• CommunicationPreference (datatype: int) Required Primary Key
• TopSignalColor (datatype: nvarchar(100)) Required Primary Key
• TopSignalIconCssClass (datatype: nvarchar(100)) Required Primary Key
• TopSignalId (datatype: int) Required Primary Key
• AgeClassification (datatype: int) Required Primary Key
• PrimaryFamilyId (datatype: int) Required Primary Key
• DaysUntilAnniversary (datatype: int) Required Primary Key
• IsLockedAsChild (datatype: bit) Required Primary Key
• DeceasedDate (datatype: datetime) Required Primary Key
• GivingLeaderId (datatype: int) Required Primary Key
• BirthDate (datatype: date) Required Primary Key
• ContributionFinancialAccountId (datatype: int) Required Primary Key
• PrimaryCampusId (datatype: int) Required Primary Key
• GivingId (datatype: nvarchar(50)) Required Primary Key
• PreferredLanguageValueId (datatype: int) Required Primary Key
• AccountProtectionProfile (datatype: int) Required Primary Key
• DaysUntilBirthday (datatype: int) Required Primary Key
• ReminderCount (datatype: int) Required Primary Key
• RaceValueId (datatype: int) Required Primary Key
• EthnicityValueId (datatype: int) Required Primary Key
• BirthDateKey (datatype: int) Required Primary Key
• AgeBracket (datatype: int) Required Primary Key
• Age (datatype: int) Required Primary Key
• FirstNamePronunciationOverride (datatype: nvarchar(200)) Required Primary Key
• NickNamePronunciationOverride (datatype: nvarchar(200)) Required Primary Key
• LastNamePronunciationOverride (datatype: nvarchar(200)) Required Primary Key
• PronunciationNote (datatype: nvarchar(1000)) Required Primary Key
• PrimaryAliasId (datatype: int) Required Primary Key