UC San Diego SearchMenu

Query Access

The information returned to you when you run a query depends on your assigned access and security designation.

Expand all

Financial Queries

Query If you... You can view...

Account
Award Data for Departments - Detail
Award Data for Departments - Summary
Balance by IFOPL
Check or Payment/Invoice
Express Card Cardholder
Express Card Transaction
Express Order
Federal Express Payment
Fund
Fund Managers
General Ledger
General Ledger Monthly Summary
Index
Index Fund Orgn and Program
Level 4 Fund Operating Ledger Summary
Location
NGN Recharges
Online Transfer of Funds
Operating Ledger Detail Activity
Operating Ledger Monthly Summary
Operating Ledger Summary by Account Type
Organization
Permanent Budget
PI Index
Program and Project Detail
Project Detail Activity
Purchase Order
Vendor Address

Have FinancialLink access Results from these queries
Distribution of Payroll Expense - Financial Have Payroll Inquiry authority assigned through FinancialLink Information for all employees

Financial Easy Queries

Query If you... You can view...
Adjusted Budget
Active Indexes for an Organization
Indexes for a Fund
Journal Voucher
New Awards for Departments
NGN Recharges by Employee
NGN Recharges by Index
Overdraft Summary Report
Payment Authorization Document
Statement of Operations
Ratio Analysis
Have FinancialLink access Results from these queries
General Liability Detail
Staffing List Detail
Staffing List Exception
Have Payroll Inquiry authority assigned through FinancialLink Information for all employees
Resident/Nonresident Withholding Statement Have gp_fin_prod / restricted access on the DB2 tab in Accesslink           Results from these queries

Accounts Receivable Queries

Query If you... You can view...
Accounts Receivable Aging
Accounts Receivable EAP
Accounts Receivable Reconciliation
Accounts Receivable Transactions
Have isis_ar database access Results from these queries
Sponsored Projects AR Aging Have FinancialLink access Results from these queries

Accounts Receivable Easy Queries

Query If you... You can view...
Payments Receivable Have TritonLink access Results from these queries

DataLink Queries

Query If you... You can view...

Data Code SQL
Data Glossary
QueryLink Stats

Have FinancialLink access  Results from these queries

Effort Reporting Queries

Query If you... You can view...

Effort Reporting

Have FinancialLink access Result from these queries

Effort Reporting Easy Queries

Query If you... You can view...

ERS Certified Aging Report
ERS Comments
ERS Non-Academic Certification
ERS Other Department Employees
ERS Other Department Indexes
ERS Overdue Aging Report
ERS Pending Certifications
ERS Status Report
ERS Unassigned Fund Manager
ERS User Roles

Have FinancialLink access Result from these queries

Employee Queries

Query If you... You can view...

Employee
Employee Nonresident Alien
Graduate Student Researcher (GSR) Tuition & Fee Remission
Vacation Accrual/ Usage

Have PPS Departmental Security assigned through the mainframe PPS system(ARSM screen) Information for employees whose current home or appointment department is a Department Code assigned to your user ID
Have PPS Central Security assigned in the mainframe PPS system (ARSM screen) Information for all employees

Distribution Of Payroll Expense
Employee Change History
Employee Monthly Snapshots
Incentive Award Program
Permanent Staffing

Have PPS Departmental Security assigned through the mainframe PPS system(ARSM screen) Information for employees who have ever had a home or appointment department in a Department Code assigned to your user ID
Have PPS Central Security assigned in the mainframe PPS system (ARSM screen) Information for all employees
MyTraining  Have a Single Sign-On account Your information (based on your user ID)
Leave Activity
Timekeeping
Have a Single Sign-On account Your information (based on your user ID)
Have PPS Departmental Security assigned through the mainframe PPS system(ARSM screen) Information for employees whose home or appointment department is a Department Codes assigned to your user ID
Have PPS Central Security assigned in the mainframe PPS system (ARSM screen) Information for all employees
Are a timekeeper Reports assigned to your Timekeeper Code(s) when they were created. If you assume someone’s timekeeper code, you can view LASRs for that code
Are a designated supervisor in PPS by having an Appointment RepresentationCode set to:
S - Supervisor
Information for employees whose home or appointment department matches your appointment department for which you are designated a supervisor
Are a designated supervisor in PPS by having a HEERA Code set to:
A – Manager, Not Confidential
B – Manager Confidential
C – Supervisor Not Confidential
D – Supervisor, Confidential
Information for employees whose home or appointment department matches your home department code

Employee Easy Queries

Query If you... You can view...

Current Term Student Employees
Employee Appointments Without Distribution
Employee Change Actions
Employee Hires
Employees Paid On E-Verify Funds
Employee Roster
Furlough Calculator
Furlough Modeling Calculator
Graduate Student Researcher (GSR) Tuition & Fee Remission
Missing Department Codes
Personnel Action Notice
Salary Reduction Band

Have PPS Departmental Security assigned through the mainframe PPS system (ARSM screen) Information for employees whose current home or appointment department is a Department Code assigned to your user ID
Have PPS Central Security assigned in the mainframe PPS system (ARSM screen) Information for all employees
Distribution Payroll Expense
Service Credit
Staffing List Detail
Have PPS Departmental Security assigned through the mainframe PPS system (ARSM screen) Information for all employees
Have PPS Central Security assigned in the mainframe PPS system (ARSM screen) Information for all employees
Employee Code Values
E-Verify Funds
Furlough Excluded Funds
Head Count
PAN Reviewer
Telephone and E-mail Lists
Have a Single Sign-On account Results from these queries
Leave Activity Summary
Leave Balance By Employee Group
Leave Balance By Timekeeper
Reclaim Vacation Hours
Time Record
Have a Single Sign-On account Your information (based on your user ID)
Have PPS Departmental Security assigned through the mainframe PPS system(ARSM screen) LASRs for employees whose home or appointment department is a Department Codes assigned to your user ID
Have PPS Central Security assigned in the mainframe PPS system (ARSM screen) Information for all employees
Are a timekeeper Reports assigned to your Timekeeper Code(s) when they were created. If you assume someone’s timekeeper code, you can view LASRs for that code
Are a designated supervisor in PPS by having an Appointment Representation Code:
S – Supervisor
Information for employees whose home or appointment department matches your appointment department for which you are designated a supervisor
Are a designated supervisor and have been designated as such in PPS byhaving a HEERA code set to:
A – Manager, Not Confidential
B – Manager Confidential
C – Supervisor Not Confidential
D – Supervisor, Confidential
Information for employees whose home or appointment department matches your home department code

Student Queries

Query If you... You can view...
Campus Admitted Students
Campus Class List
Campus Class List 3rd Week
Campus Class List Statistics
Campus Class List Statistics 3rd Week
Campus EAP Student Information
Campus Student Information 3rd Week
Campus Schedule of Classes
Campus Student Information
Campus Waitlist
Have TritonLink access Results from these queries
Campus Grades Have stu_grades_prod secure or restricted security group access Results from these queries

Student Financial Aid Queries

Query If you... You can view...
Graduate SAM Data Have fin_aide_gsam security group access Results from these queries

Expand all