RETURN TO COMPOSITE VIEW REPORTS LIST
Accounts Receivable Composite View Reports

SGHE Operational Data Store
Composite View Target: AT_AR_DEPOSIT

Description Source composite view contains accounts receivable deposit information.

Target Column Business Definition Database Data Type 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

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)

FUNCTION

F_TERM_CODE_TBDS

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)

FUNCTION

F_TERM_CODE_TBDS

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: 3.1