| Financial, Budget, Equipment & Facilities Data Contact Person: Becky Farmer Tel: (510) 987-0814 |
Personnel Data Contact Person: Karla Holmberg Tel: (510) 987-0398 |
| Contracts & Grants, Student Data Contact Person: Dominique Pfaff Tel: (510) 987-0394 |
Equipment, Facilities, and Assets System Contact Person: Cynthia De Los Santos Tel: (510) 987-0663 |
Service Description
IR&C supports the policy analysis, planning, and reporting needs of the University by developing and maintaining systems that collect corporate data and by enabling access to this data. IR&C staff work with other UC personnel to define needs for corporate data; to develop plans for data collection, reporting, and maintenance; to develop new corporate data resources and reports; to provide data reports on both a regular and an ad hoc basis; and to provide customer training in direct data access and retrieval.
Currently, IR&C maintains nine corporate data systems and produces approximately 1,000 corporate data reports per year. The data from these systems feed the Corporate Data Warehouse, an environment for storage and retrieval. The nine corporate data systems are
Corporate Account Fund Profile System
Corporate Asset Depreciation System
Corporate Budget System
Corporate Contracts and Grants System
Corporate Equipment and Facilities System
Corporate Financial System
Corporate Personnel System
Corporate Staffing System
Corporate Student System
How to Obtain Corporate Data
Data Requests
UC personnel may request ad hoc reports and data extracts through the
IR&C information retrieval service on a recharge basis. To make a request,
contact the appropriate analyst listed above.
Direct Customer Access
UCOP employees and contractors who require access to the data should complete an IT Services Request form and indicate the corporate system(s) for which data warehouse access is being requested.
Non-UCOP employees/contractors (e.g., campus personnel or individuals from external organizations) must sign and complete the Corporate Systems User Agreement.
For most of the corporate systems, two options are available for direct data access. (1) Customers are encouraged to access data through the Corporate Data Warehouse using the WebFOCUS reporting tool or another query tool of their choice. (2) In addition, customers may access corporate data on the mainframe through the user access interface using the FOCUS programming language.
Related Information
IR&C offers additional services related to information technology development and consulting, including application system development and operation.
