Support Contact
Cynthia DeLosSantos, (510) 987-0663,
Description
The Corporate Equipment, Facilities, and Assets System (EFA) contains information about facilities that house University of California programs (buildings and rooms) and equipment held by the UC campuses, the Office of the President, and the Division of Agriculture and Natural Resources. Building and room data is collected once per year, and reflects all buildings available for use by the university as of the third week of the Fall term, regardless of ownership, structural type or location, or whether assignable area is included. Equipment data is also collected once a year, and reflects the campus equipment inventory as of December 31. An equipment conversion file is submitted by campuses and contains custody departments mapped to program codes. This mapping provides a method for linking facilities data to equipment data and is used primarily for the instructional equipment replacement program. Equipment and facilities data from EFA is used to update data in the Asset Depreciation System. Production reports address equipment unit cost, the instructional equipment replacement program, space usage, and equipment management.
Customers
UCOP Budget Office (owner - facilities)
Business Operations (owner - equipment):
Financial Management
Risk Services
Access
Corporate facilities data (buildings and rooms) and equipment 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, allowing for tailoring of standard reports to meet specific requests. More direct access to the data is also available – see our Corporate Data Warehouse web page for further information on what methods of access are offered, and how to apply for access.
Technical Information
The EFA 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 an annual basis. The Corporate Data Warehouse uses the Sybase IQ database management software running on the UNIX platform
Input Specifications and
Data Element Definitions (via file layouts)
