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

PS_AV_PLDG_SCHD Table

Explanation
This table provides the payment schedule for a pledge in Atlas. All pledges have at least one schedule row.

Common Uses

Use to find all payments due within a specific time frame.

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
WHSE_OPEN_PLEDGE_SUMMARY

• For many pledges there are multiple schedule rows. Use caution when calculating summaries. WHSE_OPEN_PLEDGE_SUMMARY provides a single row per designation view of pledges with common used data such as amount past due for a specific time frame.

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