Skip to content

Equipment file EFA71


FILE NAME:
EFA71
FTP FILE NAME: /ftphome/ftpusrn/put/efa/EFA71.Yyyyy
Where 'n' represents the campus number, and 'yyyy' is the data year. See the FTP file input specifications for further information.
RECORD FORMAT: Fixed Block
RECORD LENGTH: 127
SEQUENCE: Ascending - Sort UC Location Code 1, Campus Functional Affiliation Code, Building Number, Building Name

Position Element Length   Field Format

1-2 UC Location Code 1-Major Location 2   Alphanumeric
3 Campus Functional Affiliation Code 1   Alphanumeric
4-8 Building Number 5   Alphanumeric
9-20 Building Name 12   Alphanumeric
21 Master Plan Code 1   Alphanumeric
22 Uniform Building Code 1   Alphanumeric
23 Building Functional Category Code 1   Alphanumeric
24-25 Ownership Code 2   Alphanumeric
26 Building Condition Code 1   Alphanumeric
27-33 Basic Gross Area 7   Numeric
34-40 Covered Unenclosed Gross Area 7   Numeric
41-46 Date of Occupancy 6   Numeric
47-50 Year Constructed 4   Numeric
51-52 Number of Levels 2   Numeric
53-59 Nonassignable Parking Structure Area 7   Numeric
60-63 Year of Latest Improvement 4   Numeric
64-93 Address/Location-Structure 30   Alphanumeric
94-97 City Code-Structure Location 4   Alphanumeric
98-99 County Code-Structure Location 2   Alphanumeric
100-106 Nonassignable Public Circulation Area 7   Numeric
107-113 Nonassignable Public Toilet Area 7   Numeric
114-120 Nonassignable Mechanical Area 7   Numeric
121-127 Nonassignable Custodial Area 7   Numeric

Name:

UC LOCATION CODE 1 -- MAJOR LOCATION

Type:

Alphanumeric

Length:

2

Format:

N/A

General Description:

Code indicating the benefitting campus of Systemwide location with which a structure is associated.

Code Interpretation:

'01' -- Berkeley
'02' -- San Francisco
'03' -- Davis
'04' -- Los Angeles
'05' -- Riverside
'06' -- San Diego
'07' -- Santa Cruz
'08' -- Santa Barbara
'09' -- Irvine
'10' -- Merced
'20' -- Systemwide (includes Office of the President and Regents' Offices)

Comments:

Revision Date:

November 18, 2009

Name:

CAMPUS FUNCTIONAL AFFILIATION CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating the administrative unit with which a building is affiliated in facilities inventory reports.

Code Interpretation:

'C' - Campus

'S' - Systemwide

'A' - Agricultural Field Station

Comments:

Revision Date:

Name:

BUILDING NUMBER

Type:

ALPHANUMERIC

Length:

5

Format:

N/A

General Description:

A unique number assigned to a building or structure at the time a capital project or construction contract begins to incur expenses under account group code 10202--Buildings and Structures.

Code Interpretation:

N/A

Comments:

Effective Fall 1996, use of the alpha suffix in the fifth position will not be accepted for newly capitalized buildings or structures. Numbers for buildings must be represented exactly as they appear in the Plant Asset file, under the Corporate Asset Account Number (CAAN).

Further, each building or separate structure must be assigned a unique building number, including buildings which are part of a complex. The assignment of building numbers should be coordinated with, but not limited to, the following offices: Plant Accounting, Equipment Management, Facilities Management (A&E and D&C), Facilities Inventory Management, and Capital Planning.

See February 7, 1996 letter to Assistant Vice Chancellors on the assignment of CAANs in Appendix G of the Facilities Inventory Guide for a complete discussion.

Revision Date:

February 1, 2000

Name:

BUILDING NAME 

Type:

ALPHANUMERIC 

Length:

12 

Format: 

N/A 

General Description:

The name or abbreviation of the name for a building as reported in the campus facilities data system. 

Code Interpretation:

N/A 

Comments: 

Revision Date:

Name:

MASTER PLAN CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating status of building consistent with a long-range physical development plan (also known as master plan, long-range development plan, LRDP) or other planning document used by a campus.

All buildings must be assigned a valid code, regardless of whether or not they are included in a master plan.

Code Interpretation:

'P' Permanent: a building constructed, acquired, or leased for long-term use with no expectation of removal

'O' Obsolete: a permanent building now deemed unsuitable for long-term use.

'I' Interim: a building constructed, acquired, or leased for limited-term use.

'R' Re-locatable: an interim building on a foundation of demountable construction, such as blocks or jacks.

Comments:

The classification is not affected by construction materials, ownership, age, or the interval until removal or replacement.

For leased and rented facilities, report the value with reference to the University’s intention to occupy the building for limited-term (i.e. ‘I’ or ‘R’) or indefinite use (i.e. ‘P’ or ‘O’), not the length of the current lease.

Revision Date:

November 1, 2002

Name:

UNIFORM BUILDING CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating which of five construction types, (as published by the International Conference of Building Officials and included by reference in the California State Building Code, Title 24), applies to a particular building.

Code Interpretation:

See attached Uniform Building Code.

Comments:

Revision Date:

Name:

BUILDING FUNCTIONAL CATEGORY CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating the type of building based upon the predominant current use of space within the building.

Code Interpretation:

'G' - General

'M' - Health Science

'R' - Residential

Comments:

Revision Date:
 
 

Name:

OWNERSHIP CODE 

Type:

ALPHANUMERIC 

Length:

Format: 

N/A 

General Description: 

Code indicating the basis upon which a building is available for use by the University. 

Code Interpretation: 

'UC' - UC owned, UC constructed
'UP' - UC owned, UC purchased
'UF' - UC owned, no cost to UC
'NF' - Not owned, no cost to UC
'NL' - UC lease on rental
'NX' - Not owned, charge other than lease or rental
'EX' - Third party built or leased, eventual UC ownership
'ET' - UC owned or built, eventual third party ownership

Comments: 

Revision Date:

Name:

BUILDING CONDITION CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating the overall quality of the building or structure at the time of the inventory.

Code Interpretation:

'1' - New, built within the last 5 years of the current inventory

'2' - Good

'3' - Fair

'4' - Poor

'5' - Untenable

Comments:

Revision Date:

Name:

BASIC GROSS AREA

Type:

NUMERIC

Length:

7

Format:

7 V 0

General Description:

The sum of all area, finished and unfinished, on all floors of an enclosed structure, i.e., within the environmentally controlled envelope, for all stories or areas which have floor surfaces.

Code Interpretation:

Refer to Appendix C of the Facilities Inventory Guide for detailed methodology. 

Comments:

Revision Date:
 
 

Name:

COVERED UNENCLOSED GROSS AREA

Type:

NUMERIC

Length:

7

Format:

7 V 0

General Description:

The sum of all covered or roofed areas of a building located outside of the enclosed structure, i.e., the environmentally controlled envelope, for all stories or areas which have floor surfaces.

Code Interpretation:

Refer to Appendix C of the Facilities Inventory Guide for detailed methodology. 

Comments:

Revision Date:

Name:

DATE OF OCCUPANCY 

Type:

ALPHANUMERIC 

Length:

Format: 

'MMYYYY' where 'MM'-Month, 'YYYY'-Year 

General Description: 

The month and year the building was first occupied by the University, whether by construction, purchase, gift, lease, or shared agreement and starting at that time when the University beneficially occupies the space. 

Code Interpretation:

N/A 

Comments: 

Revision Date:
 
 

Name:

YEAR CONSTRUCTED 

Type:

ALPHANUMERIC 

Length:

Format: 

N/A 

General Description: 

The year in which the construction of the building was completed, or the year of recordation of the "Notice of Completion of the Contract", when known; if exact year is not known then an estimate is acceptable. 

Code Interpretation:

N/A 

Comments: 

Revision Date:

Name:

NUMBER OF LEVELS

Type:

NUMERIC

Length:

2

Format: 

2 V 0

General Description: 

The number of floors or stories within a building, including basement, mezzanine, and attic, and any other useable area the height of which is at least 6'6" above the flooring, regardless of whether the building or structure is owned or leased by the University.

Code Interpretation:

N/A 

Comments: 

Each building must report at least one level. For split-level buildings, or buildings which may have a wing with fewer levels than the main building, report the maximum number of levels within the building.

For leased facilities, if the University occupies five levels of a 30-story building, the number of levels reported for that building would be "30".

Revision Date:

Name:

NONASSIGNABLE PARKING STRUCTURE AREA

Type:

NUMERIC

Length:

7

Format:

7 V 0

General Description:

The total measure of any gross floor area of a parking structure which is used for private vehicle access, circulation, and parking, whether in parking or non-parking buildings or structures.

Code Interpretation:

N/A

Comments:

Parking structures are not considered Covered Unenclosed Gross Area. Campuses should record measurements for parking structures and relevant parking areas as part of Basic Gross Area and asNonassignable Parking Structure Area.

See Appendix C, Building Area Overview, for further discussion.

Revision Date:

Name:

YEAR OF LATEST IMPROVEMENT

Type:

NUMERIC

Length:

4

Format:

YYYY

General Description:

The year in which the most recent major capital improvement (costing over $250,000) to an existing building or structure was completed.

Code Interpretation:

N/A

Comments:

The data element "Year of Latest Improvement" is used only to update those buildings which are already on the facilities inventory file and for which a major capital improvement project costing over $250,000 would significantly extend the useful life of the structure (e.g., new wing or floor added to an existing building; or renewal or replacement of the building's infrastructure). Do not include renovations to existing rooms undertaken solely for programmatic reasons, which do not extend the life of the structure or infrastructure.

For new buildings which are being added to the facilities inventory file for the first time, use the data element "Year Constructed."

Revision Date:

Name:

ADDRESS/LOCATION-STRUCTURE

Type:

ALPHANUMERIC

Length:

30

Format:

N/A

General Description:

The address or other physical location for a structure which is not located on or in the immediate vicinity of the core campus.

Code Interpretation:

N/A

Comments:

Values should reflect physical location for geographical identification and mapping purposes.

Examples: all Richmond Field Station Bldgs should be 1301 South 46th St.

or

Lake Arrowhead Conf Center should be 850 Willow Creed Rd.

or

Bodega Marine Lab should be Westside Rd.

or

Laurel Heights should be 3333 California

Revision Date:

Name:

CITY CODE-STRUCTURE LOCATION

Type:

ALPHANUMERIC

Length:

4

Format:

N/A

General Description:

Code indicating the city/town in which a structure is geographically located.

Code Interpretation:

See attached.

Comments:

Revision Date:

Name:

COUNTY CODE-STRUCTURE LOCATION

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

Code indicating the county in which a structure is geographically located.

Code Interpretation:

See attached.

Comments:

Revision Date:

Name:

NONASSIGNABLE CIRCULATION AREA

Type:

NUMERIC

Length:

7

Format:

7 V 0

General Description:

The sum of all areas on all floors of a building required for public physical access to some subdivision of space, whether or not physically bounded by partitions.

Code Interpretation:

N/A

Comments:

Revision Date:

Name:

NONASSIGNABLE PUBLIC TOILET AREA

Type:

NUMERIC

Length:

7

Format:

7 V 0

General Description:

The sum of all areas on all floors of a building devoted to non-assignable public toilet facilities.

Code Interpretation:

N/A

Comments:

Revision Date:

Name:

NONASSIGNABLE MECHANICAL AREA

Type:

NUMERIC

Length:

7

Format:

7 V 0

General Description:

The sum of all areas on all floors of a building designed to house mechanical equipment, utility services, and shaft areas.

Code Interpretation:

N/A

Comments:

Revision Date:

Name:

NONASSIGNABLE CUSTODIAL AREA

Type:

NUMERIC

Length:

7

Format:

7 V 0

General Description:

The sum of all areas on all floors of a building used for custodial supplies, sink rooms, and janitorial closets.

Code Interpretation:

N/A

Comments:

Revision Date: