Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Finance Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: GRANT_APPLIED_PAYMENTS

Description Contains grant billing details for payments that have been applied against charges. Reporting can be by grant or letter or credit, various dates, payment transaction number, charge transaction number, posting document, post cashier session, and withholding information.
Key & Frequency Multiple rows per grant ID per payment transaction number.
Recommended Search Columns GRANT_ID, ACCOUNT_TRANSACTION_NUMBER
APPLIED_GRANT_ID

Target Column Business Definition Database Data Type Source Name Source Column
ACCOUNT_ACTUAL_COST_AMOUNT Actual cost amount of the transaction. NUMBER

TRRACCD

TRRACCD_ACTUAL_COST_AMT

ACCOUNT_AMOUNT Amount of the payment transaction. NUMBER

TRRACCD

TRRACCD_AMOUNT

ACCOUNT_BALANCE Remaining balance of the charge amount on the transaction. NUMBER

TRRACCD

TRRACCD_BALANCE

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)

TRRACCD

TRRACCD_ACCT_FEED_IND

ACCOUNT_TRANSACTION_NUMBER A unique one up number assigned to each transaction within the grants account. NUMBER

TRRACCD

TRRACCD_TRAN_NUMBER

ADJUSTED_BILLED_INVOICE_NUMBER Billed invoice number adjusted on the charge. NUMBER

TRRACCD

TRRACCD_BILL_INV_ADJ_NO

ADJUSTED_PAID_INVOICE_NUMBER Adjusted invoice number paid with the payment. NUMBER

TRRACCD

TRRACCD_PAID_INV_ADJ_NO

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

APPLIED_AMOUNT Amount of the payment that paid off the charge. NUMBER

TRRAPPL

TRRAPPL_AMOUNT

APPLIED_GRANT_ID Unique user defined or system generated one-up number for this grant. VARCHAR2(63)

TRRAPPL

TRRAPPL_GRNT_CODE

APPLIED_POSTING_DATE Date the accounting transaction was interfaced to the financial ledgers. DATE

TRRAPPL

TRRAPPL_FEED_DATE

APPLIED_POSTING_STATUS Indicates the status of the transaction in the accounting feed process as ready to feed or transaction has been fed. VARCHAR2(63)

TRRAPPL

TRRAPPL_ACCT_FEED_IND

APPLIED_POST_DOCUMENT Document number used to post the accounting transaction into the ledgers. VARCHAR2(63)

TRRAPPL

TRRAPPL_FEED_DOC_CODE

BILLED_INVOICE_NUMBER Invoice number billed on the charge. NUMBER

TRRACCD

TRRACCD_BILL_INV_SEQ_NO

BILL_DATE Date that the transaction was billed. DATE

TRRACCD

TRRACCD_BILL_DATE

CHARGE_TRANSACTION_NUMBER Transaction number of the detail code used as the charge transaction in application of payments. NUMBER

TRRAPPL

TRRAPPL_CHG_TRAN_NUMBER

DIRECT_PAY_IND Indicates that the transaction was a direct application of payment specified when the transaction was entered on the account. VARCHAR2(63)

TRRAPPL

TRRAPPL_DIRECT_PAY_IND

EFFECTIVE_DATE Date the transaction becomes effective. As of this date, the transaction is calculated into amount due and is eligible to be fed to accounting. DATE

TRRACCD

TRRACCD_EFFECTIVE_DATE

ENTRY_DATE Date the transaction was entered on the account. DATE

TRRACCD

TRRACCD_ENTRY_DATE

LETTER_OF_CREDIT_NUMBER Actual letter of credit number associated to the payment management system code. VARCHAR2(63)

FRVPMSC

FRVPMSC_LOC_NO

LONG_TITLE Grant long title or description. VARCHAR2(256)

FRBGRNT

FRBGRNT_LONG_TITLE

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

PAID_INVOICE_NUMBER Invoice number paid with the payment. NUMBER

TRRACCD

TRRACCD_PAID_INV_SEQ_NO

PAYMENT_MANAGEMENT_SYS_CODE Unique identifier assigned as a payment management system code within grants, containing the letter of credit number and a amount limit that can be drawn on a letter of credit. VARCHAR2(63)

FRBGBIL

FRBGBIL_PMSC_CODE

PAYMENT_MANAGEMENT_SYS_DESC Payment management system description. VARCHAR2(255)

FRVPMSC

FRVPMSC_DESC

PAYMENT_REFERENCE_NUMBER External reference number of item used to make payment. Can be credit card, wire payment, check number, etc. VARCHAR2(63)

TRRACCD

TRRACCD_PAYMENT_ID

PAYMENT_TRANSACTION_NUMBER Transaction number of the detail code used as the payment transaction in application of payments. NUMBER

TRRAPPL

TRRAPPL_PAY_TRAN_NUMBER

POSTING_DATE Date the accounting transaction was interfaced to the financial ledgers. DATE

TRRACCD

TRRACCD_FEED_DATE

POSTING_DOCUMENT Document code generated to identify and feed this transaction to finance. VARCHAR2(63)

TRRACCD

TRRACCD_FEED_DOC_CODE

POST_CASHIER Identification code of the cashier who entered the transaction. VARCHAR2(63)

TRRACCD

TRRACCD_USER_ID

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

REAPPLICATION_IND Indicates that this application of payment record was created because the un-application of payment process had been run for this account. The record was created due to an un-application of payment being processed, or was an original record that was unapplied. VARCHAR2(63)

TRRAPPL

TRRAPPL_REAPPL_IND

REBILL_IND Used to trigger payment rebill on the account. VARCHAR2(63)

TRRACCD

TRRACCD_REBILL_IND

SHORT_TITLE Grant short title or description. VARCHAR2(255)

FRBGRNT

FRBGRNT_TITLE

TRANSACTION_DATE Date used by the finance system to control posting to the ledgers. DATE

TRRACCD

TRRACCD_TRANS_DATE

WITHHOLDING_AMOUNT Amount to withhold from the billed agency. NUMBER

TRRACCD

TRRACCD_WITHHOLDING_AMT

WITHHOLDING_IND Determines if withholding an amount to the billed agency. VARCHAR2(63)

TRRACCD

TRRACCD_WITHHOLDING_IND



Ver: 8.0