Composite View Source: AMBPROP

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

**Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
AMBPROP_ACTIVITY_DATE	AMAPROP	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL_MASTER	PROPOSAL_ACTIVITY_DATE
AMBPROP_ASK_AMOUNT		COMPOSITE VIEW	AA_PROSPECT_PROPOSAL_MASTER	PROPOSAL_TARGET_ASK_AMOUNT
AMBPROP_COMMENT	AMAPROP	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL_MASTER	PROPOSAL_COMMENT PROPOSAL_COMMENT	NA
AMBPROP_CREATE_DATE	AMAPROP	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL_MASTER	PROPOSAL_CREATE_DATE
AMBPROP_DUE_DATE	AMAPROP	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL_MASTER AA_PROSPECT_PROPOSAL	PROPOSAL_DUE_DATE PROPOSAL_DUE_DATE	NA
AMBPROP_PIDM	NA	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL_MASTER AA_PROSPECT_STAFF_ASSIGNMENT AA_PROSPECT_PROPOSAL	ENTITY_UID ENTITY_UID ENTITY_UID	NA
AMBPROP_PROP_CODE		COMPOSITE VIEW	AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL_MASTER	PROPOSAL PROPOSAL
AMBPROP_PROP_SEQ_NO	AMAPROP	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL_MASTER	PROPOSAL_SEQUENCE_NUMBER
AMBPROP_PRST_CODE	AMAPROP	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL_MASTER	PROPOSAL_ACTIVE_IND PROPOSAL_STATUS PROPOSAL_STATUS	NA
AMBPROP_PRST_DATE	AMAPROP	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL_MASTER	PROPOSAL_STATUS_DATE PROPOSAL_STATUS_DATE	NA
AMBPROP_STAFF_IDEN_CODE	AMAPROP	COMPOSITE VIEW	AA_PROSPECT_STAFF_ASSIGNMENT AA_PROSPECT_PROPOSAL_MASTER	STAFF_IDEN PROPOSAL_STAFF_IDEN	NA
AMBPROP_STAFF_PIDM	NA	COMPOSITE VIEW	AA_PROSPECT_STAFF_ASSIGNMENT AA_PROSPECT_PROPOSAL_MASTER	STAFF_UID PROPOSAL_STAFF_UID
AMBPROP_USER	AMAPROP	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL_MASTER	PROSPECT_PROPOSAL_USER_ID

Ver: