Penn Computing

University of Pennsylvania
Penn Computing << go backback
WHSE_DESIGNATION Table - Data Element Index   Tables and Data Elements   Advancement Home   Data Warehouse Home

WHSE_DESIGNATION Table

Explanation
This table contains the most current information for all Atlas gift designations (often called gift funds). Each SETID/DESIGNATION represents a project, area, or fund receiving gifts. Most Atlas designations represent a general ledger account. When this is true, the general ledger attributes are provided. The primary source for the data in this table is the maximum effective dated row of PS_AV_ACCOUNT_TBL.

Common Uses

This table is frequently used to display the formal name of an Atlas designation.

Primary Key Indexed Data Elements Related Tables
SETID
DESIGNATION
AV_DES_NAME
DESIGNATION
EFFDT
SETID
PS_AV_ACCOUNT_TBL
WHSE_ACTN_GIFT_MV
WHSE_CAMP_DETAIL_MV
WHSE_CAMPAIGN_INTV_MV
WHSE_GIFT_DETAIL
WHSE_GIFT_DETAIL_BEN_MV
WHSE_GIFT_DETAIL_BEN_YTD_MV
WHSE_GIFT_DETAIL_MV
WHSE_GIFT_DETAIL_YTD_MV
WHSE_GIFT_SUMMARY
WHSE_LIFE_GIFT_SUMMARY_MV
WHSE_OPEN_PLEDGES_SUMMARY
WHSE_PLEDGE_DISCOUNT_MV
WHSE_TRANSACTION_DETAIL

Cautions
  • It is possible for multiple Atlas designations to map to the same general ledger account..
WHSE_CONSTITUENTS Table - Data Element Index   Tables and Data Elements   Advancement Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania