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

WHSE_OPEN_PLEDGES_SUMMARY Table

Explanation
This table presents all open (active and reserved) pledges and includes amounts due during standard time frames. It includes one row for each designation.

Common Uses

Used to calculate amount due or expected in a specific period.

BUSINESS_UNIT
SESSION_NO
GIFT_NO
DESIGNATION

AV_DES_BU
BUSINESS_UNIT
COMMON_ID
DESIGNATION
EMPLID
EXT_ORG_ID
GIFT_NO
INTV_CD
SESSION_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

• Total pledge amount and total paid amount fields are for reference only. When summing be sure to use the designation amounts.

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