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

WHSE_HARD_CREDIT Table

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

Common Uses

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

BUSINESS_UNIT
SESSION_NO
GIFT_NO

BUSINESS_UNIT
SESSION_NO
GIFT_NO

WHSE_CAMP_DETAIL_MV
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

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