| ALIAS
|
This table contains aliases for constituents. |
| APPUSER
|
|
| APPUSERCLAIMS
|
|
| BATCHCONSTITUENTUPDATEEMAILADDRESSES
|
Stores email addresses for constituent update batch. |
| BATCHCONSTITUENTUPDATEPHONES
|
Stores phones for constituent update batch. |
| BATCHREVENUECONSTITUENT
|
Stores data for constituents added to revenue batch. |
| 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. |
| Email
|
|
| EMAILADDRESS
|
The EMAILADDRESS table stores email addresses associated with a given constituent. |
| EmailJob
|
|
| EmailJob_Recipient
|
|
| EmailJobStatus
|
|
| EmailTemplate
|
|
| MEMBERSHIPPROMO
|
Provides a way for organizations to extend terms of or reduce prices of memberships |
| MKTFINDERNUMBERCONSTITUENT
|
Stores data for constituents added by a finder number. |
| PHONE
|
The PHONE table stores phone numbers associated with a given constituent. |
| R68REFUNDDETAIL
|
Contains tax claim refund detail information for the R68 business process. |
| REVENUESPLITGIFTAID
|
Stores gift aid information for each revenue split. |
| REVENUESPLITGIFTAIDREFUND
|
Stores Gift Aid refund information for each revenue split. |
| SALESORDERITEM
|
Stores items that can be placed in a sales order. |
| SPONSORSHIPOPPORTUNITYCHILD
|
Stores child sponsorship opportunities. |
| WPRELATIONSHIP_NPA_IND
|
Contains WealthPoint Nonprofit Affiliation relationship individual information. |