Penn Computing

University of Pennsylvania
Penn Computing << go backback
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.

Primary Key Indexed Data Elements Related Tables
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

Cautions
  • 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

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania