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(63)
|
TBRDEPO
|
TBRDEPO_TERM_CODE
|
NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACADEMIC_YEAR
|
Academic year associated with the academic period on this record.
|
VARCHAR2(63)
|
STVTERM
|
STVTERM_ACYR_CODE
|
NO
|
NO
|
ACADEMIC_YEAR_DESC
|
Academic year description.
|
VARCHAR2(255)
|
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(63)
|
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
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
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
|
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(63)
|
CALCULATION
|
TO_CHAR(TBRDEPO_CSHR_END_DATE,'HH24:MM:SS')
|
NO
|
NO
|
CASHIER_SESSION_NUMBER
|
Session number assigned to each cashier session.
|
NUMBER
|
TBRDEPO
|
TBRDEPO_SESSION_NUMBER
|
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
|
DEPOSIT_TYPE
|
Type or classification of this deposit.
|
VARCHAR2(63)
|
TBBDEPC
|
TBBDEPC_DTYP_CODE
|
NO
|
NO
|
DEPOSIT_TYPE_DESC
|
Description of the type or classification of this deposit.
|
VARCHAR2(255)
|
TTVDTYP
|
TTVDTYP_DESC
|
NO
|
NO
|
DETAIL_CODE
|
Detail Code defining this deposit transaction.
|
VARCHAR2(63)
|
TBRDEPO
|
TBRDEPO_DETAIL_CODE_DEPOSIT
|
NO
|
NO
|
DETAIL_CODE_DESC
|
Deposit detail code description.
|
VARCHAR2(255)
|
TBRDEPO
|
TBRDEPO_DESC
|
NO
|
NO
|
FOREIGN_CURRENCY
|
Contains the foreign currency code used when making a payment.
|
VARCHAR2(63)
|
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(255)
|
GTVCURR
|
GTVCURR_TITLE
|
NO
|
NO
|
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
|
NO
|
NO
|
LEDGER_DESIGNATOR
|
Academic period-based designator to be used for general ledger reconciliation.
|
VARCHAR2(63)
|
FUNCTION
|
TOKODSF.F_TERM_CODE_TBDS
|
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
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
NAME
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
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
|
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
|
NO
|
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(63)
|
TBRDEPO
|
TBRDEPO_DETAIL_CODE_PAYMENT
|
NO
|
NO
|
PAYMENT_DETAIL_CODE_DESC
|
Detail code description.
|
VARCHAR2(255)
|
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(63)
|
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
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD
|
A session, portion or part of the academic period.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD_DESC
|
A session, portion or part of the academic period.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
TRANSACTION_NUMBER
|
Transaction number associated with the deposit.
|
NUMBER
|
TBRDEPO
|
TBRDEPO_TRAN_NUMBER
|
NO
|
NO
|