In addition to the CONSTIT_GIFTS table there are also nine CONSTIT_GIFTS_XX views which can be used to filter on soft credits and matching gifts.  The two-letter suffixes (BB, BC, BD, DB, DC, DD, RB, RC, RD) for these views determine the type of filtering used with the first letter representing soft credits while the second letter represents matching gifts.

The first letter represents for whom soft credits will be returned:
  • B - Both
  • D - Donor
  • R - Recipient
The second letter represents for whom matching gifts will be returned:
  • B - Both
  • C - Company
  • D - Donor (Constituent)
For example, CONSTIT_GIFTS_RD would represent a view that selects soft credit to recipient and matching gift to donor.