Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic Period	Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.	VARCHAR2(63)	TBRDEPO	TBRDEPO_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic Period Description	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic Year	Academic year associated with the academic period on this record.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic Year Description	Academic year description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACCOUNT_POSTED_AMOUNT	Account Posted Amount	Amount that has been posted.	NUMBER	CALCULATION	DECODE(TBRDEPO_FEED_DATE, NULL, NULL, TBRDEPO_AMOUNT)
ACCOUNT_POSTING_STATUS	Account Posting Status	Indicates the status of the transaction in the accounting feed process as ready to feed or transaction has been fed.	VARCHAR2(63)	TBRDEPO	TBRDEPO_ACCT_FEED_IND
ACCOUNT_UID	Account UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	TBRDEPO	TBRDEPO_PIDM
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AUTO_RELEASE_IND	Auto Release Indicator	Indicates whether the deposit should be automatically released on the account after the release date. Valid values are: Y - automatically release, N - release manually on the account detail form.	VARCHAR2(1)	TBRDEPO	TBRDEPO_AUTO_RELEASE_IND
BALANCE_AMOUNT	Balance Amount	Remaining balance of all deposit available and pending release to the receivable account.	NUMBER	CALCULATION	NVL(TBRDEPO_AMOUNT-F_ACCD_AMOUNT(TBRDEPO_PIDM,TBRDEPO_TRAN_NUMBER),0)
CASHIER_END_DATE	Cashier End Date	Ending date of the cashiering session for the transaction.	DATE	TBRDEPO	TBRDEPO_CSHR_END_DATE
CASHIER_END_TIME	Cashier End Time	Ending time of the cashiering session for the transaction.	VARCHAR2(63)	CALCULATION	TO_CHAR(TBRDEPO_CSHR_END_DATE,'HH24:MM:SS')
CASHIER_SESSION_NUMBER	Cashier Session Number	Session number assigned to each cashier session.	NUMBER	TBRDEPO	TBRDEPO_SESSION_NUMBER
DEPOSIT_ACTIVITY_DATE	Deposit Activity Date	Most current date record was created or updated.	DATE	TBRDEPO	TBRDEPO_ACTIVITY_DATE
DEPOSIT_EFFECTIVE_DATE	Deposit Effective Date	Effective date of the deposit. This date defaults to the date the deposit was entered.	DATE	TBRDEPO	TBRDEPO_EFFECTIVE_DATE
DEPOSIT_ENTRY_DATE	Deposit Entry Date	Date the deposit was entered as a deposit on the account.	DATE	TBRDEPO	TBRDEPO_ENTRY_DATE
DEPOSIT_EXPIRATION_DATE	Deposit Expiration Date	Expiration date of the deposit.	DATE	TBRDEPO	TBRDEPO_EXPIRATION_DATE
DEPOSIT_RECEIPT_NUMBER	Deposit Receipt Number	Receipt number associated with the deposit if a receipt number was system-generated when the deposit was entered.	NUMBER	TBRDEPO	TBRDEPO_RECEIPT_NUMBER
DEPOSIT_RELEASE_DATE	Deposit Release Date	Date the deposit may be released. Deposit may not be released automatically or manually before this date. If this field is blank the deposit may be released at any time.	DATE	TBRDEPO	TBRDEPO_RELEASE_DATE
DEPOSIT_TRANS_DATE	Deposit Trans Date	Date used by the finance system to control posting to the ledgers.	DATE	TBRDEPO	TBRDEPO_TRANS_DATE
DEPOSIT_TYPE	Deposit Type	Type or classification of this deposit.	VARCHAR2(63)	TBBDEPC	TBBDEPC_DTYP_CODE
DEPOSIT_TYPE_DESC	Deposit Type Description	Description of the type or classification of this deposit.	VARCHAR2(255)	TTVDTYP	TTVDTYP_DESC
DETAIL_CODE	Detail Code	Detail Code defining this deposit transaction.	VARCHAR2(63)	TBRDEPO	TBRDEPO_DETAIL_CODE_DEPOSIT
DETAIL_CODE_DESC	Detail Code Description	Deposit detail code description.	VARCHAR2(255)	TBRDEPO	TBRDEPO_DESC
FOREIGN_CURRENCY	Foreign Currency	Contains the foreign currency code used when making a payment.	VARCHAR2(63)	TBRDEPO	TBRDEPO_CURR_CODE
FOREIGN_CURRENCY_AMOUNT	Foreign Currency Amount	Amount of the transaction as stated in foreign currency.	NUMBER	TBRDEPO	TBRDEPO_FOREIGN_AMOUNT
FOREIGN_CURRENCY_DESC	Foreign Currency Description	Currency code description or title.	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
LEDGER_DESIGNATOR	Ledger Designator	Academic period-based designator to be used for general ledger reconciliation.	VARCHAR2(63)	FUNCTION	TOKODSF.F_TERM_CODE_TBDS
MIN_REMAIN_DEPOSIT_AMT	Minimum Remain Deposit Amount	Minimum amount that must remain as a deposit and not be released until the expiration date of the deposit.	NUMBER	TBRDEPO	TBRDEPO_MIN_AMOUNT
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	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OPERATING_DATE	Operating Date	Date used for initial feed of transactions to finance. For additional information, see the note preceding t11.11.	DATE	CALCULATION	NVL(TBRDEPO_TRANS_DATE,TBRDEPO_EFFECTIVE_DATE)-NVL(TBRDEPO_FEED_DATE,SYSDATE)
OPERATING_DESIGNATOR	Operating Designator	Academic period-based designator to be used for initial transactions. For additional information, see the note preceding t11.11.	VARCHAR2(63)	FUNCTION	TOKODSF.F_TERM_CODE_TBDS
ORIGINAL_AMOUNT	Original Amount	Initial amount of the deposit.	NUMBER	TBRDEPO	TBRDEPO_AMOUNT
PAYMENT_DETAIL_CODE	Payment Detail Code	Detail code associated with the method of how the deposit was paid - check, cash, etc.	VARCHAR2(63)	TBRDEPO	TBRDEPO_DETAIL_CODE_PAYMENT
PAYMENT_DETAIL_CODE_DESC	Payment Detail Code Description	Detail code description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC
POSTING_DATE	Posting Date	Date the accounting transaction was interfaced to the financial ledgers.	DATE	TBRDEPO	TBRDEPO_FEED_DATE
POSTING_DOCUMENT	Posting Document	Document code generated to identify and feed this transaction to finance.	VARCHAR2(63)	TBRDEPO	TBRDEPO_FEED_DOC_CODE
POST_CASHIER	Post Cashier	Identification code of the cashier who entered the transaction.	VARCHAR2(30)	TBRDEPO	TBRDEPO_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
SUB_ACADEMIC_PERIOD	Sub Academic Period	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub Academic Period Description	A session, portion or part of the academic period.	VARCHAR2(255)	NA	NA
TRANSACTION_NUMBER	Transaction Number	Transaction number associated with the deposit.	NUMBER	TBRDEPO	TBRDEPO_TRAN_NUMBER

Ver: 9.2