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

SGHE Banner Operational Data Store
Reporting View Target: ASC_PLEDGE - Advancement Specific Pledge

Description ASC Pledge was created to consolidate data from several pledge sources, and to include hard, soft, and vehicle credits. Hard credits are gifts or pledges associated with a primary donor. Soft credits represent additional donors associated to the same gift. This often happens when a spouse is associated with a gift. One spouse will be given the status of primary donor, and the gift record that includes that spouse ID will be designated the hard credit. A similar record will exist for the other spouse, but the record will be designated a soft credit. This folder contains multiple gift records for the same gift if there are multiple donors. The primary donor will have the Donation Entity_UID equal to the Donor Entity_UID and will have a Donation Credit Type of ‘H’. Any secondary donors will have a record where the Donor Entity_UID refers to the secondary donor and where the Donation Entity_UID refers to the primary donor, and the Donation Credit Type will be ‘S’.
Key & Frequency Donation_Entity_UID

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
DONATION_CREDIT_TYPE DONATION CREDIT TYPE Indicates (‘H’) hard or (‘S’) credits CHAR H,S    
DONATION_ENTITY_UID DONATION ENTITY UID UID used to link primary donor to ASC Constituent or other folders IDENTIFIER      
DONOR_ENTITY_UID DONOR ENTITY UID UID used to link any related donor to ASC Constituent or other folders IDENTIFIER      
ENTRY DATE ENTRY DATE ENTRY DATE DATE      


Ver: 9.0