|
CreatedDateTime
|
date
|
|
N
|
|
Non-updatable
|
|
CreateLocation
|
string
|
|
N
|
|
Non-updatable
|
|
CreatedBy
|
string
|
|
N
|
|
Non-updatable
|
|
ConstituentType
|
ConstituentTypeSummary
|
|
Y
|
|
|
| FK: TR_CUST_TYPE.id Resource: ConstituentTypes |
|
DisplayName
|
string
|
|
N
|
readonly
|
Generated display name based on name values. Not updateable.
|
|
Id
|
integer
|
|
Y
|
|
Non-updatable
|
|
EmarketIndicator
|
EmarketIndicatorSummary
|
|
N
|
|
|
| FK: TR_EMRKT_IND.id Resource: EmarketIndicators |
|
FirstName
|
string
|
20
|
N
|
|
First name of constituent. Not used for organization or household constituents.
|
|
Inactive
|
ConstituentInactiveSummary
|
|
Y
|
|
Inactive status of constituent. Inactive status of id 1 represents an active constituent.
|
| FK: TR_CUST_INACTIVE.id Resource: ConstituentInactives |
|
InactiveReason
|
InactiveReasonSummary
|
|
N
|
|
|
| FK: TR_INACTIVE_REASON.id Resource: InactiveReasons |
|
LastActivityDate
|
date
|
|
N
|
|
Date of last activity to constituent record. This is updated for most updates to data related to a constituent.
|
|
LastGiftDate
|
date
|
|
N
|
|
Date of last contribution activity.
|
|
LastTicketDate
|
date
|
|
N
|
|
Last ticketed event date for constituent.
|
|
UpdatedDateTime
|
date
|
|
Y
|
|
Auto-assigned
|
|
UpdatedBy
|
string
|
|
N
|
|
Auto-assigned
|
|
LastName
|
string
|
55
|
Y
|
|
|
|
SortName
|
string
|
55
|
N
|
|
|
|
MailIndicator
|
MailIndicatorSummary
|
|
N
|
|
|
| FK: TR_MAIL_IND.id Resource: MailIndicators |
|
MiddleName
|
string
|
20
|
N
|
|
Middle name for individual constituents. Not used for household or organization constituents.
|
|
NameStatus
|
NameStatusSummary
|
|
N
|
|
Designates a status for this constituent. Most often used to designate a deceased record.
|
| FK: TR_NAME_STATUS.id Resource: NameStatuses |
|
OriginalSource
|
OriginalSourceSummary
|
|
N
|
|
The original source that triggered the creation of this constituent.
|
| FK: TR_ORIGINAL_SOURCE.id Resource: OriginalSources |
|
PhoneIndicator
|
PhoneIndicatorSummary
|
|
N
|
|
|
| FK: TR_PHONE_IND.id Resource: PhoneIndicators |
|
Prefix
|
PrefixSummary
|
|
Y
|
|
|
| FK: TR_PREFIX.id Resource: Prefixes |
|
Gender
|
GenderSummary
|
|
N
|
|
|
| FK: TR_GENDER.id Resource: Genders |
|
Suffix
|
SuffixSummary
|
|
Y
|
|
|
| FK: TR_SUFFIX.id Resource: Suffixes |
|
ProtectionType
|
ConstituentProtectionTypeSummary
|
|
Y
|
|
Used to secure edit and view rights to a constituent.
|
| FK: TR_CONSTITUENT_PROTECTION_TYPE.id Resource: ConstituentProtectionTypes |