Composite View Source: AMRPROP

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

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

Ver: