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

WHSE_TRANSACTION_DETAIL Table

Explanation
This is the most thorough source of gift data include all gifts, pledges, and their adjustments.

Common Uses

This table will be used in almost every report that reveals constituent specific data.

COMPOSITE_KEY

COLUMN_NAME
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_GIFT_DETAIL
WHSE_DESIGNATIONS

• This table contains adjustments to gifts and pledges as well as both hard and soft credit. Use care when producing sums of values in this table.

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