Skip to content
  1. Home > Subject Areas > Equipment file EFA200

Equipment file EFA200

 PHYSICAL CHARACTERISTICS
FILE NAME: EFA200
FTP FILE NAME: /ftphome/ftpusrn/put/efa/EFA200.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: 80
SEQUENCE: Ascending - Sort UC Location Code 1, UC Location Code 2, Custodial Department Code

Position Element

Length

 Field Format

1-2

 UC Location Code 1-Major Location

2

 Alphanumeric

3

 UC Location Code 2-Universitywide Indicator

1

 Alphanumeric

4-7

 Custodial Department Code

4

 Alphanumeric

8-12

 Fund Number/Filler

5

 Alphanumeric

13-57

 Custodial Department Name

45

 Alphanumeric

58-74

 Filler

17

 Alphanumeric

75-80

 Program Classification Code

6

 Alphanumeric

Name:

UC LOCATION CODE 1 -- MAJOR LOCATION

Type:

Alphanumeric

Length:

2

Format:

N/A

General Description:

A code indicating a campus, systemwide location, major affiliated institution, or US government owned/contractor-operated laboratory of the University.

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 Administration / Office of the President

'21' -- Lawrence Berkeley Laboratory

'22' -- Lawrence Livermore National Laboratory

'23' -- Los Alamos National Laboratory

'24' -- Hastings College of the Law

Comments:

Acceptable values for the EFA-Equipment system are '01' - '09'.

Revision Date:

 November 18, 2009

Name:

UC LOCATION CODE 2 -- SUB-LOCATION INDICATOR

Type:

Alphanumeric

Length:

1

Format:

N/A

General Description:

Code indicating that an equipment item is associated with the general campus, a universitywide program, or a medical center.

Code Interpretation:

'1' -- General Campus

'2' -- Universitywide

'3' -- Medical Center

Comments:

An equipment item may be associated with only one sub-location. Where an equipment item is associated with more than one sub-location, the predominant rule should apply.

Revision Date:

October 24, 2000

Name:

CUSTODIAL DEPARTMENT CODE--EQ

Type:

Alphanumeric

Length:

4

Format:

N/A

General Description:

Code indicating the department which has custodial responsibility for an equipment item.

Code Interpretation:

0000-8999 - to be designated by the campus Inventory Office 9906 - capitalized threshold phase-in items

9996 - libraries and collections 9997 - equipment on lease with option to purchase 9998 - equipment on loan from non-UC organizations 9999 - equipment on loan to non-UC organizations

Comments:

A separate custodial department code must be established for equipment acquired with auxilliary and service enterprise funds.

Revision Date:

December 8, 2009 - added code interpretation for 9906.
Name: FUND NUMBER
Type: Alphanumeric
Length: 5
Format: N/A
General Description: Number identifying a specific source of funds used at the time of purchase.
Code Interpretation: Refer to Accounting Manual Chapter A-115-2.
Comments:
Revision Date:  
Name: CUSTODIAL DEPARTMENT NAME--EQ
Type: Alphanumeric
Length: 45
Format: N/A
General Description: Name associated with the department which has custodial responsibility for an equipment item.
Code Interpretation: N/A
Comments:  
Revision Date:  
Name:
 PROGRAM CLASSIFICATION CODE
Type:
 ALPHANUMERIC
Length:
 6
Format:
 N/A
General Description:
 Code indicating the classification of academic departments by subject field and non-academic units by activity for the purpose of facilities inventory reporting.
Code Interpretation:
 See attached table for valid program codes.
Comments:
 See Appendix A of the Facilities Inventory Guide for expanded program code-definitions.
Revision Date:
  

Name:

CUSTODIAL   DEPARTMENT CODE--EQ

Type:

Alphanumeric

Length:

4

Format:

N/A

General   Description:

Code   indicating the department which has custodial responsibility for an equipment   item.

Code   Interpretation:

0000-8999   - to be designated by the campus Inventory Office
  9906 - capitalized threshold phase-in items

9996   - libraries and collections
  9997 - equipment on lease with option to purchase
  9998 - equipment on loan from non-UC organizations
  9999 - equipment on loan to non-UC organizations

Comments:

A   separate custodial department code must be established for equipment acquired   with auxilliary and service enterprise funds.

Revision   Date:

December   8, 2009 - added code interpretation for 9906.