Reporting View Source: AFRCTYP

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

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

Ver: 8.3