PS_UP_PLG_SCHD_HDR Table   Tables and Data Elements   ATLAS Data Warehouse Home   Data Warehouse Home

PS_UP_PLG_SCHD_DTL Table

Explanation
For pledges fed to the general ledger, this table lists the face value amount due by year as set in the donor's pledge agreement. It is a snapshot of expected payment stream at the time of the pledge. It does not track payments as they arrive. See PS_AV_PLDG_SCHD for actuals.

Common Uses

Calculating future pledge payment income and NPV for a pledge.

PLEDGE_NO
SEQ_NUMBER

PLEDGE_NO
SEQ_NUMBER

PS_UP_PLG_SCHD_HDR
WHSE_PLEDGE_DISCOUNT_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_OPEN_PLEDGE_SUMMARY

PS_UP_PLG_SCHD_HDR Table   Tables and Data Elements   ATLAS Data Warehouse Home   Data Warehouse Home