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_ACCOUNT_DETAIL

Description Source composite view contains accounts receivable transaction detail information.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACADEMIC_PERIOD   Transaction academic period code. VARCHAR2(6)  

TBRACCD

TBRACCD_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)  

STVACYR

STVACYR_DESC

ACCOUNT_DETAIL_ACTIVITY_DATE Account Detail Activity Date The last date this row was created or updated. DATE  

TBRACCD

TBRACCD_ACTIVITY_DATE

ACCOUNT_DETAIL_DATA_ORIGIN Account Detail Data Origin   VARCHAR2(30)      
ACCOUNT_DETAIL_USER_ID Account Detail User ID   VARCHAR2(30)      
ACCOUNT_POSTED_AMOUNT   Amount that has been posted. NUMBER  

CALCULATION

DECODE(TBRACCD_FEED_DATE, NULL, NULL, TBRACCD_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)  

TBRACCD

TBRACCD_ACCT_FEED_IND

ACCOUNT_UID   System generated, unique, internal identification number assigned to this person or organization entity. NUMBER(8)  

TBRACCD

TBRACCD_PIDM

AID YEAR Aid Year Aid year associated with financial aid disbursement. VARCHAR2(4)  

TBRACCD

TBRACCD_AIDY_CODE

AID_ENROLLMENT_PERIOD Aid Enrollment Period Aid enrollment period associated with the financial aid disbursement. This period can span multiple student terms. VARCHAR2(15)  

TBRACCD

TBRACCD_PERIOD

AID_YEAR Financial Aid Year   VARCHAR2(4)      
AMOUNT   Sum of the amount of each account detail for this receivable account. NUMBER  

TBRACCD

TBRACCD_AMOUNT

BALANCE   Remaining balance for all account detail amounts after application of payments. NUMBER  

TBRACCD

TBRACCD_BALANCE

BILL_AMOUNT   Calculated amount of all the charges and payments on the receivable account that have been billed to the account holder. NUMBER  

CALCULATION

DECODE(TBRACCD_BILL_DATE, NULL, NULL, TBRACCD_AMOUNT)

BILL_DATE   Date that the transaction was billed. DATE  

TBRACCD

TBRACCD_BILL_DATE

BILL_SEQUENCE   Bill sequence. NUMBER  

NA

NA

CASHIER_END_DATE   Ending date of the cashiering session for the transaction. DATE  

TBRACCD

TBRACCD_CSHR_END_DATE

CASHIER_END_TIME   Ending time of the cashiering session for the transaction. VARCHAR2(8)  

TBRACCD

TBRACCD_CSHR_END_DATE

CASHIER_SESSION_NUMBER   Session number assigned to each cashier session. NUMBER(5)  

TBRACCD

TBRACCD_SESSION_NUMBER

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

TBBDETC

TBBDETC_DCAT_CODE

CATEGORY_DESC   Receivable category description. VARCHAR2(30)  

TTVDCAT

TTVDCAT_DESC

CONTRACT_PYMT_TRANSACTION_IND Contract Pymt Transaction Indicator   VARCHAR2(1)      
COURSE_REFERENCE_NUMBER Course Reference Number Course Reference Number of the course which generated the charge, when Track by CRN is used in Fee Assessment. VARCHAR2(5)  

TBRACCD

TBRACCD_CRN

CREDIT_CARD_NUMBER   Credit card number or payment identification. VARCHAR2(20)  

TBRACCD

TBRACCD_PAYMENT_ID

CROSSREF_CATEGORY   Category code that was the basis for a contract or exemption credit. VARCHAR2(3)  

TBRACCD

TBRACCD_CROSSREF_DCAT_CODE

CROSSREF_CATEGORY_DESC   Specifies the category. VARCHAR2(30)  

TTVDCAT

TTVDCAT_DESC

CROSSREF_DETAIL_CODE   Detail code of the charge that is offset by a third party or exemption credit. VARCHAR2(4)  

TBRACCD

TBRACCD_CROSSREF_DETAIL_CODE

CROSSREF_DETAIL_CODE_DESC   Detail code description. VARCHAR2(30)  

TBBDETC

TBBDETC_DESC

CROSSREF_ENTITY_UID   System generated, unique, internal identification number assigned to this person or organization entity. NUMBER(8)  

TBRACCD

TBRACCD_CROSSREF_PIDM

CROSSREF_NUMBER   Number of the deposit, contract, or exemption associated with the transaction. NUMBER(8)  

TBRACCD

TBRACCD_CROSSREF_NUMBER

CROSSREF_SOURCE   Source code that was the basis for a contract or exemption credit. VARCHAR2(1)  

TBRACCD

TBRACCD_CROSSREF_SRCE_CODE

CROSSREF_SOURCE_DESC   Specifies the charge/payment detail source associated with the source code. VARCHAR2(30)  

TTVSRCE

TTVSRCE_DESC

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

NA

SYSDATE

DESIGNATOR_TYPE Designator Type Indicates if the designator used to extract the finance accounting line was an academic period-based designator or a financial aid year-based designator. CHAR(1)      
DESIGNATOR_TYPE_DESC Designator Type Description Designator type description. VARCHAR2(21)      
DETAIL_CODE   Code defining type of transaction in accounts receivable. VARCHAR2(4)  

TBRACCD

TBRACCD_DETAIL_CODE

DETAIL_CODE_DESC   Transaction type description. VARCHAR2(30)  

TBBDETC

TBBDETC_DESC

DETAIL_CODE_TYPE   Determines if the detail code is being used as a charge or a payment. VARCHAR2(1)  

TBRACCD

TBRACCD_DOCUMENT_NUMBER

DOCUMENT_NUMBER   Document number which identifies a specific charge or payment. VARCHAR2(8)  

TBRACCD

TBRACCD_DUE_DATE

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

NA

NA

DUE_DATE   Payment due date. DATE  

TBRACCD

TBRACCD_EFFECTIVE_DATE

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  

TBRACCD

TBRACCD_ENTRY_DATE

ENTRY_DATE   Date this transaction was entered on the account. DATE  

TRRACCD

TRRACCD_ENTRY_DATE

EXTERNAL_IND   External indicator. VARCHAR2(0)  

NA

NA

FINANCIAL_AID_UPLOAD_FIELD   Links the financial aid fund to the AR transaction. VARCHAR2(0)  

NA

NA

FOREIGN_CURRENCY   Contains the foreign currency code used when making a payment. VARCHAR2(4)  

TBRACCD

TBRACCD_CURR_CODE

FOREIGN_CURRENCY_AMOUNT   Amount of the transaction as stated in foreign currency. NUMBER(12, 2)  

TBRACCD

TBRACCD_FOREIGN_AMOUNT

FOREIGN_CURRENCY_DESC   Currency code description or title. VARCHAR2(35)  

GTVCURR

GTVCURR_TITLE

INVOICE_NUMBER   Invoice number assigned to the transaction. VARCHAR2(8)  

TBRACCD

TBRACCD_INVOICE_NUMBER

JOURNAL_ENTRY   Journal entry. VARCHAR2(0)  

NA

NA

JOURNAL_SOURCE   Journal source. VARCHAR2(0)  

NA

NA

LEDGER_DESIGNATOR Ledger Designator Academic period-based or financial aid year-based designator used when using the current date (today) to reconcile balances in Accounts Receivable to the balances in the Finance general ledger for an account. VARCHAR2(2)      
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

OPERATING_DATE Operating Date Date used to extract the accounting line for the initial feed of this transaction to finance. DATE      
OPERATING_DESIGNATOR Operating Designator Academic period-based or financial aid year-based designator used when using the finance feed date to find the accounting line fed to the Finance ledgers for a charge, payment or application of payments transaction. VARCHAR2(2)      
POSTING_DATE   Date the accounting transaction was interfaced to the financial ledgers. DATE  

TBRACCD

TBRACCD_FEED_DATE

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

TBRACCD

TBRACCD_FEED_DOC_CODE

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

TBRACCD

TBRACCD_USER

PRE_BILL_FLAG   Pre bill flag. VARCHAR2(0)  

NA

NA

PRIORITY   Priority of the detail code for use in the application of payments process. VARCHAR2(3)  

TBBDETC

TBBDETC_PRIORITY

RECEIPT_NUMBER   Receipt number associated with the transaction if a receipt number was generated when the transaction was entered. NUMBER(8)  

TBRACCD

TBRACCD_RECEIPT_NUMBER

REFUND Refund Indicates the type of refund if the transaction is determined as a refund. VARCHAR2(1)  

TBBDETC

TBBDETC_REFUND_IND

REFUND_DESC Refund Description Refund description. VARCHAR2(18)  

CALCULATION

CASE WHEN TBBDETC_REFUND_IND

RETURNED_CHECK_IND   Determines if the detail code has been identified as the code to use for returned checks. VARCHAR2(1)  

CALCULATION

DECODE(TBBRETC_DETAIL_CODE,NULL,'N','Y')

SOURCE   Identifies the source of how the transaction was entered on the account. VARCHAR2(1)  

TBRACCD

TBRACCD_SRCE_CODE

SOURCE_DESC   Source code extracted description. VARCHAR2(30)  

TTVSRCE

TTVSRCE_DESC

STATEMENT_DATE Statement Date The date a statement was generated. DATE  

TBRACCD

TBRACCD_STATEMENT_DATE

STUDY_PATH Study Path Study path key sequence for the course registration. NUMBER  

TBRACCD

TBRACCD_STSP_KEY_SEQUENCE

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

TAX_AMOUNT   Amount of the transaction reported for 1098-t purposes. NUMBER(12, 2)  

TBRACCD

TBRACCD_TAX_AMOUNT

TAX_DOCUMENT   Tax document. VARCHAR2(0)  

NA

NA

TAX_DOCUMENT_BOX_NUMBER   Box in which amounts are reported for 1098-t purposes. VARCHAR2(2)  

TBRACCD

TBRACCD_TAX_REPT_BOX

TAX_FUTURE_ITEM   Specifies if the transaction is reported as a academic period beginning in a future tax year. VARCHAR2(1)  

TBRACCD

TBRACCD_TAX_FUTURE_IND

TAX_YEAR   Tax year the transaction is reported for 1098-t purposes. NUMBER(4)  

TBRACCD

TBRACCD_TAX_REPT_YEAR

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

TBRACCD

TBRACCD_TRANS_DATE

TRANSACTION_DESC   Accounting transaction description. VARCHAR2(30)  

TBRACCD

TBRACCD_DESC

TRANSACTION_NUMBER   Transaction number. NUMBER(8)  

TBRACCD

TBRACCD_TRAN_NUMBER

TRAN_NUMBER_PAID   Transaction number of a specific application of payment. This transaction was used to directly apply to the transaction number specified here. NUMBER(8)  

TBRACCD

TBRACCD_TRAN_NUMBER_PAID

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

NA

NA



Ver: