Corporate Contracts & Grants Data Warehouse

This site is for users of the Corporate Contracts & Grants Data Warehouse. It provides descriptions of the various tables available for queries, tips on ways to connect to the Data Warehouse, access to Data Definitions, and links to other relevant sites.

To gain access to the Contracts & Grants Data Warehouse, contact Charles Drucker at 510-987-6011 . UCOP personnel must also complete the UCOP IT Request form. Campus personnel must complete the Campus IT Request form (pdf) and the user agreement (pdf).

Access to CGX Dynamic Standard Reports through the Corporate Systems Gateway (CSG)

Tables/Reporting Objects available in the Contracts & Grants Data Warehouse

Access to Contracts & Grants Data Warehouse through WebFocus

Access to Contracts & Grants Data Warehouse through SAS or Brio

Change your Data Warehouse Password if you use SAS or Brio to access it

Data element descriptions

CGX Data Flow Diagram

Go back to Corporate Data Warehouse Home Page

  
  If you have questions about the Corporate Contracts & Grants Data Warehouse, contact Dominique Pfaff at 510-987-0394