UCSD
CAMPUS NOTICE
University of California, San Diego
 

OFFICE OF CONTRACT AND GRANT ADMINISTRATION
ADMINISTRATIVE COMPUTING AND TELECOMMUNICATIONS
SPEAR ADMINISTRATION

March 17, 2004


KEY ADMINISTRATORS/KEY SUPPORT STAFF (including UCSD Healthcare)

SUBJECT:    Queries Available for Contract and Grant Award Data

"Sponsored Project Excellence Achieved through Redesign" (SPEAR) was initiated as an internal cooperative UCSD effort to evaluate and implement sponsored project electronic-based innovations. One major initiative of this effort has been the development of Coeus, a campus core relational database that, for the first time, links proposal and award information to the campus core financial system.

Working with Administrative Computing and Telecommunications (ACT) and the Office of Contract and Grant Administration (OCGA), the Coeus Team of SPEAR has developed two QueryLink products. These queries provide authorized departmental users with access to key components of Award data, integrated with Chart of Account (COA) financial data. For more information about the product, please see: http://blink.ucsd.edu/go/awardquery.

The two queries presently available are:

1) Award Data for Departments ~ Summary
This query tool provides a high level summary of information pertaining to the entire award. Our goal has been to provide an "at a glance" result for each award.

Examples of available information include:

+ Award Status & Type
+ Activity Type
+ Sponsor
+ IDC Rate
+ Project Total Cost
+ Award Title
+ Base Award Number
+ Department
+ Organization Code
+ Researcher
+ Cost Sharing
+ Project Start/End Date
+ Project Direct/Indirect cost
+ Administrative Roles & Contacts

2) Award Data for Departments ~ Details
In addition to the options available with the above summary query, this query provides additional selections such as:

+ Fund Number
+ Full Award Number & Mod.
+ Budget Start/End Date
+ Adv Approvals
+ Proposal Number
+ Clinical Trials Index Pre Award Authorized
+ Amount
+ Pre Award Effective Date
+ Budget Direct/Indirect cost
+ Budget Total Cost
+ Sponsor Type
+ Pending Awards

These queries are also available via the Queries sections of FinancialLink and DataLink.

It is important to note that only awards with an active project date of December 31, 2002 and later are available in the data warehouse. Older awards will not be represented in the data warehouse.

Please look for more information and demonstrations of Coeus at the upcoming Sharecase event on March 24, 2004.

For questions regarding this announcement and the Coeus Award Data project, please contact Linda Dale at ldale@ucsd.edu or x43333. For technical questions regarding the queries, please contact Mary Wittemann at mwittemann@ucsd.edu or at x23308.


Linda Dale
Director -
Contract and Grant Administration

Elazar C. Harel
Assistant Vice Chancellor -
Administrative Computing and
Telecommunications

Angela Song
Project Director -
SPEAR