Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACTIVE_DESIGNATION_IND	Designation status active indicator determining if the status is active (Y)es, or inactive (N)o.	VARCHAR2(1)	ATVDSTA	ATVDSTA_ACTIVE_IND
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CAMPAIGN	Campaign that the constituent has responded to with a gift or pledge payment.	VARCHAR2(63)	AFRDESG	AFRDESG_CAMPAIGN
CAMPAIGN_DESG_STATUS	Indicates designation status for the campaign.	VARCHAR2(63)	AFRDESG	AFRDESG_DSTA_CODE
CAMPAIGN_DESG_STATUS_DESC	Designation status description.	VARCHAR2(255)	ATVSDTA	ATVDSTA_DESC
CAMPAIGN_DESIGNATION_GOAL	Amount of the designation goal for the campaign.	NUMBER	CALCULATION	NVL(AFRDESG_GOAL,0)
CAMPAIGN_NAME	Campaign name.	VARCHAR2(255)	AFBCAMP	AFBCAMP_NAME
CAMPAIGN_TYPE	Type of campaign recorded.	VARCHAR2(63)	AFBCAMP	AFBCAMP_CMTP_CODE
CAMPAIGN_TYPE_DESC	Campaign type description.	VARCHAR2(255)	ATVCMTP	ATVCMTP_DESC
CAMP_DESG_MATCHING_GIFTS_PAID	Corporate gift received that matches an eligible employee gift to this campaign designation combination.	NUMBER	FUNCTION	MAKFUNC.F_DESG_MATCH_GIFTS_PAID
CAMP_DESG_OUTRIGHT_GIFTS	Total amount received toward this campaign designation combination for outright gifts.	NUMBER	FUNCTION	MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS
CAMP_DESG_OUTRIGHT_GIFT_COUNT	Total number of outright gifts made to this campaign designation combination.	NUMBER	FUNCTION	MAKFUNC.F_DESG_CAMP_GIFT_COUNT
CAMP_DESG_PLEDGE_BALANCE	Total amount of outstanding pledges for this campaign designation combination.	NUMBER	CALCULATION	MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES - MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS
CAMP_DESG_PLEDGE_COUNT	Total number of pledges made to this campaign designation combination.	NUMBER	FUNCTION	MAKFUNC.F_DESG_PLEDGE_COUNT
CAMP_DESG_PLEDGE_DONOR_COUNT	Total number of donors who made one or more pledges to this campaign designation combination. This includes original donors and any individuals who received hard credit.	NUMBER	FUNCTION	MAKFUNC.F_DESG_PLEDGE_DONOR_COUNT
CAMP_DESG_PLEDGE_PAYMENTS	Total amount of pledge payments made to this campaign designation combination.	NUMBER	FUNCTION	MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS
CAMP_DESG_TOTAL_DONOR_COUNT	Total number of donors who have made one or more gifts to this campaign designation combination. This includes donors who have received hard credit from gifts and includes pledges made with no payment received to date.	NUMBER	FUNCTION	MAKFUNC.F_DESG_TOTAL_DONOR_COUNT
CAMP_DESG_TOTAL_GIFTS	Total amount of gifts received toward this campaign designation combination, including pledge payments and outright gifts.	NUMBER	FUNCTION	MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS
CAMP_DESG_TOTAL_GIFT_COUNT	Total number of gifts made to this campaign designation combination. This includes both payments and outright gifts.	NUMBER	FUNCTION	MAKFUNC.F_DESG_CAMP_GIFT_COUNT
CAMP_DESG_TOTAL_PLEDGES	Total amount of pledges made to this campaign designation combination.	NUMBER	FUNCTION	MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES
DESG_GROUP	Group associated with the designation. You can group similar designations together for institutional reporting. For example, designations by campaign objectives.	VARCHAR2(63)	ADBDESG	ADBDESG_DGRP_CODE
DESG_GROUP_DESC	Designation group description.	VARCHAR2(255)	ATVDGRP	ATVDGRP_DESC
DESG_MATCH_GIFTS_ANTICIPATED	Total amount of anticipated matching gifts toward this campaign designation combination.	NUMBER	FUNCTION	MAKFUNC.F_DESG_MATCH_GIFTS_ANTICIPATED
DESG_OUTRIGHT_GIFT_DONOR_COUNT	Total number of donors who made one or more outright gifts to this campaign designation combination.	NUMBER	FUNCTION	MAKFUNC.F_DESG_TOTAL_DONOR_COUNT
DESG_PERCENT_OF_CAMPAIGN_GOAL	Percentage of the overall campaign goal this designation goal represents.	NUMBER	CALCULATION	AFRDESG_GOAL / AFBCAMP_GOAL * 100
DESG_PLEDGE_DONOR_NO_PAY_COUNT	Total number of donors who have not made any payments toward their pledges to this campaign designation combination.	NUMBER	FUNCTION	MAKFUNC.F_DESG_PLEDGE_DONOR_COUNT
DESG_PLEDGE_DONOR_PAID_COUNT	Total number of donors who have made payments toward their pledges to this campaign designation combination. This could be fully paid or partial paid.	NUMBER	FUNCTION	MAKFUNC.F_DESG_TOTAL_DONOR_COUNT
DESG_TYPE	Type of designation. Used to identify testamentary commitments, charitable reminder trusts, and pooled income funds in Voluntary Support of Education processing.	VARCHAR2(63)	ADBDESG	ADBDESG_DSTP_CODE
DESG_TYPE_DESC	Designation type description.	VARCHAR2(255)	ATVDSTP	ATVDSTP_DESC
DESG_VSE	Predefined code determining the purpose for giving as defined for Council for Aid to Education reporting.	VARCHAR2(63)	ADBDESG	ADBDESG_CFAE_CODE
DESG_VSE_DESC	Voluntary Support of Education purpose description.	VARCHAR2(255)	ATVCFAE	ATVCFAE_DESC
DESG_VSE_PURPOSE_TYPE	Voluntary Support of Education purpose type as defined for Council for Aid to Education reporting.	NUMBER	ATVCFAE	ATVCFAE_TYPE
DESG_VSE_PURPOSE_TYPE_DESC	Voluntary Support of Education purpose type description.	VARCHAR2(255)	CONSTANT	HARCODED DESCRIPTIONS. SEE THE ONLINE HELP FOR BANNER FORM ATVVSER FOR A COMPLETE LIST OF VALUES.
DESIGNATION	User defined code for a designation.	VARCHAR2(63)	AFRDESG	AFRDESG_DESG
DESIGNATION_NAME	Designation name.	VARCHAR2(255)	ADBDESG	ADBDESG_NAME
MATCHING_GIFT_VSE_PURPOSE	The Matching Gift Purpose associates the Voluntary Support of Education code to a matching gift related purpose.	VARCHAR2(63)	ATVCFAE	ATVCFAE_MG_PURPOSE
MATCHING_GIFT_VSE_PURPOSE_DESC	Matching gift Voluntary Support of Education purpose description.	VARCHAR2(255)	CALCULATION	DECODE(ATVCFAE_MG_PURPOSE,'A','ALUMNI OR OTHER ASSOCIATIONS','B','RELIGIOUS PURPOSES AT THE INSTITUTION','C','POLITICAL PURPOSES AT THE INSTITUTION','D','ATHLETIC ACTIVITIES','E','ATHLETIC SCHOLARSHIP FUNDS','F','NON-ATHLETIC SCHOLARSHIP FUNDS',ETC.)
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PCT_DESG_PROGRESS_CAMP_GOAL	Percentage of progress toward the campaign goal represented by the gift amount received for this designation. This includes the outstanding pledge balance.	NUMBER	CALCULATION	(MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS + MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES + MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100
PCT_PROGRESS_DESIGNATION_GOAL	Percentage progress toward the designation goal for this campaign represented by the gift amount received for this designation. This includes the outstanding pledge balance.	NUMBER	CALCULATION	(MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS + MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES + MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS) / AFRDESG_GOAL * 100
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
RESTRICTED_IND	Indicates whether the designation is restricted to transfer of pledges and/or gifts across fiscal years.	VARCHAR2(1)	ADBDESG	ADBDESG_RESTR_IND

Ver: 9.1