Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Accounts Receivable Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AT_GRANT_APPLICATION_PAYMENT

Description Source composite view contains application of payment information for research accounting billing.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
APPLIED_AMOUNT Amount of the payment that paid off the charge.    

TRRAPPL

TRRAPPL_AMOUNT

 
APPLIED_GRANT_ID Unique user defined or system generated one-up number for this grant.    

TRRAPPL

TRRAPPL_GRNT_CODE

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

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.    

TRRAPPL

TRRAPPL_ACCT_FEED_IND

 
APPLIED_POST_DOCUMENT Document number used to post the accounting transaction into the ledgers.    

TRRAPPL

TRRAPPL_FEED_DOC_CODE

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

TRRAPPL

TRRAPPL_CHG_TRAN_NUMBER

 
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

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

TRRAPPL

TRRAPPL_DIRECT_PAY_IND

 
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined.    

NA

NA

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

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

TRRAPPL

TRRAPPL_PAY_TRAN_NUMBER

 
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.    

TRRAPPL

TRRAPPL_REAPPL_IND

 
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 


Ver: 8.3