WHSE_SOFT_CREDIT Table - Data Element Index   Tables and Data Elements   Advancement Home   Data Warehouse Home

WHSE_SOFT_CREDIT Table

Explanation
This table provides a single row view of individuals and organizations receiving soft credit for a gift or pledge. It presents the count of all donors receiving soft credit, as well as the name and ids of the first three individuals and first organization with soft credit.

Common Uses

Join to a hard credit gift to find the donor responsible for hard credit.

BUSINESS_UNIT
SESSION_NO
GIFT_NO

BUSINESS_UNIT
SESSION_NO
GIFT_NO

WHSE_GIFT_DETAIL
WHSE_GIFT_DETAIL_YTD_MV
WHSE_CAMP_DETAIL
WHSE_GIFT_DETAIL_BEN_MV
WHSE_GIFT_DETAIL_YTD_BEN_MV
WHSE_TRANSACTION_DETAIL

• Although rare, there are certain transactions for which no hard credit exists.

WHSE_SOFT_CREDIT Table - Data Element Index   Tables and Data Elements   Advancement Home   Data Warehouse Home