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(6)	TBRDEPO	TBRDEPO_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(30)	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(1)	TBRDEPO	TBRDEPO_ACCT_FEED_IND
ACCOUNT_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	TBRDEPO	TBRDEPO_PIDM
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	Calculated 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(8)	TBRDEPO	TBRDEPO_CSHR_END_DATE
CASHIER_SESSION_NUMBER	Session number assigned to each cashier session.	NUMBER	TBRDEPO	TBRDEPO_SESSION_NUMBER
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
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
DETAIL_CODE	Code defining type of transaction in accounts receivable.	VARCHAR2(4)	TBRDEPO	TBRDEPO_DETAIL_CODE_DEPOSIT
DETAIL_CODE_DESC	Transaction type description.	VARCHAR2(30)	TBRDEPO	TBRDEPO_DESC
DETAIL_TYPE	Identify the type or classification of this deposit.	VARCHAR2(3)	TBBDEPC	TBBDEPC_DTYP_CODE
DETAIL_TYPE_DESC	Description of the type or classification of this deposit.	VARCHAR2(30)	TTVDTYP	TTVDTYP_DESC
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
FOREIGN_CURRENCY	Contains the foreign currency code used when making a payment.	VARCHAR2(4)	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(35)	GTVCURR	GTVCURR_TITLE
LEDGER_DESIGNATOR	Extracts academic period-based designator to be used for general ledger reconciliation.	VARCHAR2(2)
MIF_DESC	Institution description 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
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
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	Extracts academic period-based designator to be used for general ledger reconciliation.	VARCHAR2(2)
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(4)	TBRDEPO	TBRDEPO_DETAIL_CODE_PAYMENT
PAYMENT_DETAIL_CODE_DESC	Detail code description.	VARCHAR2(30)	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(8)	TBRDEPO	TBRDEPO_FEED_DOC_CODE
POST_CASHIER	Identification code of the cashier who entered the transaction.	VARCHAR2(30)	TBRDEPO	TBRDEPO_USER
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(0)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	A session, portion or part of the academic period.	VARCHAR2(0)	NA	NA
TRANSACTION_NUMBER	Transaction number associated with the deposit.	NUMBER	TBRDEPO	TBRDEPO_TRAN_NUMBER
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: