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

Ver: