UCSD Blink: Query Access

Blink Home > Technology > Query Access

Query Access

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

Select a query topic:

Financial IFOAPAL Queries
Query	If you...	You can view...
Account Fund Fund Managers’ Index Index, Fund, Orgn and Program Location Organization Program Back to top	Have a FinancialLink user ID	Results from these queries.
Financial Queries
Query	If you...	You can view...
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 General Ledger General Ledger Monthly Summary Level 4 Fund Operating Ledger Summary NGN Recharges Online Transfer of Funds Operating Ledger Detail Activity Operating Ledger Monthly Summary Operating Ledger Summary by Account Type Permanent Budget Project Detail Activity Purchase Order Vendor Address	Have a FinancialLink user ID	Results from these queries.
Distribution of Payroll Expense - Financial Back to top	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 General Liability Detail 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 a FinancialLink user ID	Results from these queries.
Staffing List Detail Staffing List Exception Back to top	Have Payroll Inquiry authority assigned through FinancialLink	Information for all employees.
Accounts Receivable Queries
Query	If you...	You can view...
Accounts Receivable Aging Accounts Receivable EAP Accounts Receivable Reconciliation Accounts Receivable Transactions	Have a isis_ar database user ID	Results from these queries.
Sponsored Projects AR Aging Back to top	Have a FinancialLink user ID	Results from these queries.
Accounts Receivable Easy Queries
Query	If you...	You can view...
Payments Receivable Back to top	Have a TritonLink user ID	Results from these queries.
DataLink Queries
Query	If you...	You can view...
Data Code SQL Data Glossary Back to top	Have a FinancialLink user ID	Results from these queries.
Academic Personnel Queries
Query	If you...	You can view...
Academic Personnel Next Review Due Academic Personnel History Academic Personnel Sabbatical Credit Accrual Back to top	Have PPS Departmental Security assigned through the mainframe PPS system (ARSM screen)	Information for academics whose home or appointment department is a Department Codes assigned to your user ID. If you do not have any departments assigned to your user ID, you will be able to look at, but not execute the queries.
	Have PPS Central Security assigned in the mainframe PPS system (ARSM screen)	Information for all academics.
Employee Queries
Query	If you...	You can view...
Distribution Of Payroll Expense Employee Employee Monthly Snapshots Employee Change History Employee Nonresident Alien Incentive Award Program Permanent Staffing Vacation Leave Accrual	Have PPS Departmental Security assigned through the mainframe PPS system (ARSM screen)	Information for employees whose 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.
Training Activity	Have a Single Sign-On ID	Your information (based on your user ID).
	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.
	Are a safety officer having title codes 7132-7137 or 7141-7143	Information for all employees who completed an Environment, Health and Safety training course.
Leave Activity Timekeeping Back to top	Have a Single Sign-On ID	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 Representation Code 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...
Distribution Of Payroll Expense Termination Payments	Have PPS Departmental Security assigned through the mainframe PPS system (ARSM screen)	Information for employees whose home or appointment department is a Department Code assigned to your user ID.
Distribution Of Payroll Expense Termination Payments	Have PPS Central Security assigned in the mainframe PPS system (ARSM screen)	Information for all employees.
Employee Code Values Telephone and E-mail Lists Head Count	Have a Single Sign-On ID	Results from these queries.
MyTraining Training Activity by Employee	Have a Single Sign-On ID	Your information (based on your user ID).
	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.
	Are a safety officer having title codes 7132-7137 or 7141-7143	Information for all employees who completed an Environment, Health and Safety training course.
Leave Activity Summary Leave Balance By Employee Group Leave Balance By Timekeeper Reclaim Vacation Hours Time Record Back to top	Have a Single Sign-On ID	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 designating supervisor and have been designated as such 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.
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 Back to top	Have a TritonLink user ID	Results from these queries.
Campus Admin Resources
Query	If you...	You can view...
AdCom Customer Request (ACR) Back to top	Have a FinancialLink user ID	Results from these queries.