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
|