Reporting View | Description | Key & Frequency | Recommended Search Columns |
| APPLICATION_OF_PAYMENT
| Contains accounts receivable information for payments applied to charges Reporting can be by the payment transaction number, charge transaction number, applied amount, posting document, cashier, and session information.Multiple rows per account per payment transaction.ACCOUNT_UID, CHARGE_TRAN_NUMBER ACCOUNT_UID, PAY_TRAN_NUMBER, CHARGE_TRAN_NUMBER DETAIL_CODE | | |
APPL_OF_PAY_DETAIL_ACCOUNTING
| Contains accounting information sent to Finance for each payment applied to a charge on a receivable account. .Multiple rows per account_id per pay_tran_number per charge_tran_number.DETAIL_CODE ACCOUNT_UID, CHARGE_TRAN_NUMBER ACCOUNT_UID, PAY_TRAN_NUMBER, CHARGE_TRAN_NUMBER | | |
CONTRACT
| Contains third party contract and exemption information for a student including academic period, contract number, contract description, contract expiration date, third party, detail code, and account ID.One row per academic period per person per contract priority. PERSON_UID ACADEMIC_PERIOD, THIRD_PARTY_UID, CONTRACT_NUMBER ACADEMIC_PERIOD, PERSON_UID, CONTRACT_NUMBER | | |
CONTRACT_PAYMENT_DETAIL
| Contains the contract payment detail information identifying the student charges, academic period, contract number being paid by the third party contract payment transaction number.One record per third party per transaction number per contract payment transactionTHIRD_PARTY_UID, TRANSACTION_NUMBER, CONTRACT_PAYMENT_TRANSACTION | | |
DEPOSIT
| Contains accounts receivable deposits including account ID, detail code, academic period, transaction number, original amount, balance amount, payment detail code, post cashier, deposit entry date, deposit receipt number, minimum remaining deposit amount, and posting document.One row per account per transaction number.ACCOUNT_UID, TRANSACTION_NUMBER ACCOUNT_UID, DETAIL_CODE | | |
EXEMPTION
| Contains student exemption information including academic period, account ID, exemption priority, exemption, authorized amount, amount paid, exemption payment code, detail code, and expiration date.One row per person per academic period per exemption priority.PERSON_UID, EXEMPTION EXEMPTION, START_DATE, END_DATE, PERSON_UID ACADEMIC_PERIOD, PERSON_UID | | |
INSTALLMENT_PLAN
| Contains installment plan information (short-term loans, tuition payment plans, etc.) for each account including installment plan reference number, academic period, number of payments, first installment date, plan amount, interest rate, and late fee amount.One row per installment reference number.ACCOUNT_UID, INSTALLMENT_PLAN REFERENCE_NUMBER ACADEMIC_PERIOD, INSTALLMENT_PLAN | | |
MEMO
| Contains Charge/Payment Detail Memo information.One row per pidm per transaction number.ENTITY_UID, TRANSACTION_NUMBER | | |
MISCELLANEOUS_TRANSACTION
| Contains miscellaneous transaction detail for receivable accounting. This includes receipt number, payment and charge detail codes, cashier, amount, transaction description, payment and charge accounting distribution, external accounting line, credit card number, posting document, person name and address. Used to track payments and charges not on a student's account.One row per receipt number per user per transaction numberRECEIPT_NUMBER ENTITY_UID | | |
RECEIVABLE_ACCOUNT
| Contains general account information for each person or organization including name, tax ID, entity category, account balance, current amount due, deposit balance, hold counts, delinquency, collection information, and credit limit.One row per account.ACCOUNT_UID COLLECTION_AGENCY_UID | | |
RECEIVABLE_ACCOUNTING
| Contains detail code ledger accounting distribution information by effective date for debits and credits to be sent to post into the ledgers. This includes the percentage each accounting transaction is applied to on each transaction amount. Use this view joining to the detail codes by effective date in other views to determine actual accounting for reconciliation.One row per detail code per effective date.DETAIL_CODE A_CHART_OF_ACCOUNTS, A_FUND, A_ACCOUNT B_CHART_OF_ACCOUNTS, B_FUND, B_ACCOUNT | | |
RECEIVABLE_ACCOUNT_DETAIL
| Contains account transaction detail for all payments and charges including academic period, detail code, category, priority, entry date, transaction amount, balance, bill date, due date, post cashier, and posting document.One row per account per transaction number.ACCOUNT_UID,TRANSACTION_NUMBER DETAIL_CODE ACADEMIC_PERIOD AID_YEAR | | |
RECEIVABLE_SUMMARY
| Contains summarized totals for amount and balance by term, category and detail code.One row per academic period per category per detail code.DETAIL_CODE ACADEMIC_PERIOD | | |
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 numberTAX_YEAR, FEDERAL_REPORT_STATUS TAX_YEAR, NOTIFICATION_STATUS PERSON_UID, TAX_YEAR, ID,SEQUENCE_NUMBER | | |