Target Column	Business Definition	Database Data Type	Source Name	Source Column
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.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACCOUNT_POSTED_AMOUNT	Amount that has been posted.	NUMBER	CALCULATION	DECODE(TBRDEPO_FEED_DATE, NULL, NULL, TBRDEPO_AMOUNT)
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	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	TBRDEPO	TBRDEPO_PIDM
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	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	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	Ending date of the cashiering session for the transaction.	DATE	TBRDEPO	TBRDEPO_CSHR_END_DATE
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	Session number assigned to each cashier session.	NUMBER	TBRDEPO	TBRDEPO_SESSION_NUMBER
DEPOSIT_ACTIVITY_DATE	Most current date record was created or updated.	DATE	TBRDEPO	TBRDEPO_ACTIVITY_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	Date the deposit was entered as a deposit on the account.	DATE	TBRDEPO	TBRDEPO_ENTRY_DATE
DEPOSIT_EXPIRATION_DATE	Expiration date of the deposit.	DATE	TBRDEPO	TBRDEPO_EXPIRATION_DATE
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	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	Date used by the finance system to control posting to the ledgers.	DATE	TBRDEPO	TBRDEPO_TRANS_DATE
DEPOSIT_TYPE	Type or classification of this deposit.	VARCHAR2(63)	TBBDEPC	TBBDEPC_DTYP_CODE
DEPOSIT_TYPE_DESC	Description of the type or classification of this deposit.	VARCHAR2(255)	TTVDTYP	TTVDTYP_DESC
DETAIL_CODE	Detail Code defining this deposit transaction.	VARCHAR2(63)	TBRDEPO	TBRDEPO_DETAIL_CODE_DEPOSIT
DETAIL_CODE_DESC	Deposit detail code description.	VARCHAR2(255)	TBRDEPO	TBRDEPO_DESC
FOREIGN_CURRENCY	Contains the foreign currency code used when making a payment.	VARCHAR2(63)	TBRDEPO	TBRDEPO_CURR_CODE
FOREIGN_CURRENCY_AMOUNT	Amount of the transaction as stated in foreign currency.	NUMBER	TBRDEPO	TBRDEPO_FOREIGN_AMOUNT
FOREIGN_CURRENCY_DESC	Currency code description or title.	VARCHAR2(255)	GTVCURR	GTVCURR_TITLE
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	Academic period-based designator to be used for general ledger reconciliation.	VARCHAR2(63)	FUNCTION	TOKODSF.F_TERM_CODE_TBDS
MIN_REMAIN_DEPOSIT_AMT	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	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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	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	Initial amount of the deposit.	NUMBER	TBRDEPO	TBRDEPO_AMOUNT
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	Detail code description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC
POSTING_DATE	Date the accounting transaction was interfaced to the financial ledgers.	DATE	TBRDEPO	TBRDEPO_FEED_DATE
POSTING_DOCUMENT	Document code generated to identify and feed this transaction to finance.	VARCHAR2(63)	TBRDEPO	TBRDEPO_FEED_DOC_CODE
POST_CASHIER	Identification code of the cashier who entered the transaction.	VARCHAR2(30)	TBRDEPO	TBRDEPO_USER
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	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	A session, portion or part of the academic period.	VARCHAR2(255)	NA	NA
TRANSACTION_NUMBER	Transaction number associated with the deposit.	NUMBER	TBRDEPO	TBRDEPO_TRAN_NUMBER

Ver: 9.1