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)
|
ATVSDTA
|
ATVDSTA_ACTIVE_IND
|
ACTIVITY_DATE
|
Date information for this record in the table was entered or last updated.
|
DATE
|
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.
|
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')
|
CURRENT_DATE
|
System current date (sysdate), or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
DESG_COLLEGE
|
Specific college to which the fund is allocated or designated.
|
VARCHAR2(2)
|
ADBDESG
|
ADBDESG_COLL_CODE
|
DESG_COLLEGE_DESC
|
College description.
|
VARCHAR2(30)
|
STVCOLL
|
STVCOLL_DESC
|
DESG_DEPARTMENT
|
Department associated with the designation.
|
VARCHAR2(4)
|
ADBDESG
|
ADBDESG_DEPT_CODE
|
DESG_DEPARTMENT_DESC
|
Designation department description.
|
VARCHAR2(30)
|
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(5)
|
ADBDESG
|
ADBDESG_DGRP_CODE
|
DESG_GROUP_DESC
|
Designation group description.
|
VARCHAR2(30)
|
ATVDGRP
|
ATVDGRP_DESC
|
DESG_STATUS
|
Current designation status.
|
VARCHAR2(1)
|
ADBDESG
|
ADBDESG_DSTA_CODE
|
DESG_STATUS_DESC
|
Designation status description.
|
VARCHAR2(30)
|
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(5)
|
ADBDESG
|
ADBDESG_DSTP_CODE
|
DESG_TYPE_DESC
|
Designation type description.
|
VARCHAR2(30)
|
ATVDSTP
|
ATVDSTP_DESC
|
DESG_VSE
|
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
|
Voluntary Support of Education purpose description.
|
VARCHAR2(30)
|
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(35)
|
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(10)
|
ADBDESG
|
ADBDESG_DESG
|
DESIGNATION_END_DATE
|
Date the designation is no longer active.
|
DATE
|
ADBDESG
|
ADBDESG_END_DATE
|
DESIGNATION_NAME
|
Designation name.
|
VARCHAR2(60)
|
ADBDESG
|
ADBDESG_NAME
|
DESIGNATION_PROJECT
|
Project to which this designation is assigned.
|
VARCHAR2(6)
|
AMRDESG
|
AMRDESG_PROJ_CODE
|
DESIGNATION_PROJECT_DESC
|
Designation project description.
|
VARCHAR2(30)
|
ATVPROJ
|
ATVPROJ_DESC
|
DESIGNATION_START_DATE
|
Date the designation becomes active.
|
DATE
|
ADBDESG
|
ADBDESG_START_DATE
|
DESIGNATION_USER_ID
|
Unique identification code of the user who entered or last touched the designation.
|
VARCHAR2(30)
|
ADBDESG
|
ADBDESG_USER
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
EXPENDITURE_EXTERNAL_ACCOUNT
|
External general ledger account number associated with expenditures for this designation.
|
VARCHAR2(60)
|
ADBDESG
|
ADBDESG_GL_NO_CREDIT_EXPND
|
EXPEND_ACCOUNT
|
Banner Finance account code for expenditures.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_ACCT_CODE_EXPND
|
EXPEND_ACCOUNT_DESC
|
Expenditure account description.
|
VARCHAR2(35)
|
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.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_ACCI_CODE_EXPND
|
EXPEND_ACCOUNT_INDEX_DESC
|
Expenditure account index description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
EXPEND_ACTIVITY
|
Banner Finance activity code for expenditures.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_ACTV_CODE_EXPND
|
EXPEND_ACTIVITY_DESC
|
Expenditure activity description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
EXPEND_CHART_OF_ACCOUNTS
|
Banner Finance chart of accounts for expenditures.
|
VARCHAR2(1)
|
ADBDESG
|
ADBDESG_COAS_CODE_EXPND
|
EXPEND_CHART_OF_ACCOUNTS_DESC
|
Chart of accounts description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
EXPEND_FUND
|
Banner Finance fund code for expenditures.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_FUND_CODE_EXPND
|
EXPEND_FUND_DESC
|
Expenditure fund description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
EXPEND_LOCATION
|
Banner Finance location code for expenditures.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_LOCN_CODE_EXPND
|
EXPEND_LOCATION_DESC
|
Expenditure location description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
EXPEND_ORGANIZATION
|
Banner Finance organization code for expenditures.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_ORGN_CODE_EXPND
|
EXPEND_ORGRANIZATION_DESC
|
Expenditure organization description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
EXPEND_PROGRAM
|
Banner Finance program code for expenditures.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_PROG_CODE_EXPND
|
EXPEND_PROGRAM_DESC
|
Expenditure program description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
GIFT_ACCOUNT
|
Banner Finance account code for gifts.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_ACCT_CODE
|
GIFT_ACCOUNT_DESC
|
Gift account description.
|
VARCHAR2(35)
|
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.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_ACCI_CODE
|
GIFT_ACCOUNT_INDEX_DESC
|
Gift account index description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
GIFT_ACTIVITY
|
Banner Finance activity code for gifts.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_ACTV_CODE
|
GIFT_ACTIVITY_DESC
|
Gift activity description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
GIFT_CHART_OF_ACCOUNTS
|
Banner Finance chart of accounts for gifts.
|
VARCHAR2(1)
|
ADBDESG
|
ADBDESG_COAS_CODE
|
GIFT_CHART_OF_ACCOUNTS_DESC
|
Chart of accounts description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
GIFT_EXTERNAL_ACCOUNT
|
External general ledger credit account number associated with gifts for this designation.
|
VARCHAR2(60)
|
ADBDESG
|
ADBDESG_GL_NO_CREDIT
|
GIFT_FUND
|
Banner Finance fund code for gifts.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_FUND_CODE
|
GIFT_FUND_DESC
|
Gift fund description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
GIFT_LOCATION
|
Banner Finance location code for gifts.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_LOCN_CODE
|
GIFT_LOCATION_DESC
|
Gift location description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
GIFT_ORGANIZATION
|
Banner Finance organization code for gifts.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_ORGN_CODE
|
GIFT_ORGRANIZATION_DESC
|
Gift organization description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
GIFT_PROGRAM
|
Banner Finance program code for gifts.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_PROG_CODE
|
GIFT_PROGRAM_DESC
|
Gift program description.
|
VARCHAR2(35)
|
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.
|
VARCHAR2(1)
|
ATVCFAE
|
ATVCFAE_MG_PURPOSE
|
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.)
|
MIF_DESC
|
Institution description for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
PAYMENT_ACCOUNT
|
Banner Finance account code for payments.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_ACCT_CODE_PYMNT
|
PAYMENT_ACCOUNT_DESC
|
Payment account description.
|
VARCHAR2(35)
|
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.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_ACCI_CODE_PYMNT
|
PAYMENT_ACCOUNT_INDEX_DESC
|
Payment account index description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PAYMENT_ACTIVITY
|
Banner Finance activity code for payments.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_ACTV_CODE_PYMNT
|
PAYMENT_ACTIVITY_DESC
|
Payment activity description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PAYMENT_CHART_OF_ACCOUNTS
|
Banner Finance chart of accounts for payments.
|
VARCHAR2(1)
|
ADBDESG
|
ADBDESG_COAS_CODE_PYMNT
|
PAYMENT_CHART_OF_ACCOUNTS_DESC
|
Chart of accounts description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
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
|
Banner Finance fund code for payments.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_FUND_CODE_PYMNT
|
PAYMENT_FUND_DESC
|
Payment fund description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PAYMENT_LOCATION
|
Banner Finance location code for payments.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_LOCN_CODE_PYMNT
|
PAYMENT_LOCATION_DESC
|
Payment location description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PAYMENT_ORGANIZATION
|
Banner Finance organization code for payments.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_ORGN_CODE_PYMNT
|
PAYMENT_ORGRANIZATION_DESC
|
Payment organization description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PAYMENT_PROGRAM
|
Banner Finance program code for payments.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_PROG_CODE_PYMNT
|
PAYMENT_PROGRAM_DESC
|
Payment program description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PLEDGE_ACCOUNT
|
Banner Finance account code for pledges.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_ACCT_CODE_PLDG
|
PLEDGE_ACCOUNT_DESC
|
Pledge account description.
|
VARCHAR2(35)
|
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.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_ACCI_CODE_PLDG
|
PLEDGE_ACCOUNT_INDEX_DESC
|
Pledge account index description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PLEDGE_ACTIVITY
|
Banner Finance activity code for pledges.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_ACTV_CODE_PLDG
|
PLEDGE_ACTIVITY_DESC
|
Pledge activity description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PLEDGE_CHART_OF_ACCOUNTS
|
Banner Finance chart of accounts for pledges.
|
VARCHAR2(1)
|
ADBDESG
|
ADBDESG_COAS_CODE_PLDG
|
PLEDGE_CHART_OF_ACCOUNTS_DESC
|
Chart of accounts description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
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
|
Banner Finance fund code for pledges.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_FUND_CODE_PLDG
|
PLEDGE_FUND_DESC
|
Pledge fund description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PLEDGE_LOCATION
|
Banner Finance location code for pledges.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_LOCN_CODE_PLDG
|
PLEDGE_LOCATION_DESC
|
Pledge location description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PLEDGE_ORGANIZATION
|
Banner Finance organization code for pledges.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_ORGN_CODE_PLDG
|
PLEDGE_ORGRANIZATION_DESC
|
Gift pledge description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
PLEDGE_PROGRAM
|
Banner Finance program code for pledges.
|
VARCHAR2(6)
|
ADBDESG
|
ADBDESG_PROG_CODE_PLDG
|
PLEDGE_PROGRAM_DESC
|
Pledge program description.
|
VARCHAR2(35)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
RESTRICTED_IND
|
Indicates whether the designation is restricted to transfer of pledges and/or gifts across fiscal years.
|
VARCHAR2(1)
|
ADBDESG
|
ADBDESG_RESTR_IND
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|