Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVE_DESIGNATION_IND	Active Designation Indicator	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 Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
CAMPAIGN	Campaign	User defined code for a campaign	VARCHAR2(63)		AFRDESG	AFRDESG_CAMPAIGN
CAMPAIGN_DESG_STATUS	Campaign Designation Status	Indicates designation status for the campaign.	VARCHAR2(63)		AFRDESG	AFRDESG_DSTA_CODE
CAMPAIGN_DESG_STATUS_DESC	Campaign Designation Status Description	Designation status description.	VARCHAR2(255)		ATVSDTA	ATVDSTA_DESC
CAMPAIGN_DESIGNATION_GOAL	Campaign Designation Goal	Amount of the designation goal for the campaign.	NUMBER		CALCULATION	NVL(AFRDESG_GOAL,0)
CAMPAIGN_NAME	Campaign Name	Campaign name.	VARCHAR2(255)		AFBCAMP	AFBCAMP_NAME
CAMPAIGN_TYPE	Campaign Type	Type of campaign recorded.	VARCHAR2(63)		AFBCAMP	AFBCAMP_CMTP_CODE
CAMPAIGN_TYPE_DESC	Campaign Type Description	Campaign type description.	VARCHAR2(255)		ATVCMTP	ATVCMTP_DESC
CAMP_DESG_MATCHING_GIFTS_PAID	Camp Designation 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	Camp Designation 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	Camp Designation 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	Camp Designation 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	Camp Designation Pledge Count	Total number of pledges made to this campaign designation combination.	NUMBER		FUNCTION	MAKFUNC.F_DESG_PLEDGE_COUNT
CAMP_DESG_PLEDGE_DONOR_COUNT	Camp Designation 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	Camp Designation 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	Camp Designation 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	Camp Designation 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	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	Camp Designation Total Pledges	Total amount of pledges made to this campaign designation combination.	NUMBER		FUNCTION	MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES
DESG_GROUP	Designation 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	Designation group description.	VARCHAR2(255)		ATVDGRP	ATVDGRP_DESC
DESG_MATCH_GIFTS_ANTICIPATED	Designation 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	Designation 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	Designation 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	Designation Pledge Donor Number 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	Designation 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	Designation 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	Designation type description.	VARCHAR2(255)		ATVDSTP	ATVDSTP_DESC
DESG_VSE	Designation VSE - Voluntary Support of Education	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	Designation VSE - Voluntary Support of Education Description	Voluntary Support of Education purpose description.	VARCHAR2(255)		ATVCFAE	ATVCFAE_DESC
DESG_VSE_PURPOSE_TYPE	Designation VSE - Voluntary Support of Education 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	Designation VSE - Voluntary Support of Education Purpose Type Description	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	Designation	User defined code for a designation.	VARCHAR2(63)		AFRDESG	AFRDESG_DESG
DESIGNATION_NAME	Designation Name	Designation name.	VARCHAR2(255)		ADBDESG	ADBDESG_NAME
MATCHING_GIFT_VSE_PURPOSE	Matching Gift VSE - Voluntary Support of Education 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 VSE - Voluntary Support of Education Purpose Description	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	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)		NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)		NA	NA
PCT_DESG_PROGRESS_CAMP_GOAL	Percent Designation 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	Percent 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 Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
RESTRICTED_IND	Restricted Indicator	Indicates whether the designation is restricted to transfer of pledges and/or gifts across fiscal years.	VARCHAR2(1)		ADBDESG	ADBDESG_RESTR_IND

Ver: 9.0