Composite View Source: AFRCTYP

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column
AFRCTYP_ACTIVITY_DATE	AFACSLT	COMPOSITE VIEW	AA_SOLICITOR_ASSIGNMENT	SOLICITOR_ASSIGN_ACTIVITY_DATE
AFRCTYP_ASK_AMOUNT	AFACSLT	COMPOSITE VIEW	AA_SOLICITOR_ASSIGNMENT	ASK_AMOUNT
AFRCTYP_ASK_DATE	AFACSLT	COMPOSITE VIEW	AA_SOLICITOR_ASSIGNMENT	ASK_DATE
AFRCTYP_ASSSIGN_DATE	AFACSLT	COMPOSITE VIEW	AA_SOLICITOR_ASSIGNMENT	ASSIGN_DATE
AFRCTYP_CAMPAIGN	AFACSLT	COMPOSITE VIEW	AA_SOLICITOR_ASSIGNMENT	CAMPAIGN
AFRCTYP_COMMENT	AFACSLT	COMPOSITE VIEW	AA_SOLICITOR_ASSIGNMENT	ASSIGNMENT_COMMENT
AFRCTYP_CONSTITUENT_PIDM	AFACSLT	COMPOSITE VIEW	AA_SOLICITOR_ASSIGNMENT	ENTITY_UID
AFRCTYP_DCYR_CODE	AGAGIFT	COMPOSITE VIEW	AA_SOLICITOR_ASSIGNMENT	SOLICITATION_YEAR
AFRCTYP_PIDM	AFACSLT	COMPOSITE VIEW	AA_SOLICITOR_ASSIGNMENT	SOLICITOR_UID
AFRCTYP_RATER_PIDM	AFACSLT	COMPOSITE VIEW	AA_SOLICITOR_ASSIGNMENT	RATER_UID
AFRCTYP_RATE_CODE	AFACSLT	COMPOSITE VIEW	AA_SOLICITOR_ASSIGNMENT	RATING
AFRCTYP_RSCR_CODE	AFACSLT	COMPOSITE VIEW	AA_SOLICITOR_ASSIGNMENT	SCREENING
AFRCTYP_SEQ_NO	AFACSLT	COMPOSITE VIEW	AA_SOLICITOR_ASSIGNMENT	ASSIGNMENT_SEQUENCE_NUMBER
AFRCTYP_SOLC_CODE	AFACSLT	COMPOSITE VIEW	AA_SOLICITOR_ASSIGNMENT	SOLICITATION_TYPE
AFRCTYP_SOL_ORG	AFACSLT	COMPOSITE VIEW	AA_SOLICITOR_ASSIGNMENT	SOLICITOR_ORGANIZATION
AFRCTYP_USER	AFACSLT	COMPOSITE VIEW	AA_SOLICITOR_ASSIGNMENT	SOLICITOR_ASSIGN_USER_ID
DECODE (AFRCTYP_PIDM, NULL, 'N', 'Y')	TBD
DECODE (AFRCTYP_PIDM, NULL, 'N)	TBD	COMPOSITE VIEW	AA_SOLICITOR_ASSIGNMENT	SOLICITOR_ASSIGNED_IND

Ver: