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

Source Column Source Form Target Type Target Target Column Calculation Formula
'N' AMAINFO COMPOSITE VIEW

AA_PROSPECT_STAFF_ASSIGNMENT

PRIMARY_IND

 
AMRSTAF_ACTIVITY_DATE AMAINFO        
AMRSTAF_IDEN_CODE AMACONT COMPOSITE VIEW

AA_PROSPECT_STAFF_ASSIGNMENT

AA_PROSPECT_INFO

AA_CONSTITUENT_STAFF_ASSIGN

AA_CONSTITUENT_CONTACT

AA_CONSTITUENT_PLAN

STAFF_IDEN

PRIMARY_STAFF_ASSIGN_IDEN_CODE

STAFF_IDEN_CODE

PRIMARY_PROSPECT_STAFF_ID

PRIMARY_STAFF_IDEN_CODE

NA
AMRSTAF_PIDM NA COMPOSITE VIEW

AA_CONSTITUENT_STAFF_ASSIGN

AA_PROSPECT_STAFF_ASSIGNMENT

ENTITY_UID

ENTITY_UID

NA
AMRSTAF_PRIMARY_IND AMAINFO COMPOSITE VIEW

AA_CONSTITUENT_STAFF_ASSIGN

PRIMARY_IND

NA
AMRSTAF_SOLICIT_IND NA COMPOSITE VIEW

AA_CONSTITUENT_STAFF_ASSIGN

AA_PROSPECT_STAFF_ASSIGNMENT

SOLICITOR_IND

SOLICITOR_IND

 
AMRSTAF_STAFF_PIDM NA COMPOSITE VIEW

AA_CONSTITUENT_STAFF_ASSIGN

AA_PROSPECT_STAFF_ASSIGNMENT

STAFF_UID

STAFF_UID

NA
AMRSTAF_START_DATE AMAINFO        
AMRSTAF_STATUS_IND AMAINFO        
AMRSTAF_STFT_CODE AMAINFO COMPOSITE VIEW

AA_CONSTITUENT_STAFF_ASSIGN

AA_PROSPECT_INFO

AA_PROSPECT_STAFF_ASSIGNMENT

STAFF_TYPE

PRIMARY_STAFF_ASSIGN_TYPE

STAFF_TYPE

NA
AMRSTAF_USER AMAINFO        


Ver: