Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST


Accounts Receivable Composite View Meta Data Reports

Target Reports:

Composite ViewDescription
AT_ACCOUNT
Source composite view contains account level or overall information for the person or organization for this account id.
AT_ACCOUNT_DETAIL
Source composite view contains accounts receivable transaction detail information.
AT_APPLICATION_OF_PAYMENT
Source composite view contains accounts receivable application of payment information.
AT_AR_DEPOSIT
Source composite view contains accounts receivable deposit information.
AT_CONTRACT
Source composite view contains accounts receivable third party contract information.
AT_CONTRACT_PAYMENT_DETAIL
Source composite view contains accounts receivable contract payment transaction detail information.One record per third party per transaction number per contract payment transaction
AT_EXEMPTION
Source composite view contains accounts receivable exemption information.
AT_GRANT_ACCOUNT_DETAIL
Source composite view contains research accounting receivable account transaction detail information.
AT_GRANT_APPLICATION_PAYMENT
Source composite view contains application of payment information for research accounting billing.
AT_INSTALLMENT_PLAN
Source composite view contains installment plan information. (short term loans, tuition payment plans, etc.).
AT_LEDGER_ACCOUNTING
Source composite view contains accounting rules relative to each detail code.
AT_MEMO
Contains Charge/Payment Detail Memo information.One row per pidm per transaction number.
AT_MISCELLANEOUS_TRANSACTION
Source composite view contains miscellaneous transaction detail information for accounts receivable.
AT_STUDENT_TAX_NOTIFICATION
Contains student tax information to be reported for federal compliance regarding billed qualifed charges and scholarships or grants. Student name and demographic data sent to the federal government, tax year, person UID, tax ID, student notification status, federal notification status, qualified charges billed, qualified charges adjusted from prior years, scholarship or grant amounts, scholarship or grant amounts adjusted from prior years, and an indicator to denote the latest notification record in existance for a student's tax year.One record per person UID per tax year per ID per sequence number
AT_VALIDATION
Source composite view contains a number of the source systems' validation table records. This view was meant to be used with reporting tools to create list of values as well as for cleansing purposes in the Enterprise Data Warehouse.

Source Reports:

FUNCTION
NA
STVNATN
STVSTAT
STVTERM
TBBACCT
TBBCONT
TBBCPRF
TBBCSTU
TBBDEPC
TBBDETC
TBBEACT
TBBESTU
TBBEXPT
TBBMISC
TBRACCD
TBRACCT
TBRAPPL
TBRCOLC
TBRCPDT
TBRDEPO
TBRISTL
TBRMEMO
TBRMISD
TRRACCD
TRRAPPL
TTBTAXN
TTVABDS
TTVBILL
TTVDCAT
TTVDELI
TTVDTYP
TTVECAT
TTVSRCE
TTVTBDS


Ver: