Support Contact
Dominique Pfaff, (510) 987-0394,
Description
The Corporate Contracts and Grants System (CGX) is a set of databases and processes that provides information about sponsored projects at the University of California. CGX contains data on all university proposals to and awards from governmental agencies and other extramural entities that support project-based activities with contractual or quasi-contractual agreements rather than gifts. The CGX database is updated quarterly with files from the UC campuses, the Office of the President, the Division of Agriculture and Natural Resources, and the Lawrence Berkeley National Laboratory. CGX award information includes account and fund numbers, which permit a link to contract and grant expenditure data in the Corporate Financial System. CGX produces reports on a quarterly and annual basis for use by UCOP Research Administration, campus sponsored project offices, and other customers. The reports address proposals, awards, and sponsors.
Customers
Academic Affairs:
Office of Research
Business and Finance:
Costing Policy and Analysis
Research and Grants Administration (owner)
Industry-University Cooperative Research Program
UCOP Budget Office
Access
Corporate Contracts and Grants data resides in the UCOP Corporate Data Warehouse (CDW). Standard reports are available via the Web through the Corporate Systems Gateway (CSG). These reports are parameter-driven, which allows standard reports to be tailored to meet specific requests. Direct access to the data is also available for those who wish to program their own data requests. See our Corporate Data Warehouse Web page for further information on the methods of access that are offered, and how to obtain authorization.
Technical Information
The CGX production system runs in the IBM mainframe environment using the MVS operating system. Data is stored in FOCUS databases and production jobs are written in FOCUS and COBOL. Data from the system is extracted and loaded into the Corporate Data Warehouse on a routine basis. The Corporate Data Warehouse uses the Sybase IQ database management software running on the UNIX platform.
Input Specifications
Data Element Definitions (via file layouts)
