Composite View Source: AMBPROP

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

**SGHE 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_MASTER AA_PROSPECT_PROPOSAL	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 AA_PROSPECT_PROPOSAL_MASTER	PROPOSAL_DUE_DATE PROPOSAL_DUE_DATE	NA
AMBPROP_PIDM	NA	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL_MASTER AA_PROSPECT_STAFF_ASSIGNMENT	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_MASTER AA_PROSPECT_PROPOSAL	PROPOSAL_STATUS PROPOSAL_STATUS PROPOSAL_ACTIVE_IND	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_PROPOSAL_MASTER AA_PROSPECT_STAFF_ASSIGNMENT	PROPOSAL_STAFF_IDEN STAFF_IDEN	NA
AMBPROP_STAFF_PIDM	NA	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL_MASTER AA_PROSPECT_STAFF_ASSIGNMENT	PROPOSAL_STAFF_UID STAFF_UID
AMBPROP_USER	AMAPROP	COMPOSITE VIEW	AA_PROSPECT_PROPOSAL_MASTER	PROSPECT_PROPOSAL_USER_ID

Ver: