Facilities Inventory Guide - Chapter 5 - Edit and Standard Output Reports
Most of the data which enters the CEFA system comes from campus input. Campuses extract data from their local facilities systems and forward it to the Office of the President on computer files in a format prescribed by the CEFA input specifications (see Chapters 3 and 4). Other data in the CEFA system comes from tables developed and maintained at UCOP. These tables allow the system to categorize and sort the data in other ways. The OMP Funding Eligibility Codes and Program Code Names are examples of classification tables.
Facilities Files
Each year, on the tenth working day of December, campuses submit replacement facilities files. In order to insure that the data which enter the CEFA is correct, they are filtered through an edit process. The edit process examines the data and judges it according to established criteria for validity. The edit program generates a series of reports which list all invalid data and flag data which fall out of expected ranges. These reports are reviewed by the appropriate Office of the President functional user and forwarded to the campus functional user. All campus files must clear the edit process and be approved for use before the corporate database can be built and any data can be used.
Standard output reports are produced upon completion of the edit process and the building of the corporate database. These standard output reports are provided to the functional users in the Office of the President.
Conversion File
The Facilities-Equipment Conversion File is used to link facilities and equipment data for various reporting requirements at the Office of the President (e.g., instructional equipment replacement and capital improvements reporting). The Conversion file, with data as of the end of each fiscal year, is used in conjunction with the Fall facilities data from the previous calendar year (the same fiscal year). The mapping of equipment custody codes to the appropriate program codes is critical to the accurate reporting and analysis of these data. The current reporting schedule to meet State and Regental deadlines does not usually allow for the resubmission of this file. Therefore, edit reports should be reviewed and corrections made prior to the next reporting cycle.
However, the edits are only able to catch gross errors in the file (e.g., invalid or missing data). The accuracy of the mapping can only be detected through careful scrutiny by knowledgeable campus personnel. Therefore, the standard output reports listing the file as submitted by the campuses and as used in the corporate databases (data is rolled up at UCOP so that each custody code has only one program code) should be reviewed each cycle.
Facilities File Edit Reports
Before the corporate facilities inventory database can be built, the CEFA team (consisting of OP functional users in the Budget Office and Information Resources and Communications) reviews a series of edit reports that are generated from updated campus data files. The CEFA team examines the data contained in the edit reports for accuracy, consistency, and validity. Upon completion of the review, the CEFA team advises and notifies the campus of (a) the outcome of the edit review and (b) whether or not corrections to and re-submittal of the building and room files are required.
EFA1000A Primary Edit of Alpha Fields in Facilities Building File: Edits all non-numeric fields on the campus building file for valid values and lists erroneous records that are given error codes. (Error interpretation codes are provided at the bottom of each page of the edit report.)
EFA1000B Primary Edit of Numeric Fields in Facilities Building File: Edits all numeric fields and lists erroneous records that are given error codes. (Error interpretation codes are provided at the bottom of each page of the edit report.)
EFA1000C Primary Edit - Building Control Totals: Summarizes major square footage fields for all records not rejected in the primary edit of Campus building data.
EFA1000D Primary Edit - Control Totals on Rejected Buildings: Summarizes major square footage fields for all rejected records in the primary edit of campus building data.
EFA1010A Primary Edit of Facilities Room File: Edits every field on the campus room file for valid values and lists erroneous records that are given error codes. (Error interpretation codes provided at the bottom of each page of the edit report.)
EFA1010B Primary Edit - Room Control Totals: Summarizes numeric fields for all records not rejected in the primary edit of campus room data.
EFA1010C Primary Edit - Control Totals on Rejected Rooms: Summarizes numeric fields for all rejected records in the primary edit of the campus room data.
EFA1011 List of Invalid Room Use Codes: Matches campus room file against table of valid room use codes which is maintained by the Office of the President; prints a list of invalid records by building key, room number, and room use code.
EFA1012 List of Invalid Program Codes: Matches campus room file against the table of valid program codes which is maintained by the Office of the President; prints a list of invalid records by building key, room number, program code, and facilities department name.
EFA1013 List of Rooms without Buildings: Matches campus room file against building file and lists all rooms that do not have a corresponding building on the building file by building key (as it appears in the room file), room number, room use code, room ASF, facilities department name, and program code.
EFA1014 Department Information by Program: Summarizes ASF, class lab and research station size codes, and NSF discipline codes by program code, program name, and facilities department name. This is not an error report.
EFA1015 Buildings Without Room Level Data: Lists buildings without room level data by building number and name, providing all non-assignable space, basic gross, and outside gross.
EFA1016 Total Usable Square Footage Greater Than OGSF or Less Than 10% of OGSF: Displays buildings for which the total useable square footage is greater than OGSF (based on Basic Gross plus 100% Covered Unenclosed Area), or less than 10% of OGSF. Lists building number and name, number of levels, basic gross, covered unenclosed gross, outside gross, building assignable square feet, building non-assignable square feet, and the ratio of total useable square feet to OGSF.
EFA1017 Buildings with Duplicate Rooms: Lists buildings which report duplicate rooms by building number and name, room number, facilities department name, room use code and name, and assignable square feet.
EFA1018 Rooms That Should Have Stations But Report None: Provides list of rooms that should reflect a station count but report none by building number and name, program code, facilities department name, room number, room use code and name, and assignable square feet.
EFA1019 Edit of ASF per Station for Classrooms and Seminar Rooms: Lists rooms coded as 110-Classrooms and 130-Seminar rooms which fall out of expected threshold ranges by room use code and name, building number and name, facilities department name, room number, assignable square feet, stations, and ASF per station. For 110-Classrooms, the expected range is 8-25 ASF per station; for 130-Seminar Rooms, the expected range is 15-35 ASF per station.
EFA1020 Room Use Codes Mapped to Incorrect CPEC Category: Compares campus CPEC category code designation with OP table of valid CPEC category codes and lists invalid campus input by building number and name, program code, facilities department name, room use code and name, room number, and assignable square feet.
EFA1021 Rooms That Should Not Be Assigned a CPEC Category: Lists rooms assigned to non-instructional programs (i.e., program codes other than 1.1 and 1.2) that inadvertently were assigned a CPEC Category code by building number and name, program code, facilities department name, room use code and name, room number, campus CPEC category code and assignable square feet.
EFA1022 Inconsistent Room Codes Based on Program Code: Displays room use codes and names that may not be used or would normally not appear in certain program codes. Inconsistencies are sorted by program code, facilities department name, building number and name, room number, room use code and name, and assignable square feet.
EFA1025 OP Sign-off Use of Room code 740-Miscellaneous: The use of the 740-Miscellaneous room code requires prior UCOP approval. This edit report lists rooms coded 740-Miscellaneous by building, room number, program code, facilities department name, and assignable square feet.
EFA1026 Inconsistent Building Age and Condition Code for UC-Owned Buildings: Lists UC-owned buildings that are over 5 years old for which the Building Condition Code is '1-Satisfactory' and which do not reflect renovations in the Year of Latest Improvement field. This is not an error list, but rather, a list which campuses should review annually to see if a downgrading of the Condition Code is warranted.
EFA1027 Invalid Class Lab and Research Size Codes: Matches the campus-assigned class lab and research station size codes to the UCOP-approved table of valid values and prints any inconsistencies by program code, facilities department name, class lab station size code, research station size code, and assignable square feet.
EFA1028 Buildings with Unknown City or County Codes and Missing Structural Address: Lists buildings with invalid or blank values for city and/or county codes and structural address by ownership, date occupied, and building. All buildings, regardless of ownership, must report this information.
EFA1029 Listing of Rooms with ASF Less Than or Equal to 1: Lists ASF and stations by building number and name, program code, facilities department, room number, room use code and name.
EFA1030 Building ASF Information at CAAN vs. Building Number Level: Lists buildings that report a 5-digit building number. This report is used to evaluate proration of the book value from the Plant Asset file. Lists buildings by 4-digit Capital Asset Account Number (CAAN), 5-digit building number, total usable square feet, building ASF and all non-assignable spaces. Effective February 7, 1996, the use of 5-digit building numbers is not allowed.
EFA1031 EFASIZE Validation: Lists rooms which have been assigned class lab and research station size code values in Programs or facilities departments that have not been approved for inclusion in the OP EFASIZE Table.
EFA1032 Assembly Rooms: Lists rooms coded as 650-Assembly by building number and name, room number, program code, facilities department name, assignable square feet, stations, and ASF per station.
EFA1033 Structural Address: Buildings located within the periphery or boundary of the core or main campus should have an address of “Core Campus.” For off-campus buildings, the actual street number and street name may be recorded.
Facilities Standard Output Reports
When all campuses have cleared the edit cycle, the corporate facilities database is built and the following standard output reports are generated and provided to functional users in the Office of the President.
EFA3000 Building and Room Statistics from Campus Supplied Files: Sums all numeric fields on building and room files by building count, basic gross area, covered unenclosed gross area, outside gross area, assignable square feet, station count, and room count. (OP functional user: Budget Office)
EFA3200 Library ASF by Building: Sums ASF and counts rooms by building name and number, facilities department and room use code for buildings which house library programs only. (OP functional user: Library Affairs)
EFA3400 Building Biographical Listing:: Lists buildings and their characteristics (age, ownership, condition, assignable square feet, basic gross area, covered unenclosed area, and outside gross area) by building name. (OP functional users: Budget Office, Facilities Management)
EFA3410 Building Listing by Building Number: Lists all buildings by campus by building number. Shows building category, master plan, uniform building code, condition, ownership, levels, outside gross area, assignable square feet, stations, number of rooms, and efficiency ratios. (OP functional user: Budget Office)
EFA3425 List of Buildings by Building Number: Lists campus functional affiliation, building name, ownership, plant asset description, basic gross area, building assignable area, total fixed equipment and federal capitalized values, by campus and by building number. Uses Fall facilities file data in conjunction with fiscal year-end plant asset data. (OP functional users: Corporate Accounting, Financial Costing Policy and Analysis, Budget Office, Risk Management)
EFA3426 Summary Building Values By Campus: Campus level summary of basic gross area and building assignable area with plant asset, fixed equipment, and federal values. (OP functional users: Corporate Accounting, Financial Costing Policy and Analysis, Budget Office, Risk Management)
EFA3500 Individual Rooms by Building: Lists every room, by building number and name, building category code, room number, room use code and name, room standard code, facilities department name, program standard code, program code and name, assignable square feet, and station count. (OP functional user: Budget Office)
EFA3600 Summary of Total Campus Space by Program (Table A-0): Displays standard and nonstandard assignable square footages by CPEC category for standard I&R programs and by specific program groupings for all nonstandard programs. (OP functional user: Capital Planning)
EFA3601 Program Space by Department and Room Use: Lists number of rooms, total assignable square feet, and number of stations for each room use code by program code and department. (OP functional user: Capital Planning)
EFA3602 Departmental Space by Building and Room Use: Lists number of rooms, total assignable square feet, and number of stations for each room use code by department and building. (OP functional user: Capital Planning)
EFA3603 Campus I&R Space by CPEC Size Category: Shows standard and nonstandard assignable square footages for I&R programs by CPEC category, with data for each station size category of teaching laboratory and research/scholarly activity. (OP functional user: Capital Planning)
EFA3604 I&R Space by Program Code and CPEC Category: Displays total assignable square feet for each CPEC category by program code (for program code series 1.1 and 1.2 only). (OP functional user: Capital Planning)
EFA3605 Departmental I&R Space by Program and CPEC Category: Displays total assignable square feet for each CPEC category by program code and department (for program code series 1.1 and 1.2). (OP functional user: Capital Planning)
EFA3606 Classrooms, Classroom Service, and Seminar Rooms: Displays every classroom (110), classroom service area (125), and seminar room (130) with all associated data (room use name and code, program code, facilities department name, assignable square feet, stations and average ASF per station) by building number, building name, and room number. (OP functional user: Capital Planning)
EFA3607 Departmental Classrooms, Seminar Rooms and Teaching Labs: Lists assignable square feet and number of stations for every classroom, seminar room, and teaching laboratory by department, room use code and name, building number and name, and room number. (OP functional user: Capital Planning)
EFA3608 Classrooms, Seminar Rooms and Teaching Labs by Room Use: Lists assignable square feet, number of stations, by room use code and name, building number and name, program code, department, and room number for every classroom, seminar room, and teaching laboratory by room use. (OP Functional user: Capital Planning)
EFA3620 Total ASF by Functional Categories for Regents' Budget: Shows total assignable square feet by campus in the categories of central campus, hospitals and clinics, veterinary medicine, agricultural field stations and system-wide. (OP Functional user: Capital Planning)
EFA3621 Distribution of ASF for Minor Capital Improvement Program: Shows total campus assignable square feet and the proportion that is eligible and ineligible for inclusion in the State Minor Capital Improvement Program. (OP Functional user: Capital Planning)
EFA3700A Distribution of ASF by OMP Funding Eligibility: Distributes assignable square feet by OMP eligibility, by building name, by building number, by outside gross area. (OP functional user: Budget Office)
EFA3700B Distribution of ASF by OMP Funding Eligibility: Distributes assignable square feet by OMP eligibility, by building name, by building number, by outside gross area. (OP functional user: Budget Office)
Facilities-Equipment Conversion File Edit Reports
EFA1200 Listing of Conversion File: List campus files as sent: UCLoc 1 and 2, custody code fund, custody code title, and program code. (OP Functional user: Budget Office)
EFA1201 Edit of Invalid Fields
Lists all data elements for a record when the campus code, UC2 code or the program code is
invalid. (OP Functional user: Budget Office)
EFA1202 Edit of Custody Departments without Titles or with Duplicate Data
Edit error report which displays incomplete or duplicate records in the file. (OP Functional user:
Budget Office)
EFA1203 UC2 Edit
Edit error report listing records with same custody code but different UCLocation 2 values. (OP
Functional user: Budget Office)
EFA1204 Edit Report of Inconsistent Custody Code and Program Code
Edit error report listing all data elements on a record when a custody department has been assigned more than one program code. (OP Functional user: Budget Office)
EFA1205 Edit Report of Inconsistent Recharge Fund and Program Code
Edit error report for recharge-funded custody departments assigned inappropriate program codes.
(OP Functional user: Budget Office)
EFA6000 List of Equipment without a Program Code
Matches the equipment file to the conversion file and sums all equipment (by federal vs. state
funding) by custody code when not found in the conversion file (equipment therefore not assigned to a program). (OP Functional user: Capital Planning)
EFA6100 Facilities in Programs without Equipment
Provides assignable square feet by program code and facilities department for programs without
equipment. (OP Functional user: Budget Office)
EFA2000 Equipment Custody Department/Program Code Conversion File
Displays the custody department title and program code by campus, custody code, and sub/fund.
(OP Functional user: Budget Office)
EFA2001 Program Code/Equipment Custody Department Conversion File
Displays the custody department title by campus, program code, custody code, and fund/sub. (OP Functional user: Budget Office)
EFA 6500 Equipment Unit Costs
Reports equipment cost per square foot for every program by federal and state funding source for
each campus. (OP Functional user: Capital Planning)