Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ASSIGNMENT_RESULT_COMMENT	Comments about the constituent contact result.	VARCHAR2(2000)	AFRCRES	AFRCRES_COMMENT	NO	NO
ASSIGNMENT_SEQUENCE_NUMBER	System-generated one-up number assigned to constituents assigned to a campaign, and or solicitation type, and or solicitor organization, and or solicitor in this record.	NUMBER	AFRCRES	AFRCRES_CTYP_SEQ_NO	NO	NO
CAMPAIGN	Campaign that the constituent has responded to with a gift or pledge payment.	VARCHAR2(5)	AFRCRES	AFRCRES_CAMPAIGN	NO	NO
CONTACT	Type of contact made.	VARCHAR2(3)	AFRCRES	AFRCRES_SCNT_CODE	NO	NO
CONTACT_DESC	Contact description.	VARCHAR2(30)	ATVSCNT	ATVSCNT_DESC	NO	NO
CURRENT_DATE	System current date (sysdate), or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
GIFT_NUMBER	Number of the gift.	VARCHAR2(7)	AFRCRES	AFRCRES_GIFT_NO	NO	NO
MIF_DESC	Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
PLEDGE_NUMBER	System assigned number of the pledge.	VARCHAR2(7)	AFRCRES	AFRCRES_PLEDGE_NO	NO	NO
RESULT	Result code used to determine the outcome of the constituent contact. For example, agreed to pledge, couldn't contact, or agreed to give.	VARCHAR2(3)	AFRCRES	AFRCRES_SCRS_CODE	NO	NO
RESULT_DESC	Result description.	VARCHAR2(30)	ATVSCRS	ATVSCRS_DESC	NO	NO
RESULT_SEQUENCE_NUMBER	System-generated one-up number assigned to a constituent contact result within a campaign, and or solicitation type, and or solicitor organization, and or solicitor in this record.	NUMBER	AFRCRES	AFRCRES_SEQ_NO	NO	NO
SOLICITATION_DATE	Date the constituent was contacted for a solicitation.	DATE	AFRCRES	AFRCRES_DATE	NO	NO
SOLICITATION_IND	Determines if the result ended as a solicitation.	VARCHAR2(1)	ATVSCRS	ATVSCRS_SOLICITATION_IND	NO	NO
SOLICITATION_TYPE	Solicitation type code.	VARCHAR2(15)	AFRCRES	AFRCRES_SOLC_CODE	NO	NO
SOLICITATION_TYPE_DESC	Solicitation type description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SOLICITATION_YEAR	Year in which the solicitation ask amount should be made.	VARCHAR2(4)	AFRCRES	AFRCRES_DCYR_CODE	NO	NO
SOLICITATION_YEAR_DESC	Year description.	VARCHAR2(30)	ATVDCYR	ATVDCYR_DCYR_DESC	NO	NO
SOLICITATION_YEAR_END_DATE	Year end date.	DATE	ATVDCYR	ATVDCYR_END_DATE	NO	NO
SOLICITATION_YEAR_START_DATE	Year start date.	DATE	ATVDCYR	ATVDCYR_START_DATE	NO	NO
SOLICITOR_ORGANIZATION	Solicitor organization code.	VARCHAR2(5)	AFRCRES	AFRCRES_SOL_ORG	NO	NO
SOLICITOR_ORGANIZATION_NAME	Solicitor organization name.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SOLICITOR_RESULT_ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	AFRCRES	AFRCRES_ACTIVITY_DATE	NO	NO
SOLICITOR_RESULT_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	AFRCRES	AFRCRES_USER	NO	NO
SOLICITOR_UID	System generated, unique, internal identification number assigned to this solicitor.	NUMBER	AFRCRES	AFRCRES_PIDM	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: