Reporting View Target: ASC_GIFT_TOTALS_BY FISCALYEAR

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

SGHE Banner Operational Data Store
Reporting View Target: ASC_GIFT_TOTALS_BY FISCALYEAR - ASC GIFT TOTALS BY FISCALYEAR

Description ASC Gift Totals By Fiscal Year was created to enable historical reporting. It is a custom view that goes against the ASC Gift and ASC Pledge folders for each entity in ASC Constituent.
Key & Frequency Entity_UID

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ENTITY_UID ENTITY_UID Northeastern University generated, unique identification number assigned to an entity (typically and individual). Key identifying number used to join with other tables. IDENTIFIER

LT_GIFT_COUNT Count of all gifts for which this donor was the primary donor NUMBER

LT_PLEDGES Sum of pledge amounts for this donor NUMBER

Ver: 9.0

Description	ASC Gift Totals By Fiscal Year was created to enable historical reporting. It is a custom view that goes against the ASC Gift and ASC Pledge folders for each entity in ASC Constituent.
Key & Frequency	Entity_UID

Target Column	Business Name	Business Definition	Database Data Type
ENTITY_UID	ENTITY_UID	Northeastern University generated, unique identification number assigned to an entity (typically and individual). Key identifying number used to join with other tables.	IDENTIFIER
LT_GIFT_COUNT		Count of all gifts for which this donor was the primary donor	NUMBER
LT_PLEDGES		Sum of pledge amounts for this donor	NUMBER