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

Source Column Source Form Target Type Target Target Column Calculation Formula
'N' AMAINFO        
AMRSTAF_ACTIVITY_DATE AMAINFO        
AMRSTAF_IDEN_CODE AMACONT

REPORTING VIEW

CONSTITUENT_CONTACT

PROSPECT_INFO

PROSPECT_STAFF_ASSIGNMENT

CONSTITUENT_PLAN

CONSTITUENT_STAFF_ASSIGN

PRIMARY_STAFF_IDEN

PRIMARY_STAFF_ASSIGN_IDEN

STAFF_IDEN

PRIMARY_STAFF_IDEN

STAFF_IDEN

NA
AMRSTAF_PIDM NA

REPORTING VIEW

PROSPECT_STAFF_ASSIGNMENT

CONSTITUENT_STAFF_ASSIGN

ENTITY_UID

ENTITY_UID

NA
AMRSTAF_PRIMARY_IND AMAINFO

REPORTING VIEW

PROSPECT_STAFF_ASSIGNMENT

CONSTITUENT_STAFF_ASSIGN

PRIMARY_IND

PRIMARY_IND

NA
AMRSTAF_SOLICIT_IND NA

REPORTING VIEW

PROSPECT_STAFF_ASSIGNMENT

CONSTITUENT_STAFF_ASSIGN

SOLICITOR_IND

SOLICITOR_IND

 
AMRSTAF_STAFF_PIDM NA

REPORTING VIEW

CONSTITUENT_STAFF_ASSIGN

PROSPECT_STAFF_ASSIGNMENT

STAFF_UID

STAFF_UID

NA
AMRSTAF_START_DATE AMAINFO

REPORTING VIEW

PROSPECT_STAFF_ASSIGNMENT

STAFF_ASSIGNMENT_START_DATE

 
AMRSTAF_STATUS_IND AMAINFO

REPORTING VIEW

PROSPECT_STAFF_ASSIGNMENT

PROSPECT_STAFF_ASSIGNMENT

STAFF_ASSIGNMENT_STATUS_IND

STAFF_ASSIGN_STATUS_IND_DESC

 
AMRSTAF_STFT_CODE AMAINFO

REPORTING VIEW

CONSTITUENT_STAFF_ASSIGN

PROSPECT_STAFF_ASSIGNMENT

PROSPECT_INFO

STAFF_TYPE

STAFF_TYPE

PRIMARY_STAFF_ASSIGN_TYPE

NA
AMRSTAF_USER AMAINFO        


Ver: 9.0