Query Access

Last Updated: January 24, 2020 11:17:25 AM PST

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

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

For more information, contact the BIA team.