Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: AMRCONT Advancement
SGHE Banner Operational Data Store Composite View Source: AMRCONT - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
AMRCONT_ACTIVITY_DATE AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

PROSPECT_CONTACT_ACTIVITY_DATE

 
AMRCONT_ASK_AMT AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

AA_CONSTITUENT_PLAN

AA_PROSPECT_MOVES_MANAGEMENT

ASKING_AMOUNT

ASKING_AMOUNT

ASK_AMOUNT

 
AMRCONT_ASK_AMT_2 AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

ASK_AMOUNT2

 
AMRCONT_ASK_AMT_3 AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

ASK_AMOUNT3

 
AMRCONT_ASK_AMT_4 AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

ASK_AMOUNT4

 
AMRCONT_CALL_REPORT AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

CALL_REPORT_COMMENT

 
AMRCONT_CONTACT AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

CONTACT_COMMENT

 
AMRCONT_CONTACT_DATE AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

AA_CONSTITUENT_PLAN

AA_PROSPECT_MOVES_MANAGEMENT

CONTACT_DATE

MOVE_COMPLETION_DATE

MOVE_COMPLETION_DATE

 
AMRCONT_CREATE_DATE AMRCONT        
AMRCONT_CREATE_TICKLER AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

CREATE_TICKLER_IND

 
AMRCONT_IDEN_CODE AMACONT COMPOSITE VIEW

AA_PROSPECT_MOVES_MANAGEMENT

AA_CONSTITUENT_CONTACT

AA_CONSTITUENT_PLAN

AA_PROSPECT_MOVES_MANAGEMENT

AA_PROSPECT_STAFF_ASSIGNMENT

AA_CONSTITUENT_PLAN

PERSON_COMPLETED_CONTACT_IDEN

PERSON_RESPONSIBLE_ID

PERSON_COMPLETED_CONTACT_ID

PERSON_RESPONSIBLE_IDEN

STAFF_IDEN

PERSON_RESPONSIBLE_ID

 
AMRCONT_IDEN_CODE_ASGN AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

PERSON_COMPLETED_CONTACT_ID

NA
AMRCONT_ITEM_REFNO AMACONT COMPOSITE VIEW

AA_PROSPECT_MOVES_MANAGEMENT

AA_CONSTITUENT_PLAN

AA_CONSTITUENT_CONTACT

ITEM_REF_NUMBER

ITEM_REF_NUMBER

ITEM_REF_NUMBER

NA
AMRCONT_MOVE_CODE AMACONT COMPOSITE VIEW

AA_CONSTITUENT_PLAN

AA_PROSPECT_MOVES_MANAGEMENT

AA_CONSTITUENT_CONTACT

UNPLANNED_MOVE

MOVE

MOVE

 
AMRCONT_MOVE_SEQ_NO AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

PLAN_MOVE_SEQUENCE_NUMBER

 
AMRCONT_PIDM AMACONT COMPOSITE VIEW

AA_PROSPECT_MOVES_MANAGEMENT

AA_CONSTITUENT_CONTACT

AA_CONSTITUENT_PLAN

AA_PROSPECT_STAFF_ASSIGNMENT

ENTITY_UID

PERSON_UID

PERSON_UID

ENTITY_UID

NA
AMRCONT_PROJ_CODE AMACONT COMPOSITE VIEW

AA_PROSPECT_MOVES_MANAGEMENT

AA_CONSTITUENT_CONTACT

AA_CONSTITUENT_PLAN

PROJECT

PROJECT

PROJECT

NA
AMRCONT_PROJ_CODE_2 AMACONT COMPOSITE VIEW

AA_PROSPECT_MOVES_MANAGEMENT

AA_CONSTITUENT_CONTACT

PROJECT

PROJECT2

 
AMRCONT_PROJ_CODE_3 AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

AA_PROSPECT_MOVES_MANAGEMENT

AA_CONSTITUENT_CONTACT

PROJECT3

PROJECT

PROJECT4

 
AMRCONT_PROJ_CODE_4 AMACONT COMPOSITE VIEW

AA_PROSPECT_MOVES_MANAGEMENT

PROJECT

 
AMRCONT_PROP_CODE AMACONT COMPOSITE VIEW

AA_PROSPECT_MOVES_MANAGEMENT

AA_CONSTITUENT_CONTACT

PROPOSAL

PROPOSAL

 
AMRCONT_PROP_SEQ_NO AMACONT COMPOSITE VIEW

AA_PROSPECT_MOVES_MANAGEMENT

AA_CONSTITUENT_CONTACT

PROPOSAL_SEQUENCE_NUMBER

PROPOSAL_SEQUENCE_NUMBER

 
AMRCONT_SCNT_CODE AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

CONTACT_TYPE

 
AMRCONT_STGY_PLAN AMACONT COMPOSITE VIEW

AA_PROSPECT_MOVES_MANAGEMENT

AA_CONSTITUENT_CONTACT

STRATEGY_PLAN

STRATEGY_PLAN

 
AMRCONT_TICKLER AMACONT COMPOSITE VIEW

AA_CONSTITUENT_PLAN

AA_CONSTITUENT_CONTACT

TICKLER_MESSAGE

TICKLER_MESSAGE

 
AMRCONT_TICK_DATE AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

AA_CONSTITUENT_PLAN

TICKLER_DATE

TICKLER_DATE

NA
AMRCONT_TICK_STATUS AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

RECENT_TICKLER_STATUS

 
AMRCONT_USER_ID AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

PROSPECT_CONTACT_USER_ID

 
AMRPEXP_ACTIVITY_DATE AMACONT COMPOSITE VIEW

AA_PROSPECT_CONTACT_EXPENSE

CONTACT_EXPENSE_ACTIVITY_DATE

 
DECODE(TO_CHAR(AMRCONT_MOVE_SEQNO),NULL, 'N','Y') CALCULATION        


Ver: