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. Determines if the status is active (Y)es, or inactive (N)o.	VARCHAR2(1)		ATVSDTA	ATVDSTA_ACTIVE_IND
ACTIVITY_DATE	Activity Date	Date information for this record in the table was entered or last updated.	DATE		ADBDESG	ADBDESG_ACTIVITY_DATE
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')
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')
CURRENT_DATE	Current Date	System current date (sysdate), or date the data was extracted.	DATE		NA	SYSDATE
DESG_COLLEGE	Designation College	Specific college to which the fund is allocated or designated.	VARCHAR2(2)		ADBDESG	ADBDESG_COLL_CODE
DESG_COLLEGE_DESC	Designation College Description	College description.	VARCHAR2(30)		STVCOLL	STVCOLL_DESC
DESG_DEPARTMENT	Designation Department	Department associated with the designation.	VARCHAR2(4)		ADBDESG	ADBDESG_DEPT_CODE
DESG_DEPARTMENT_DESC	Designation Department Description	Designation department description	VARCHAR2(30)		STVDEPT	STVDEPT_DESC
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(5)		ADBDESG	ADBDESG_DGRP_CODE
DESG_GROUP_DESC	Designation Group Description	Designation group description.	VARCHAR2(30)		ATVDGRP	ATVDGRP_DESC
DESG_STATUS	Designation Status	Current designation status.	VARCHAR2(1)		ADBDESG	ADBDESG_DSTA_CODE
DESG_STATUS_DESC	Designation Status Description	Designation status description.	VARCHAR2(30)		ATVSDTA	ATVDSTA_DESC
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(5)		ADBDESG	ADBDESG_DSTP_CODE
DESG_TYPE_DESC	Designation Type Description	Designation type description.	VARCHAR2(30)		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(5)		ADBDESG	ADBDESG_CFAE_CODE
DESG_VSE_DESC	Designation VSE - Voluntary Support of Education Description	Voluntary Support of Education purpose description.	VARCHAR2(30)		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(2)		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(35)		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(10)		ADBDESG	ADBDESG_DESG
DESIGNATION_END_DATE	Designation End Date	Date the designation is no longer active.	DATE		ADBDESG	ADBDESG_END_DATE
DESIGNATION_NAME	Designation Name	Designation name.	VARCHAR2(60)		ADBDESG	ADBDESG_NAME
DESIGNATION_PROJECT	Designation Project	Project to which this designation is assigned.	VARCHAR2(6)		AMRDESG	AMRDESG_PROJ_CODE
DESIGNATION_PROJECT_DESC	Designation Project Description	Designation project description.	VARCHAR2(30)		ATVPROJ	ATVPROJ_DESC
DESIGNATION_START_DATE	Designation Start Date	Date the designation becomes active.	DATE		ADBDESG	ADBDESG_START_DATE
DESIGNATION_USER_ID	Designation User ID	Unique identification code of the user who entered or last touched the designation.	VARCHAR2(30)		ADBDESG	ADBDESG_USER
DOMAIN_VALUE	Domain Value	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
EXPENDITURE_EXTERNAL_ACCOUNT	Expenditure External Account	External general ledger account number associated with expenditures for this designation.	VARCHAR2(60)		ADBDESG	ADBDESG_GL_NO_CREDIT_EXPND
EXPEND_ACCOUNT	Expenditure Account	Banner Finance account code for expenditures.	VARCHAR2(6)		ADBDESG	ADBDESG_ACCT_CODE_EXPND
EXPEND_ACCOUNT_DESC	Expenditure Account Description	Expenditure account description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
EXPEND_ACCOUNT_INDEX	Expenditure 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
EXPEND_ACCOUNT_INDEX_DESC	Expenditure Account INDEX Description	Expenditure account index description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
EXPEND_ACTIVITY	Expenditure Activity	Banner Finance activity code for expenditures.	VARCHAR2(6)		ADBDESG	ADBDESG_ACTV_CODE_EXPND
EXPEND_ACTIVITY_DESC	Expenditure Activity Description	Expenditure activity description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
EXPEND_CHART_OF_ACCOUNTS	Expenditure Chart Of Accounts	Banner Finance chart of accounts for expenditures.	VARCHAR2(1)		ADBDESG	ADBDESG_COAS_CODE_EXPND
EXPEND_CHART_OF_ACCOUNTS_DESC	Expenditure Chart Of Accounts Description	Chart of accounts description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
EXPEND_FUND	Expenditure Fund	Banner Finance fund code for expenditures.	VARCHAR2(6)		ADBDESG	ADBDESG_FUND_CODE_EXPND
EXPEND_FUND_DESC	Expenditure Fund Description	Expenditure fund description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
EXPEND_LOCATION	Expenditure Location	Banner Finance location code for expenditures.	VARCHAR2(6)		ADBDESG	ADBDESG_LOCN_CODE_EXPND
EXPEND_LOCATION_DESC	Expenditure Location Description	Expenditure location description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
EXPEND_ORGANIZATION	Expenditure Organization	Banner Finance organization code for expenditures.	VARCHAR2(6)		ADBDESG	ADBDESG_ORGN_CODE_EXPND
EXPEND_ORGRANIZATION_DESC	Expenditure Orgranization Description	Expenditure organization description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
EXPEND_PROGRAM	Expenditure Program	Banner Finance program code for expenditures.	VARCHAR2(6)		ADBDESG	ADBDESG_PROG_CODE_EXPND
EXPEND_PROGRAM_DESC	Expenditure Program Description	Expenditure program description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
GIFT_ACCOUNT	Gift Account	Banner Finance account code for gifts.	VARCHAR2(6)		ADBDESG	ADBDESG_ACCT_CODE
GIFT_ACCOUNT_DESC	Gift Account Description	Gift account description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
GIFT_ACCOUNT_INDEX	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
GIFT_ACCOUNT_INDEX_DESC	Gift Account INDEX Description	Gift account index description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
GIFT_ACTIVITY	Gift Activity	Banner Finance activity code for gifts.	VARCHAR2(6)		ADBDESG	ADBDESG_ACTV_CODE
GIFT_ACTIVITY_DESC	Gift Activity Description	Gift activity description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
GIFT_CHART_OF_ACCOUNTS	Gift Chart Of Accounts	Banner Finance chart of accounts for gifts.	VARCHAR2(1)		ADBDESG	ADBDESG_COAS_CODE
GIFT_CHART_OF_ACCOUNTS_DESC	Gift Chart Of Accounts Description	Chart of accounts description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
GIFT_EXTERNAL_ACCOUNT	Gift External Account	External general ledger credit account number associated with gifts for this designation.	VARCHAR2(60)		ADBDESG	ADBDESG_GL_NO_CREDIT
GIFT_FUND	Gift Fund	Banner Finance fund code for gifts.	VARCHAR2(6)		ADBDESG	ADBDESG_FUND_CODE
GIFT_FUND_DESC	Gift Fund Description	Gift fund description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
GIFT_LOCATION	Gift Location	Banner Finance location code for gifts.	VARCHAR2(6)		ADBDESG	ADBDESG_LOCN_CODE
GIFT_LOCATION_DESC	Gift Location Description	Gift location description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
GIFT_ORGANIZATION	Gift Organization	Banner Finance organization code for gifts.	VARCHAR2(6)		ADBDESG	ADBDESG_ORGN_CODE
GIFT_ORGRANIZATION_DESC	Gift Orgranization Description	Gift organization description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
GIFT_PROGRAM	Gift Program	Banner Finance program code for gifts.	VARCHAR2(6)		ADBDESG	ADBDESG_PROG_CODE
GIFT_PROGRAM_DESC	Gift Program Description	Gift program description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
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(1)		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(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.)
MIF_DESC	MIF Description	Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE	MIF Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
PAYMENT_ACCOUNT	Payment Account	Banner Finance account code for payments.	VARCHAR2(6)		ADBDESG	ADBDESG_ACCT_CODE_PYMNT
PAYMENT_ACCOUNT_DESC	Payment Account Description	Payment account description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
PAYMENT_ACCOUNT_INDEX	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
PAYMENT_ACCOUNT_INDEX_DESC	Payment Account INDEX Description	Payment account index description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
PAYMENT_ACTIVITY	Payment Activity	Banner Finance activity code for payments.	VARCHAR2(6)		ADBDESG	ADBDESG_ACTV_CODE_PYMNT
PAYMENT_ACTIVITY_DESC	Payment Activity Description	Payment activity description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
PAYMENT_CHART_OF_ACCOUNTS	Payment Chart Of Accounts	Banner Finance chart of accounts for payments.	VARCHAR2(1)		ADBDESG	ADBDESG_COAS_CODE_PYMNT
PAYMENT_CHART_OF_ACCOUNTS_DESC	Payment Chart Of Accounts Description	Chart of accounts description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
PAYMENT_EXTERNAL_ACCOUNT	Payment External Account	External general ledger debit account number associated with payments for this designation.	VARCHAR2(60)		ADBDESG	ADBDESG_GL_NO_CREDIT_PYMNT
PAYMENT_FUND	Payment Fund	Banner Finance fund code for payments.	VARCHAR2(6)		ADBDESG	ADBDESG_FUND_CODE_PYMNT
PAYMENT_FUND_DESC	Payment Fund Description	Payment fund description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
PAYMENT_LOCATION	Payment Location	Banner Finance location code for payments.	VARCHAR2(6)		ADBDESG	ADBDESG_LOCN_CODE_PYMNT
PAYMENT_LOCATION_DESC	Payment Location Description	Payment location description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
PAYMENT_ORGANIZATION	Payment Organization	Banner Finance organization code for payments.	VARCHAR2(6)		ADBDESG	ADBDESG_ORGN_CODE_PYMNT
PAYMENT_ORGRANIZATION_DESC	Payment Orgranization Description	Payment organization description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
PAYMENT_PROGRAM	Payment Program	Banner Finance program code for payments.	VARCHAR2(6)		ADBDESG	ADBDESG_PROG_CODE_PYMNT
PAYMENT_PROGRAM_DESC	Payment Program Description	Payment program description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
PLEDGE_ACCOUNT	Pledge Account	Banner Finance account code for pledges.	VARCHAR2(6)		ADBDESG	ADBDESG_ACCT_CODE_PLDG
PLEDGE_ACCOUNT_DESC	Pledge Account Description	Pledge account description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
PLEDGE_ACCOUNT_INDEX	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
PLEDGE_ACCOUNT_INDEX_DESC	Pledge Account INDEX Description	Pledge account index description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
PLEDGE_ACTIVITY	Pledge Activity	Banner Finance activity code for pledges.	VARCHAR2(6)		ADBDESG	ADBDESG_ACTV_CODE_PLDG
PLEDGE_ACTIVITY_DESC	Pledge Activity Description	Pledge activity description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
PLEDGE_CHART_OF_ACCOUNTS	Pledge Chart Of Accounts	Banner Finance chart of accounts for pledges.	VARCHAR2(1)		ADBDESG	ADBDESG_COAS_CODE_PLDG
PLEDGE_CHART_OF_ACCOUNTS_DESC	Pledge Chart Of Accounts Description	Chart of accounts description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
PLEDGE_EXTERNAL_ACCOUNT	Pledge External Account	External general ledger credit account number associated with pledges for this designation.	VARCHAR2(60)		ADBDESG	ADBDESG_GL_NO_CREDIT_PLDG
PLEDGE_FUND	Pledge Fund	Banner Finance fund code for pledges.	VARCHAR2(6)		ADBDESG	ADBDESG_FUND_CODE_PLDG
PLEDGE_FUND_DESC	Pledge Fund Description	Pledge fund description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
PLEDGE_LOCATION	Pledge Location	Banner Finance location code for pledges.	VARCHAR2(6)		ADBDESG	ADBDESG_LOCN_CODE_PLDG
PLEDGE_LOCATION_DESC	Pledge Location Description	Pledge location description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
PLEDGE_ORGANIZATION	Pledge Organization	Banner Finance organization code for pledges.	VARCHAR2(6)		ADBDESG	ADBDESG_ORGN_CODE_PLDG
PLEDGE_ORGRANIZATION_DESC	Pledge Orgranization Description	Gift pledge description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
PLEDGE_PROGRAM	Pledge Program	Banner Finance program code for pledges.	VARCHAR2(6)		ADBDESG	ADBDESG_PROG_CODE_PLDG
PLEDGE_PROGRAM_DESC	Pledge Program Description	Pledge program description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
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
ZONE_VALUE	Zone Value	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: