Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ASK_AMOUNT	Ask Amount	Amount the solicitor asked the constituent to give or pledge.	NUMBER(11,2)		AFRCTYP	AFRCTYP_ASK_AMOUNT
ASK_DATE	Ask Date	Date when the solicitor asked the constituent for a gift or a pledge.	DATE		AFRCTYP	AFRCTYP_ASK_DATE
ASSIGNMENT_COMMENT	Assignment Comment	Assignment comment.	VARCHAR2(2000)		AFRCTYP	AFRCTYP_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)		AFRCTYP	AFRCTYP_SEQ_NO
ASSIGN_DATE	Assignment Date	Date when the constituent was assigned to the solicitor.	DATE		AFRCTYP	AFRCTYP_ASSSIGN_DATE
CAMPAIGN	Campaign	User defined code for a campaign.	VARCHAR2(5)		AFRCTYP	AFRCTYP_CAMPAIGN
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
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this constituent.	NUMBER(8)		AFRCTYP	AFRCTYP_CONSTITUENT_PIDM
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
RATER_UID	Rater UID	System generated, unique, internal identification number assigned to this rater.	NUMBER(8)		AFRCTYP	AFRCTYP_RATER_PIDM
RATE_AMOUNT	Rate Amount	Rating amount.	NUMBER		ATVRATE	ATVRATE_RATE_AMT
RATING	Rating	Rating code assigned to the constituent by the rater.	VARCHAR2(2)		AFRCTYP	AFRCTYP_RATE_CODE
RATING_DESC	Rating Description	Rating description.	VARCHAR2(30)		ATVRATE	ATVRATE_DESC
SCREENING	Screening	Rate screening type assigned to the rater. For example, staff, consultant, volunteer, etc.	VARCHAR2(5)		AFRCTYP	AFRCTYP_RSCR_CODE
SCREENING_DESC	Screening Description	Screening description.	VARCHAR2(30)		ATVRSCR	ATVRSCR_DESC
SOLICITATION_TYPE	Solicitation Type	Solicitation type code.	VARCHAR2(15)		AFRCTYP	AFRCTYP_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)		AFRCTYP	AFRCTYP_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_ASSIGNED_IND	Solicitor Assigned Indicator	Determines if the solicitor has been assigned to the contact. (Y)es, solicitor is assigned, (N)o, solicitor is not assigned.	VARCHAR2(1)		AFRCTYP	DECODE (AFRCTYP_PIDM, NULL, 'N)
SOLICITOR_ASSIGN_ACTIVITY_DATE	Solicitor Assignment Activity Date	Date that information for this record in the table was entered or last updated.	DATE		AFRCTYP	AFRCTYP_ACTIVITY_DATE
SOLICITOR_ASSIGN_USER_ID	Solicitor Assignment User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)		AFRCTYP	AFRCTYP_USER
SOLICITOR_ORGANIZATION	Solicitor Organization	Solicitor organization code.	VARCHAR2(5)		AFRCTYP	AFRCTYP_SOL_ORG
SOLICITOR_ORGANIZATION_NAME	Solicitor Organization Name	Solicitor organization name.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
SOLICITOR_UID	Solicitor UID	System generated, unique, internal identification number assigned to this solicitor.	NUMBER(8)		AFRCTYP	AFRCTYP_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: