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_IDEN_CODE AMACONT

REPORTING VIEW

PROSPECT_STAFF_ASSIGNMENT

CONSTITUENT_CONTACT

CONSTITUENT_STAFF_ASSIGN

PROSPECT_INFO

CONSTITUENT_PLAN

STAFF_IDEN

PRIMARY_STAFF_IDEN

STAFF_IDEN

PRIMARY_STAFF_ASSIGN_IDEN

PRIMARY_STAFF_IDEN

NA
AMRSTAF_PIDM NA

REPORTING VIEW

CONSTITUENT_STAFF_ASSIGN

PROSPECT_STAFF_ASSIGNMENT

ENTITY_UID

ENTITY_UID

NA
AMRSTAF_PRIMARY_IND AMAINFO

REPORTING VIEW

CONSTITUENT_STAFF_ASSIGN

PROSPECT_STAFF_ASSIGNMENT

PRIMARY_IND

PRIMARY_IND

NA
AMRSTAF_SOLICIT_IND NA

REPORTING VIEW

CONSTITUENT_STAFF_ASSIGN

PROSPECT_STAFF_ASSIGNMENT

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_ASSIGN_STATUS_IND_DESC

STAFF_ASSIGNMENT_STATUS_IND

 
AMRSTAF_STFT_CODE AMAINFO

REPORTING VIEW

PROSPECT_STAFF_ASSIGNMENT

CONSTITUENT_STAFF_ASSIGN

PROSPECT_INFO

STAFF_TYPE

STAFF_TYPE

PRIMARY_STAFF_ASSIGN_TYPE

NA


Ver: 8.5