Queries

Last Updated: June 2, 2025 2:40:00 PM PDT

Give feedback

Find information about queries.

Query Access: The information returned to you when you run a query depends on your assigned access and security designation. Find out what your access allows you to see.

Note: Some queries require require VPN access if you aren't on the UC San Diego network.

How to Create a SQL Statement: Read about how to create a select SQL statement to use in the SQL Executer.

Data Warehouse: Link to information about the Data Warehouse (DW). The DW allows access to a read-only central repository of campus data, including data generated through the campus financial (IFIS), student (ISIS), and payroll/ personnel (PPS) systems.

Query Options

View your saved queries

Financial IFOAPAL Queries

Employee Queries

Financial Queries

Employee Easy Queries

Financial Easy Queries

Student Queries

Upcoming Changes to Student QueryLink Reports

In preparation for the implementation of the new student information system, Triton Student System (TSS), Student QueryLink reports have undergone a comprehensive review and assessment. For more information–including remediation plans, timelines, updates, access details, and more–please visit Student Operational Reporting: Report Development

Accounts Receivable Queries

Travel & Entertainment Queries

Contract & Grant Queries

Med Center Network Recharge Easy Queries

Contract & Grant Easy Queries

Datalink Queries

Effort Reporting Queries

Effort Reporting

ARRA Reporting

ARRA Fund Reporting