Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Accounts Receivable Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: RECEIVABLE_SUMMARY

Description Contains summarized totals for amount and balance by term, category and detail code.
Key & Frequency One row per academic period per category per detail code.
Recommended Search Columns DETAIL_CODE
ACADEMIC_PERIOD

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACADEMIC_PERIOD Transaction academic period code.    

TBRACCD

TBRACCD_TERM_CODE

 
ACADEMIC_PERIOD_DESC Academic period description.    

STVTERM

STVTERM_DESC

 
ACADEMIC_YEAR Academic year associated with the academic period on this record.    

STVTERM

STVTERM_ACYR_CODE

 
ACADEMIC_YEAR_DESC Academic year description.    

STVACYR

STVACYR_DESC

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

NA

NA

 
AMOUNT Sum of the amount in accounts receivable for this account.    

FUNCTION

F_SUM_AMOUNT_TERM

 
BALANCE Sum of the receivable activity or balance on the account.    

FUNCTION

F_SUM_BALANCE_TERM

 
CATEGORY Identities category for a receivable transaction type. Examples are registration, housing, meal, contract.    

TBBDETC

TBBDETC_DCAT_CODE

 
CATEGORY_DESC Receivable category description.    

TTVDCAT

TTVDCAT_DESC

 
DETAIL_CODE Code defining type of transaction in accounts receivable.    

TBRACCD

TBRACCD_DETAIL_CODE

 
DETAIL_CODE_DESC Transaction type description.    

TBBDETC

TBBDETC_DESC

 
DETAIL_CODE_TYPE Determines if the detail code is being used as a charge or a payment.    

TBBDETC

TBBDETC_TYPE_IND

 
EXTERNAL_IND External indicator.    

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

 
SUB_ACADEMIC_PERIOD A session, portion or part of the academic period.    

NA

NA

 
SUB_ACADEMIC_PERIOD_DESC A session, portion or part of the academic period.    

NA

NA

 


Ver: 8.3