Composite View Source: AMRSTAF

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: AMRSTAF Advancement

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
'N'	AMAINFO	COMPOSITE VIEW	AA_PROSPECT_STAFF_ASSIGNMENT	PRIMARY_IND
AMRSTAF_ACTIVITY_DATE	TBD
AMRSTAF_IDEN_CODE	AMACONT	COMPOSITE VIEW	AA_PROSPECT_STAFF_ASSIGNMENT AA_PROSPECT_INFO AA_CONSTITUENT_STAFF_ASSIGN AA_CONSTITUENT_CONTACT AA_CONSTITUENT_PLAN	STAFF_IDEN PRIMARY_STAFF_ASSIGN_IDEN_CODE STAFF_IDEN_CODE PRIMARY_PROSPECT_STAFF_ID PRIMARY_STAFF_IDEN_CODE	NA
AMRSTAF_PIDM	NA	COMPOSITE VIEW	AA_CONSTITUENT_STAFF_ASSIGN AA_PROSPECT_STAFF_ASSIGNMENT	ENTITY_UID ENTITY_UID	NA
AMRSTAF_PRIMARY_IND	AMAINFO	COMPOSITE VIEW	AA_CONSTITUENT_STAFF_ASSIGN	PRIMARY_IND	NA
AMRSTAF_SOLICIT_IND	NA	COMPOSITE VIEW	AA_CONSTITUENT_STAFF_ASSIGN AA_PROSPECT_STAFF_ASSIGNMENT	SOLICITOR_IND SOLICITOR_IND
AMRSTAF_STAFF_PIDM	NA	COMPOSITE VIEW	AA_CONSTITUENT_STAFF_ASSIGN AA_PROSPECT_STAFF_ASSIGNMENT	STAFF_UID STAFF_UID	NA
AMRSTAF_START_DATE	AMAINFO
AMRSTAF_STATUS_IND	AMAINFO
AMRSTAF_STFT_CODE	AMAINFO	COMPOSITE VIEW	AA_CONSTITUENT_STAFF_ASSIGN AA_PROSPECT_INFO AA_PROSPECT_STAFF_ASSIGNMENT	STAFF_TYPE PRIMARY_STAFF_ASSIGN_TYPE STAFF_TYPE	NA
AMRSTAF_USER	AMAINFO
SYSDATE	TBD

Ver: