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..
Questions about this page? Email us at da-staff@isc.upenn.edu
|