Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACTIVE_DESIGNATION_IND	Designation status active indicator. Determines if the status is active (Y)es, or inactive (N)o.	VARCHAR2(1)	ATVDSTA	ATVDSTA_ACTIVE_IND
ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	DATE	ADBDESG	ADBDESG_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ALLOW_WEB_GIFT_IND	Indicates if gifts for this designation will be accepted from the Web. (Y)es accepted from the web or (N)ot accepted from the web.	VARCHAR2(1)	CALCULATION	NVL(ADBDESG_WEB_GIFT_IND,'N')
ALLOW_WEB_PLEGE_IND	Indicates if pledges for this designation will be accepted from the Web. (Y)es is accepted. (N)ot is not accepted.	VARCHAR2(1)	CALCULATION	NVL(ADBDESG_WEB_PLDG_IND,'N')
DESG_COLLEGE	Specific college to which the fund is allocated or designated.	VARCHAR2(63)	ADBDESG	ADBDESG_COLL_CODE
DESG_COLLEGE_DESC	College description.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC
DESG_DEPARTMENT	Department associated with the designation.	VARCHAR2(63)	ADBDESG	ADBDESG_DEPT_CODE
DESG_DEPARTMENT_DESC	Designation department description.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC
DESG_GROUP	User defined attribute associating designations of similar purpose or function. 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 designation.	NUMBER	FUNCTION	MAKFUNC.F_DESG_MATCH_GIFTS_ANTICIPATED
DESG_OUTRIGHT_GIFT_COUNT	Total number of outright gifts made to this designation.	NUMBER	FUNCTION	MAKFUNC.F_DESG_OUTRIGHT_GIFT_COUNT
DESG_OUTRIGHT_GIFT_DONOR_COUNT	Total number of donors who made one or more outright gifts to this designation.	NUMBER	FUNCTION	MAKFUNC.F_DESG_OUTRIGHT_GIFT_DONOR_CNT
DESG_PLEDGE_DONOR_NO_PAY_COUNT	Total number of donors who have not made any payments toward their pledges.	NUMBER	FUNCTION	MAKFUNC.F_DESG_PLEDGE_DONOR_NO_PAY_CNT
DESG_PLEDGE_DONOR_PAID_COUNT	Total number of donors who have made payments toward their pledges. This could be fully paid or partial paid.	NUMBER	FUNCTION	MAKFUNC.F_DESG_PLEDGE_DONOR_PAID_COUNT
DESG_STATUS	Current designation status.	VARCHAR2(63)	ADBDESG	ADBDESG_DSTA_CODE
DESG_STATUS_DESC	Designation status description.	VARCHAR2(255)	ATVSDTA	ATVDSTA_DESC
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)	ADBDESG	ADBDESG_DESG
DESIGNATION_END_DATE	Date the designation is no longer active.	DATE	ADBDESG	ADBDESG_END_DATE
DESIGNATION_NAME	Designation name.	VARCHAR2(255)	ADBDESG	ADBDESG_NAME
DESIGNATION_OUTRIGHT_GIFTS	Total amount received toward this designation for outright gifts.	NUMBER	FUNCTION	MAKFUNC.F_DESG_OUTRIGHT_GIFTS
DESIGNATION_PLEDGE_BALANCE	Total amount of outstanding pledges for this designation.	NUMBER	FUNCTION	MAKFUNC.F_DESG_PLEDGE_BALANCE
DESIGNATION_PLEDGE_COUNT	Total number of pledges made to this designation.	NUMBER	FUNCTION	MAKFUNC.F_DESG_PLEDGE_COUNT
DESIGNATION_PLEDGE_DONOR_COUNT	Total number of donors who made one or more pledges to this designation. This includes original donors and any individuals who received hard credit.	NUMBER	FUNCTION	MAKFUNC.F_DESG_PLEDGE_DONOR_COUNT
DESIGNATION_PLEDGE_PAYMENTS	Total amount of pledge payments made to this designation.	NUMBER	FUNCTION	MAKFUNC.F_DESG_PLEDGE_PAYMENT
DESIGNATION_PROJECT	Project to which this designation is assigned.	VARCHAR2(63)	AMRDESG	AMRDESG_PROJ_CODE
DESIGNATION_PROJECT_DESC	Designation project description.	VARCHAR2(255)	ATVPROJ	ATVPROJ_DESC
DESIGNATION_START_DATE	Date the designation becomes active.	DATE	ADBDESG	ADBDESG_START_DATE
DESIGNATION_TOTAL_DONOR_COUNT	Total number of donors who have made one or more gifts to this designation. This includes donors who have received hard credit from gifts made to this designation. This includes pledges made with no payment received to date.	NUMBER	FUNCTION	MAKFUNC.F_DESG_TOTAL_DONOR_COUNT
DESIGNATION_TOTAL_GIFTS	Total amount of gifts received toward this designation, including pledge payments and outright gifts.	NUMBER	FUNCTION	MAKFUNC.F_DESG_TOTAL_GIFTS
DESIGNATION_TOTAL_GIFT_COUNT	Total number of gifts made to this designation. This includes both payments and outright gifts.	NUMBER	FUNCTION	MAKFUNC.F_DESG_TOTAL_GIFT_COUNT
DESIGNATION_TOTAL_PLEDGES	Total amount of pledges made to this designation.	NUMBER	FUNCTION	MAKFUNC.F_DESG_TOTAL_PLEDGES
DESIGNATION_USER_ID	Unique identification code of the user who entered or last touched the designation.	VARCHAR2(63)	ADBDESG	ADBDESG_USER
FINANCIAL_AID_FUND_IND	Indicates that at least one financial aid fund for the designation is active.	VARCHAR2(1)	FUNCTION	SUBSTR (MAKFUNC.F_DESG_FINAID_FUND_IND
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
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