Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
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	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC	NO	NO
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE	NO	NO
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACCOUNT_POSTED_AMOUNT	Amount that has been posted.	NUMBER	CALCULATION	DECODE(TBRDEPO_FEED_DATE, NULL, NULL, TBRDEPO_AMOUNT)	NO	NO
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	NO	NO
ACCOUNT_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	TBRDEPO	TBRDEPO_PIDM	NO	NO
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	NO	NO
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)	NO	NO
CASHIER_END_DATE	Ending date of the cashiering session for the transaction.	DATE	TBRDEPO	TBRDEPO_CSHR_END_DATE	NO	NO
CASHIER_END_TIME	Ending time of the cashiering session for the transaction.	VARCHAR2(8)	TBRDEPO	TBRDEPO_CSHR_END_DATE	NO	NO
CASHIER_SESSION_NUMBER	Session number assigned to each cashier session.	NUMBER	TBRDEPO	TBRDEPO_SESSION_NUMBER	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DEPOSIT_ACTIVITY_DATE	Most current date record was created or updated.	DATE	TBRDEPO	TBRDEPO_ACTIVITY_DATE	NO	NO
DEPOSIT_EFFECTIVE_DATE	Effective date of the deposit. This date defaults to the date the deposit was entered.	DATE	TBRDEPO	TBRDEPO_EFFECTIVE_DATE	NO	NO
DEPOSIT_ENTRY_DATE	Date the deposit was entered as a deposit on the account.	DATE	TBRDEPO	TBRDEPO_ENTRY_DATE	NO	NO
DEPOSIT_EXPIRATION_DATE	Expiration date of the deposit.	DATE	TBRDEPO	TBRDEPO_EXPIRATION_DATE	NO	NO
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	NO	NO
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	NO	NO
DEPOSIT_TRANS_DATE	Date used by the finance system to control posting to the ledgers.	DATE	TBRDEPO	TBRDEPO_TRANS_DATE	NO	NO
DETAIL_CODE	Code defining type of transaction in accounts receivable.	VARCHAR2(4)	TBRDEPO	TBRDEPO_DETAIL_CODE_DEPOSIT	NO	NO
DETAIL_CODE_DESC	Transaction type description.	VARCHAR2(30)	TBRDEPO	TBRDEPO_DESC	NO	NO
DETAIL_TYPE	Identify the type or classification of this deposit.	VARCHAR2(3)	TBBDEPC	TBBDEPC_DTYP_CODE	NO	NO
DETAIL_TYPE_DESC	Description of the type or classification of this deposit.	VARCHAR2(30)	TTVDTYP	TTVDTYP_DESC	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
FOREIGN_CURRENCY	Contains the foreign currency code used when making a payment.	VARCHAR2(4)	TBRDEPO	TBRDEPO_CURR_CODE	NO	NO
FOREIGN_CURRENCY_AMOUNT	Amount of the transaction as stated in foreign currency.	NUMBER	TBRDEPO	TBRDEPO_FOREIGN_AMOUNT	NO	NO
FOREIGN_CURRENCY_DESC	Currency code description or title.	VARCHAR2(35)	GTVCURR	GTVCURR_TITLE	NO	NO
LEDGER_DESIGNATOR	Extracts academic period-based designator to be used for general ledger reconciliation.	VARCHAR2(2)				NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
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	NO	NO
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)	NO	NO
OPERATING_DESIGNATOR	Extracts academic period-based designator to be used for general ledger reconciliation.	VARCHAR2(2)				NO
ORIGINAL_AMOUNT	Initial amount of the deposit.	NUMBER	TBRDEPO	TBRDEPO_AMOUNT	NO	NO
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	NO	NO
PAYMENT_DETAIL_CODE_DESC	Detail code description.	VARCHAR2(30)	TBBDETC	TBBDETC_DESC	NO	NO
POSTING_DATE	Date the accounting transaction was interfaced to the financial ledgers.	DATE	TBRDEPO	TBRDEPO_FEED_DATE	NO	NO
POSTING_DOCUMENT	Document code generated to identify and feed this transaction to finance.	VARCHAR2(8)	TBRDEPO	TBRDEPO_FEED_DOC_CODE	NO	NO
POST_CASHIER	Identification code of the cashier who entered the transaction.	VARCHAR2(30)	TBRDEPO	TBRDEPO_USER	NO	NO
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(0)	NA	NA	NO	NO
SUB_ACADEMIC_PERIOD_DESC	A session, portion or part of the academic period.	VARCHAR2(0)	NA	NA	NO	NO
TRANSACTION_NUMBER	Transaction number associated with the deposit.	NUMBER	TBRDEPO	TBRDEPO_TRAN_NUMBER	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: