Reporting View Source: AMRPROP

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

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
AMRPROP_ACTIVITY_DATE	AMAPROP	PROSPECT_PROPOSAL_PROJECT PROSPECT_PROPOSAL	PROPOSAL_PROJECT_ACTIVITY_DATE PROPOSAL_ACTIVITY_DATE
AMRPROP_GIVH_CODE	AMAPROP	PROSPECT_PROPOSAL PROSPECT_PROPOSAL_PROJECT	PROPOSAL_PROJ_GIVH PROJECT_GIVING_VEHICLE
AMRPROP_PIDM	AMAPROP	PROSPECT_PROPOSAL_PROJECT	ENTITY_UID
AMRPROP_PROJ_CODE	AMAPROP	PROSPECT_PROPOSAL_PROJECT PROSPECT_PROPOSAL	PROPOSAL_PROJECT PROPOSAL_PROJECT
AMRPROP_PROJ_EFF_FROM_DATE	AMAPROP	PROSPECT_PROPOSAL PROSPECT_PROPOSAL_PROJECT	PROPOSAL_PROJ_EFF_FROM_DATE PROPOSAL_PROJECT_START_DATE
AMRPROP_PROJ_EFF_TO_DATE	AMAPROP	PROSPECT_PROPOSAL_PROJECT PROSPECT_PROPOSAL	PROPOSAL_PROJECT_END_DATE PROPOSAL_PROJ_EFF_TO_DATE
AMRPROP_PROJ_TEXT	AMAPROP	PROSPECT_PROPOSAL_PROJECT	PROPOSAL_PROJECT_COMMENT
AMRPROP_PROP_CODE	AMAPROP	PROSPECT_PROPOSAL_PROJECT	PROPOSAL
AMRPROP_PROP_SEQ_NO	AMAPROP	PROSPECT_PROPOSAL PROSPECT_PROPOSAL_PROJECT	PROPOSAL_SEQUENCE_NUMBER PROPOSAL_SEQUENCE_NUMBER
AMRPROP_PRST_CODE	AMAPROP	PROSPECT_PROPOSAL_PROJECT	PROPOSAL_PROJECT_STATUS
AMRPROP_PRST_DATE	AMAPROP	PROSPECT_PROPOSAL_PROJECT	PROPOSAL_PROJECT_STATUS_DATE
AMRPROP_TARGET_ASK_AMOUNT	AMAPROP	PROSPECT_PROPOSAL PROSPECT_PROPOSAL_PROJECT	PROPOSAL_ASK_AMOUNT PROJECT_TARGET_ASK_AMOUNT
AMRPROP_TARGET_ASK_DATE	AMAPROP	PROSPECT_PROPOSAL_PROJECT	PROJECT_TARGET_ASK_DATE
AMRPROP_USER	AMAPROP	PROSPECT_PROPOSAL_PROJECT	PROPOSAL_PROJECT_USER_ID

Ver: 8.3