Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: AMRPROP Advancement Reporting View Meta Data Reports
SGHE Banner Operational Data Store Reporting View Source: AMRPROP - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
AMRPROP_ACTIVITY_DATE AMAPROP

REPORTING VIEW

PROSPECT_PROPOSAL_PROJECT

PROSPECT_PROPOSAL

PROPOSAL_PROJECT_ACTIVITY_DATE

PROPOSAL_ACTIVITY_DATE

NA
AMRPROP_GIVH_CODE AMAPROP

REPORTING VIEW

PROSPECT_PROPOSAL

PROSPECT_PROPOSAL_PROJECT

PROPOSAL_PROJ_GIVH

PROJECT_GIVING_VEHICLE

NA
AMRPROP_PIDM AMAPROP

REPORTING VIEW

PROSPECT_PROPOSAL_PROJECT

ENTITY_UID

 
AMRPROP_PROJ_CODE AMAPROP

REPORTING VIEW

PROSPECT_PROPOSAL_PROJECT

PROSPECT_PROPOSAL

PROPOSAL_PROJECT

PROPOSAL_PROJECT

NA
AMRPROP_PROJ_EFF_FROM_DATE AMAPROP

REPORTING VIEW

PROSPECT_PROPOSAL

PROSPECT_PROPOSAL_PROJECT

PROPOSAL_PROJ_EFF_FROM_DATE

PROPOSAL_PROJECT_START_DATE

NA
AMRPROP_PROJ_EFF_TO_DATE AMAPROP

REPORTING VIEW

PROSPECT_PROPOSAL_PROJECT

PROSPECT_PROPOSAL

PROPOSAL_PROJECT_END_DATE

PROPOSAL_PROJ_EFF_TO_DATE

NA
AMRPROP_PROJ_TEXT AMAPROP

REPORTING VIEW

PROSPECT_PROPOSAL_PROJECT

PROPOSAL_PROJECT_COMMENT

 
AMRPROP_PROP_CODE AMAPROP

REPORTING VIEW

PROSPECT_PROPOSAL_PROJECT

PROPOSAL

 
AMRPROP_PROP_SEQ_NO AMAPROP

REPORTING VIEW

PROSPECT_PROPOSAL

PROSPECT_PROPOSAL_PROJECT

PROPOSAL_SEQUENCE_NUMBER

PROPOSAL_SEQUENCE_NUMBER

 
AMRPROP_PRST_CODE AMAPROP

REPORTING VIEW

PROSPECT_PROPOSAL_PROJECT

PROPOSAL_PROJECT_STATUS

 
AMRPROP_PRST_DATE AMAPROP

REPORTING VIEW

PROSPECT_PROPOSAL_PROJECT

PROPOSAL_PROJECT_STATUS_DATE

 
AMRPROP_TARGET_ASK_AMOUNT AMAPROP

REPORTING VIEW

PROSPECT_PROPOSAL

PROSPECT_PROPOSAL_PROJECT

PROPOSAL_ASK_AMOUNT

PROJECT_TARGET_ASK_AMOUNT

NA
AMRPROP_TARGET_ASK_DATE AMAPROP

REPORTING VIEW

PROSPECT_PROPOSAL_PROJECT

PROJECT_TARGET_ASK_DATE

 
AMRPROP_USER AMAPROP

REPORTING VIEW

PROSPECT_PROPOSAL_PROJECT

PROPOSAL_PROJECT_USER_ID

 


Ver: 9.0