CONSTITUENT

Every individual or organization, constituent or non-constituent, is represented by a row in the CONSTITUENT table. Each row in the CONSTITUENT table identifies that entity as an individual or organization, a constituent or non-constituent, and contains that entity's name and its various properties, such as gender or matching gift limits.

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
KEYNAME nvarchar(100) Default = '' Last name for individuals, Org name for organizations.
KEYNAMEPREFIX nvarchar(50) Default = '' For organizations, stores the name contents before the sort break slash.
FIRSTNAME nvarchar(50) Default = '' For individuals, stores the first name.
MIDDLENAME nvarchar(50) Default = '' For individuals, stores the middle name.
MAIDENNAME nvarchar(100) Default = '' For individuals, stores the maiden name.
NICKNAME nvarchar(50) Default = '' For individuals, stores the nickname.
SSN nvarchar(4000) Default = '' For individuals, stores the SSN or other government ID.
SSNINDEX nvarchar(24) yes
GENDERCODE tinyint Default = 0 0=Unknown, 1=Male, 2=Female
BIRTHDATE UDT_FUZZYDATE Default = '00000000' For individuals, stores the date of birth.
ISINACTIVE bit Default = 0 Indicates whether or not the record is inactive.
GIVESANONYMOUSLY bit Default = 0 Indicates whether or not the record gives anonymously.
WEBADDRESS UDT_WEBADDRESS Default = '' The constituent's web address.
PICTURE varbinary yes A photo or emblem for this constituent.
PICTURETHUMBNAIL varbinary yes
ISORGANIZATION bit Default = 0 Indicates whether a record is an organization.
NETCOMMUNITYMEMBER bit Default = 0 Indicates whether a record is a member of our online community.
DONOTMAIL bit Default = 0 Indicates whether a constituent does not want to be mailed at any address.
DONOTEMAIL bit Default = 0 Indicates whether a constituent does not want to be emailed at any email address.
DONOTPHONE bit Default = 0 Indicates whether a constituent does not want to be called at any phone number.
CUSTOMIDENTIFIER nvarchar(100) Default = '' User-definable custom identifier.
SEQUENCEID int Identity column used to increment the default lookupid.
DATEADDED datetime Default = getdate() Indicates the date this record was added.
DATECHANGED datetime Default = getdate() Indicates the date this record was last changed.
TS timestamp Timestamp.
TSLONG bigint (Computed) yes CONVERT(bigint, TS) Numeric representation of the timestamp.
ISGROUP bit Default = 0 Indicates whether a record is a group
DISPLAYNAME nvarchar(100) Default = '' Display name for households.
LOOKUPID nvarchar(100) (Computed) yes (CASE LEN(CUSTOMIDENTIFIER) WHEN 0 THEN '8-' + CAST(SEQUENCEID AS nvarchar(20)) ELSE CUSTOMIDENTIFIER END) Unique identifier that supports user defined values as well as system generated values.
ISCONSTITUENT bit Default = 1 Indicates if the record is a constituent for fundraising purposes.
AGE int (Computed) yes dbo.UFN_AGEFROMFUZZYDATE(CONSTITUENT.BIRTHDATE, getdate()) For individuals, returns the age.
KEYNAMESOUNDEX varchar(5) (Computed) yes soundex(KEYNAME) The soundex value of the keyname field.
NAME nvarchar(154) (Computed) yes CASE ISORGANIZATION WHEN 1 THEN CASE KEYNAMEPREFIX WHEN '' THEN KEYNAME ELSE KEYNAMEPREFIX + ' ' + KEYNAME END ELSE CASE ISGROUP WHEN 1 THEN CASE DISPLAYNAME WHEN '' THEN KEYNAME ELSE DISPLAYNAME END ELSE CASE FIRSTNAME WHEN '' THEN '' ELSE FIRSTNAME + ' ' END + CASE MIDDLENAME WHEN '' THEN '' ELSE LEFT(MIDDLENAME,1) + '. ' END + KEYNAME END END Returns the constituent name (First + Middle Initial + Last (individuals), Prefix + Org name (orgs)).
GENDER nvarchar(7) (Computed) yes CASE [GENDERCODE] WHEN 0 THEN N'Unknown' WHEN 1 THEN N'Male' WHEN 2 THEN N'Female' WHEN 3 THEN N'Other' END

Foreign Keys

Foreign Key Field Type Null Notes Description
TITLECODEID uniqueidentifier yes TITLECODE.LOCALID FK to TITLECODE
SUFFIXCODEID uniqueidentifier yes SUFFIXCODE.LOCALID FK to SUFFIXCODE
MARITALSTATUSCODEID uniqueidentifier yes MARITALSTATUSCODE.LOCALID FK to MARITALSTATUSCODE
ADDEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.
CHANGEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.
TITLE2CODEID uniqueidentifier yes TITLECODE.LOCALID FK to TITLECODE
SUFFIX2CODEID uniqueidentifier yes SUFFIXCODE.LOCALID FK to SUFFIXCODE
GENDERCODEID uniqueidentifier yes GENDERCODE.ID

Indexes

Index Name Fields Unique Primary Clustered
IX_CONSTITUENT_DATEADDED DATEADDED yes
IX_CONSTITUENT_DATECHANGED DATECHANGED
IX_CONSTITUENT_ID ID
IX_CONSTITUENT_ISCONSTITUENT_ID ISCONSTITUENT, ID
IX_CONSTITUENT_KEYNAME KEYNAME
IX_CONSTITUENT_KEYNAMESOUNDEX KEYNAMESOUNDEX
IX_CONSTITUENT_MAIDENNAME MAIDENNAME
IX_CONSTITUENT_SSNINDEX SSNINDEX
PK_CONSTITUENT ID yes yes
UC_CONSTITUENT_LOOKUPID LOOKUPID yes
UIX_CONSTITUENT_SEQUENCEID SEQUENCEID yes

Triggers

Trigger Name Description
TR_CONSTITUENT_INSERT_GENDERCODE
TR_CONSTITUENT_UPDATE_HOUSEHOLD
TR_CONSTITUENT_UPDATE_GENDERCODE
TR_CONSTITUENT_INSERT_SEARCHCONSTITUENT
TR_CONSTITUENT_DELETE_SEARCHCONSTITUENT
TR_CONSTITUENT_UPDATE_SEARCHCONSTITUENT
TR_CONSTITUENT_TASYNC_I
TR_CONSTITUENT_TASYNC_U
TR_CONSTITUENT_TASYNC_D
TR_CONSTITUENT_UPDATE_ISORGANIZATION
TR_CONSTITUENT_AUDIT_ETLDELETEDID
TR_CONSTITUENT_AUDIT_UPDATE
TR_CONSTITUENT_AUDIT_DELETE

Referenced by

Referenced by Field
ADDPROSPECTPLANSPROCESS PRIMARYMANAGERFUNDRAISERID
ADDPROSPECTPLANSPROCESS SECONDARYMANAGERFUNDRAISERID
ADDPROSPECTPLANSPROCESS PROSPECTMANAGERFUNDRAISERID
ADDPROSPECTPLANSPROCESSSECONDARYFUNDRAISER FUNDRAISERID
ADDRESS CONSTITUENTID
ADDRESSBOOKFAF CONSTITUENTID
ADDSTEWARDSHIPPLANSPROCESS MANAGERID
ADVOCACYACTIVITY CONSTITUENTID
ADVOCACYLOG CONSTITUENTID
ADVOCACYLOG SOURCECONSTITUENTID
ADVOCACYPETITION CONSTITUENTID
ADVOCATERDATERANGE CONSTITUENTID
ALIAS CONSTITUENTID
ALTERNATELOOKUPID CONSTITUENTID
APPEALATTACHMENT AUTHORID
APPEALMAILINGTASK OWNERID
APPEALMEDIALINK AUTHORID
APPEALNOTE AUTHORID
APPUSER CONSTITUENTID
AUCTIONITEMRESERVATION PURCHASERID
BANK ID
BANKACCOUNTADJUSTMENTATTACHMENT AUTHORID
BANKACCOUNTADJUSTMENTMEDIALINK AUTHORID
BANKACCOUNTADJUSTMENTNOTE AUTHORID
BANKACCOUNTDEPOSITATTACHMENT AUTHORID
BANKACCOUNTDEPOSITCORRECTIONATTACHMENT AUTHORID
BANKACCOUNTDEPOSITCORRECTIONMEDIALINK AUTHORID
BANKACCOUNTDEPOSITCORRECTIONNOTE AUTHORID
BANKACCOUNTDEPOSITMEDIALINK AUTHORID
BANKACCOUNTDEPOSITNOTE AUTHORID
BATCHADDRESSVALIDATION CONSTITUENTID
BATCHAMPROIMPORTCONSTITUENT CONSTITUENT_LINKID
BATCHAUCTIONITEMCONSTITUENT EXISTINGCONSTITUENTID
BATCHAUCTIONITEMCONSTITUENT PARENTCORPID
BATCHBBNCDONATION DONORID
BATCHBBNCDONATION CORPORATEDONORID
BATCHBBNCDONATION MGCONSTITUENTID
BATCHBBNCDONATION TRIBUTEACKNOWLEDGEELINKID
BATCHBBNCDONATION SPOUSELINKID
BATCHBBNCDONATIONGIFTAPPLICATION CONSTITUENTID
BATCHBBNCDONATIONSOLICITOR FUNDRAISERID
BATCHBBNCEVENTREGISTRATION DONORID
BATCHBBNCMEMBERSHIPMEMBER MEMBERCONSTITUENTID
BATCHBBNCPROFILE LINKID
BATCHBBNCPROFILE PRIMARYBUSINESSORGANIZATIONLINKID
BATCHBBNCPROFILE SPOUSELINKID
BATCHBBNCSIGNUP LINKID
BATCHCOAUPDATE CONSTITUENTID
BATCHCONSTITUENT PARENTCORPID
BATCHCONSTITUENT SPOUSEID
BATCHCONSTITUENT PRIMARYBUSINESSID
BATCHCONSTITUENT PRIMARYBUSINESS_PARENTCORPID
BATCHCONSTITUENTGROUPMEMBER CONSTITUENTID
BATCHCONSTITUENTUPDATE PRIMARYRECORDID
BATCHCONSTITUENTUPDATE PROSPECTMANAGERFUNDRAISERID
BATCHCONSTITUENTUPDATE ORG_PARENTCORPID
BATCHCONSTITUENTUPDATE SPOUSE_ID
BATCHCONSTITUENTUPDATE BUSINESS_ID
BATCHCONSTITUENTUPDATE BUSINESS_PARENTCORPID
BATCHCONSTITUENTUPDATERELATIONSHIPS RECIPROCALCONSTITUENTID
BATCHDECEASEDFINDER CONSTITUENTID
BATCHEDUCATIONALHISTORYUPDATE PRIMARYCONTEXTRECORDID
BATCHEMAILFINDER CONSTITUENTID
BATCHEVENT EVENTLOCATIONCONTACTID
BATCHEVENTCOORDINATOR CONSTITUENTID
BATCHEVENTEXPENSE VENDORID
BATCHEVENTREGISTRANT CONSTITUENTID
BATCHEVENTREGISTRANTGUEST CONSTITUENTID
BATCHEVENTSPONSORSHIP ORIGINALCONSTITUENTID
BATCHEVENTSPONSORSHIP ORGANIZATIONCONSTITUENTID
BATCHEVENTTASK OWNERID
BATCHGIVINGSUMMARYUPDATE PRIMARYRECORDID
BATCHINTERACTION CONSTITUENTID
BATCHINTERACTION FUNDRAISERID
BATCHMEMBERSHIPDUESDONATIONSOLICITOR CONSTITUENTID
BATCHMEMBERSHIPMEMBER CONSTITUENTID
BATCHMEMBERSHIPTRANSACTION DONORID
BATCHMODELINGANDPROPENSITY CONSTITUENTID
BATCHMODELINGANDPROPENSITYUPDATE PRIMARYRECORDID
BATCHPEOPLEFINDER CONSTITUENTID
BATCHPHONEFINDER CONSTITUENTID
BATCHRE7INTEGRATIONGIVINGSUMMARY CONSTITUENTID
BATCHREVENUE NOTEAUTHORID
BATCHREVENUE MGMATCHINGCONSTITUENTID
BATCHREVENUE ACKNOWLEDGEEID
BATCHREVENUECONSTITUENT EXISTINGCONSTITUENTID
BATCHREVENUECONSTITUENT PARENTCORPID
BATCHREVENUEENHANCEDMATCHINGGIFTS ORGANIZATIONID
BATCHREVENUENOTE AUTHORID
BATCHREVENUESOLICITOR CONSTITUENTID
BATCHSPONSORSHIPCONSTITUENT EXISTINGCONSTITUENTID
BATCHSPONSORSHIPCONSTITUENT PARENTCORPID
BATCHSTEWARDSHIPPLANSTEPUPDATE CONTACTPERSONID
BATCHSTEWARDSHIPPLANSTEPUPDATE CONSTITUENTID
BATCHSTEWARDSHIPPLANSTEPUPDATESTEPPARTICIPANT CONSTITUENTID
BATCHTIMESHEET VOLUNTEERID
BENEFIT BENEFITVENDORID
BENEFIT FULFILLMENTVENDORID
BENEFITCONSTITUENTDECLINED CONSTITUENTID
BOARDMEMBERDATERANGE CONSTITUENTID
CAMPAIGNATTACHMENT AUTHORID
CAMPAIGNFUNDRAISER CONSTITUENTID
CAMPAIGNMEDIALINK AUTHORID
CAMPAIGNNOTE AUTHORID
CHARGELINEITEMRESPONSIBILITY CONSTITUENTID
COMMITTEE ID
COMMITTEEDATERANGE CONSTITUENTID
CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENT CONSTITUENTID
CONSTITUENCY CONSTITUENTID
CONSTITUENCYDATERANGE CONSTITUENTID
CONSTITUENCYREFRESHPROCESSSELECTIONRESULT CONSTITUENTID
CONSTITUENTACCOUNT CONSTITUENTID
CONSTITUENTAPPEAL CONSTITUENTID
CONSTITUENTATTACHMENT AUTHORID
CONSTITUENTATTACHMENT CONSTITUENTID
CONSTITUENTCORRESPONDENCE CONSTITUENTID
CONSTITUENTHOUSEHOLD ID
CONSTITUENTINACTIVEDETAIL ID
CONSTITUENTINTEREST CONSTITUENTID
CONSTITUENTJOBINFO ID
CONSTITUENTMEDIALINK AUTHORID
CONSTITUENTMEDIALINK CONSTITUENTID
CONSTITUENTNOTE AUTHORID
CONSTITUENTNOTE CONSTITUENTID
CONSTITUENTNOTEATTACHMENT AUTHORID
CONSTITUENTORIGINATION ID
CONSTITUENTRECOGNITION CONSTITUENTID
CONSTITUENTRECOGNITIONDECLINEDLEVEL CONSTITUENTID
CONSTITUENTRECOGNITIONDECLINEDPROGRAM CONSTITUENTID
CONSTITUENTRESTRICTIONOPTION CONSTITUENTID
CONSTITUENTSITE CONSTITUENTID
CONSTITUENTSOLICITCODE CONSTITUENTID
CONSTITUENTSOURCEANALYSISCACHEADDRESS CONSTITUENTID
CONSTITUENTSOURCEANALYSISCACHECOMMUNITYMEMBER CONSTITUENTID
CONSTITUENTSOURCEANALYSISCACHEDONOR CONSTITUENTID
CONSTITUENTSOURCEANALYSISCACHEMEMBERSHIPMEMBER CONSTITUENTID
CONSTITUENTSOURCEANALYSISCACHEMGORG CONSTITUENTID
CONSTITUENTSOURCEANALYSISCACHESMARTFIELDLIFETIMEGIFTSONFILE CONSTITUENTID
CONSTITUENTSOURCEANALYSISCACHESMARTFIELDLIFETIMEGIVING CONSTITUENTID
CONSTITUENTSOURCEANALYSISCACHESMARTFIELDYEARSASDONOR CONSTITUENTID
CORPORATESTRUCTURESELECTION ROOTID
CORPORATESTRUCTURESELECTION SELECTEDID
COURSEATTACHMENT AUTHORID
COURSEMEDIALINK AUTHORID
COURSENOTE AUTHORID
CREDITITEMMEMBERSHIP GIVENBYID
CUSTOMMODELING CONSTITUENTID
DECEASEDCONSTITUENT ID
DECEASEDFINDERGETPROCESSDATA CONSTITUENTID
DEMOGRAPHIC ID
DESIGNATIONLEVEL ADMINISTRATORID
DESIGNATIONLEVELATTACHMENT AUTHORID
DESIGNATIONLEVELDECAPITALIZATION APPROVEDBYID
DESIGNATIONLEVELDISBURSEMENT CONSTITUENTID
DESIGNATIONLEVELDONORINFORMATION CONSTITUENTID
DESIGNATIONLEVELMEDIALINK AUTHORID
DESIGNATIONLEVELNOTE AUTHORID
DESIGNATIONLEVELRECIPIENT CONSTITUENTID
DESIGNATIONLEVELRELATEDSTAFF CONSTITUENTID
DESIGNATIONLEVELSTEWARDSHIPRECIPIENTS CONSTITUENTID
DISABLEDWEALTHUPDATES ID
DISSOLVEDGROUP ID
DONATIONBATCH ORIGINALCONSTITUENTID
DONATIONBATCH ORGANIZATIONCONSTITUENTID
DONORCHALLENGE EXTERNALSPONSORID
DONORCHALLENGEATTACHMENT AUTHORID
DONORCHALLENGEENCUMBERED CONSTITUENTID
DONORCHALLENGEMEDIALINK AUTHORID
DONORCHALLENGENOTE AUTHORID
EDUCATIONALHISTORY CONSTITUENTID
EDUCATIONALINSTITUTION ID
EDUCATIONALINVOLVEMENT CONSTITUENTID
EMAILADDRESS CONSTITUENTID
EMAILJOBEXTENSION CONSTITUENTID
EVENT EVENTLOCATIONCONTACTID
EVENTATTACHMENT AUTHORID
EVENTCOORDINATOR CONSTITUENTID
EVENTDONOR CONSTITUENTID
EVENTEXPENSE VENDORID
EVENTINSTRUCTOR CONSTITUENTID
EVENTLODGINGLOCATION CONSTITUENTID
EVENTMEDIALINK AUTHORID
EVENTNOTE AUTHORID
EVENTSPEAKER CONSTITUENTID
EVENTSPONSOR CONSTITUENTID
EVENTSTAFFRESOURCEASSIGNMENT CONSTITUENTID
EVENTTASK OWNERID
EVENTVENDOR ID
EXCHANGECALENDARITEMBATCH CONSTITUENTID
EXCHANGECONTACT CONSTITUENTID
EXCHANGECONTACTBATCH CONSTITUENTID
EXCHANGEEMAILBATCH CONSTITUENTID
FACULTY ID
FAFCOMMUNICATIONSLOG CONSTITUENTID
FAFDONATION CONSTITUENTID
FAFDONATION RECOGNITIONID
FAFEVENTBATCH EVENTLOCATIONCONTACTID
FAFEVENTINQUIRY CONSTITUENTID
FAFGROUPDIRECTHIERARCHY GROUPCONSTITUENTID
FAFGROUPSUMMARYINFORMATION GROUPCONSTITUENTID
FAFIMAGES CONSTITUENTID
FAFNFGCAMPAIGN GROUPCONSTITUENTID
FAFNFGCAMPAIGN ORGANIZATIONCONSTITUENTID
FAFNFGCAMPAIGN CONTACTID
FAFNFGCAMPAIGNLEVEL CONTACTID
FAFORGANIZATIONINDIVIDUALRELATION INDIVIDUALCONSTITUENTID
FAFORGANIZATIONINDIVIDUALRELATION ORGANIZATIONCONSTITUENTID
FAFPARTICIPANTGALLERYIMAGES CONSTITUENTID
FAFRAISEDTOTAL CONSTITUENTID
FAFRAISEDTOTAL_CATEGORIZED CONSTITUENTID
FAFREGISTRANTBENEFITSUMMARY CONSTITUENTID
FAFREGISTRANTPENDINGSUMMARY CONSTITUENTID
FAFREGISTRANTPREVIOUSSUMMARY CONSTITUENTID
FINANCIALTRANSACTION CONSTITUENTID
FINANCIALTRANSACTIONATTACHMENT AUTHORID
FINANCIALTRANSACTIONLINEITEMADJUSTMENT CONSTITUENTID
FINANCIALTRANSACTIONMEDIALINK AUTHORID
FINANCIALTRANSACTIONNOTE AUTHORID
FLAGGEDPROSPECT PROSPECTID
FUNDINGPLAN FUNDINGPLANMANAGERID
FUNDINGPLANATTACHMENT AUTHORID
FUNDINGPLANMEDIALINK AUTHORID
FUNDINGPLANNOTE AUTHORID
FUNDINGREQUEST PRIMARYMANAGERID
FUNDINGREQUEST SECONDARYMANAGERID
FUNDINGREQUESTATTACHMENT AUTHORID
FUNDINGREQUESTMEDIALINK AUTHORID
FUNDINGREQUESTNOTE AUTHORID
FUNDINGREQUESTSPONSOR SPONSORID
FUNDRAISERDATERANGE CONSTITUENTID
GIFTAIDDISQUALIFIEDBYATTRIBUTE CONSTITUENTID
GIFTINKINDAPPRAISAL APPRAISERID
GLACCOUNTCODEATTACHMENT AUTHORID
GLACCOUNTCODEMEDIALINK AUTHORID
GLACCOUNTCODENOTE AUTHORID
GRANTOR ID
GROUPDATA ID
GROUPMEMBER GROUPID
GROUPMEMBER MEMBERID
HOUSEHOLDRECOGNITIONSETTINGS ID
INTERACTION CONSTITUENTID
INTERACTION FUNDRAISERID
INTERACTIONADDITIONALFUNDRAISER FUNDRAISERID
INTERACTIONATTACHMENT AUTHORID
INTERACTIONMEDIALINK AUTHORID
INTERACTIONNOTE AUTHORID
INTERACTIONPARTICIPANT CONSTITUENTID
INVITEE CONSTITUENTID
INVITEE INVITATIONRECIPIENTCONSTITUENTID
INVITEEHISTORY CONSTITUENTID
ITINERARY LEADERID
ITINERARYITEMSTAFFRESOURCEASSIGNMENT CONSTITUENTID
ITINERARYSTAFFRESOURCEASSIGNMENT CONSTITUENTID
JOBATTACHMENT AUTHORID
JOBMEDIALINK AUTHORID
JOBNOTE AUTHORID
LEDGERACCOUNTATTACHMENT AUTHORID
LEDGERACCOUNTMEDIALINK AUTHORID
LEDGERACCOUNTNOTE AUTHORID
MAILPREFERENCE CONSTITUENTID
MAILPREFERENCEGROUPCONTACT CONSTITUENTID
MATCHFINDERCONSTITUENT ID
MATCHINGGIFTCONDITION ORGANIZATIONID
MEMBER CONSTITUENTID
MEMBERATTACHMENT AUTHORID
MEMBERMEDIALINK AUTHORID
MEMBERNOTE AUTHORID
MEMBERSHIP GIVENBYID
MEMBERSHIPPROGRAMCONTRIBUTIONREVENUE CONSTITUENTID
MEMBERSHIPTRANSACTION DONORID
MERCHANDISEPRODUCTATTACHMENT AUTHORID
MERCHANDISEPRODUCTMEDIALINK AUTHORID
MERCHANDISEPRODUCTNOTE AUTHORID
MKTFINDERNUMBERCONSTITUENT PARENTCORPID
MKTMARKETINGPLANITEMTASK OWNERID
MODELINGANDPROPENSITY ID
NAMEFORMAT CONSTITUENTID
NAMINGOPPORTUNITY CONTACTID
NAMINGOPPORTUNITYATTACHMENT AUTHORID
NAMINGOPPORTUNITYMEDIALINK AUTHORID
NAMINGOPPORTUNITYNOTE AUTHORID
NAMINGOPPORTUNITYRECOGNITION CONSTITUENTID
NETCOMMUNITYCLIENTUSER CONSTITUENTID
NETCOMMUNITYEMAILJOBRECIPIENT CONSTITUENTID
NETCOMMUNITYNEWSLETTERSUBSCRIPTION CONSTITUENTID
OPPORTUNITYDESIGNATION CONSTITUENTID
ORGANIZATIONDATA ID
ORGANIZATIONDATA PARENTCORPID
ORGANIZATIONMERGERHISTORY SOURCEORG1ID
ORGANIZATIONMERGERHISTORY SOURCEORG2ID
ORGANIZATIONMERGERHISTORY NEWORGID
ORGANIZATIONPARENTHISTORY CHILDCORPID
ORGANIZATIONPARENTHISTORY PARENTCORPID
ORGANIZATIONPOSITIONHOLDER CONSTITUENTID
PHONE CONSTITUENTID
PLANNEDGIFT CONSTITUENTID
PLANNEDGIFTADDITIONASSETHOLDER HOLDERCONSTITUENTID
PLANNEDGIFTASSETHOLDER HOLDERCONSTITUENTID
PLANNEDGIFTATTACHMENT AUTHORID
PLANNEDGIFTBENEFICIARY BENEFICIARYCONSTITUENTID
PLANNEDGIFTMEDIALINK AUTHORID
PLANNEDGIFTNOTE AUTHORID
PLANPARTICIPANT CONSTITUENTID
PROJECTATTACHMENT AUTHORID
PROJECTMEDIALINK AUTHORID
PROJECTNOTE AUTHORID
PROSPECT ID
PROSPECT PROSPECTMANAGERFUNDRAISERID
PROSPECTASSIGNMENTPROCESS SOURCEMANAGERID
PROSPECTASSIGNMENTPROCESS DESTINATIONMANAGERID
PROSPECTASSIGNMENTREQUEST NEWFUNDRAISERID
PROSPECTASSIGNMENTREQUESTPROSPECT PROSPECTID
PROSPECTDATERANGE CONSTITUENTID
PROSPECTMANAGERHISTORY FUNDRAISERID
PROSPECTPLAN PROSPECTID
PROSPECTPLAN PRIMARYMANAGERFUNDRAISERID
PROSPECTPLAN SECONDARYMANAGERFUNDRAISERID
PROSPECTPLANATTACHMENT AUTHORID
PROSPECTPLANMANAGERHISTORY FUNDRAISERID
PROSPECTPLANMEDIALINK AUTHORID
PROSPECTPLANNOTE AUTHORID
PROSPECTPLANREQUEST PROSPECTID
PROSPECTPLANREQUEST PRIMARYMANAGERFUNDRAISERID
PROSPECTPLANREQUEST SECONDARYMANAGERFUNDRAISERID
PROSPECTRESEARCHREQUEST REQUESTEDBYID
PROSPECTRESEARCHREQUEST SUBMITTEDBYID
PROSPECTRESEARCHREQUEST ASSIGNEDTOID
PROSPECTRESEARCHREQUESTATTACHMENT AUTHORID
PROSPECTRESEARCHREQUESTCONSTITUENT CONSTITUENTID
PROSPECTRESEARCHREQUESTCONSTITUENT ASSIGNEDTOID
PROSPECTRESEARCHREQUESTCONSTITUENTATTACHMENT AUTHORID
PROSPECTRESEARCHREQUESTCONSTITUENTMEDIALINK AUTHORID
PROSPECTRESEARCHREQUESTCONSTITUENTNOTE AUTHORID
PROSPECTRESEARCHREQUESTMEDIALINK AUTHORID
PROSPECTRESEARCHREQUESTNOTE AUTHORID
PROSPECTSEGMENTATIONPROSPECT CONSTITUENTID
PROSPECTTEAM PROSPECTID
PROSPECTTEAM MEMBERID
R68DETAIL CONSTITUENTID
R68REFUNDDETAIL CONSTITUENTID
RE7INTEGRATIONCONSTITUENTMAP ID
RE7INTEGRATIONGIVINGSUMMARY ID
RECEIVABLEPAYMENT CONSTITUENTID
RECOGNITIONCREDIT CONSTITUENTID
RECURRINGGIFTAMENDMENT CONSTITUENTID
RECURRINGGIFTAMENDMENT PREVIOUSCONSTITUENTID
REGISTRANT CONSTITUENTID
REGISTRANTBATCH ORGANIZATIONID
REGISTRANTBATCH ORIGINALCONSTITUENTID
REGISTRANTLODGING REGISTRANTCONSTITUENTID
REGISTRANTPACKAGE CONSTITUENTID
REGISTRANTPACKAGE GUESTOFCONSTITUENTID
REGISTRANTTRAVEL REGISTRANTCONSTITUENTID
RELATIONSHIP RELATIONSHIPCONSTITUENTID
RELATIONSHIP RECIPROCALCONSTITUENTID
RELATIONSHIPMANAGER CONSTITUENTID
RELATIONSHIPMANAGER FUNDRAISERID
RESEARCHGROUP FUNDRAISERID
RESEARCHGROUPMEMBER CONSTITUENTID
RESERVATIONATTACHMENT AUTHORID
RESERVATIONMEDIALINK AUTHORID
RESERVATIONNOTE AUTHORID
REVENUEATTACHMENT AUTHORID
REVENUELETTER ACKNOWLEDGEEID
REVENUELIFECYCLE CONSTITUENTID
REVENUELIFECYCLEHISTORY CONSTITUENTID
REVENUEMEDIALINK AUTHORID
REVENUENOTE AUTHORID
REVENUERECOGNITION CONSTITUENTID
REVENUERECOGNITIONDEFAULT SOURCECONSTITUENTID
REVENUERECOGNITIONDEFAULT RECIPIENTCONSTITUENTID
REVENUESOLICITOR CONSTITUENTID
REVENUESPLITGIFTAIDREFUND CONSTITUENTID
REVENUETRIBUTELETTER CONSTITUENTID
SALESORDER CONSTITUENTID
SALESORDER RECIPIENTID
SALESORDERATTACHMENT AUTHORID
SALESORDERITEMMEMBER CONSTITUENTID
SALESORDERITEMMEMBERSHIP GIVENBYID
SALESORDERITEMSPONSORSHIP GIFTRECIPIENTID
SALESORDERMEDIALINK AUTHORID
SALESORDERNOTE AUTHORID
SECONDARYFUNDRAISER FUNDRAISERID
SITEIMAGESEXTENSION CONSTITUENTID
SOCIALMEDIAACCOUNT CONSTITUENTID
SOLICITCODECHANNELOPTOUT CONSTITUENTID
SPONSOR ID
SPONSORDATERANGE CONSTITUENTID
SPONSORSHIP CONSTITUENTID
SPONSORSHIPAFFILIATEPROGRAM AFFILIATEID
SPONSORSHIPCOMMITMENT CONSTITUENTID
SPONSORSHIPLOCATION FIELDOFFICEID
SPONSORSHIPOPPORTUNITYATTACHMENT AUTHORID
SPONSORSHIPOPPORTUNITYCHILD CONSTITUENTID
SPONSORSHIPOPPORTUNITYMEDIALINK AUTHORID
SPONSORSHIPOPPORTUNITYNOTE AUTHORID
SPONSORSHIPPAYMENT GIFTFINANCIALSPONSORID
SPONSORSHIPTRANSACTION GIFTFINANCIALSPONSORID
STAFFDATERANGE CONSTITUENTID
STEWARDSHIPATTACHMENT AUTHORID
STEWARDSHIPMEDIALINK AUTHORID
STEWARDSHIPNOTE AUTHORID
STEWARDSHIPPLAN MANAGERID
STEWARDSHIPPLAN CONSTITUENTID
STEWARDSHIPPLANASSIGNMENTPROCESS OLDOFFICERID
STEWARDSHIPPLANASSIGNMENTPROCESS NEWOFFICERID
STEWARDSHIPPLANMANAGERHISTORY MANAGERID
STEWARDSHIPPLANSTEP CONTACTPERSONID
STEWARDSHIPPLANSTEP CONSTITUENTID
STEWARDSHIPPLANSTEPPARTICIPANT CONSTITUENTID
STEWARDSHIPPLANSTEWARD CONSTITUENTID
STUDENT ID
SURVEY CONSTITUENTID
SURVEYATTACHMENT AUTHORID
SURVEYMEDIALINK AUTHORID
SURVEYNOTE AUTHORID
TAIMPORTIDMAP ID
TAXDECLARATION CONSTITUENTID
TEAMEXTENSION TEAMCONSTITUENTID
TEAMFUNDRAISER CONSTITUENTID
TEAMFUNDRAISINGTEAMCAPTAIN CONSTITUENTID
TIMESHEET VOLUNTEERID
TRIBUTE TRIBUTEEID
TRIBUTEACKNOWLEDGEE CONSTITUENTID
TRIBUTEEXTENSION FROMCONSTITUENTID
UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH CONSTITUENTID
UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH CONTACTLINKID
USERDEFINEDELEMENTATTACHMENT AUTHORID
USERDEFINEDELEMENTMEDIALINK AUTHORID
USERDEFINEDELEMENTNOTE AUTHORID
VENDOR ID
VIDEO CONSTITUENTID
VOLUNTEER ID
VOLUNTEER SPONSORID
VOLUNTEERADMINISTRATIVE VOLUNTEERID
VOLUNTEERASSIGNMENT VOLUNTEERID
VOLUNTEERATTACHMENT AUTHORID
VOLUNTEERATTACHMENT VOLUNTEERID
VOLUNTEERAVAILABILITY VOLUNTEERID
VOLUNTEERAWARDASSIGNMENT VOLUNTEERID
VOLUNTEERCERTIFICATION VOLUNTEERID
VOLUNTEERCOURSE VOLUNTEERID
VOLUNTEERDATERANGE CONSTITUENTID
VOLUNTEERINTEREST VOLUNTEERID
VOLUNTEERLICENSE VOLUNTEERID
VOLUNTEERMEDIALINK AUTHORID
VOLUNTEERMEDIALINK VOLUNTEERID
VOLUNTEERMEDICAL VOLUNTEERID
VOLUNTEERNOTE AUTHORID
VOLUNTEERNOTE VOLUNTEERID
VOLUNTEERSCREENPLAN VOLUNTEERID
VOLUNTEERSKILL VOLUNTEERID
VOLUNTEERSPECIALNEED VOLUNTEERID
VOLUNTEERVOLUNTEERLOCATION VOLUNTEERID
VOLUNTEERVOLUNTEERTYPE VOLUNTEERID
WEALTH ID
WEALTHCAPACITY ID
WPRELATIONSHIP_BO CONSTITUENTID
WPRELATIONSHIP_BO_IND CONSTITUENTID
WPRELATIONSHIP_NPA CONSTITUENTID
WPRELATIONSHIP_NPA_IND CONSTITUENTID
WPRELATIONSHIP_PF CONSTITUENTID
WPRELATIONSHIP_PF_IND CONSTITUENTID
WPSEARCHHISTORY CONSTITUENTID
WPSEARCHHISTORYSELECTEDCONSTITUENT CONSTITUENTID