ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ASK_AMOUNT	Amount the solicitor asked the constituent to give or pledge.			AFRCTYP	AFRCTYP_ASK_AMOUNT
ASK_DATE	Date when the solicitor asked the constituent for a gift or a pledge.			AFRCTYP	AFRCTYP_ASK_DATE
ASSIGNMENT_COMMENT	Assignment comment.			AFRCTYP	AFRCTYP_COMMENT
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.			AFRCTYP	AFRCTYP_SEQ_NO
ASSIGN_DATE	Date when the constituent was assigned to the solicitor.			AFRCTYP	AFRCTYP_ASSSIGN_DATE
CAMPAIGN	User defined code for a campaign.			AFRCTYP	AFRCTYP_CAMPAIGN
CURRENT_DATE	System current date (sysdate), or date the data was extracted.			NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.			NA	NA
ENTITY_UID	System generated, unique, internal identification number assigned to this constituent.			AFRCTYP	AFRCTYP_CONSTITUENT_PIDM
MIF_DESC	Institution description for the record when the optional multi-institution facility feature has been applied.			NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
RATER_UID	System generated, unique, internal identification number assigned to this rater.			AFRCTYP	AFRCTYP_RATER_PIDM
RATE_AMOUNT	Rating amount.			ATVRATE	ATVRATE_RATE_AMT
RATING	Rating code assigned to the constituent by the rater.			AFRCTYP	AFRCTYP_RATE_CODE
RATING_DESC	Rating description.			ATVRATE	ATVRATE_DESC
SCREENING	Rate screening type assigned to the rater. For example, staff, consultant, volunteer, etc.			AFRCTYP	AFRCTYP_RSCR_CODE
SCREENING_DESC	Screening description.			ATVRSCR	ATVRSCR_DESC
SOLICITATION_TYPE	Solicitation type code.			AFRCTYP	AFRCTYP_SOLC_CODE
SOLICITATION_TYPE_DESC	Solicitation type description.			FUNCTION	GOKODSF.F_GET_DESC
SOLICITATION_YEAR	Year in which the solicitation ask amount should be made.			AFRCTYP	AFRCTYP_DCYR_CODE
SOLICITATION_YEAR_DESC	Year description.			ATVDCYR	ATVDCYR_DCYR_DESC
SOLICITATION_YEAR_END_DATE	Year end date.			ATVDCYR	ATVDCYR_END_DATE
SOLICITATION_YEAR_START_DATE	Year start date.			ATVDCYR	ATVDCYR_START_DATE
SOLICITOR_ASSIGNED_IND	Determines if the solicitor has been assigned to the contact. (Y)es, solicitor is assigned, (N)o, solicitor is not assigned.			AFRCTYP	DECODE (AFRCTYP_PIDM, NULL, 'N)
SOLICITOR_ASSIGN_ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.			AFRCTYP	AFRCTYP_ACTIVITY_DATE
SOLICITOR_ASSIGN_USER_ID	Unique identification code of the user who entered or last touched the transaction.			AFRCTYP	AFRCTYP_USER
SOLICITOR_ORGANIZATION	Solicitor organization code.			AFRCTYP	AFRCTYP_SOL_ORG
SOLICITOR_ORGANIZATION_NAME	Solicitor organization name.			FUNCTION	GOKODSF.F_GET_DESC
SOLICITOR_UID	System generated, unique, internal identification number assigned to this solicitor.			AFRCTYP	AFRCTYP_PIDM
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA

Ver: 8.3