Blink Home > Research > How to Run an Award Data Query: Department Report
How to Run an Award Data Query: Department Report  
 
Summary: See an example of how to find all sponsored project award data for your department during a particular fiscal year.

Note: Only awards that were active on Dec. 31, 2002, or later are included in this report.
What to do How to do it
1 Find out how to use the query tool, if necessary.
  1. Review How to Retrieve Data Using QueryLink.
2 Go to the Award Data for Departments-Summary query in FinancialLink.
  1. Access the Award Data for Departments-Summary query in FinancialLink.
Note: If you don't have access to FinancialLink, follow the directions in How to Get a User ID (Business Systems).

3 Make your selections in the query fields.
  1. On the Department tab:
    • Select your department from the drop-down list next to Department Name.
  2. On the Money/Dates tab:
    • Select <= from the drop-down list next to Project Start Date.
    • Enter the ending date of the fiscal year for which you are retrieving data, e.g., 6/30/2003.
    • Select >= from the drop-down list next to Project End Date.
    • Enter the beginning date of the fiscal year you are retrieving data for, e.g., 7/01/2002.
4 Submit your query.
  1. Click the Submit button to run the query.
  2. Your query will show up in your browser window as one long row. To save the data to an Excel file or to make a chart, make a selection from the drop-down box to the right.
5 Modify your query, if needed.
  1. After running your query, you can make changes to your selections:
    • Click the check box next to a field to have that field display on the query results.
    • Un-click the check box next to a field to have that field not display on the query results.
    • Enter values in the boxes next to fields to further refine the query.


Questions? Contact Anthony Slay, (858) 534-0326, or Mary Wittemann, (858) 822-3308.


  Print
Print
this page
  Email
Share
this page
  Add to MyBlink
Save
this link
  Get notified when this page is updated
Notify
on change
  Add a sticky note to this page
Add
a note
 
Get what you wanted?    yes   no   Comments.


Last reviewed/updated on March 14, 2008 (see more info)
Blink A-Z Index:   0-9  A B C D E F G H  I  J K L M N O P Q R S T U V W X Y Z 


Blink Home  Site Map  Help  Accessibility Tips  Privacy Statement  Content Manager  RSS Feed 


Copyright ©2008 Regents of the University of California. All rights reserved.
Official Web Page of the University of California, San Diego

Blink version 1.7 12-17/2007 Blink Usability Group