Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Advancement Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: Z_GIFT_PLEDGE_DONOR - Donor Gift Pledge NEU

Description This view was created to support donor where gifts are summarized for outright gifts and annual giving pledge payments are summarize stored for the fiscal year in which they were received, and multi-year pledge amounts are stored for the fiscal year in which the pledge was made.
Key & Frequency One per person or organization per gift payment or multi-year pledge per fiscal year.
Recommended Search Columns ENTITY_UID, ENTITY_IND
ENTITY_IND
CAMPAIGN
DESIGNATION
ENTITY_UID, GIFT_NUMBER, PLEDGE_NUMBER, CAMPAIGN, DESIGNATION
FISCAL_YEAR
CAMPAIGN, PLEDGE_NUMBER
ENTITY_UID, GIFT_NUMBER, PLEDGE_NUMBER, GIFT_PLEDGE_IND
ENTITY_UID, PLEDGE_NUMBER, GIFT_PLEDGE_IND
ENTITY_UID, PLEDGE_NUMBER, CAMPAIGN, DESIGNATION

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
FISCAL_YEAR Fiscal Year The fiscal year associated with a gift's date, or for pledges, the fiscal year in which was made. Note that the fiscal year runs from July 1 to June 30. VARCHAR2      


Ver: 9.0