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_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