Composite View Source: AMRPROP

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: AMRPROP Advancement

**Banner Operational Data Store**
Source Column	Source Form	Local Source	Target Type	Target	Target Column	Local Target	Calculation Formula
AMRPROP_ACTIVITY_DATE	AMAPROP	NO	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL_PROJECT	PROPOSAL_ACTIVITY_DATE PROPOSAL_PROJECT_ACTIVITY_DATE	NO NO	NA
AMRPROP_GIVH_CODE	AMAPROP	NO	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL_PROJECT	PROPOSAL_PROJ_GIVH PROJECT_GIVING_VEHICLE	NO NO	NA
AMRPROP_PIDM	AMAPROP	NO	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL_PROJECT	ENTITY_UID	NO
AMRPROP_PROJ_CODE	AMAPROP	NO	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL_PROJECT AA_PROSPECT_PROPOSAL	PROPOSAL_PROJECT PROPOSAL_PROJECT	NO NO	NA
AMRPROP_PROJ_EFF_FROM_DATE	AMAPROP	NO	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL_PROJECT	PROPOSAL_PROJ_EFF_FROM_DATE PROPOSAL_PROJECT_START_DATE	NO NO	NA
AMRPROP_PROJ_EFF_TO_DATE	AMAPROP	NO	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL_PROJECT	PROPOSAL_PROJ_EFF_TO_DATE PROPOSAL_PROJECT_END_DATE	NO NO	NA
AMRPROP_PROJ_TEXT	AMAPROP	NO	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL_PROJECT	PROPOSAL_PROJECT_COMMENT	NO
AMRPROP_PROP_CODE	AMAPROP	NO	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL_PROJECT	PROPOSAL	NO
AMRPROP_PROP_SEQ_NO	AMAPROP	NO	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL_PROJECT	PROPOSAL_SEQUENCE_NUMBER PROPOSAL_SEQUENCE_NUMBER	NO NO
AMRPROP_PRST_CODE	AMAPROP	NO	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL_PROJECT	PROPOSAL_PROJECT_STATUS	NO
AMRPROP_PRST_DATE	AMAPROP	NO	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL_PROJECT	PROPOSAL_PROJECT_STATUS_DATE	NO
AMRPROP_TARGET_ASK_AMOUNT	AMAPROP	NO	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL_PROJECT	PROPOSAL_ASK_AMOUNT PROJECT_TARGET_ASK_AMOUNT	NO NO	NA
AMRPROP_TARGET_ASK_DATE	AMAPROP	NO	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL_PROJECT	PROJECT_TARGET_ASK_DATE	NO
AMRPROP_USER	AMAPROP	NO	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL_PROJECT	PROPOSAL_PROJECT_USER_ID	NO

Ver: