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 email@example.com.
The University maintains an internal database/SmartGrant query system known as the Research Administration Data Warehouse (formerly Jordan-on-Line or JOL). The Data Warehouse allows users to see where in the overall process a proposal or award is currently, including whether a proposal has been submitted to the sponsor or an award has been sent to Accounting. The user may run custom reports and save the results to an Excel spreadsheet for further analysis or reporting. There are selection criteria and result columns that allow for tremendous flexibility in requests and results. There are also 'canned" reports that request the user to enter a timeframe and the major Budgetary Unit as appropriate. The result is in-line or can be saved in an Excel format.
OPAS status and submission dates are reported live but other changes will not appear until 4:15 AM on the date following the change.
Some Standard reports are also available below and can be run for specific time periods, by College or Department.
- How to use the Query Parameters.
- How to choose the Result Columns.
- How to interpret the resulting data and the statuses and award warnings fields.
Standard Reports for Proposals or Awards by OU or Department
Reports all proposals (awarded and unawarded) in one specified College (MBU) mailed in the date range entered by the user.
Reports all awards granted to one specified College (MBU) in the date range entered by the user.
Reports all proposals from one specified Department mailed in the date range entered by the user.
Reports all awards granted to one specified Department in the date range entered by the user.