ConstituentDetail

Type: Tessitura.Service.Client.CRM.ConstituentDetail

Property Name Data Type Length Required Readonly Notes
CreatedDateTime date N readonly Date and time constituent was created.
CreateLocation string N readonly Machine location when creating constituent.
CreatedBy string N readonly UserId who created this constituent.
ConstituentType ConstituentTypeSummary Y Type of constituent, also determines group (individual, household, or organization).
FK: TR_CUST_TYPE.   Resource: ConstituentTypes
DisplayName string N readonly Standardized display name built from constituent name data and used in many places in applications. Readonly and not editable.
Id integer N Primary identity in system for constituent.
EmarketIndicator EmarketIndicatorSummary N TO BE DEPRECATED, replaced by Contact Permissions.
FirstName string N Required if Constituent Group is individual.
Inactive ConstituentInactiveSummary N Inactive status of the constituent. Id 1 is Active, and default.
FK: TR_CUST_INACTIVE.
InactiveReason InactiveReasonSummary N Selected reason for inactivating the constituent. Required if inactive is not 1 (active).
FK: TR_CUST_INACTIVE_REASON.   Resource: InactiveReasons
LastActivityDate date N readonly Date of last activity (update or transaction) from constituent.
LastGiftDate date N readonly Date of last contribution activity.
LastTicketDate date N readonly Date of last ticketing activity.
UpdatedDateTime date N readonly Date of last update to constituent record.
UpdatedBy string N readonly UserId of last update.
LastName string Y Last Name for individuals or group name.
SortName string Y Used to sort in lists.
MailIndicator MailIndicatorSummary N TO BE DEPRECATED, replaced by Contact Permissions.
MiddleName string N Middle name of Individual constituents. Not used for group or household.
NameStatus NameStatusSummary N Status of the constituent.
FK: TR_NAME_STATUS.   Resource: NameStatuses
OriginalSource OriginalSourceSummary Y Source for constituent when created.
FK: TR_ORIGINAL_SOURCE.   Resource: OriginalSources
PhoneIndicator PhoneIndicatorSummary N TO BE DEPRECATED, replaced by Contact Permissions.
FK: TR_PHONE_IND.
Prefix PrefixSummary N Prefix of constituent. Only used for Individuals.
FK: TR_PREFIX.   Resource: Prefixes
Gender GenderSummary N Gender of constituent. Only used for Individuals.
FK: TR_GENDER.   Resource: Genders
Suffix SuffixSummary N Suffix of constituent. Only used for Individuals.
FK: TR_SUFFIX.   Resource: Suffixes
Addresses Collection of Address N Collection of Addresses associated to the constituent. Depending on system configuration, one of addresses must be marked primary.
ElectronicAddresses Collection of ElectronicAddress N Collection of ElectronicAddresses associated to the constituent. Depending on system configuration, one of electronic addresses may be required to be marked primary.
Salutations Collection of Salutation N Collection of Salutations associated to the constituent. Depending on system configuration, one of addresses must be marked primary.
PhoneNumbers Collection of Phone N Collection of Phones associated to the constituent.
ProtectionType ConstituentProtectionTypeSummary N Used to restrict access and visibility to constituent.
FK: TR_CUST_PROTECTION_TYPE.