Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD		Academic period associated with the transaction.	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(8)		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(5)		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(8)		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	Detail Type	Identify the type or classification of this deposit.	VARCHAR2(3)		TBBDEPC	TBBDEPC_DTYP_CODE
DETAIL_TYPE_DESC	Detail Type Description	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(12, 2)		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(7, 2)		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(7, 2)		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(8)		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: