Reporting View Source: AMRPRRS

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column
AMRPRRS_ACTIVITY_DATE	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL_RESULT	PROPOSAL_RESULT_ACTIVITY_DATE
AMRPRRS_CAMPAIGN	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL_RESULT	PROPOSAL_RESULT_CAMPAIGN
AMRPRRS_COMMENT	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL_RESULT	PROPOSAL_RESULT_COMMENT
AMRPRRS_DATA_ORIGIN	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL_RESULT	PROPOSAL_RESULT_DATA_ORIGIN
AMRPRRS_DESG	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL_RESULT	PROPOSAL_RESULT_DESIGNATION
AMRPRRS_GIFT_NO	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL_RESULT	PROPOSAL_RESULT_GIFT_NUMBER
AMRPRRS_PIDM	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL_RESULT	ENTITY_UID
AMRPRRS_PLEDGE_NO	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL_RESULT	PROPOSAL_RESULT_PLEDGE_NUMBER
AMRPRRS_PROJ_CODE	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL_RESULT	PROPOSAL_PROJECT
AMRPRRS_PROP_CODE	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL_RESULT	PROPOSAL
AMRPRRS_PROP_SEQ_NO	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL_RESULT	PROPOSAL_SEQUENCE_NUMBER
AMRPRRS_RESULT_DATE	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL_RESULT	PROPOSAL_RESULT_DATE
AMRPRRS_SEQ_NO	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL_RESULT	PROPOSAL_RESULT_SEQUENCE
AMRPRRS_USER	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL_RESULT	PROPOSAL_RESULT_USER_ID
NVL(AMRPRRS_VALUE,0)	NA	REPORTING VIEW	PROSPECT_PROPOSAL_RESULT	PROPOSAL_RESULT_AMOUNT

Ver: 8.5