Description
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. | | |