Background: Queries are a result of the COEUS project, a campus core relational database that links proposal and award information to the campus legacy financial systems.

The Award Data for Departments queries let you retrieve sponsored project award information for your department, organization, or fund based on criteria such as the research person (PI or Co-Pi), budget/ project dates and amounts, or award status.

There are two award data queries:

• The Award Data for Departments-Detail query provides information by the full UCSD award number. Use this query to find detailed information on any any award for a particular department, PI, or fund.
• The Award Data for Departments-Summary query provides information by the base UCSD award number. Use this query to find a high-level summary of information on the entire award for a particular department or PI.

You must have access to mainframe IFIS or Darwin accounts to use either of these queries.

See examples of types of information you can find with these queries:

• How to Run an Award Data Query: Department Report
• How to Run an Award Data Query: PI Report
• How to Run an Award Data Query: Pending Awards Report

For more information, see a tutorial (PPT) on the award data query.

Questions? Contact Anthony Slay, (858) 534-0326.