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

Ver: 8.3