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

WHSE_GIFT_DETAIL Table

Explanation
This detailed view of gifts and pledges excludes adjustments and reallocations. It contains gifts and pledges as well as the hard and soft credit entries for both.

WHSE_GIFT_DETAIL_YTD_MV is an alternate version of this table. With an identical structure, it contains only the gifts for the current fiscal year as determined by gift date. Please refer to the WHSE_GIFT_DETAIL data element index for its structure.

Common Uses

Gift analysis

COMPOSITE_KEY

AV_DES_BU
BUSINESS_UNIT
COMMON_ID
DESIGNATION
EMPLID
EXT_ORG_ID
GIFT_DT
GIFT_DT_FISCAL_YEAR
GIFT_NO
REFERENCE_DT
SESSION_NO
WHSE_GIFT_TYPE

WHSE_DESIGNATION
WHSE_HARD_CREDIT
WHSE_SOFT_CREDIT
WHE_TRIBUTE_ALL

• This table contains both hard and soft credit for gifts and pledges but excludes adjustments. All rows are valid for reporting. Use care when producing sums of values in this table because summing both hard and soft credit will produce overstated totals.

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