OGCA Data Warehouse (JOL)

OGCA maintains an internal database/SmartGrant query system known as the OGCA 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.

OGCA 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 Guides

Standard Reports for Proposals or Awards by OU or Department

Proposals by Major Budgetary Unit (MBU)

Reports all proposals (awarded and unawarded) in one specified College (MBU) mailed in the date range entered by the user.

Awards by Major Budgetary Unit (MBU)

Reports all awards granted to one specified College (MBU) in the date range entered by the user.

PI and CO-PI Proposals By OU

Reports all proposals from one specified Department mailed in the date range entered by the user.

PI and CO-PI Awards By OU

Reports all awards granted to one specified Department in the date range entered by the user.