RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: AMRCONT Advancement Composite View Reports
SGHE Operational Data Store Composite View Source: AMRCONT

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

AA_CONSTITUENT_CONTACT

AA_CONSTITUENT_PLAN

ASKING_AMOUNT

ASKING_AMOUNT

NA
AMRCONT_CONTACT AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

CONTACT_COMMENT

NA
AMRCONT_CONTACT_DATE AMACONT COMPOSITE VIEW

AA_CONSTITUENT_PLAN

AA_CONSTITUENT_CONTACT

MOVE_COMPLETION_DATE

CONTACT_DATE

NA
AMRCONT_IDEN_CODE AMACONT COMPOSITE VIEW

AA_CONSTITUENT_PLAN

AA_CONSTITUENT_CONTACT

AA_CONSTITUENT_CONTACT

AA_CONSTITUENT_PLAN

PERSON_COMPLETED_CONTACT_ID

OFFICE_RESPONSIBLE_CONTACT

PERSON_RESPONSIBLE_ID

PERSON_RESPONSIBLE_ID

NA
AMRCONT_IDEN_CODE_ASGN AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

PERSON_COMPLETED_CONTACT_ID

NA
AMRCONT_ITEM_REFNO AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

AA_CONSTITUENT_PLAN

ITEM_REF_NUMBER

ITEM_REF_NUMBER

NA
AMRCONT_MOVE_CODE AMACONT COMPOSITE VIEW

AA_CONSTITUENT_PLAN

AA_CONSTITUENT_CONTACT

UNPLANNED_MOVE

MOVE

NA
AMRCONT_PIDM NA COMPOSITE VIEW

AA_CONSTITUENT_PLAN

AA_CONSTITUENT_CONTACT

PERSON_UID

PERSON_UID

NA
AMRCONT_PROJ_CODE AMACONT COMPOSITE VIEW

AA_CONSTITUENT_PLAN

AA_CONSTITUENT_CONTACT

PROJECT

PROJECT

NA
AMRCONT_SCNT_CODE AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

AA_CONSTITUENT_CONTACT

CONTACT

CONTACT_TYPE

NA
AMRCONT_TICKLER AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

AA_CONSTITUENT_PLAN

TICKLER_MESSAGE

TICKLER_MESSAGE

NA
AMRCONT_TICK_DATE AMACONT COMPOSITE VIEW

AA_CONSTITUENT_CONTACT

AA_CONSTITUENT_PLAN

TICKLER_DATE

TICKLER_DATE

NA


Ver: 3.1