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

PS_UP_ACCOUNT_INTV_MV Table

Explanation
This structure is designed to link initiative codes to designations. It enables grouping of funds by school or center defined priorities.

Common Uses

Link all designations that support a specific department, e.g. Radiology.

BUSINESS_UNIT
SESSION_NO
GIFT_NO

BUSINESS_UNIT
SESSION_NO
GIFT_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

• Many designations have multiple codes in this table. Be careful to select only the initiatives of interest, otherwise you may double count gifts.

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