Target Column	Business Name	Business Definition	Database Data Type	Business Data Type	Domain Value	Source Name	Source Column	Local Source	Local Target
DESIGNATION	Designation	User defined code for a designation.	VARCHAR2(63)			ADBDESG	ADBDESG_DESG	NO	NO
DESIGNATION_NAME	Designation Name	Designation name.	VARCHAR2(255)			ADBDESG	ADBDESG_NAME	NO	NO
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	NO	NO
DESG_TYPE_DESC	Designation Type Description	Designation type description.	VARCHAR2(255)			ATVDSTP	ATVDSTP_DESC	NO	NO
DESG_GROUP	Designation 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	NO	NO
DESG_GROUP_DESC	Designation Group Description	Designation group description.	VARCHAR2(255)			ATVDGRP	ATVDGRP_DESC	NO	NO
DESIGNATION_START_DATE	Designation Start Date	Date the designation becomes active.	DATE			ADBDESG	ADBDESG_START_DATE	NO	NO
DESIGNATION_END_DATE	Designation End Date	Date the designation is no longer active.	DATE			ADBDESG	ADBDESG_END_DATE	NO	NO
DESIGNATION_PROJECT	Designation Project	Project to which this designation is assigned.	VARCHAR2(63)			AMRDESG	AMRDESG_PROJ_CODE	NO	NO
DESIGNATION_PROJECT_DESC	Designation Project Description	Designation project description.	VARCHAR2(255)			ATVPROJ	ATVPROJ_DESC	NO	NO
ALLOW_WEB_GIFT_IND	Allow Web Gift Indicator	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')	NO	NO
ALLOW_WEB_PLEGE_IND	Allow Web Plege Indicator	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')	NO	NO
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	NO	NO
DESG_COLLEGE	Designation College	Specific college to which the fund is allocated or designated.	VARCHAR2(63)			ADBDESG	ADBDESG_COLL_CODE	NO	NO
DESG_COLLEGE_DESC	Designation College Description	College description.	VARCHAR2(255)			STVCOLL	STVCOLL_DESC	NO	NO
DESG_DEPARTMENT	Designation Department	Department associated with the designation.	VARCHAR2(63)			ADBDESG	ADBDESG_DEPT_CODE	NO	NO
DESG_DEPARTMENT_DESC	Designation Department Description	Designation department description.	VARCHAR2(255)			STVDEPT	STVDEPT_DESC	NO	NO
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	NO	NO
DESG_VSE_DESC	Designation VSE - Voluntary Support of Education Description	Voluntary Support of Education purpose description.	VARCHAR2(255)			ATVCFAE	ATVCFAE_DESC	NO	NO
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	NO	NO
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.	NO	NO
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	NO	NO
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.)	NO	NO
DESG_STATUS	Designation Status	Current designation status.	VARCHAR2(63)			ADBDESG	ADBDESG_DSTA_CODE	NO	NO
DESG_STATUS_DESC	Designation Status Description	Designation status description.	VARCHAR2(255)			ATVSDTA	ATVDSTA_DESC	NO	NO
DESIGNATION_USER_ID	Designation User ID	Unique identification code of the user who entered or last touched the designation.	VARCHAR2(63)			ADBDESG	ADBDESG_USER	NO	NO
ACTIVITY_DATE	Activity Date	Date information for this record in the table was entered or last updated.	DATE			ADBDESG	ADBDESG_ACTIVITY_DATE	NO	NO
DESIGNATION_TOTAL_PLEDGES	Designation Total Pledges	Total amount of pledges made to this designation.	NUMBER			FUNCTION	MAKFUNC.F_DESG_TOTAL_PLEDGES	NO	NO
DESIGNATION_PLEDGE_PAYMENTS	Designation Pledge Payments	Total amount of pledge payments made to this designation.	NUMBER			FUNCTION	MAKFUNC.F_DESG_PLEDGE_PAYMENT	NO	NO
DESIGNATION_PLEDGE_BALANCE	Designation Pledge Balance	Total amount of outstanding pledges for this designation.	NUMBER			FUNCTION	MAKFUNC.F_DESG_PLEDGE_BALANCE	NO	NO
DESIGNATION_TOTAL_GIFTS	Designation Total Gifts	Total amount of gifts received toward this designation, including pledge payments and outright gifts.	NUMBER			FUNCTION	MAKFUNC.F_DESG_TOTAL_GIFTS	NO	NO
DESIGNATION_OUTRIGHT_GIFTS	Designation Outright Gifts	Total amount received toward this designation for outright gifts.	NUMBER			FUNCTION	MAKFUNC.F_DESG_OUTRIGHT_GIFTS	NO	NO
DESG_MATCH_GIFTS_ANTICIPATED	Designation Match Gifts Anticipated	Total amount of anticipated matching gifts toward this designation.	NUMBER			FUNCTION	MAKFUNC.F_DESG_MATCH_GIFTS_ANTICIPATED	NO	NO
DESIGNATION_PLEDGE_DONOR_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	NO	NO
DESIGNATION_PLEDGE_COUNT	Designation Pledge Count	Total number of pledges made to this designation.	NUMBER			FUNCTION	MAKFUNC.F_DESG_PLEDGE_COUNT	NO	NO
DESIGNATION_TOTAL_DONOR_COUNT	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	NO	NO
DESG_PLEDGE_DONOR_PAID_COUNT	Designation 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	NO	NO
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.	NUMBER			FUNCTION	MAKFUNC.F_DESG_PLEDGE_DONOR_NO_PAY_CNT	NO	NO
DESG_OUTRIGHT_GIFT_DONOR_COUNT	Designation 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	NO	NO
DESIGNATION_TOTAL_GIFT_COUNT	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	NO	NO
DESG_OUTRIGHT_GIFT_COUNT	Designation Outright Gift Count	Total number of outright gifts made to this designation.	NUMBER			FUNCTION	MAKFUNC.F_DESG_OUTRIGHT_GIFT_COUNT	NO	NO
FINANCIAL_AID_FUND_IND	Financial Financial Aid Fund Indicator	Indicates that at least one financial aid fund for the designation is active.	VARCHAR2(1)			FUNCTION	SUBSTR (MAKFUNC.F_DESG_FINAID_FUND_IND	NO	NO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)			NA	NA	NO	NO
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)			NA	NA	NO	NO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
ACTIVE_DESIGNATION_IND	Active Designation Indicator	Designation status active indicator. Determines if the status is active (Y)es, or inactive (N)o.	VARCHAR2(1)			ATVDSTA	ATVDSTA_ACTIVE_IND	NO	NO

Ver: 9.2