Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVE_DESIGNATION_IND	Designation status active indicator. Determines if the status is active (Y)es, or inactive (N)o.	VARCHAR2(1)	ATVSDTA	ATVDSTA_ACTIVE_IND	NO	NO
ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	DATE	ADBDESG	ADBDESG_ACTIVITY_DATE	NO	NO
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')	NO	NO
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')	NO	NO
CURRENT_DATE	System current date (sysdate), or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DESG_COLLEGE	Specific college to which the fund is allocated or designated.	VARCHAR2(2)	ADBDESG	ADBDESG_COLL_CODE	NO	NO
DESG_COLLEGE_DESC	College description.	VARCHAR2(30)	STVCOLL	STVCOLL_DESC	NO	NO
DESG_DEPARTMENT	Department associated with the designation.	VARCHAR2(4)	ADBDESG	ADBDESG_DEPT_CODE	NO	NO
DESG_DEPARTMENT_DESC	Designation department description.	VARCHAR2(30)	STVDEPT	STVDEPT_DESC	NO	NO
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(5)	ADBDESG	ADBDESG_DGRP_CODE	NO	NO
DESG_GROUP_DESC	Designation group description.	VARCHAR2(30)	ATVDGRP	ATVDGRP_DESC	NO	NO
DESG_STATUS	Current designation status.	VARCHAR2(1)	ADBDESG	ADBDESG_DSTA_CODE	NO	NO
DESG_STATUS_DESC	Designation status description.	VARCHAR2(30)	ATVSDTA	ATVDSTA_DESC	NO	NO
DESG_TYPE	Type of designation. Used to identify testamentary commitments, charitable reminder trusts, and pooled income funds in Voluntary Support of Education processing.	VARCHAR2(5)	ADBDESG	ADBDESG_DSTP_CODE	NO	NO
DESG_TYPE_DESC	Designation type description.	VARCHAR2(30)	ATVDSTP	ATVDSTP_DESC	NO	NO
DESG_VSE	Predefined code determining the purpose for giving as defined for Council for Aid to Education reporting.	VARCHAR2(5)	ADBDESG	ADBDESG_CFAE_CODE	NO	NO
DESG_VSE_DESC	Voluntary Support of Education purpose description.	VARCHAR2(30)	ATVCFAE	ATVCFAE_DESC	NO	NO
DESG_VSE_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	Voluntary Support of Education purpose type description.	VARCHAR2(35)	CONSTANT	HARCODED DESCRIPTIONS. SEE THE ONLINE HELP FOR BANNER FORM ATVVSER FOR A COMPLETE LIST OF VALUES.	NO	NO
DESIGNATION	User defined code for a designation.	VARCHAR2(10)	ADBDESG	ADBDESG_DESG	NO	NO
DESIGNATION_END_DATE	Date the designation is no longer active.	DATE	ADBDESG	ADBDESG_END_DATE	NO	NO
DESIGNATION_NAME	Designation name.	VARCHAR2(60)	ADBDESG	ADBDESG_NAME	NO	NO
DESIGNATION_PROJECT	Project to which this designation is assigned.	VARCHAR2(6)	AMRDESG	AMRDESG_PROJ_CODE	NO	NO
DESIGNATION_PROJECT_DESC	Designation project description.	VARCHAR2(30)	ATVPROJ	ATVPROJ_DESC	NO	NO
DESIGNATION_START_DATE	Date the designation becomes active.	DATE	ADBDESG	ADBDESG_START_DATE	NO	NO
DESIGNATION_USER_ID	Unique identification code of the user who entered or last touched the designation.	VARCHAR2(30)	ADBDESG	ADBDESG_USER	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
EXPENDITURE_EXTERNAL_ACCOUNT	External general ledger account number associated with expenditures for this designation.	VARCHAR2(60)	ADBDESG	ADBDESG_GL_NO_CREDIT_EXPND	NO	NO
EXPEND_ACCOUNT	Banner Finance account code for expenditures.	VARCHAR2(6)	ADBDESG	ADBDESG_ACCT_CODE_EXPND	NO	NO
EXPEND_ACCOUNT_DESC	Expenditure account description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
EXPEND_ACCOUNT_INDEX	Expenditure account index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.	VARCHAR2(6)	ADBDESG	ADBDESG_ACCI_CODE_EXPND	NO	NO
EXPEND_ACCOUNT_INDEX_DESC	Expenditure account index description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
EXPEND_ACTIVITY	Banner Finance activity code for expenditures.	VARCHAR2(6)	ADBDESG	ADBDESG_ACTV_CODE_EXPND	NO	NO
EXPEND_ACTIVITY_DESC	Expenditure activity description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
EXPEND_CHART_OF_ACCOUNTS	Banner Finance chart of accounts for expenditures.	VARCHAR2(1)	ADBDESG	ADBDESG_COAS_CODE_EXPND	NO	NO
EXPEND_CHART_OF_ACCOUNTS_DESC	Chart of accounts description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
EXPEND_FUND	Banner Finance fund code for expenditures.	VARCHAR2(6)	ADBDESG	ADBDESG_FUND_CODE_EXPND	NO	NO
EXPEND_FUND_DESC	Expenditure fund description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
EXPEND_LOCATION	Banner Finance location code for expenditures.	VARCHAR2(6)	ADBDESG	ADBDESG_LOCN_CODE_EXPND	NO	NO
EXPEND_LOCATION_DESC	Expenditure location description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
EXPEND_ORGANIZATION	Banner Finance organization code for expenditures.	VARCHAR2(6)	ADBDESG	ADBDESG_ORGN_CODE_EXPND	NO	NO
EXPEND_ORGRANIZATION_DESC	Expenditure organization description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
EXPEND_PROGRAM	Banner Finance program code for expenditures.	VARCHAR2(6)	ADBDESG	ADBDESG_PROG_CODE_EXPND	NO	NO
EXPEND_PROGRAM_DESC	Expenditure program description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
GIFT_ACCOUNT	Banner Finance account code for gifts.	VARCHAR2(6)	ADBDESG	ADBDESG_ACCT_CODE	NO	NO
GIFT_ACCOUNT_DESC	Gift account description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
GIFT_ACCOUNT_INDEX	Gift account index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.	VARCHAR2(6)	ADBDESG	ADBDESG_ACCI_CODE	NO	NO
GIFT_ACCOUNT_INDEX_DESC	Gift account index description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
GIFT_ACTIVITY	Banner Finance activity code for gifts.	VARCHAR2(6)	ADBDESG	ADBDESG_ACTV_CODE	NO	NO
GIFT_ACTIVITY_DESC	Gift activity description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
GIFT_CHART_OF_ACCOUNTS	Banner Finance chart of accounts for gifts.	VARCHAR2(1)	ADBDESG	ADBDESG_COAS_CODE	NO	NO
GIFT_CHART_OF_ACCOUNTS_DESC	Chart of accounts description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
GIFT_EXTERNAL_ACCOUNT	External general ledger credit account number associated with gifts for this designation.	VARCHAR2(60)	ADBDESG	ADBDESG_GL_NO_CREDIT	NO	NO
GIFT_FUND	Banner Finance fund code for gifts.	VARCHAR2(6)	ADBDESG	ADBDESG_FUND_CODE	NO	NO
GIFT_FUND_DESC	Gift fund description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
GIFT_LOCATION	Banner Finance location code for gifts.	VARCHAR2(6)	ADBDESG	ADBDESG_LOCN_CODE	NO	NO
GIFT_LOCATION_DESC	Gift location description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
GIFT_ORGANIZATION	Banner Finance organization code for gifts.	VARCHAR2(6)	ADBDESG	ADBDESG_ORGN_CODE	NO	NO
GIFT_ORGRANIZATION_DESC	Gift organization description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
GIFT_PROGRAM	Banner Finance program code for gifts.	VARCHAR2(6)	ADBDESG	ADBDESG_PROG_CODE	NO	NO
GIFT_PROGRAM_DESC	Gift program description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MATCHING_GIFT_VSE_PURPOSE	The Matching Gift Purpose associates the Voluntary Support of Education code to a matching gift related purpose.	VARCHAR2(1)	ATVCFAE	ATVCFAE_MG_PURPOSE	NO	NO
MATCHING_GIFT_VSE_PURPOSE_DESC	Matching gift Voluntary Support of Education purpose description.	VARCHAR2(35)	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
MIF_DESC	Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
PAYMENT_ACCOUNT	Banner Finance account code for payments.	VARCHAR2(6)	ADBDESG	ADBDESG_ACCT_CODE_PYMNT	NO	NO
PAYMENT_ACCOUNT_DESC	Payment account description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PAYMENT_ACCOUNT_INDEX	Payment account index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.	VARCHAR2(6)	ADBDESG	ADBDESG_ACCI_CODE_PYMNT	NO	NO
PAYMENT_ACCOUNT_INDEX_DESC	Payment account index description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PAYMENT_ACTIVITY	Banner Finance activity code for payments.	VARCHAR2(6)	ADBDESG	ADBDESG_ACTV_CODE_PYMNT	NO	NO
PAYMENT_ACTIVITY_DESC	Payment activity description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PAYMENT_CHART_OF_ACCOUNTS	Banner Finance chart of accounts for payments.	VARCHAR2(1)	ADBDESG	ADBDESG_COAS_CODE_PYMNT	NO	NO
PAYMENT_CHART_OF_ACCOUNTS_DESC	Chart of accounts description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PAYMENT_EXTERNAL_ACCOUNT	External general ledger debit account number associated with payments for this designation.	VARCHAR2(60)	ADBDESG	ADBDESG_GL_NO_CREDIT_PYMNT	NO	NO
PAYMENT_FUND	Banner Finance fund code for payments.	VARCHAR2(6)	ADBDESG	ADBDESG_FUND_CODE_PYMNT	NO	NO
PAYMENT_FUND_DESC	Payment fund description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PAYMENT_LOCATION	Banner Finance location code for payments.	VARCHAR2(6)	ADBDESG	ADBDESG_LOCN_CODE_PYMNT	NO	NO
PAYMENT_LOCATION_DESC	Payment location description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PAYMENT_ORGANIZATION	Banner Finance organization code for payments.	VARCHAR2(6)	ADBDESG	ADBDESG_ORGN_CODE_PYMNT	NO	NO
PAYMENT_ORGRANIZATION_DESC	Payment organization description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PAYMENT_PROGRAM	Banner Finance program code for payments.	VARCHAR2(6)	ADBDESG	ADBDESG_PROG_CODE_PYMNT	NO	NO
PAYMENT_PROGRAM_DESC	Payment program description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PLEDGE_ACCOUNT	Banner Finance account code for pledges.	VARCHAR2(6)	ADBDESG	ADBDESG_ACCT_CODE_PLDG	NO	NO
PLEDGE_ACCOUNT_DESC	Pledge account description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PLEDGE_ACCOUNT_INDEX	Pledge account index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.	VARCHAR2(6)	ADBDESG	ADBDESG_ACCI_CODE_PLDG	NO	NO
PLEDGE_ACCOUNT_INDEX_DESC	Pledge account index description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PLEDGE_ACTIVITY	Banner Finance activity code for pledges.	VARCHAR2(6)	ADBDESG	ADBDESG_ACTV_CODE_PLDG	NO	NO
PLEDGE_ACTIVITY_DESC	Pledge activity description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PLEDGE_CHART_OF_ACCOUNTS	Banner Finance chart of accounts for pledges.	VARCHAR2(1)	ADBDESG	ADBDESG_COAS_CODE_PLDG	NO	NO
PLEDGE_CHART_OF_ACCOUNTS_DESC	Chart of accounts description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PLEDGE_EXTERNAL_ACCOUNT	External general ledger credit account number associated with pledges for this designation.	VARCHAR2(60)	ADBDESG	ADBDESG_GL_NO_CREDIT_PLDG	NO	NO
PLEDGE_FUND	Banner Finance fund code for pledges.	VARCHAR2(6)	ADBDESG	ADBDESG_FUND_CODE_PLDG	NO	NO
PLEDGE_FUND_DESC	Pledge fund description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PLEDGE_LOCATION	Banner Finance location code for pledges.	VARCHAR2(6)	ADBDESG	ADBDESG_LOCN_CODE_PLDG	NO	NO
PLEDGE_LOCATION_DESC	Pledge location description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PLEDGE_ORGANIZATION	Banner Finance organization code for pledges.	VARCHAR2(6)	ADBDESG	ADBDESG_ORGN_CODE_PLDG	NO	NO
PLEDGE_ORGRANIZATION_DESC	Gift pledge description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PLEDGE_PROGRAM	Banner Finance program code for pledges.	VARCHAR2(6)	ADBDESG	ADBDESG_PROG_CODE_PLDG	NO	NO
PLEDGE_PROGRAM_DESC	Pledge program description.	VARCHAR2(35)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
RESTRICTED_IND	Indicates whether the designation is restricted to transfer of pledges and/or gifts across fiscal years.	VARCHAR2(1)	ADBDESG	ADBDESG_RESTR_IND	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: