Reporting View Source: EXPRESSION

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: EXPRESSION Common Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column
(CAMPAIGN_SOLICITOR_GOAL / CAMPAIGN_GOAL * 100)	NA	REPORTING VIEW REPORTING VIEW	CAMPAIGN_FUNDRAISER CAMPAIGN_FUNDRAISER	SOLICITOR_PCT_OF_CAMPAIGN_GOAL SOLICITOR_PCT_OF_CAMPAIGN_GOAL
CASE WHEN (CAMPAIGN_GOAL > 0	NA	REPORTING VIEW REPORTING VIEW	CAMPAIGN_FUNDRAISER CAMPAIGN_FUNDRAISER	PCT_SOLC_PROGRESS_CAMP_GOAL PCT_SOLC_PROGRESS_CAMP_GOAL
DECODE (AMRPLAN_PROJ_CODE, AMRCONT_PROJ_CODE	NA	REPORTING VIEW REPORTING VIEW	PROSPECT_MOVES_MANAGEMENT PROSPECT_MOVES_MANAGEMENT	PRIMARY_PROJECT_IND PRIMARY_PROJECT_IND
DECODE (APRIGRP_DISP_WEB_IND, 'Y', 'Y', 'N')	NA	REPORTING VIEW	INTEREST	DISPLAY_WEB_IND
NVL(CASE WHEN(CAMPAIGN_SOLICITOR_GOAL > 0	TBD	REPORTING VIEW REPORTING VIEW	CAMPAIGN_FUNDRAISER CAMPAIGN_FUNDRAISER	PCT_PROGRESS_SOLICITOR_GOAL PCT_PROGRESS_SOLICITOR_GOAL

Ver: 9.0