Reporting View Source: AMRPRRT

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
ACTIVE_PROSPECT_IND_LD_EXPRESSION	TBD				case when ATVPRST_ACTIVE_IND = null or ATVPRST_ACTIVE_IND ='Y' THEN 'Yes' ELSE 'No' end
ACTIVE_PROSPECT_IND_SD_EXPRESSION	TBD				case when ATVPRST_ACTIVE_IND = null or ATVPRST_ACTIVE_IND ='Y' THEN 'Yes' ELSE 'No' end
AMRPRRT_ACTIVITY_DATE	AMAINFO	REPORTING VIEW	ADVANCEMENT_RATING	RATING_DATE	NA
AMRPRRT_PIDM	NA	REPORTING VIEW	ADVANCEMENT_RATING_SLOT ADVANCEMENT_RATING	ENTITY_UID ENTITY_UID	NA
AMRPRRT_PRIMARY_IND	AMAINFO	REPORTING VIEW	ADVANCEMENT_RATING	PRIMARY_IND	NA
AMRPRRT_RATE_CODE	AMAINFO	REPORTING VIEW	ADVANCEMENT_RATING_SLOT ADVANCEMENT_RATING_SLOT ADVANCEMENT_RATING ADVANCEMENT_RATING_SLOT	RATING3 RATING2 RATING RATING1	NA
AMRPRRT_RSCR_CODE	AMAINFO	REPORTING VIEW	ADVANCEMENT_RATING	SCREENING	NA
AMRPRRT_RTGT_CODE	AMAINFO	REPORTING VIEW	ADVANCEMENT_RATING_SLOT ADVANCEMENT_RATING_SLOT ADVANCEMENT_RATING_SLOT ADVANCEMENT_RATING	RATING_TYPE1 RATING_TYPE3 RATING_TYPE2 RATING_TYPE	NA
PROSPECT_RATING_EXPRESSION	TBD				AMRPRRT_RATE_CODE

Ver: 8.4.1