| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACCOUNT_POSTING_STATUS
|
Account Posting Status
|
Status of the transaction in the accounting feed process as ready to feed or transaction has been fed.
|
VARCHAR2(1)
|
TBRMISD
|
TBRMISD_ACCT_FEED_IND
|
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
AMOUNT
|
Amount
|
Transaction amount.
|
NUMBER
|
TBRMISD
|
TBRMISD_AMOUNT
|
|
CASHIER_END_DATE
|
Cashier End Date
|
Ending date of the cashiering session for the transaction.
|
DATE
|
TBRMISD
|
TBRMISD_CSHR_END_DATE
|
|
CASHIER_END_TIME
|
Cashier End Time
|
Ending time of the cashiering session for the transaction.
|
VARCHAR2(255)
|
CALCULATION
|
TO_CHAR(TBRMISD_CSHR_END_DATE,'HH24:MM:SS')
|
|
CASHIER_SESSION_NUMBER
|
Cashier Session Number
|
Session number assigned to each cashier session.
|
NUMBER
|
TBRMISD
|
TBRMISD_SESSION_NUMBER
|
|
CHARGE_ACCOUNT
|
Charge Account
|
Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_CHARGE_ACCT
|
|
CHARGE_ACCOUNT_DESC
|
Charge Account Description
|
Account code description or title.
|
VARCHAR2(255)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
|
|
CHARGE_ACCOUNT_INDEX
|
Charge Account Index
|
Short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_CHARGE_ACCI
|
|
CHARGE_ACCOUNT_INDEX_DESC
|
Charge Account Index Description
|
Account index description.
|
VARCHAR2(255)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
|
|
CHARGE_ACCOUNT_INDEX_STATUS
|
Charge Account Index Status
|
Current status of the associated account index.
|
VARCHAR2(1)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
|
|
CHARGE_ACCOUNT_STATUS
|
Charge Account Status
|
Current status of the associated account.
|
VARCHAR2(1)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
|
|
CHARGE_ACTIVITY
|
Charge Activity
|
Identifies accounting data by activity.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_CHARGE_ACTV
|
|
CHARGE_ACTIVITY_DESC
|
Charge Activity Description
|
Activity code title or description.
|
VARCHAR2(255)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
|
|
CHARGE_ACTIVITY_STATUS
|
Charge Activity Status
|
Extracted current status of the associated activity.
|
VARCHAR2(1)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
|
|
CHARGE_CATEGORY
|
Charge Category
|
Identities category for a receivable transaction type. For example, registration, housing, meal, and contract.
|
VARCHAR2(63)
|
TBBDETC
|
TBBDETC_DCAT_CODE
|
|
CHARGE_CATEGORY_DESC
|
Charge Category Description
|
Receivable category description.
|
VARCHAR2(255)
|
TTVDCAT
|
TTVDCAT_DESC
|
|
CHARGE_CHART_OF_ACCOUNTS
|
Charge Chart Of Accounts
|
Primary identification code for any chart of accounts which uniquely identifies that chart from any other in a multi-chart environment.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_CHARGE_COAS
|
|
CHARGE_CHART_OF_ACCOUNTS_DESC
|
Charge Chart Of Accounts Description
|
Chart of accounts code description or title.
|
VARCHAR2(255)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
|
|
CHARGE_CHART_STATUS
|
Charge Chart Of Accounts Status
|
Extracted current status of the associated chart of accounts.
|
VARCHAR2(1)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
|
|
CHARGE_DETAIL_CODE
|
Charge Detail Code
|
Detail code identifying type of charge used on this receipt.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_CHARGE_DETAIL_CODE
|
|
CHARGE_DETAIL_CODE_DESC
|
Charge Detail Code Description
|
Detail code description.
|
VARCHAR2(255)
|
TBBDETC
|
TBBDETC_DESC
|
|
CHARGE_DETAIL_CODE_TYPE
|
Charge Detail Code Type
|
Determines if the detail code is being used as a charge or a payment.
|
VARCHAR2(63)
|
TBBDETC
|
TBBDETC_TYPE_IND
|
|
CHARGE_EXTERNAL_ACCOUNT
|
Charge External Account
|
Free form account number used to interface to finance systems when Banner Finance is not present.
|
VARCHAR2(255)
|
TBRMISD
|
TBRMISD_CHARGE_ACCOUNT
|
|
CHARGE_FUND
|
Charge Fund
|
The funding source code used with this accounting transaction.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_CHARGE_FUND
|
|
CHARGE_FUND_DESC
|
Charge Fund Description
|
Associated fund description or title.
|
VARCHAR2(255)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
|
|
CHARGE_FUND_STATUS
|
Charge Fund Status
|
Extracted current status of the associated fund.
|
VARCHAR2(1)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
|
|
CHARGE_LOCATION
|
Charge Location
|
Accounting identification code of a physical location.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_CHARGE_LOCN
|
|
CHARGE_LOCATION_DESC
|
Charge Location Description
|
Extracted description or title of the associated location.
|
VARCHAR2(255)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
|
|
CHARGE_LOCATION_STATUS
|
Charge Location Status
|
Extracted current status of the associated location.
|
VARCHAR2(1)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
|
|
CHARGE_ORGANIZATION
|
Charge Organization
|
Identification accounting code used for the department.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_CHARGE_ORGN
|
|
CHARGE_ORGANIZATION_DESC
|
Charge Organization Description
|
Extracted description or title associated with the organization code.
|
VARCHAR2(255)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
|
|
CHARGE_ORGANIZATION_STATUS
|
Charge Organization Status
|
Extracted current status of the associated organization.
|
VARCHAR2(1)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
|
|
CHARGE_PRIORITY
|
Charge Priority
|
Detail code priority for use in the application of payments process.
|
VARCHAR2(63)
|
TBBDETC
|
TBBDETC_PRIORITY
|
|
CHARGE_PROGRAM
|
Charge Program
|
Accounting identification code. Program classification structure, or a subset or that structure, as defined by the national council of higher education management systems.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_CHARGE_PROG
|
|
CHARGE_PROGRAM_DESC
|
Charge Program Description
|
Extracted description or title of the associated program.
|
VARCHAR2(255)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
|
|
CHARGE_PROGRAM_STATUS
|
Charge Program Status
|
Extracted current status of the associated program.
|
VARCHAR2(1)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
|
|
CHARGE_RULE_CLASS
|
Charge Rule Class
|
Accounting transaction code defining rules used to control transaction updates to the ledgers.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_CHARGE_RUCL_CODE
|
|
CHARGE_RULE_CLASS_DESC
|
Charge Rule Class Description
|
Unique title assigned to a rule class.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_NULL_VARCHAR2
|
|
CITY
|
City
|
City associated with the address.
|
VARCHAR2(63)
|
TBBMISC
|
TBBMISC_CITY
|
|
COUNTY
|
County
|
County associated with the address.
|
VARCHAR2(63)
|
NA
|
NA
|
|
COUNTY_DESC
|
County Description
|
County address name.
|
VARCHAR2(255)
|
NA
|
NA
|
|
CREDIT_CARD_NUMBER
|
Credit Card Number
|
Credit card number or payment identification.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_PAYMENT_ID
|
|
DEBIT_CREDIT_IND
|
Debit Credit Indicator
|
Determines a debit or credit effect on the ledgers; plus or minus, debit or credit.
|
VARCHAR2(1)
|
TBRMISD
|
TBRMISD_DR_CR_IND
|
|
DOCUMENT_NUMBER
|
Document Number
|
Unique transaction id assigned from posting.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_DOCUMENT_NUMBER
|
|
ENTITY_UID
|
Entity UID
|
System internally generated ID to uniquely identify the person or oragnization for this transaction.
|
NUMBER
|
TBRMISD
|
TBRMISD_PIDM
|
|
EXTERNAL_IND
|
External Indicator
|
Indicates the transaction is for a person outside the institution system.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(TBRMISD_PIDM)
|
|
FOREIGN_CURRENCY
|
Foreign Currency
|
Contains the foreign currency code used when making a payment.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_CURR_CODE
|
|
FOREIGN_CURRENCY_AMOUNT
|
Foreign Currency Amount
|
Transaction amount as stated in foreign currency.
|
NUMBER
|
TBRMISD
|
TBRMISD_FOREIGN_AMOUNT
|
|
FOREIGN_CURRENCY_DESC
|
Foreign Currency Description
|
Foreign currency code description.
|
VARCHAR2(255)
|
GTVCURR
|
GTVCURR_TITLE
|
|
ID
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
|
NAME
|
Name
|
Current name of the person or organization for this transaction.
|
VARCHAR2(255)
|
TBBMISC
|
TBBMISC_NAME
|
|
NATION
|
Nation
|
Nation code associated with the address.
|
VARCHAR2(63)
|
TBBMISC
|
TBBMISC_NATN_CODE
|
|
NATION_DESC
|
Nation Description
|
Address nation/country description.
|
VARCHAR2(255)
|
STVNATN
|
STVNATN_NATION
|
|
PAYMENT_ACCOUNT
|
Payment Account
|
Represents an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_PAY_ACCT
|
|
PAYMENT_ACCOUNT_DESC
|
Payment Account Descripiton
|
Account code description or title.
|
VARCHAR2(255)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
|
|
PAYMENT_ACCOUNT_INDEX
|
Payment Account INDEX
|
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)
|
TBRMISD
|
TBRMISD_PAY_ACCI
|
|
PAYMENT_ACCOUNT_INDEX_DESC
|
Payment Account INDEX Description
|
Account index description.
|
VARCHAR2(255)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
|
|
PAYMENT_ACCOUNT_INDEX_STATUS
|
Payment Account INDEX Status
|
Current status of the associated account index.
|
VARCHAR2(1)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
|
|
PAYMENT_ACCOUNT_STATUS
|
Payment Account Status
|
Current status of the associated account.
|
VARCHAR2(1)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
|
|
PAYMENT_ACTIVITY
|
Payment Activity
|
Identifies accounting data by activity.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_PAY_ACTV
|
|
PAYMENT_ACTIVITY_DESC
|
Payment Activity Description
|
Activity code title or description.
|
VARCHAR2(255)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
|
|
PAYMENT_ACTIVITY_STATUS
|
Payment Activity Status
|
Extracted current status of the associated activity.
|
VARCHAR2(1)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
|
|
PAYMENT_CATEGORY
|
Payment Category
|
Identities category for a receivable transaction type. For example, registration, housing, meal, and contract.
|
VARCHAR2(63)
|
TBBDETC
|
TBBDETC_DCAT_CODE
|
|
PAYMENT_CATEGORY_DESC
|
Payment Category Description
|
Receivable category description.
|
VARCHAR2(255)
|
TTVDCAT
|
TTVDCAT_DESC
|
|
PAYMENT_CHART_OF_ACCOUNTS
|
Payment Chart Of Accounts
|
Primary identification code for any chart of accounts which uniquely identifies that chart from any other in a multi-chart environment.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_PAY_COAS
|
|
PAYMENT_CHART_OF_ACCOUNTS_DESC
|
Payment Chart Of Accounts Description
|
Chart of accounts code description or title.
|
VARCHAR2(255)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
|
|
PAYMENT_CHART_STATUS
|
Payment Chart Of Accounts Status
|
Extracted current status of the associated chart of accounts.
|
VARCHAR2(1)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
|
|
PAYMENT_DETAIL_CODE
|
Payment Detail Code
|
Detail code identifying type of payment used on this receipt.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_PAY_DETAIL_CODE
|
|
PAYMENT_DETAIL_CODE_DESC
|
Payment Detail Code Description
|
Detail code description.
|
VARCHAR2(255)
|
TBBDETC
|
TBBDETC_DESC
|
|
PAYMENT_DETAIL_CODE_TYPE
|
Payment Detail Code Type
|
Determines if the detail code is being used as a charge or a payment.
|
VARCHAR2(63)
|
TBBDETC
|
TBBDETC_TYPE_IND
|
|
PAYMENT_EXTERNAL_ACCOUNT
|
Payment External Account
|
Free form account number used to interface to finance systems when Banner Finance is not present.
|
VARCHAR2(255)
|
TBRMISD
|
TBRMISD_PAY_ACCOUNT
|
|
PAYMENT_FUND
|
Payment Fund
|
Funding source code used with this accounting transaction.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_PAY_FUND
|
|
PAYMENT_FUND_DESC
|
Payment Fund Description
|
Associated fund description or title.
|
VARCHAR2(255)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
|
|
PAYMENT_FUND_STATUS
|
Payment Fund Status
|
Extracted current status of the associated fund.
|
VARCHAR2(1)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
|
|
PAYMENT_LOCATION
|
Payment Location
|
Accounting identification code of a physical location.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_PAY_LOCN
|
|
PAYMENT_LOCATION_DESC
|
Payment Location Description
|
Extracted description or title of the associated location.
|
VARCHAR2(255)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
|
|
PAYMENT_LOCATION_STATUS
|
Payment Location Status
|
Extracted current status of the associated location.
|
VARCHAR2(1)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
|
|
PAYMENT_ORGANIZATION
|
Payment Organization
|
Identification accounting code used for the department.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_PAY_ORGN
|
|
PAYMENT_ORGANIZATION_DESC
|
Payment Organization Description
|
Extracted description or title associated with the organization code.
|
VARCHAR2(255)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
|
|
PAYMENT_ORGANIZATION_STATUS
|
Payment Organization Status
|
Extracted current status of the associated organization.
|
VARCHAR2(1)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
|
|
PAYMENT_PRIORITY
|
Payment Priority
|
Priority of the detail code for use in the application of payments process.
|
VARCHAR2(63)
|
TBBDETC
|
TBBDETC_PRIORITY
|
|
PAYMENT_PROGRAM
|
Payment Program
|
Accounting identification code. Identifies the program classification structure, or a subset or that structure, as defined by the national council of higher education management systems.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_PAY_PROG
|
|
PAYMENT_PROGRAM_DESC
|
Payment Program Description
|
Extracted description or title of the associated program.
|
VARCHAR2(255)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
|
|
PAYMENT_PROGRAM_STATUS
|
Payment Program Status
|
Extracted current status of the associated program.
|
VARCHAR2(1)
|
FUNCTION
|
TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
|
|
PAYMENT_RULE_CLASS
|
Payment Rule Class
|
Accounting transaction code defining rules used to control transaction updates to the ledgers.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_PAY_RUCL_CODE
|
|
PAYMENT_RULE_CLASS_DESC
|
Payment Rule Class Description
|
Unique title assigned to a rule class.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_NULL_VARCHAR2
|
|
POSTAL_CODE
|
Potal Code
|
Address postal code.
|
VARCHAR2(63)
|
TBBMISC
|
TBBMISC_ZIP
|
|
POSTING_DATE
|
Posting Date
|
Date the accounting transaction was interfaced to the ledgers.
|
DATE
|
TBRMISD
|
TBRMISD_FEED_DATE
|
|
POSTING_DOCUMENT
|
Posting Document
|
Document code generated to identify and feed this transaction to finance.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_FEED_DOC_CODE
|
|
POST_CASHIER
|
Post Cashier
|
Identification code of the cashier who entered the transaction.
|
VARCHAR2(63)
|
TBRMISD
|
TBRMISD_USER
|
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
RECEIPT_NUMBER
|
Receipt Number
|
Receipt number associated with the transaction if a receipt number was generated when the transaction was entered.
|
NUMBER
|
TBRMISD
|
TBRMISD_RECEIPT_NUMBER
|
|
STATE_PROVINCE
|
State Province
|
State/Province code for the address.
|
VARCHAR2(63)
|
TBBMISC
|
TBBMISC_STAT_CODE
|
|
STATE_PROVINCE_DESC
|
State Province Description
|
State/Province name.
|
VARCHAR2(255)
|
STVSTAT
|
STVSTAT_DESC
|
|
STREET_LINE1
|
Street Line1
|
First line of the address.
|
VARCHAR2(255)
|
TBBMISC
|
TBBMISC_STREET_LINE1
|
|
STREET_LINE2
|
Street Line2
|
Second line of the address.
|
VARCHAR2(255)
|
TBBMISC
|
TBBMISC_STREET_LINE2
|
|
STREET_LINE3
|
Street Line3
|
Third line of the address.
|
VARCHAR2(255)
|
TBBMISC
|
TBBMISC_STREET_LINE3
|
|
STREET_LINE4
|
Street Line 4
|
Fourth line of the address.
|
VARCHAR2(255)
|
NA
|
NA
|
|
TRANSACTION_ACTIVITY_DATE
|
Transaction Activity Date
|
Date record was inserted or updated.
|
DATE
|
TBRMISD
|
TBRMISD_ACTIVITY_DATE
|
|
TRANSACTION_DATE
|
Transaction Date
|
Date the transaction was posted into the ledgers.
|
DATE
|
TBRMISD
|
TBRMISD_TRANS_DATE
|
|
TRANSACTION_DESC
|
Transaction Description
|
Accounting transaction description.
|
VARCHAR2(255)
|
TBRMISD
|
TBRMISD_DESC
|
|
TRANSACTION_NUMBER
|
Transaction Number
|
A unique one-up number assigned to each transaction on the receipt.
|
NUMBER
|
TBRMISD
|
TBRMISD_TRAN_NUMBER
|