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
|
Group associated with the designation. 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_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
|
GIFT_EXTERNAL_ACCOUNT
|
Gift External Account
|
Actual account number from a finance system associated with gifts.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_GL_NO_CREDIT
|
NO
|
NO
|
PLEDGE_EXTERNAL_ACCOUNT
|
Pledge External Account
|
Actual account number from a finance system associated with pledges.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_GL_NO_CREDIT_PLDG
|
NO
|
NO
|
PAYMENT_EXTERNAL_ACCOUNT
|
Payment External Account
|
Actual account number from a finance system associated with payments.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_GL_NO_CREDIT_PYMNT
|
NO
|
NO
|
EXPENDITURE_EXTERNAL_ACCOUNT
|
Expenditure External Account
|
Actual account number from a finance system associated with expenditures.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_GL_NO_CREDIT_EXPND
|
NO
|
NO
|
GIFT_CHART_OF_ACCOUNTS
|
Gift Chart Of Accounts
|
Banner Finance chart of accounts for gifts.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_COAS_CODE
|
NO
|
NO
|
GIFT_CHART_OF_ACCOUNTS_DESC
|
Gift Chart Of Accounts Description
|
Chart of accounts description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
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(63)
|
|
|
ADBDESG
|
ADBDESG_ACCI_CODE
|
NO
|
NO
|
GIFT_ACCOUNT_INDEX_DESC
|
Gift Account INDEX Description
|
Gift account index description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
GIFT_FUND
|
Gift Fund
|
Banner Finance fund code for gifts.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_FUND_CODE
|
NO
|
NO
|
GIFT_FUND_DESC
|
Gift Fund Description
|
Gift fund description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
GIFT_ORGANIZATION
|
Gift Organization
|
Banner Finance organization code for gifts.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_ORGN_CODE
|
NO
|
NO
|
GIFT_ORGRANIZATION_DESC
|
Gift Orgranization Description
|
Gift organization description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
GIFT_ACCOUNT
|
Gift Account
|
Banner Finance account code for gifts.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_ACCT_CODE
|
NO
|
NO
|
GIFT_ACCOUNT_DESC
|
Gift Account Description
|
Gift account description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
GIFT_PROGRAM
|
Gift Program
|
Banner Finance program code for gifts.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_PROG_CODE
|
NO
|
NO
|
GIFT_PROGRAM_DESC
|
Gift Program Description
|
Gift program description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
GIFT_ACTIVITY
|
Gift Activity
|
Banner Finance activity code for gifts.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_ACTV_CODE
|
NO
|
NO
|
GIFT_ACTIVITY_DESC
|
Gift Activity Description
|
Gift activity description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
GIFT_LOCATION
|
Gift Location
|
Banner Finance location code for gifts.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_LOCN_CODE
|
NO
|
NO
|
GIFT_LOCATION_DESC
|
Gift Location Description
|
Gift location description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PLEDGE_CHART_OF_ACCOUNTS
|
Pledge Chart Of Accounts
|
Banner Finance chart of accounts for pledges.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_COAS_CODE_PLDG
|
NO
|
NO
|
PLEDGE_CHART_OF_ACCOUNTS_DESC
|
Pledge Chart Of Accounts Description
|
Chart of accounts description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
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(63)
|
|
|
ADBDESG
|
ADBDESG_ACCI_CODE_PLDG
|
NO
|
NO
|
PLEDGE_ACCOUNT_INDEX_DESC
|
Pledge Account INDEX Description
|
Pledge account index description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PLEDGE_FUND
|
Pledge Fund
|
Banner Finance fund code for pledges.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_FUND_CODE_PLDG
|
NO
|
NO
|
PLEDGE_FUND_DESC
|
Pledge Fund Description
|
Pledge fund description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PLEDGE_ORGANIZATION
|
Pledge Organization
|
Banner Finance organization code for pledges.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_ORGN_CODE_PLDG
|
NO
|
NO
|
PLEDGE_ORGRANIZATION_DESC
|
Pledge Orgranization Description
|
Gift pledge description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PLEDGE_ACCOUNT
|
Pledge Account
|
Banner Finance account code for pledges.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_ACCT_CODE_PLDG
|
NO
|
NO
|
PLEDGE_ACCOUNT_DESC
|
Pledge Account Description
|
Pledge account description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PLEDGE_PROGRAM
|
Pledge Program
|
Banner Finance program code for pledges.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_PROG_CODE_PLDG
|
NO
|
NO
|
PLEDGE_PROGRAM_DESC
|
Pledge Program Description
|
Pledge program description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PLEDGE_ACTIVITY
|
Pledge Activity
|
Banner Finance activity code for pledges.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_ACTV_CODE_PLDG
|
NO
|
NO
|
PLEDGE_ACTIVITY_DESC
|
Pledge Activity Description
|
Pledge activity description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PLEDGE_LOCATION
|
Pledge Location
|
Banner Finance location code for pledges.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_LOCN_CODE_PLDG
|
NO
|
NO
|
PLEDGE_LOCATION_DESC
|
Pledge Location Description
|
Pledge location description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PAYMENT_CHART_OF_ACCOUNTS
|
Payment Chart Of Accounts
|
Banner Finance chart of accounts for payments.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_COAS_CODE_PYMNT
|
NO
|
NO
|
PAYMENT_CHART_OF_ACCOUNTS_DESC
|
Payment Chart Of Accounts Description
|
Chart of accounts description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
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(63)
|
|
|
ADBDESG
|
ADBDESG_ACCI_CODE_PYMNT
|
NO
|
NO
|
PAYMENT_ACCOUNT_INDEX_DESC
|
Payment Account INDEX Description
|
Payment account index description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PAYMENT_FUND
|
Payment Fund
|
Banner Finance fund code for payments.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_FUND_CODE_PYMNT
|
NO
|
NO
|
PAYMENT_FUND_DESC
|
Payment Fund Description
|
Payment fund description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PAYMENT_ORGANIZATION
|
Payment Organization
|
Banner Finance organization code for payments.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_ORGN_CODE_PYMNT
|
NO
|
NO
|
PAYMENT_ORGRANIZATION_DESC
|
Payment Orgranization Description
|
Payment organization description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PAYMENT_ACCOUNT
|
Payment Account
|
Banner Finance account code for payments.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_ACCT_CODE_PYMNT
|
NO
|
NO
|
PAYMENT_ACCOUNT_DESC
|
Payment Account Description
|
Payment account description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PAYMENT_PROGRAM
|
Payment Program
|
Banner Finance program code for payments.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_PROG_CODE_PYMNT
|
NO
|
NO
|
PAYMENT_PROGRAM_DESC
|
Payment Program Description
|
Payment program description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PAYMENT_ACTIVITY
|
Payment Activity
|
Banner Finance activity code for payments.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_ACTV_CODE_PYMNT
|
NO
|
NO
|
PAYMENT_ACTIVITY_DESC
|
Payment Activity Description
|
Payment activity description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
PAYMENT_LOCATION
|
Payment Location
|
Banner Finance location code for payments.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_LOCN_CODE_PYMNT
|
NO
|
NO
|
PAYMENT_LOCATION_DESC
|
Payment Location Description
|
Payment location description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
EXPEND_CHART_OF_ACCOUNTS
|
Expenditure Chart Of Accounts
|
Banner Finance chart of accounts for expenditures.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_COAS_CODE_EXPND
|
NO
|
NO
|
EXPEND_CHART_OF_ACCOUNTS_DESC
|
Expenditure Chart Of Accounts Description
|
Chart of accounts description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
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(63)
|
|
|
ADBDESG
|
ADBDESG_ACCI_CODE_EXPND
|
NO
|
NO
|
EXPEND_ACCOUNT_INDEX_DESC
|
Expenditure Account INDEX Description
|
Expenditure account index description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
EXPEND_FUND
|
Expenditure Fund
|
Banner Finance fund code for expenditures.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_FUND_CODE_EXPND
|
NO
|
NO
|
EXPEND_FUND_DESC
|
Expenditure Fund Description
|
Expenditure fund description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
EXPEND_ORGANIZATION
|
Expenditure Organization
|
Banner Finance organization code for expenditures.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_ORGN_CODE_EXPND
|
NO
|
NO
|
EXPEND_ORGRANIZATION_DESC
|
Expenditure Orgranization Description
|
Expenditure organization description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
EXPEND_ACCOUNT
|
Expenditure Account
|
Banner Finance account code for expenditures.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_ACCT_CODE_EXPND
|
NO
|
NO
|
EXPEND_ACCOUNT_DESC
|
Expenditure Account Description
|
Expenditure account description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
EXPEND_PROGRAM
|
Expenditure Program
|
Banner Finance program code for expenditures.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_PROG_CODE_EXPND
|
NO
|
NO
|
EXPEND_PROGRAM_DESC
|
Expenditure Program Description
|
Expenditure program description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
EXPEND_ACTIVITY
|
Expenditure Activity
|
Banner Finance activity code for expenditures.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_ACTV_CODE_EXPND
|
NO
|
NO
|
EXPEND_ACTIVITY_DESC
|
Expenditure Activity Description
|
Expenditure activity description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
EXPEND_LOCATION
|
Expenditure Location
|
Banner Finance location code for expenditures.
|
VARCHAR2(63)
|
|
|
ADBDESG
|
ADBDESG_LOCN_CODE_EXPND
|
NO
|
NO
|
EXPEND_LOCATION_DESC
|
Expenditure Location Description
|
Expenditure location description.
|
VARCHAR2(255)
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
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
|