Section 01788 EQUIPMENT AND INSTRUMENT DATABASE (EID)

Section 01788

EQUIPMENT AND INSTRUMENT DATABASE (EID)

PART 1 - GENERAL

1.1 DESCRIPTION

A. The Equipment and Instrument Database (EID) is an Excel-based spreadsheet data loader for the OCSD Computerized Maintenance Management System (CMMS). The CONTRACTOR shall complete the EID spreadsheets in accordance with this Specification and instructions contained within the EID spreadsheets.

B. The EID consists of up to 8 spreadsheets per process area that cover the following equipment categories: Driven, Driver, Electrical, Instrument, Mechanical, Valve, No Detail, and Transformer. Portions of the EID are filled in by the “Designer” (ENGINEER), portions by “OCSD” (ENGINEER) and portions by the CONTRACTOR. The CONTRACTOR’s portion is designated in the Data Dictionary that is part of each individual EID spreadsheet. Refer to the data dictionaries and the sample EID included in this Specification section.

C. The EID is completely separate from the SCADA Administration Tool (SAT) defined in Specification section 17410, Programming by Contractor section 17411, Programming by OCSD. The SAT database contains data for instrumentation points and has its own data dictionary.

1.2 RELATED WORK SPECIFIED ELSEWHERE

A. The requirements of the following sections and divisions apply to the Work of this section. Other sections and divisions of the Specifications, not referenced below, shall also apply to the extent required for proper performance of this Work.

1. Section 01810, Commissioning

2. Section 17410, Programming by Contractor

3. Section 17411, Programming by OCSD

1.3 CONTRACTOR SUBMITTALS

A. Submittals shall be made in accordance with the General Requirements, Additional

General Requirements and as specified herein.

B. CONTRACTOR shall submit final, completed EID electronic files to ENGINEER for review. This submittal shall occur subsequent to product submittals for the job phase, but at least 90 days before the end of Pre-Commissioning as defined in Specification section

01810, Commissioning. Applicable portions of EIDs shall be submitted for each phase of a multi-phase project.

PART 2 - PRODUCTS (NOT USED) 

PART 3 - EXECUTION

3.1 GENERAL

A. The EID is the tool used by OCSD to load equipment and instrument data into the Computerized Maintenance Management System. The EID is not intended to be a complete listing of all equipment and instrumentation required by the project. However, every equipment item, device, and instrument that has an assigned Loop Tag Number (LTN) is included in the EID and receives one entry in the appropriate EID spreadsheet. The Process & Instrumentation Diagrams coupled with the Single Line Diagrams, the demolition Drawings, and LTNs added through Change Orders will provide all of the LTNs for the project, with the exception of LTNs added because of CONTRACTOR selected packaged equipment that, although it meets contract requirements, may require additional LTNs. CONTRACTOR shall include these additional LTNs in the Contract Work and in the EIDs at no additional cost to OCSD

B. “OCSD” (ENGINEER) will provide the CONTRACTOR with a partially completed EID in MS Excel format complying with OCSD standard documentation within six months after Notice to Proceed. If any data/information in this original-issue EID is in conflict with information shown elsewhere in the Contract Documents, the other Contract Document requirements shall take precedence over the information listed in the EID. In this case CONTRACTOR shall modify the EID to conform to the contract documents at CONTRACTOR’s cost, and inform the ENGINEER.

C. The CONTRACTOR shall be responsible for completing the number of assets in each portion of the EID show below:

Category Number of Assets

Driven 200

Driver 200

Electrical 750

Instrument 2000

Mechanical 300

No Detail 5200

Transformer 20

Valve 2200

D. The CONTRACTOR shall complete the EID, per asset, based on the sample EID, and the data dictionaries and noun list contained within the EID spreadsheet.

E. It shall be the CONTRACTOR's responsibility to use the as-built plans and Specifications to compile a complete and accurate list of equipment and instrumentation loop tag numbers.

F. The electronic copy of the EID provided by “OCSD” (ENGINEER) contains all of the initial design LTNs plus a portion of the data for these LTNs.

G. The CONTRACTOR shall be responsible for filling in EID fields identified with a “C” in the data dictionary, and shall add, modify, or delete records as required for every device and all equipment on the project that are assigned a Loop Tag Number to match the equipment actually furnished on the project. The CONTRACTOR shall also be responsible for verifying and updating the OCSD-provided information in the EID to match the equipment actually furnished on the project.

H. Additional Work may be added to the contract during the course of construction via RFI, RFP, FCO, and Bulletin. The CONTRACTOR shall post the changes to a working copy of the EID in a timely manner. The CONTRACTOR shall fill in both the “D” and the “C” fields for all equipment, instruments, and devices receiving Loop Tag Numbers and installed as additional Work.

I. The CONTRACTOR shall return the final, completed EID spreadsheets without any changes in structure, column headings, drop-down menus or other non-data items. Any changes made to the working EID for the convenience of the CONTRACTOR (or otherwise) shall be removed for the final, completed EID spreadsheets. The CONTRACTOR shall NOT change the wording of the column headings on the working copy.

J. Some spreadsheet cells have predefined drop-down menus with predefined selections (such as manufacturers). Should the drop-down selection be inadequate for the product at hand, the CONTRACTOR shall arrange with the ENGINEER to directly contact the OCSD CMMS support group for direction.

3.2 SAMPLE DATA DICTIONARY, SAMPLE EID AND SAMPLE NOUN LIST

A. Each of the EID spreadsheets has a data dictionary tab, a data sheet tab, and a noun list tab. Samples of a data dictionary, a data sheet, and a noun list are found below, solely for the purpose of estimating the effort required by the CONTRACTOR to complete the EID spreadsheets. Complete data dictionaries are shown below for each equipment type. However, for reasons of space, a sample data sheet is shown for only the “Driven” equipment type, and only a few example entries are shown, although the CONTRACTOR shall be required to provide entries for all the driven assets in the Project. The noun lists are identical for each EID spreadsheet.

B. The “No Detail” equipment type EID spreadsheet has the fewest data entries fields and the most records. Every other EID spreadsheet requires all the information of the “No Detail” spreadsheet as well as additional information pertaining to that type of equipment. For example, the “Driven” EID requires all of the “No Detail” information plus driven unit type (e.g., PMP), capacity, total dynamic head, impeller size, and other information specifically applicable to driven equipment such as gearboxes, pumps, fans, compressors, and blowers. The Data Dictionaries shown below contain a complete listing of the information required by the data sheet for each equipment type.

C. In the copy of the EID spreadsheets provided to the CONTRACTOR the fields marked as “D” in the data dictionary will be filled in by the “Designer” (ENGINEER); and fields marked “OC” will be filled in by “OCSD” (ENGINEER), based on the Project design. The “D” entries shall be confirmed, modified, or extended by the CONTRACTOR based on the equipment actually supplied by the Project. In addition, some EID fields may not be applicable for the particular equipment provided. For example MAX FLOW is one field in the “Instrumentation” EID; but this field will only be filled in when the instrument supports this information.

D. Sample data dictionaries are shown below:

SAMPLE NO DETAIL DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
A	ASSET# STATUS	D	Select entry from drop-down list	NEW — New Equipment or Instrumentation added by “Designer” (ENGINEER) or construction CONTRACTOR during the design or construction of the Project. Indicates new Equipment or Instrumentation procured and installed by the Project. DEMOLISH — Existing Equipment or Instrumentation demolished and removed from OCSD ownership. WAREHOUSE — Equipment or Instrumentation surrendered to OCSD Warehouse for reuse by OCSD. NO CHANGE -- No change to the Asset # of the Equipment or Instrumentation. Examples are when Equipment or Instrumentation is relocated to a different process location; or when Equipment or Instrumentation is removed and replaced in the same process location.
B	LTN STATUS	D	Select entry from drop-down list	ADD — New loop tag number at a new process location added by “Designer” (ENGINEER) or CONTRACTOR. SCRAP — The process location (loop tag number) is eliminated by the Project. Equipment and instruments should have the ASSET # STATUS field marked as DEMOLISH, WAREHOUSE, or NO CHANGE, as appropriate. MODIFY — Loop Tag Number has not changed but the Description has changed. Example: 10BPMP010 stays the same but (PUMP #1, MSP, HDWKS #1) changes to (PUMP, SUMP, UNIT #4, HDWKS #1). NO CHANGE -- No change to the process location of the equipment or instrument.
C	LOC	D	Select entry from drop-down list	The OCSD 3-character location code from the OCSD Tagging Procedures.
D	ASSET #	OC	Request Asset Number from CMMS Support Group	“OCSD” (ENGINEER) to assign asset tag numbers.
E	LOOP	D	Key-in, 6- characters with hyphen	LOOP NUMBER -- This field identifies equipment at the system level. Equipment is grouped together in process related groups. This code is made up of a three character location code (27B), a dash ‘-‘(27B-), and a three digit numeric block number (27B- 040). In the example 27B-040 the loop code refers to the High Flow Pump #2 system located in location 27B (City Water Facility) at Plant 2. The OCSD Engineering Group is responsible for assigning the loop numbers.

SAMPLE NO DETAIL DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
F	LOOP DESC	D	Key-in the loop number description, 0-50 characters	Loop Number Description- is a 50-character field, which identifies the system or process represented by the Loop Number. The Loop Number description field is made of two or more components. The first component is the system or process and the second component is the location of the system or process. The description for the example would be PUMP, HIGH FLOW #1, CITY WATER STATION, P-2.
G	LOOP TAG	D	Key-in, 7-11 characters	LOOP TAG NUMBER -- This field identifies a specific process location within a loop number’s group of assets. The loop tag number uses as its first three characters the location code from the Area / Location code list for the Plants and Pump Stations, i.e. 27BFBK040. The next two to four characters represent the asset’s equipment abbreviation/acronym and are taken from the OCSD's Loop Tag Alpha list for the Electrical, Mechanical and Piping divisions, i.e. 27BFBK040. For the Instrumentation division it is taken from the OCSD's ISA listing. In this example, the FBK stands for Feeder Breaker. The last three digits are the block number of the loop being used, i.e. 27BFBK040. A suffix A thru Z may be present to make the Loop Tag Number unique. Loop Tag Numbers are formed in accordance with the OCSD Tagging Procedure.
H	LOOP TAG DESC	D	Key-in the loop tag number description, 0-50 characters	This is a 50-character field that provides a description of the asset that is represented by the Loop Tag Number. This description field will contain two to three components, the asset generic name same as found in the asset description field which is obtained from the ‘Asset First Word List’, a modifier if needed and the Loop Number Description leaving off the process/facility location description if there is insufficient room to fit. The description for the example would be BREAKER, FEEDER, PUMP, HIGH FLOW #1. The highlighted word FEEDER is the modifier.
I	PHYSICAL LOOP TAG	D	Select entry from drop-down list	This field is used to indicate whether or not there will be a HARD TAG installed in the field. The CONTRACTOR shall provide tags in accordance with the OCSD Tagging Procedure and the Specifications for each Loop Tag Number where this field is marked HARD TAGGED.
J	ASSET DESC	D	Key-in a short description taken from the NOUN LIST and 0-50 characters in length.	See NOUN LIST, column A (ASSET 1ST WORD NOUN) and B (MODIFIER) for the noun/adjective combinations. Contact CMMS Help Desk at ext. 3107 if a new noun is needed.
K	DRAWING DOCU- MENT	D	Key-in the P&ID file name here	Reference to the P&ID file number, 0-50 characters.

Sludge Dewatering and Odor Control at Plant 1 EQUIPMENT AND INSTRUMENT

SAMPLE NO DETAIL DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
L	CRIT MA	D	Select entry from drop-down list	Identify the maintenance criticality for the equipment. See NOUN LIST, column G (M/C) for typical maintenance strategy of c ommon equipment. MCAP=Managed Capital equipment; Capital Asset per Finance definition of $5000.00 or 3 years life. MNCAP=Managed None Capital.
M	CRIT OA	D	Select entry from drop-down list	Identify the criticality of the process. High: (Impact on process is critical or a health and safety hazard. Immediate action is required.) Med: (Impact on process is moderate. Alternate methods are available. Plan and schedule within 48 hours.) Low: (Impact on process is negligible. Plan and schedule within 2 weeks.)
N	IN SERV	D	Select entry from drop-down list	Enter whether or not the Asset is in service. Example: ("Y" for "Yes" or "N" for "No"). Typically all new equipment is in service.
O	DETAIL	XXXXXX XXXXX	Do not enter anything here!	Leave this field blank.
P	MEAN TIME BEFORE FAILURE	C	Key-in the MTBF	Fr om manufacturers specifications in hours. Example: (7,000.00)
Q	MTBF UNITS	C	Select entry from drop-down list	Set all MTBF Units to "HOURS".
R	MAINT STRAT	C	Select entry from drop-down list	Identify the maintenance strategy for the equipment. See NOUN LIST, column F (M/S) for typical maintenance strategy of common equipment. CAL = Calibration, Asset needs to be calibrated on a regular basis, but it does not increase the life of the asset per definition. NSM = No Scheduled Maintenance PD = Predictive Maintenance PM = Preventive Maintenance RTF = Run To Failure
S	EQ TYPE	OC	Entered from a Lookup Table	List of function codes such as PMP, SWI, BKR, etc used to describe the general equipment type.

EQUIPMENT AND INSTRUMENT Sludge Dewatering and Odor Control at Plant 1

SAMPLE NO DETAIL DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
T	EQ TYPE DESCRIP- TION	C	Select entry from drop-down list	List of equipment names such as PUMP, SWITCH, BREAKER, etc used to describe the general equipment type. There are ten (10) User Defined entries to be used by the CONTRACTOR for entering equipment types not found in the drop-down list, however, the CONTRACTOR shall make a request for use of the new equipment type and get written Authorization from “OCSD CMMS Support Group Supervisor or his/her designate” (ENGINEER) before using. CONTRACTOR shall also provide to “OCSD” (ENGINEER) a list of all User Defined entries used and their equivalent in a MS-Word document on or before submitting the EIDs for review.
U	MASTER EQ #	OC	Key-in the master equipment code	Enter the master equipment code related to the Asset if any.
V	EQ CLASS	OC	Entered from a Lookup Table	List of values of EQ CLASS such as AIR, CHEM, ELECT and so on.
W	EQ CLASS DESCRIP- TION	D	Select entry from drop-down list	List of descriptions for EQ CLASS such as "COMPRESSED AIR SYSTEMS", "CHEMICAL SYSTEMS", "ELECTRICAL SYSTEMS" and so on. There are ten (10) User Defined entries to be used by the “Designer” (ENGINEER) for entering equipment class description not found in the drop-down list, however, the “Designer” (ENGINEER) will make a request for use of the new equipment class description and get written Authorization from “OCSD CMMS Support Group Supervisor or his/her designate” (ENGNEER) before using. “Designer” (ENGINEER) will also provide to “OCSD” (ENGINEER) a list of all User Defined entries used and their equivalent in a MS-Word document on or before submitting the EIDs for review.
X	EQ PROCESS	OC	Entered from a Lookup Table	List of values of EQ PROCESS such as INST, FECHL, DISLOW and so on.
Y	EQ PROCESS DESCRIP- TION	D	Select entry from drop-down list	List of descriptions for EQ PROCESS such as "INSTRUMENT AIR EQUIPMENT", "FERRIC/FERROUS CHLORIDE EQUIPMENT", "ELECTRICAL DISTRIBUTION LOW" and so on. There are ten (10) User Defined entries to be used by the “Designer” (ENGINEER) for entering equipment process description not found in the drop-down list, however, the “Designer” (ENGINEER) will make a request for use of the new equipment process description and get written Authorization from “OCSD CMMS Support Group Supervisor or his/her designate” (ENGNEER) before using. “Designer” (ENGINEER) will also provide to “OCSD” (ENGINEER) a list of all User Defined entries used and their equivalent in a MS-Word document on or before submitting the EIDs for review.
Z	MANUF. CODE	OC	Entered from a Lookup Table	List of values of MANUF. CODE such as ABEL, BEC, MOY and so on.

Sludge Dewatering and Odor Control at Plant 1 EQUIPMENT AND INSTRUMENT

SAMPLE NO DETAIL DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
AA	MANUF. NAME	C	Select entry from drop-down list	List of descriptions for MANUF. NAME such as "ABEL PUMPS", "BECKMAN", "MOYNO" and so on. There are ten (10) User Defined entries to be used by the CONTRACTOR for entering manufacturer name not found in the drop-down list, however, the CONTRACTOR shall make a request for use of the new manufacturer name and get written Authorization from “OCSD CMMS Support Group Supervisor or his/her designate” (ENGNEER) before using. CONTRACTOR shall also provide to “OCSD” (ENGINEER) a list of all User Defined entries used and their equivalent along with manufacturer information including but limited to address and phone numbers in an MS-Word document on or before submitting the EIDs for review.
AB	MODEL #	C	Key-in manufacturers model number	T ype in the model number related to the asset up to 30 characters.
AC	SERIAL #	C	Key-in manufacturers serial number	T ype in the serial number related to the asset up to 30 characters.
AD	CAPACITY	C	Key-in the m aximum capacity of the asset	This field is 20 characters maximum.
AE	DEPRE- CIATION METHOD	OC	Select entry from drop-down list	SLSD — STRAIGHT-LINE/STARTUP DATE
AF	PURCHAS E DATE	C	Key-in date asset was purchased	Use MM/DD/YYYY format.
AG	W ARRANT Y DATE	OC	Key-in date the warranty expires	Note this is the date that the asset warranty will expire in the future.
AH	STARTUP DATE	OC	Key-in date the asset was placed in service	Use MM/DD/YYYY format.
AI	PURCHAS E PRICE	C	Key-in CONTRACTOR's cost for the asset, material only	In dollars rounded off to the nearest dollar. Split the lump sum costs for AE/AIT-type configurations.
AJ	LAST CAL DATE	OC	None	Last Calculated Date is entered after all of the Depreciation information has been entered and the Calculate Depreciation button has been clicked.
AK	LIFE EXPEC- TANCY	C	Key-in estimated asset life	Measured in months. See NOUN LIST, column E (LIFE EXP) for typical life expectancy.

EQUIPMENT AND INSTRUMENT Sludge Dewatering and Odor Control at Plant 1

SAMPLE NO DETAIL DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
AL	ACCUMU- LATED DEPRE- CIATION	OC	None	Accumulated Depreciation is calculated after all of the Depreciation information has been entered and the Calculate Depreciation button has been clicked.
A M	SALVAGE VALUE	OC	None	Salvage Value is calculated after all of the Depreciation information has been entered and the Calculate Depreciation button has been clicked.
AN	NET PRESENT VALUE	OC	None	Net Present Value is calculated after all of the Depreciation information has been entered and the Calculate Depreciation button has been clicked.

Sludge Dewatering and Odor Control at Plant 1 EQUIPMENT AND INSTRUMENT

DRIVEN EID DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
ALL “NO DETAIL” DATA IS REQUIRED PLUS THE FOLLOWING:
	Driven Information
AO	ASSET #	OC	None	This is the Asset Number that comes from the Asset Information Screen.
AP	DRIVEN UNIT CODE	C	Select entry f rom drop- down list	Same as FUNCTION CODE (or Asset Type). Example: (PMP = PUMP, CMP = COMPRESSOR and GBX = GEARBOX)
AQ	DRIVEN CAPACITY	C	Key-in 7, 2 Number, xxxxx.xx	Maximum rated capacity of the asset.
AR	CAPACITY UNITS	C	Select entry f rom drop- down list	Units of measure for Capacity. Example: (GPM = Gallons per Minute, GPH = Gallons per Hour, CFM = Cubic Feet per Minute and MGD = Million Gallons per Day)
AS	TOTAL D YNAMIC HEAD	C	Key-in 7, 2 Number, xxxxx.xx	Maximum head under normal full-speed operating conditions.
AT	TOTAL D YNAMIC HEAD UNITS	C	Select entry from drop- down list	Units of measure for TDH. Example: (FT = Feet)
AU	IMPELLER SIZE	C	Key-in 7, 2 Number, xxxxx.xx	Per design Specifications. Example: (10, 12, 15)
AV	IMPELLER UNITS	C	Select entry f rom drop- down list	Units of measure for the impeller size. Example: (INCH = Inches or MM = Millimeters)
AW	TRIM SIZE	C	Key-in 7, 2 Number, xxxxx.xx	The clearance between the wear rings. Example: (0.0500 inches)
AX	TRIM UNITS	C	Select entry f rom drop- down list	Units of measure for Trim Size. Example: (INCH = Inches)
AY	SUCTION SIZE	C	Key-in 7, 2 Number, xxxxx.xx	Nominal size of the suction-side connecting pipe.
AZ	SUCTION SIZE UNITS	C	Select entry f rom drop- down list	Units of measure for the suction size. Example: (INCH = Inches)
BA	DISCHARGE SIZE	C	Key-in 7, 2 Number, xxxxx.xx	Nominal size of the discharge-side connecting pipe.

EQUIPMENT AND INSTRUMENT Sludge Dewatering and Odor Control at Plant 1

DRIVEN EID DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
ALL “NO DETAIL” DATA IS REQUIRED PLUS THE FOLLOWING:
BB	DISCHARGE SIZE UNITS	C	Select entry f rom drop- down list	Units of measure for the discharge size. Example: (INCH = Inches)
BC	BHP REQUIRED	C	Key-in 7, 2 Number, xxxxx.xx	Per design Specifications (Brake Horse Power) to meet the maximum rated capacity.
BD	BHP UNITS	C	Select entry f rom drop- down list	Units of measure for BHP (Brake Horse Power).
BE	DISCHARGE CAPACITY	C	Key-in 7, 2 Number, xxxxx.xx	Maximum discharge capacity after installation design.
BF	DISCHARGE CAP UNITS	C	Select entry f rom drop- down list	Units of measure for discharge capacity. Example: (PSI or GPM)
BG	DRIVEN UNIT HIGH RPM	C	Key-in 6, 1 Number, xxxxx.x	Use the design value for the maximum RPM of the asset.
BH	DRIVEN UNIT LOW RPM	C	Key-in 6, 1 Number, xxxxx.x	Use the design value for the minimum RPM of the asset.
BI	ROTATION	C	Select entry f rom drop- down list	This is the normal direction of rotation of the asset. Example: (CW = Clock Wise or CCW = Counter Clock Wise)
BJ	ROTATION FROM END	C	Select entry f rom drop- down list	Facing the DRIVE end or DRIVEN end. (Example: DRIVE or DRVN)
BK	IMPELLER MATERIAL	C	Select entry f rom drop- down list	Per design Specifications.
BL	WEAR RING MATERIAL	C	Select entry f rom drop- down list	Per design Specifications.
BM	FRONT SEAL	C	Key-in 20- character Front Seal information	Enter the information in this order "Type/Size".
BN	SHAFT SEAL	C	Key-in 20- character Shaft Seal information	Enter the information in this order "Type/Size".

Sludge Dewatering and Odor Control at Plant 1 EQUIPMENT AND INSTRUMENT

DRIVEN EID DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
ALL “NO DETAIL” DATA IS REQUIRED PLUS THE FOLLOWING:
BO	FRONT BEARING	C	Key-in 20- character Front Bearing information	Enter the information in this order "Type/Size".
BP	END SHAFT BEARING	C	Key-in 20- character End Shaft Bearing information	Enter the information in this order "Type/Size".
BQ	AGMA LUBRI- CATION CODE	C	Select entry from drop- down list	Use the AGMA Code supplied by the manufacturer.
BR	FRAME	C	Enter information found on Nameplate	Used to identify the assets Frame.
BS	COUPLING DATA	C	Key-in 2000- character Coupling Data	Enter the information in this order: Manufacturer, Modifier, Size, Type, Lubrication/Marital.

EQUIPMENT AND INSTRUMENT Sludge Dewatering and Odor Control at Plant 1

nameplate. nameplate.

_nameplate.

nameplate. nameplate. nameplate. nameplate. nameplate.

_nameplate.

Sludge Dewatering and Odor Control at Plant 1 EQUIPMENT AND INSTRUMENT

ELECTRICAL EID DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
ALL “NO DETAIL” DATA IS REQUIRED PLUS THE FOLLOWING:
	Electrical Information
AO	ASSET #	OC	Entered from Plant Information Screen Table	Same as Asset # form Plant Information Screen.
AP	MCC NUMBER	OC	None	This is for information only!
AQ	ELECTRI- CAL CODE	OC	VLOOKUP	Look up using ELECTRICAL_DESC_TO_CODE table in EID.
AR	ELECTRI- CAL CODE DESCRIP- TION	C	Select entry from drop- down list	Used to describe the type of electrical asset. Example (TUB, SWITCH, VFD)
AS	BREAKER MANU- FACTURER NAME	C	Enter information found on Breakers Nameplate	Used to identify “Manufacture Name” of Breaker or Fuses in Tub
AT	AMPS	C	Enter information found on Nameplate	Used to identify AMPS information: Example (20.00, 30.00, 60.00, 100.00)
AU	BREAKER VOLTS	C	Enter information found on Nameplate	Used to identify Breaker Volts: Example (240.00, 480.00, 600.00)
AV	CATALOG	C	Enter information found on Nameplate	Used to identify Catalog Number: Example (HFD3060L, FHL36015, 2610D55G06)
AW	STYLE	C	Enter information found on Nameplate	Used to identify Style: Example (FAL TYPE 3 POLE, RACK OUT, M68T1691)
AX	STARTER "MANUFACT URE" "NAME"	C	Enter information found on Starters Nameplate	Used to identify “Manufacture Name” of Starter in Tub

EQUIPMENT AND INSTRUMENT Sludge Dewatering and Odor Control at Plant 1

ELECTRICAL EID DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
ALL “NO DETAIL” DATA IS REQUIRED PLUS THE FOLLOWING:
AY	STARTER SIZE	C	Enter information found on Starters Nameplate	Used to identify Size of Starter in Tub
AZ	VOLTS (High)	C	Enter information found on Nameplate	Used to identify Maximum voltage: Example (110, 220)
BA	VOLTS (Low)	C	Enter information found on Nameplate	Used to identify Minimum voltage: Example (110, 220)
BB	NUMBER OF HEATERS	C	Enter information found on Nameplate	Used to identify number of Heaters: Example (3)
BC	HEATERS TYPE	C	Enter information found on Nameplate	Used to identify the Model Number of the Heaters: Example (W33, AR6.4, AU 44, C8.67A, 1045)
BD	MAX. HP	C	Enter information found on Nameplate	Used to identify Maximum horsepower: Example (10, 25, 100)
BE	COIL NUMBER	C	Enter information found on Nameplate	Used to identify the Coil part number: Example (CB236, 1887-1, 15D21G002)
BF	AUXILIARY CONTACT NUMBERS	C	Enter information found on Nameplate	Used by OCSD to identify the Auxiliary Contact Number: Example (Normally Open, Normally Closed)
BG	SERIES	C	Enter information found on Nameplate	Used to identify the Series: Example (A, A1, B)
BH	SERIES TYPE	C	Enter information found on Nameplate	Used to identify the Series Type: Example (SK6, SX7, SCO3)

Sludge Dewatering and Odor Control at Plant 1 EQUIPMENT AND INSTRUMENT

ELECTRICAL EID DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
ALL “NO DETAIL” DATA IS REQUIRED PLUS THE FOLLOWING:
BI	CONTROL TRANS- FORMER	C	Enter information found on Nameplate	This is the Control Transformers Manufacturer. Example: (SQUARE D, ACME ELECTRIC, JEFFRIES)
BJ	TRANS- FORMER KVA	C	Enter information found on Nameplate	This is the Control Transformer KVA: Example (0.20, 0.50)
BK	TRANS- FORMER FUSE	C	Enter information found on Nameplate	This is the Control Transformers Fuse Type
BL	TRANS- FORMER AMPS	C	Enter information found on Nameplate	This is the Control Transformers AMPS: Example (1.00, 2.00, 3.00)
BM	TRANS- FORMER PART NO	C	Enter information found on Nameplate	This is the Control Transformers Fuse part number: Example (C340CNG, 42-35379)
BN	TRANS- FORMER TYPE	C	Enter information found on Nameplate	This is the Control Transformer Type: Example (Dry)

EQUIPMENT AND INSTRUMENT Sludge Dewatering and Odor Control at Plant 1

INSTRUMENT DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
ALL “NO DETAIL” DATA IS REQUIRED PLUS THE FOLLOWING:
	Instrumentation Information
AO	ASSET #	OC	None	This is the Asset Number that comes from the Asset Information Screen.
AP	INSTRU- MENT CODE	OC	Entered from a Lookup Table	List of descriptions for INSTRUMENT CODE such as ALRM, ANA, DISP and so on.
AQ	INSTRU- MENT CODE DESCRIP- TION	C	Select entry from drop- down list	List of descriptions for INSTRUMENT CODE DESCRIPTION such as "ALARMS, AUDIO-VISUAL AND SOFTWARE", "ANALYZER", "DISPLAY, ELECTRONIC" and so on.
	Instrument Identification Information
AR	PLC ADDRESS	C	Enter as needed	Network address for PLC. (For PLC's only)
AS	CIRCUIT NUMBER	C	Key-in the Breaker number in Branch circuit Panel	Breaker number in Branch circuit Panel that feeds the device.
AT	SINGLE PHASE PANEL ID	C	Key-in the Alpha ID of the branch circuit panel	Alpha ID of the branch circuit panel where breaker is located.
AU	MCC NUMBER	C	Key-in the ID	MCC is the MCC letter ID where the asset is fed from.
AV	INSTR VOLTAGE	C	Key-in the Instrument Voltage	Primary Instrument Voltage.
	Instrument Parameter Information
AW	ISOLATION FUSE NUMBER	C	Key-in the Fuse ID# in fuse block	Fuse ID# in fuse block. (Example: #1, #2, #3 & so on.)
AX	ISOLATION FUSE LOCATION	C	Key-in the Fuse Panel No./Fuse Block No.	Fuse Panel No./Fuse Block No..
AY	DUTY	C	Key-in the Fuse catalog number	Fuse catalog number. (Example: AGC-1, NON-1 and so on.)
AZ	OPERATING RANGE	C	Key-in the Min/Max range	Min/Max of range.

Sludge Dewatering and Odor Control at Plant 1 EQUIPMENT AND INSTRUMENT

INSTRUMENT DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
ALL “NO DETAIL” DATA IS REQUIRED PLUS THE FOLLOWING:
BA	ACCU-RACY	C	Key-in the Percentage of accuracy for the asset	Percentage of accuracy for the asset. (Example: 001.000 = 1%)
	Range & Signal Data
BB	MAX OUTPUT RANGE	C	Key-in the Maximum output signal	Maximum output signal.
BC	SIGNAL OUTPUT	C	Key-in the Signal output T ype	Signal output Type. (Example: Milliamps)
BD	NUMBER OF OUTPUTS	C	Key-in the Number of outputs	Number of outputs.
BE	MAX INPUT RANGE	C	Key-in the Maximum input signal	Maximum input signal.
BF	SIGNAL INPUT	C	Key-in the Signal input T ype	Signal input Type. (Example: Milliamps)
BG	NUMBER OF CHANNELS	C	Key-in the Number of channels	Number of channels.
BH	TOTALIZER FACTOR	C	Key-in the Multiplication of display	Multiplication of display. (Example: X10 or X100)
BI	ENCLOSUR E TYPE	C	Key-in the Enclosure Type	Enclosure Type using "NEMA".
BJ	SENSOR TYPE	C	Key-in the Process variable	Process variable. (Example: Thermal)
	Power & Control Data
BK	PRIMARY POWER	C	Key-in the Voltage used to power the asset	Voltage used to power the asset. (Example: 120)
BL	PRIMARY POWER UNIT	C	Select entry from drop- down list	Voltage unit of measure to power the asset. (Example: AC/DC)

EQUIPMENT AND INSTRUMENT Sludge Dewatering and Odor Control at Plant 1

INSTRUMENT DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
ALL “NO DETAIL” DATA IS REQUIRED PLUS THE FOLLOWING:
BM	RE- FERENCE VOLTS	C	Key-in the Reference Volts supplied by Manufacture	Volts supplied by the Manufacture. (Example: 0480.00)
BN	REFERENC E VOLTS UNIT	C	Select entry f rom drop- down list	Volts unit of measure supplied by the Manufacture. (Example: AC/DC)
BO	CONTROL PANEL NUMBER	C	Key-in the Field Control Panel number	Field Control Panel (FCP) number.
BP	KVA	C	Key-in the KVA of the Asset	KVA of Asset.
BQ	W ATTS	C	Key-in the W attage of the Asset	W attage of Asset.
BR	AMPS	C	Key-in the Amperage of the Asset	Amperage of Asset.
BS	CURRENT TYPE	C	Select entry f rom drop- down list	T ype of Voltage. (AC/DC)
	Process Variable Parameters
BT	PROCESS FLUID	C	Select entry f rom drop- down list	This is the fluid that the instrument is processing. (Use the "Process Material Code List of Values.xls")
BU	PROCESS FLUID UNIT	C	Select entry f rom drop- down list	Unit of measure for PROCESS FLUID. (Example: GPM, GPH, PSI)
BV	METER FACTOR	C	Key-in the Meter Factor	Definition from Name Plate.
BW	OPERA- TING PRESSURE	C	Key-in the numeric value of the operating pressure	This is the numeric value of the operating pressure.
BX	OPERA- TING PRESSURE UNIT	C	Select entry from drop- down list	This is the type of measure of the operating pressure. (Example: PSI)
BY	LINER MATERIAL	C	Key-in the type of Liner Material	Liner for instrument. (Example: Teflon)

Sludge Dewatering and Odor Control at Plant 1 EQUIPMENT AND INSTRUMENT

INSTRUMENT DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
ALL “NO DETAIL” DATA IS REQUIRED PLUS THE FOLLOWING:
BZ	OPERA-- TING TEMP	C	Key-in the Operating Temperature	T emperature the instrument operates at. (Example: 153)
CA	OPERA- TING TEMP UNIT	C	Select entry f rom drop- down list	The unit of measure that the instrument operates at. (Example: F/C)
	Calibration & Recording Data
CB	DEAD BAND (%)	C	Key-in the Dead Band numeric percentage	Dead Band numeric in percentage. (Example: 20%)
CC	CAL FACTOR	C	Key-in the Cal Factor	Numeric value from the Name Plate of the instrument. (Same as "K FACTOR")
CD	K FACTOR	C	Key-in the "K" Factor	Numeric value from the Name Plate of the instrument. (Same as "CAL FACTOR")
CE	CALIBRATIO N SPAN	C	Key-in the Calibration Span	Difference between Min/Max flow.
CF	MAX FLOW	C	Key-in the Maxi-mum flow of the instrument	Maximum flow of the instrument. (100 MGD)
CG	MAX RANGE	C	Key-in the Maximum range of the instrument	Maximum range of the instrument. (0 to 100 PSI)
CH	LINE SIZE	C	Key-in the Line Size	Size of the line that the instrument is connected to. (Example: 02.00)
	PLC information
CI	RACK	C	Key-in the PLC Rack ID	PLC RACK ID.
CJ	SLOT	C	Key-in the PLC Slot ID	PLC SLOT ID.
CK	POINT	C	Key-in the PLC Point ID	PLC POINT ID.

EQUIPMENT AND INSTRUMENT Sludge Dewatering and Odor Control at Plant 1

MECHANICAL EID DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
ALL “NO DETAIL” DATA IS REQUIRED PLUS THE FOLLOWING:
	Mechanical Information
AO	ASSET #	OC	Entered from Plant Information Screen Table	Same as Asset # form Plant Information Screen.
AP	DRIVE SHEAVE	C	Enter information in the order of Size and Type	This is the information for the Drive (Sheave, Coupling or Sprocket).
AQ	DRIVE BUSHING	C	Enter information in the order of Size and Type	This is the information for the Drive Sheaves Bushing only.
AR	DRIVE SHAFT SIZE	C	Enter the Drive Shaft Size	Enter size in Inches. Example: (3.500)
AS	DRIVE BELT	C	Enter the Drive Belt Part Number	Belt number (Standard used by all manufactures).
AT	DRIVE INSERT	C	Enter information in the order of T ype and Size	This is the information for the Drive Insert. Example: (Type/Size)
AU	DRV CHAIN	C	Enter information in the order of T ype and Size	This is the information for the Drive Chain. Example: (Type/Size)
AV	DRV AMOUNT	C	Enter the Drive Belt, Chain or Sprocket amount	This is the number of Belts, Links or Teeth used. Example: (1 - 1000)
AW	DRIVEN SHEAVE	C	Enter information in the order of Size and Type	This is the information for the Driven (Sheave, Coupling or Sprocket).
AX	DRIVEN BUSHING	C	Enter information in the order of Size and Type	This is the information for the Driven Sheaves Bushing only.
ALL “NO DETAIL” DATA IS REQUIRED PLUS THE FOLLOWING:
AY	DRIVEN SHAFT SIZE	C	Enter the Driven Shaft Size	Enter size in Inches. Example: (3.500)
AZ	DRIVEN INSERT	C	Enter information in the order of Type and Size	This is the information for the Driven Insert. Example: (Type/Size)

Sludge Dewatering and Odor Control at Plant 1 EQUIPMENT AND INSTRUMENT

MECHANICAL EID DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
BA	DRVN AMOUNT	C	Enter the Driven Sprocket amount	This is the number of Belts, Links or Teeth used. Example: (1 - 1000)
BB	INPUT RPM	C	Enter the m aximum input of the shaft	This is the Maximum Input of the shaft. Example: (1,788.0)
BC	OUTPUT RPM	C	Enter the m aximum output of the shaft	This is the Maximum Output of the shaft. Example: (6,573.0)
BD	RATIO	C	Enter the ratio of the asset	This is the Ratio used to calculate shaft input to shaft output. Example: (3.67:1)
BE	FRAME	C	Enter information found on Nameplate	Used to identify the assets Frame
BF	ROTATION	C	Select entry from drop-down list	This is the Rotation of the asset when viewing from the front, looking at the shaft. Example: ( CW = Clock Wise and CCW = Counter Clock Wise)
BG	MECH SIZE	C	Enter information found on Nameplate	Nameplate Data if any.
BH	SERVICE FACTOR	C	Enter information found on Nameplate	Used to identify the manufactures’ Service Factor.
BI	C YLIN- DERS	C	Enter the number of cylinders of the asset	This is the number of Cylinders the asset has. Example: (1 - 16)
BJ	HORSE- POWER	C	Enter information found on Nameplate	Used to identify the Horsepower of the asset.
ALL “NO DETAIL” DATA IS REQUIRED PLUS THE FOLLOWING:
BK	LUBRICA- TION	C	Select entry from drop-down list	Use AGMA Lubrication Code standards to identify the lubrication type.
BL	AMOUNT	C	Enter the quantity of lubrication that the asset requires	The amount of Lubricant required indicated in whole numbers. Example (1, 10, 50, 500)
BM	VOLUME	C	Enter the type of measurement for the quantity of lubrication to be used	The measurement type used. Example: (Quarts, Gallons, Cubic inches, Cubic feet or Tube)
BN	PSI	C	Enter information found on Nameplate	This is the Pounds Per Square Inch measured in Static or Range. Example (150 or "25 to 150")

EQUIPMENT AND INSTRUMENT Sludge Dewatering and Odor Control at Plant 1

MECHANICAL EID DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
BO	COM- MENTS	C	Open for use by the “Designer” (ENGINEER), CONTRACTOR or “OCSD” (ENGINEER)	Enter any information determined to be valuable.

Sludge Dewatering and Odor Control at Plant 1 EQUIPMENT AND INSTRUMENT

TRANSFORMER EID DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
ALL “NO DETAIL” DATA IS REQUIRED PLUS THE FOLLOWING:
	T ransformer Information
AO	ASSET #	OC	Entered from Plant Information Screen Table	Same as Asset # form Plant Information Screen.
AP	TRANSFOR MER TYPE	C	Select entry f rom drop-down list	This is the type of Transformer it is. Example: (Dry type or Oil Filled)
AQ	KVA RATING	C	Enter information found on Name Plate	This information can be found on the nameplate of the asset.
AR	PHASE RATING	C	Select entry f rom drop-down list	How many legs for this Transformer. Example: (1 or 3)
AS	IMPEDANCE	C	Enter information found on Name Plate	This is the Ohms. Example: (200.00, 300.00 and so on)
AT	VOLTAGE	C	Enter information found on Name Plate	W hat is the Voltage of the Transformer. Example: (220, 460 and so on)
AU	CONFIGURA TION	C	Select entry f rom drop-down list	Example: (WYE/DELTA, DELTA/WYE, WYE/WYE and DELTA/DELTA)
AV	OIL CAPACITY	C	Enter information found on Name Plate	Quantity indicated by a number. Example: (5, 10, 20 and so on)
AW	OIL CAPACITY UNITS	OC	Entered from a Lookup Table	This is the unit type. Example: (Gal, Qrt and Pnt)
AX	OIL CAPA- CITY UNITS DESCRIP- TION	C	Select entry from drop-down list	This is the unit type description. Example: (Gallons, Quarts and Pints)
AY	OIL TYPE	C	Select entry from drop-down list	This is the type of oil used. Example: (Silicone or Mineral)

EQUIPMENT AND INSTRUMENT Sludge Dewatering and Odor Control at Plant 1

Book Number

VALVE DETAIL DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
ALL “NO DETAIL” DATA IS REQUIRED PLUS THE FOLLOWING:
AO	ASSET #	OC	None	This is the Asset Number that comes from the Asset Information Screen.
AP	VALVE CODE	OC	Entered from a Lookup Table	Valve Type of Asset. Example: (BV = BALL, GV =GATE, BFV = BUTTERFLY)
AQ	VALVE CODE DESCRIP- TION	C	Select entry from drop-down list	Valve Type of Asset. Example: (BALL, GATE, BUTTERFLY)
AR	PART NO	C	Key-in 0-20 character manufacturers part number	Manufactures SKU Number.
AS	CATALOG	C	Key-in 0-20 character manufacturers catalog number	W hen available.
AT	VALVE MATERIAL	C	Select entry f rom drop-down list	Material from which the valve body was cast.
AU	VALVE SIZE	C	Key-in 0-7 character valve size xxxxx.xx	This is the size of the valve indicated in inches, (4.00 equals 4 inches).
AV	VALVE SIZE UNIT	C	Select entry f rom drop-down list	This is the units of measure indicated in inches.
AW	VALVE SEAT MATERIAL	C	Select entry f rom drop-down list	Material from which the valve seat is cast
AX	VALVE MOUNTING	C	Select entry f rom drop-down list	Flange, threaded, etc
AY	PROCESS PRESSURE	C	Key-in 0-8 character normal pressure rating xxxxxx.xx	This is the amount of pressure that the valve is rated for.
AZ	PROCESS PRESSURE UNIT	C	Select entry from drop-down list	This is the units of measure usually indicated in pounds per square inch (PSI).
BA	PROCESS MATERIAL	C	Select entry from drop-down list	This is the type of material that is passing through the valve, (Water, Air, Oil, Sludge, etc.).

EQUIPMENT AND INSTRUMENT Sludge Dewatering and Odor Control at Plant 1

VALVE DETAIL DATA DICTIONARY
COLUMN REF	Field Heading	Provided by D-Designer C-CONTRACTOR OC-OCSD	Action to be T aken	Remarks
ALL “NO DETAIL” DATA IS REQUIRED PLUS THE FOLLOWING:
BB	PACKING TYPE	C	Key-in 0-20 character packing material	This is the type of packing used in the valve.
BC	VOLTAGE	C	Select entry f rom drop-down list	This is the voltage value if the valve is opened and closed using electricity, (120 AC or 480 AC).
BD	OPEN DIRECTION	C	Select entry f rom drop-down list	This is the direction to turn the actuator to open the valve as you face the actuator, ( CW = Clock Wise and CCW = Counter Clock Wise).
BE	TURNS TO CLOSE	C	Key-in 0-8 numeric characters.	This is how many turns it takes to close the valve, (500.50 equals 500 1/2 turns)

E. Below is shown the first few lines (records) of a sample of a “Driven” EID as it might be provided to the CONTRACTOR. It illustrates the type of information that shall be provided in the CONTRACTOR’s submittal. The blank cells (fields) are to be filled in by the CONTRACTOR. The non-blank fields are OCSD-provided data that shall be confirmed by the CONTRACTOR and modified if as-built conditions differ. Shaded columns in the table indicate fields that are entered by “OCSD” (ENGINEER) and that may be hidden in the CONTRACTOR’s copy; even if these fields are shown as blank in the sample, the CONTRACTOR is not to fill out these fields.

_{SAMPLE EID DATA SHEET (DRIVEN)}

SAMPLES FOR THE EQUIPMENT Sludge Dewatering and Odor Control at Plant 1

AND INSTRUMENT DATABASE (EID) Project No. P1-101

Sludge Dewatering and Odor Control at Plant 1 EQUIPMENT AND INSTRUMENT Project No. P1-101 DATABASE (EID) February 2012 01788-29

EQUIPMENT AND INSTRUMENT Sludge Dewatering and Odor Control at Plant 1

DATABASE (EID) Project No. P1-101

F. A sample noun list is shown below. The CONTRACTOR uses the noun list to fill in the predicted equipment life in months (“LIFE EXP”). The noun list tab provides typical values for life expectancy – the CONTRACTOR fills in actual values provided by the manufacturer if they differ from the typical values. Maintenance criticality ( “M/C”) is not filled in by the CONTRACTOR.

S AMPLE NOUN LIST
A SSET 1ST WORD NOUN	M ODIFIER	LIFE EXP	M/S	M/C
AIR-CONDITIONER	PACKAGE	120	PM	MCAP
AIR-CONDITIONER	SPLIT SYSTEM	120	PM	MCAP
AIR-CONDITIONER	W INDOW	60	PM	MNCAP
AIR-CONTROLLER	VAV BOX	60	RTF	MNCAP
(Followed by approximately ten thousand additional entries)