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

PS_UP_PLG_SCHD_HDR Table

Explanation
For pledges fed to the general ledger, this is a pledge's gift agreement schedule header. It lists the discount rate used to calculate pledge discount. See the related tables, PS_UP_PLG_SCHD_DTL for the face value amounts due by year and WHSE_PLEDGE_DISCOUNT_MV for the current cumulative discount balance for a given pledge.

Common Uses

Long-term pledge anaylysis - linking to

PLEDGE_NO
SEQ_NUMBER

PLEDGE_NO
SEQ_NUMBER

PS_UP_PLG_SCHD_DTL
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