Banner EDW Source: AMBPROP

RETURN TO BANNER EDW META DATA REPORTS LIST

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
AMBPROP_ACTIVITY_DATE	NO	REPORTING VIEW	PROSPECT_PROPOSAL_MASTER	PROPOSAL_ACTIVITY_DATE	NA	NO
AMBPROP_ASK_AMOUNT	NO	FACT TABLE REPORTING VIEW	WFT_PROPOSAL PROSPECT_PROPOSAL_MASTER	PROPOSAL_TARGET_AMOUNT PROPOSAL_TARGET_ASK_AMOUNT	PROPOSAL NA	NO NO
AMBPROP_COMMENT	NO	REPORTING VIEW	PROSPECT_PROPOSAL PROSPECT_PROPOSAL_MASTER	PROPOSAL_COMMENT PROPOSAL_COMMENT	NA NA	NO NO
AMBPROP_CREATE_DATE	NO	REPORTING VIEW	PROSPECT_PROPOSAL_MASTER	PROPOSAL_CREATE_DATE	NA	NO
AMBPROP_DUE_DATE	NO	REPORTING VIEW	PROSPECT_PROPOSAL_MASTER PROSPECT_PROPOSAL	PROPOSAL_DUE_DATE PROPOSAL_DUE_DATE	NA NA	NO NO
AMBPROP_PIDM	NO	REPORTING VIEW	PROSPECT_PROPOSAL PROSPECT_PROPOSAL_MASTER PROSPECT_STAFF_ASSIGNMENT	ENTITY_UID ENTITY_UID ENTITY_UID	NA NA NA	NO NO NO
AMBPROP_PROP_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_PROPOSAL_ATTRIBUTE PROSPECT_PROPOSAL PROSPECT_PROPOSAL_MASTER	PROPOSAL_TYPE PROPOSAL PROPOSAL	CONTACT REPORT, MANAGE PROSPECT PIPELINE, PROPOSAL NA NA	NO NO NO
AMBPROP_PROP_SEQ_NO	NO	REPORTING VIEW	PROSPECT_PROPOSAL_MASTER	PROPOSAL_SEQUENCE_NUMBER	NA	NO
AMBPROP_PRST_CODE	NO	REPORTING VIEW	PROSPECT_PROPOSAL PROSPECT_PROPOSAL_PROJECT PROSPECT_PROPOSAL_MASTER	PROPOSAL_STATUS PROPOSAL_STATUS PROPOSAL_STATUS	NA NA NA	NO NO NO
AMBPROP_PRST_DATE	NO	REPORTING VIEW	PROSPECT_PROPOSAL_PROJECT PROSPECT_PROPOSAL PROSPECT_PROPOSAL_MASTER	PROPOSAL_STATUS_DATE PROPOSAL_STATUS_DATE PROPOSAL_STATUS_DATE	NA NA NA	NO NO NO
AMBPROP_STAFF_IDEN_CODE	NO	REPORTING VIEW	PROSPECT_PROPOSAL PROSPECT_PROPOSAL_MASTER PROSPECT_STAFF_ASSIGNMENT	PROPOSAL_STAFF_IDEN PROPOSAL_STAFF_IDEN STAFF_IDEN	NA NA NA	NO NO NO
AMBPROP_STAFF_PIDM	NO	REPORTING VIEW	PROSPECT_STAFF_ASSIGNMENT PROSPECT_PROPOSAL_MASTER	STAFF_UID PROPOSAL_STAFF_UID	NA NA	NO NO
AMBPROP_USER	NO	REPORTING VIEW	PROSPECT_PROPOSAL_MASTER	PROSPECT_PROPOSAL_USER_ID	NA	NO

Ver: 9.0