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**
Banner Source Column	Source Form	ODS Target	ODS Target Column
'N'	AMAINFO
AMRSTAF_ACTIVITY_DATE	AMAINFO
AMRSTAF_IDEN_CODE	AMACONT	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
AMRSTAF_PIDM	NA	PROSPECT_STAFF_ASSIGNMENT CONSTITUENT_STAFF_ASSIGN	ENTITY_UID ENTITY_UID
AMRSTAF_PRIMARY_IND	AMAINFO	PROSPECT_STAFF_ASSIGNMENT CONSTITUENT_STAFF_ASSIGN	PRIMARY_IND PRIMARY_IND
AMRSTAF_SOLICIT_IND	NA	PROSPECT_STAFF_ASSIGNMENT CONSTITUENT_STAFF_ASSIGN	SOLICITOR_IND SOLICITOR_IND
AMRSTAF_STAFF_PIDM	NA	CONSTITUENT_STAFF_ASSIGN PROSPECT_STAFF_ASSIGNMENT	STAFF_UID STAFF_UID
AMRSTAF_STATUS_IND	TBD
AMRSTAF_STFT_CODE	AMAINFO	CONSTITUENT_STAFF_ASSIGN PROSPECT_STAFF_ASSIGNMENT PROSPECT_INFO	STAFF_TYPE STAFF_TYPE PRIMARY_STAFF_ASSIGN_TYPE
AMRSTAF_USER	AMAINFO

Ver: 8.3