Search Criteria

Starting July 1, 2019, no new data will be fed into JOL. All reporting will be done out of Kuali Research. If you have questions, please email


 Tab 1: Choose Query Parameters (Search Criteria)

Note: When there is an asterisk in the field, it means you may use a wild card. To find records where the data is contained within it somewhere use an asterisk on both ends *national* for instance in the sponsor field. See the data fields below with an explanation of how to use them to filter your search of the database.

OGCA #: format example 116-0001

OGCA # Range: again must be 110-0001 format or 116-0001 for FY 2016, but better off using a date range as in #3.

Proposed date: date the proposal was sent to the sponsor so Fiscal Year 2015, would be from 07/01/2014 to 06/30/2015.

Award date: date the Office of Post-Award Management (OPAM) Director signed off on the award, entered the same way as # 3.

PI Name(s): [Separate with a semicolon for more than one. Use a comma to separate last name from first name
e.g. "kelly, j* ; morris*" to select names like 'John Kelly' and 'Jane Kelly' along with anyone with a last name starting with 'Morris'.]

Search CO-PIs too?:  Check this box if you want all the records that this person has been associated with either as the PI or the Co-PI. In the results query, you will see the CO-PI’s listed with their associated departments.

Award $ Total: Enter a range From: and To: will give you listing of awards within that range of Dollars on a per award basis – not a sum by project.   You can also select on Awards $ Direct and/or Indirect by themselves.

Speed code: If you have this number for a particular award, this will give you all funding associated with it.

Do not show No Cost Ext of time:  Extensions of time extend the active award period, and will show as an OGCA# with an ‘e’ suffix. If you don’t want to see these in your result set suppress them by checking this box.

Do not Show ‘p’ Records:   These records will show as OGCA#s with an ‘p’ suffix. If an award has not been completely processed through OPAM, but has been preliminarily funding, it will show if this is not checked off.  This allows you to see Awards that have not yet been fully funding but the PI can start the project.  As soon as the award is fully funded, the ‘p’ records will not show and you will see instead the actual award amount.

Department: pick from the drop down (includes any that have ever submitted a proposal or received an award, even if they no longer exist as listed).

College: pick from the drop down (includes any that have ever submitted a proposal or received an award, even if they no longer exist as listed).

Institute:  check off the ones you want or you can select all. These are currently ONLY the Institute of Applied Life Sciences centers.

Title: This is helpful if you are looking for full title or a single keyword. If you have part of a title, you can put it in inside two asterisks *part of title*, or single word *word*

Title Keywords: you can just list as many keywords as you want. Ex: nano bio, brings back records with both words within the title. Using words that are as unique as possible will limit the number of records in the result set.

Proposal GPID: The SmartGrant Proposal ID number.

Award GPID: The SmartGrant record that is associated with the award.

GAID: The SmartGrant Award #, it is also considered the project number, so once you have the GAID of a Project, you can do a search on it to show all the activity of that project .

Sponsor: pick from the drop down.

Sponsor number: This can be the full number or it can be a subset of the number. As an example, NIH Changes the beginning of their award number depending on whether it's a new, continuation, or competing renewal. By just entering the #'s in the center, you will still get a full list of that award project, Ex: *D0006241*.

Sponsor Agency: Which is really Agency type, ex: DOD, USDA, Commonwealth of Massachusetts, Foundations, Other Colleges and Universities, etc. Note: we may not have categorized it the way you expect so try a couple of different categories if you are looking for specific records.

Prime: pick from the drop down, just as you can pick a sponsor.  See all actions where the funding has come through another entity. Ex. There are many actions that have a federal prime, so by selecting a prime, like NSF or NIH, you can see all actions where the originating funding source was that federal agency.