Reporting View Source: AMRSTAF

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: AMRSTAF Advancement Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
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