Accounts Receivable Transactions

Last Updated: October 27, 2025 2:18:27 PM PDT

Accounts Receivable Transactions information is used in the Student Information System (SIS) to show the amount of money owed & paid to the University. This money may be owed/paid by students, vendors, or other organizations doing business with the University.

Coming Soon!

This report is coming soon. Check out the link below for the release schedule.

Current and Future Report Development

The Accounts Receivable Transactions report is available from the Student section of the Business Analytics Hub (bah.ucsd.edu) under the SIS Financial Management category.

This report will allow you to see who owes/pays the University money.

Some sample uses of the Accounts Receivable Transactions Query are:

Review financial transactions related to student and vendor accounts
To list who owes the University money and how much.

Report User Guide

For tips and information on how to run reports, please review the SIS Financial Management, Get Started and Student Operational Reporting Help pages.

Access

Quality Assurance and User Acceptance Testing Phase:

During QA and User Acceptance Testing (UAT), access is provisioned only to the development and testing team. Access can be requested in advance for when the reports go live.

When requesting access to this report, please select the "SIS Financial Management" reporting category in the report access request.

Please see Requesting Access to Student Reports on the Get Started page for more information.

Before access can be requested, the following UC Learning trainings are required:

FERPA - Confidentiality of Student Records and Privacy Rights
Privacy at UC San Diego (or Privacy 101)
UC San Diego Business Analytics Hub Fundamentals

Once the trainings have been completed, please allow at least 24 business hours for the data to update then submit the Student Reporting Access Request SNOW form.

Data Overview

Please review the information below which is critical to understanding what is and is not included in this report.

AR Aging vs AR Transactions

AR Aging leverages the AR Transactions with outstanding balances to allow the user to focus only on outstanding balances. While the AR Transactions report focuses purely on the transaction amount (SIS data), the AR Aging report includes accounting information that would be found in Financial Information System, Oracle Financial Cloud.

ISIS Data Only

Charges and payments currently available in the Student Information System (ISIS/TSS) are included in this report. Archived transactions that are no longer in ISIS/TSS are not currently available (though plans to include these archived transactions are being evaluated).

Oracle Financial Cloud (OFC) Chart of Accounts

While some legacy ISIS fields are available, most often the accounting information you will see in the remediated reports will be the OFC codes.

Financial Aid Data Masked

Information identified as sensitive by the AR Data Governance Committee will display a generic message instead of the original values. Non-sensitive data such as amounts and dates are still available.

Querylink Field Mapping

QueryLink Field Names not listed in the table below were not migrated. The fields removed were carefully assessed and approved for removal by the data steward, considering factors such as data privacy, relevance, and applicability to general report usage. If any of the removed fields are needed, please submit an enhancement request and describe why the information is needed and how it will be used.

Table that maps between field names from the original Querylink reports and the field names in the new report.
Field Name	SAH Field	Comments
PID	SIS Account ID	For students, this is the Student ID. For non-student accounts, this is the account number.
NA - NEW FIELD!!	Student Level Current
NA - NEW FIELD!!	Registration Status Current
NA - NEW FIELD!!	Academic Status Current
NA - NEW FIELD!!	Student Residency Status Current
NA - NEW FIELD!!	Attempted Units Term
Name	SIS Account Full Name
Person/ entity	SIS Person Entity Indicator
Account Balance	SIS Account Balance
Detail Code	SIS Detail Code
Detail Type	SIS Detail Type
Category Code	SIS Category Code
Transaction Number	SIS Transaction Number
Detail Amount	SIS Transaction Amount
Detail Balance	SIS Transaction Balance
Document Number	SIS Transaction Document Number
Detail Description	SIS Transaction Description
Transaction Date	SIS Transaction Date
Effective Date	SIS Transaction Effective Date
Bill Date	SIS Bill Date
Bill Due Date	SIS Bill Due Date
Cashier	SIS Cashier ID
Session Number	SIS Cashiering Session Number
Term	SIS Transaction Term Code
Email Address	Campus Email Address

Release Notes & Communications

Table showing update release dates and release notes.
Date	Release Notes & Communications
Coming December 2025	Initial version of the report will be released in December 2025.