Reporting View Source: AMBPROP

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: AMBPROP Advancement Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
AMBPROP_ACTIVITY_DATE	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL_MASTER	PROPOSAL_ACTIVITY_DATE
AMBPROP_ASK_AMOUNT		REPORTING VIEW	PROSPECT_PROPOSAL_MASTER	PROPOSAL_TARGET_ASK_AMOUNT
AMBPROP_COMMENT	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL PROSPECT_PROPOSAL_MASTER	PROPOSAL_COMMENT PROPOSAL_COMMENT	NA
AMBPROP_CREATE_DATE	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL_MASTER	PROPOSAL_CREATE_DATE
AMBPROP_DUE_DATE	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL PROSPECT_PROPOSAL_MASTER	PROPOSAL_DUE_DATE PROPOSAL_DUE_DATE	NA
AMBPROP_PIDM	NA	REPORTING VIEW	PROSPECT_STAFF_ASSIGNMENT PROSPECT_PROPOSAL PROSPECT_PROPOSAL_MASTER	ENTITY_UID ENTITY_UID ENTITY_UID	NA
AMBPROP_PROP_CODE		REPORTING VIEW	PROSPECT_PROPOSAL_MASTER PROSPECT_PROPOSAL	PROPOSAL PROPOSAL
AMBPROP_PROP_SEQ_NO	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL_MASTER	PROPOSAL_SEQUENCE_NUMBER
AMBPROP_PRST_CODE	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL PROSPECT_PROPOSAL_MASTER PROSPECT_PROPOSAL_PROJECT	PROPOSAL_STATUS PROPOSAL_STATUS PROPOSAL_STATUS	NA
AMBPROP_PRST_DATE	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL PROSPECT_PROPOSAL_MASTER PROSPECT_PROPOSAL_PROJECT	PROPOSAL_STATUS_DATE PROPOSAL_STATUS_DATE PROPOSAL_STATUS_DATE	NA
AMBPROP_STAFF_IDEN_CODE	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL PROSPECT_STAFF_ASSIGNMENT PROSPECT_PROPOSAL_MASTER	PROPOSAL_STAFF_IDEN STAFF_IDEN PROPOSAL_STAFF_IDEN	NA
AMBPROP_STAFF_PIDM	NA	REPORTING VIEW	PROSPECT_STAFF_ASSIGNMENT PROSPECT_PROPOSAL_MASTER	STAFF_UID PROPOSAL_STAFF_UID
AMBPROP_USER	AMAPROP	REPORTING VIEW	PROSPECT_PROPOSAL_MASTER	PROSPECT_PROPOSAL_USER_ID

Ver: 8.5