Composite View Source: AMBPROP

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

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

Ver: 8.3