18-2466,_Amendment_No._0004.pdf

AMENDMENT OF SOLICITATION/MODIFICATION OF CONTRACT

Except as provided herein, all terms and conditions of the document referenced in Item 9A or 10A, as heretofore changed, remains unchanged and in full force and effect.

15A. NAME AND TITLE OF SIGNER (Type or print)

30-105-04EXCEPTION TO SF 30

APPROVED BY OIRM 11-84

STANDARD FORM 30 (Rev. 10-83) Prescribed by GSA

FAR (48 CFR) 53.243

FIRE PROTECTION SYSTEMS MAINTENANCE AND REPAIR SERVICES, OAHU, HAWAII

The proposal due date is hereby extended to January 26, 2018, 2:00 PM, HST.

1. CONTRACT ID CODE PAGE OF PAGES

1 2

16A. NAME AND TITLE OF CONTRACTING OFFICER (Type or print)

16C. DATE SIGNED

BY 16-Jan-2018

16B. UNITED STATES OF AMERICA15C. DATE SIGNED15B. CONTRACTOR/OFFEROR

(Signature of Contracting Officer)(Signature of person authorized to sign)

8. NAME AND ADDRESS OF CONTRACTOR (No., Street, County, State and Zip Code) X N6247818R2466

X 9B. DATED (SEE ITEM 11)

15-Dec-2017

10B. DATED (SEE ITEM 13)

9A. AMENDMENT OF SOLICITATION NO.

11. THIS ITEM ONLY APPLIES TO AMENDMENTS OF SOLICITATIONS

X The above numbered solicitation is amended as set forth in Item 14. The hour and date specified for receipt of Offer X is extended, is not extended.

Offer must acknowledge receipt of this amendment prior to the hour and date specified in the solicitation or as amended by one of the following methods:

(a) By completing Items 8 and 15, and returning 1 copies of the amendment; (b) By acknowledging receipt of this amendment on each copy of the offer submitted;

or (c) By separate letter or telegram which includes a reference to the solicitation and amendment numbers. FAILURE OF YOUR ACKNOWLEDGMENT TO BE RECEIVED AT THE PLACE DESIGNATED FOR THE RECEIPT OF OFFERS PRIOR TO THE HOUR AND DATE SPECIFIED MAY RESULT IN

REJECTION OF YOUR OFFER. If by virtue of this amendment you desire to change an offer already submitted, such change may be made by telegram or letter, provided each telegram or letter makes reference to the solicitation and this amendment, and is received prior to the opening hour and date specified.

12. ACCOUNTING AND APPROPRIATION DATA (If required)

13. THIS ITEM APPLIES ONLY TO MODIFICATIONS OF CONTRACTS/ORDERS.

IT MODIFIES THE CONTRACT/ORDER NO. AS DESCRIBED IN ITEM 14.

A. THIS CHANGE ORDER IS ISSUED PURSUANT TO: (Specify authority) THE CHANGES SET FORTH IN ITEM 14 ARE MADE IN THE

CONTRACT ORDER NO. IN ITEM 10A.

B. THE ABOVE NUMBERED CONTRACT/ORDER IS MODIFIED TO REFLECT THE ADMINISTRATIVE CHANGES (such as changes in paying office, appropriation date, etc.) SET FORTH IN ITEM 14, PURSUANT TO THE AUTHORITY OF FAR 43.103(B).

C. THIS SUPPLEMENTAL AGREEMENT IS ENTERED INTO PURSUANT TO AUTHORITY OF:

D. OTHER (Specify type of modification and authority)

E. IMPORTANT: Contractor is not, is required to sign this document and return copies to the issuing office.

14. DESCRIPTION OF AMENDMENT/MODIFICATION (Organized by UCF section headings, including solicitation/contract subject matter where feasible.)

10A. MOD. OF CONTRACT/ORDER NO.

2. AMENDMENT/MODIFICATION NO. 5. PROJECT NO.(If applicable)

6. ISSUED BY

3. EFFECTIVE DATE

16-Jan-2018

CODE

NAVFAC HAWAII

SERVICES ACQUISITION DIVISION (PRJ233)

400 MARSHALL ROAD

JBPHH HI 96860-3139

N62478 7. ADMINISTERED BY (If other than item 6)

4. REQUISITION/PURCHASE REQ. NO.

CODE

See Item 6

FACILITY CODECODE

EMAIL:TEL:

N6247818R2466

SECTION SF 30 BLOCK 14 CONTINUATION PAGE

The following items are applicable to this modification:

SUMMARY OF CHANGES (REVISED)

SECTION C

Annex 0200000 – Replace Pages 8, 9, and 15 with the attached Pages 8, 9, and 15 (Amendment No. 0004).

SECTION F

Attachment F-1 – Replace Pages 1 and 10 with the attached Pages 1 and 10 (Amendment No. 0004).

SECTION J

Table of Contents – Replace Page 1 (Amendment No. 0002) with the attached Page 1 (Amendment No.

0004).

Attachment J-0200000-06 – Replace Pages 1 and 2 with the attached Pages 1 through 4 (Amendment No.

Attachment J-0200000-07 – Replace Pages 1 and 2 with the attached Pages 1 through 3 (Amendment No.

Attachment J-0200000-08 – Replace Pages 1 and 2 with the attached Pages 1 through 4 (Amendment No.

Attachment J-0200000-09 – Replace Pages 1 through 3 with the attached Pages 1 through 4 (Amendment No. 0004).

Attachment J-0200000-18 – Insert Pages 1 through 3 (Amendment No. 0004).

(End of Summary of Changes)

14-18-2466

0200000, Page 8 of 31 (Amendment No. 0004)

0200000 - Management and Administration

Spec Item Title Description

Section F. The Contractor shall submit accurate and complete documents within the required timeframes as specified in Section F.

Government acceptance of deliverables will not relieve the Contractor of the responsibility for any error or omission which may exist in the deliverable, as the Contractor is responsible for all requirements of this contract.

The Contractor shall establish and maintain a secure website for posting an electronic copy of all deliverables listed in Section F. The Contractor shall allow only authorized Government and Contractor personnel to access the website. Government personnel access shall be limited to viewing and downloading of deliverables, but restricted from posting to the website. The Contractor shall notify the Government by email whenever there are new or updated deliverables posted to the website.

Each deliverable posting on the website and each email notification shall include the title of the deliverable, the spec item requiring the deliverable, and the date and time the deliverable was posted. All deliverables shall be available to authorized Government personnel 24 hours/day and 365 days/year for the duration of the contract.

2.6.5 Service Interruptions If any utilities or other services must be discontinued (even temporarily) due to scheduled contract work, the Contractor shall submit a Service

Interruption Notification to the KO, affected tenants, and customers per

Section F. If the discontinued service is due to an emergency breakdown the Contractor shall notify the KO, affected tenants and customers as soon as practicable.

2.6.6 NAVFAC MAXIMO MAXIMO is the Computerized Maintenance Management System

(CMMS) used by the Government for work order history, asset management, and condition assessment. The Contractor shall provide all required data for NAVFAC MAXIMO as identified below:

2.6.6.1 MAXIMO Data Required data fields for work orders are indicated in the Asset Information provided in J-0200000-06. Asset Specification requirements are indicated in J-0200000-07. Required data for documenting condition assessments is indicated in the Characteristic Meter Reading Information provided in J-0200000-08. Service Provider Information is indicated in J-0200000-09. Specified data shall be provided for all work performed in 1502000 Facility Investment. Further instructional information detailing the process for submitting the specified information for NAVFAC MAXIMO Data Reporting is provided in J-0200000-18. The Asset Information, Asset Specification, and Characteristic Meter Reading Interfaces are used in multiple processes for loading data into MAXIMO by the Government and the format may be updated periodically.

As part of the update the Contractor may be asked to modify the file to add/move columns in their submission. The Contractor also shall provide up to 10 extra data elements or columns with as many as 150 characters per element for the Government to define during contract performance at no additional cost to the Government. The Government will provide the

Contractor 60 calendar day notice of modifications to the Service

Provider, Asset, Specification, or Characteristic Meter Reading Interfaces file format.

2.6.6.2 MAXIMO Method of

Data Entry

The Contractor shall provide data for NAVFAC MAXIMO using the methods detailed below if access to MAXIMO is not available:

0200000, Page 9 of 31 (Amendment No. 0004)

0200000 - Management and Administration

Spec Item Title Description

The Contractor shall submit asset data in spreadsheet form or in a Pipe Delimited Flat File following the NAVFAC MAXIMO Data Reporting process described in J-0200000-18 per Section F.

2.6.7 Quality Management

System (QMS)

The Contractor shall establish and maintain a complete QMS program in accordance with the provisions specified herein. The Contractor’s QMS program shall provide an effective and efficient means of identifying and correcting problems throughout the entire scope of operations. The

Contractor's QMS program shall address:

Accurate documentation of work processes, procedures, and output measures.

A systematic procedure for assessing compliance with performance objectives and standards.

Accurate documentation of quality inspections and surveillance conducted throughout the execution of work.

Assessment-driven corrective actions and process adjustments as appropriate in a timely manner.

2.6.7.1 Quality Management

(QM) Plan

The Contractor shall develop and submit a QM Plan per Section F. The

QM Plan shall describe the QMS methodology and approaches used under this contract. If any changes are made during the period of performance, submit to the KO a revised QM Plan for acceptance.

The Contractor’s QM Plan shall include, at a minimum, the following:

• Policy and objectives of Quality Management System (QMS)

• Quality organization o List of personnel o Responsibilities & lines of authority o Training and qualifications

• Approach to assuring quality of services provided and conformance with performance objectives and standards

• Methods and procedures for effective planning, operation and control of processes and performance of work

• Procedures for inspection and surveillance of services o Scheduling and performance of inspection and surveillance o Measurement, data collection and analysis o Corrective action, preventive action, and continuous improvement o Oversight of subcontracted work

• Documentation and records management

• Communication with government (customers)

2.6.7.2 Quality Inspection and

Surveillance

The Contractor shall establish and maintain an inspection and surveillance system in accordance with the FAR Clause 52.246-4, INSPECTION OF

SERVICES – FIXED PRICE, to ensure that the work performed conforms to the contract requirements. The Contractor shall document and maintain a file of all scheduled and performed inspections and surveillances, inspection and surveillance results, and dates and details of corrective and preventive actions. The quality inspection and surveillance file shall be the property of the Government and made available during the

Government’s regular working hours. The file shall be turned over to the

KO within five calendar days of termination of the contract.

2.6.7.3 Quality Inspection and

Surveillance Report

The Contractor shall submit a copy of the Contractor Quality Inspection and Surveillance Report per Section F. The Contractor Quality

0200000, Page 15 of 31 (Amendment No. 0004)

0200000 - Management and Administration

Spec Item Title Description

Government estimates the wait period can be up to 15 minutes. The

Contractor shall notify the Government Performance Assessment

Representative (PAR) and appropriate point of contract if an escort is not available after 15 minutes and access to accomplish the work is denied.

Unscheduled requirements, e.g., trouble calls, may require a longer wait for an escort. A list of facilities that may require a building escort is listed in J-0200000-17.

2.8.7 Security Clearances The Contractor shall obtain all required corporate and personnel Security

Clearances prior to commencement of work. The Contractor shall ensure that a list of all personnel with Security Clearances is maintained current, including clearances that are pending.

2.8.8 Access to Sensitive

Unclassified

Information

The Contractor personnel whose work involves access to sensitive unclassified information shall undergo a National Agency Check

Investigation (NACI) to verify their suitability. If the Contractor personnel currently have a favorably adjudicated NACI the Contractor shall notify the Government Command Security Manager who will validate this in the Joint Personnel Adjudication System (JPAS).

The Contractor shall request from the Government for access to the E-QIP

Direct program for the Contractor employees to complete the SF-85 form on line for an NACI. The Security Manager will determine suitability.

Upon a favorable NACI, the Contractor personnel shall provide the completed Personnel Security Investigation (PSI) to the Security Manager along with the original signed release statements, applicant fingerprint card (FD87), and an OF-306 Declaration for Federal Employment per

Section F. The Contractor shall be responsible for providing the fingerprint card.

The request shall be renewed annually or for the duration of the contract if less than one year.

2.8.9 Employee Status The Contractor shall notify the KO of any changes to any employee’s status to include, but not limited to, termination, convictions/arrests, adverse actions taken on the job for any reason or any other documented misbehavior that may affect, or have the potential to affect, security standing in terms of access to federal facilities or IT systems.

2.9 Contractor Safety

Program

The Contractor shall develop and implement a Safety Program detailing how the Contractor plans, staffs, performs, and controls all safety practices while delivering best value services to the Government without any accidents or mishaps. The Contractor’s safety program shall comply with all safety standards identified in the U.S. Army Corps of Engineers Safety and Health Requirements Manual, EM 385-1-1 and Public Law 91-596, Occupational Safety and Health Act.

Any reference to “USACE" facilities, property, or equipment specified in

EM 385-1-1 should be interpreted as Government facilities, property, and equipment.

2.9.1 Accident Prevention

Plan (APP)

The Contractor shall develop and implement a site Accident Prevention

Plan (APP). The APP shall be prepared by the Contractor’s SSHO and shall be followed by all Contractor employees, subcontractors, and vendors at each service site.

The APP shall follow the format and include all elements addressed in

Appendix A of EM 385-1-1. The APP shall incorporate Activity Hazard

ATTACHMENT F-1

DELIVERABLES

Annex/ Spec Item

Form Attachment

Number Deliverable

Title Date (s) of Submission

Distribution

Frequency Original

Copies (including original)

0200000/ 2.3.4

N/A Permits and Licenses

No later than five calendar days prior to commencing work and as requested by

KO

KO 1 As required

0200000/ 2.3.5

N/A Certificate of Insurance

Within 15 calendar days after contract award and as subsequent changes occur

KO 1 Initial report:

Once

Subsequent reports: Once per change 0200000/

2.6.2 N/A Verbal

Scheduling & Work Status Report

Within two hours of the inquiry by KO during regular working hours, and by 0800 the following workday for inquiries after regular working hours

KO 1 As required

0200000/ 2.6.5

N/A Service Interruption Notification

Minimum of 14 calendar days prior to the scheduled outage

KO 1 Once per outage

0200000/ 2.6.6.2

J-0200000-

NAVFAC

MAXIMO

Data Report

Within 5 calendar days after end of month

KO 1 As required

0200000/ 2.6.7.1

N/A Quality Management (QM) Plan

Within 15 calendar days after contract award and within seven calendar days of any change during period of performance

KO 1 Initial Plan:

Once

Subsequent plans: Once per change

0200000/ 2.6.7.3

N/A Quality Inspection and Surveillance Report

Within five calendar days after end of quarter

KO 1 Quarterly

0200000/ 2.7.1

N/A List of Key Personnel and Qualifications

Within 15 calendar days after contract award

Subsequent reports: within seven calendar days of any change

KO and

COR

1 Initial report:

Once

Subsequent reports: Once per change

0200000/ 2.7.1

N/A Organizational Chart

Initial report: Within 15 calendar days after contract award

Subsequent reports: Within seven calendar days of any change

KO and

COR

1 Initial report:

once

Subsequent reports: Once per change

0200000/ 2.8.1

N/A Employee List Initially within 15 calendar days after contract award and subsequently within

KO 1 Initial report:

Once

ATTACHMENT F-1, Page 1 of 47 (Amendment No. 0004)

Deliverables Form Preparation Instructions

Deliverable Title: 0200000/2.6.6.2 – Maximo Method of Data Entry

Form Attachment No.: J-0200000-18

Government Acceptance Required: _ X__ Yes __ No

Media: ___ Hard Copy X Electronic ___ Direct System Input

Instructions:

1. The plan shall be prepared using Microsoft Office software.

2. The Contractor shall submit asset data in a Spreadsheet format or a Pipe Delimited Flat File following the NAVFAC MAXIMO Data Reporting process described in J-0200000-18.

3. Submit to COR and Mr. Joel Pai at email < joel.pai@navy.mil >.

ATTACHMENT F-1, Page 10 of 47 (Amendment No. 0004)

SECTION J

DOCUMENTS, EXHIBITS, AND OTHER ATTACHMENTS

TABLE OF CONTENTS

ATTACHMENT

NUMBER ATTACHMENT TITLE

J-0200000-01 Definitions and Acronyms J-0200000-02 Wage Determinations J-0200000-03 References and Technical Documents J-0200000-04 Sample Invoice Form J-0200000-05 NAVFAC Contractor Incident Reporting System (CIRS) J-0200000-06 MAXIMO Asset Information J-0200000-07 MAXIMO Asset Specification J-0200000-08 MAXIMO Characteristic Meter Reading Information J-0200000-09 MAXIMO Service Provider Information J-0200000-10 Security Requirements Applicable For The Fleet Logistics Center, Pearl Harbor Fuel Complex J-0200000-11 Reserved J-0200000-12 Exhibit Line Item Numbers, Base Period J-0200000-13 Exhibit Line Item Numbers, Option Period One J-0200000-14 Exhibit Line Item Numbers, Option Period Two J-0200000-15 Exhibit Line Item Numbers, Option Period Three J-0200000-16 Exhibit Line Item Numbers, Option Period Four J-0200000-17 Special/Secure Access Locations J-0200000-18 NAVFAC MAXIMO Data Reporting J-1502000-01 Site Maps J-1502000-02 Fleet Logistics Center Description of Fire Protection and Alarm Systems J-1502000-03 Reserved J-1502000-04 Fleet Logistics Center Inspection, Testing and Preventive Maintenance Schedule J-1502000-05 MCBH Fire Alarm Systems J-1502000-06 Reserved J-1502000-07 Reserved J-1502000-08 MCBH Fire Sprinkler Systems J-1502000-09 MCBH Inspection, Testing & Maintenance Form J-1502000-10 Testing & Inspecting MATOC 3 & 4 Flight Simulator J-1502000-11 Kitchen Fire Suppression Systems & Equipment J-1502000-12 Testing & Inspecting Kitchen Fire Suppression System J-1502000-13 Historical Service Order Workload J-1502000-14 Facilities and Equipment Summary Table

Section J – TOC, Page 1 of 1 (Amendment No. 0004)

Interface: Service Provider

VERSION #: V1

Current as of: 7/7/2013

Version History V1 - Updated to reflect current interface in MAXIMO

TABS

1-Service Provider Info This Sheet 2-Service Provider Field List Service Provider Template Data

Format Information 3-Service Provider - Template Sample Excel Format

ATTACHMENT J-0200000-06

MAXIMO ASSET INFORMATION

J-0200000-06, Page 1 of 4 (Amendment No. 0004)

Interface: Asset File

VERSION #:V1

Current as of: 7 July 2013

Position Name Required Length Limit Data Format Note Content Notes MAXIMO Field Name

1 AssetNum Y 25 ASSETNUM

2 Changed Date N MM/DD/YYYY CHANGEDATE

3 Description Y 100 DESCRIPTION

4 Long Description N 1,000 LONGDESCRIPTION

5 Master System Y Must match Value List in

Maximo

Value list in REFERENCE SPREADSHEET.

POSITIONs 5,6,and 7 should not only be on the value list but be related in the UNIFORMAT Hierarchy: D30, D3010, D3010100 etc…

MASTERSYSTEM

6 System Y Must match Value List in

Maximo

Value list in REFERENCE SPREADSHEET.

POSITIONs 5,6,and 7 should not only be on the value list but be related in the UNIFORMAT Hierarchy: D30, D3010, D3010100 etc…

SYSTEM

7 Sub-System Y Must match Value List in

Maximo

Value list in REFERENCE SPREADSHEET.

POSITIONs 5,6,and 7 should not only be on the value list but be related in the UNIFORMAT Hierarchy: D30, D3010, D3010100 etc…

SUBSYSTEM

8 Location Y Must match Value List in

Maximo Value list in REFERENCE SPREADSHEET LOCATION

9 Site ID Y Must match Value List in

Maximo Value list in REFERENCE SPREADSHEET -or- For this contract only: XXXXX

SITEID

10 Work Center (Person Group) Y Must match Value List in

Maximo

Value list in REFERENCE SPREADSHEET -or- For this contract:

- use the following identifier "XXXX"

PERSONGROUP

11 Asset Type Y Must match Value List in

Maximo Value list in REFERENCE SPREADSHEET ASSETTYPE

12 Asset Quantity N Integer QUANTITY

13 Inventory Category Y Must match Value List in

Maximo Value list in REFERENCE SPREADSHEET INVENTORYCATEGORY

14 Purchase Price N Integer PURCHASEPRICE

15 Budgeted Cost N Integer BUDGETCOST

16 Replacement Cost Y Integer REPLACECOST

17 Meter Group N Must match Value List in

Maximo Value list in REFERENCE SPREADSHEET GROUPNAME

18 Belongs To (Parent) N Must match an existing ASSETNUM in Maximo.

Asset Number of Parent. The asset and its parent can't be created in the same file

PARENT

19 Contract Number N 25 Appended to

LONGDESCRIPTION

J-0200000-06, Page 2 of 4 (Amendment No. 0004)

Interface: Asset File

VERSION #:V1

Current as of: 7 July 2013

Position Name Required Length Limit Data Format Note Content Notes MAXIMO Field Name

20 Task/Delivery Order Number N 25 Appended to

LONGDESCRIPTION

21 Drawing Reference ID N 25 Appended to

LONGDESCRIPTION

22 Warranty Expiration Date N MM/DD/YYYY Appended to

LONGDESCRIPTION

23 Status Date N LEAVE BLANK Leave blank/Do Not Use STATUSDATE

24 Installation Date Y MM/DD/YYYY INSTALLDATE

25 Asset Status N Must match Value List in

Maximo

Value list in REFERENCE SPREADSHEET -or- "Operating" for NEW and "Decommissioned or DEA" for removed equipment

STATUS

26 CLASSSTRUCTUREID N

Must match Value List in

Maximo Value list in REFERENCE SPREADSHEET CLASSSTRUCTUREID

27 Job Plan Code N 25 Appended to

LONGDESCRIPTION

28 Equipment Tag Number N 25 Appended to

LONGDESCRIPTION

29 Additional Loc Info N 250 ADDLOCINFO

30 Manufacturer N Must match Value List in

Maximo Value list in REFERENCE SPREADSHEET MANUFACTURER

31 Model N 25 MODEL

32 Serial # N 25 SERIALNUM

J-0200000-06, Page 3 of 4 (Amendment No. 0004)

Interface: Service Provider

VERSION #: V1

Current as of: 7/7/2013

Position 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

Name Approved

Date Work Type

Customer Reference

Number Description Location

Reported By

Master System

Status Status Date

Priority Actual Start

Actual Finish

Supervisor Labor Hours

(Actual)

Labor Cost (Actual)

Material Cost

(Actual) Duration Asset

Required Field(s) N Y Y Y Y N N Y Y Y N N N Y Y Y N N

NOTES:

• ONLY COLUMNs 1-35, and rows containing data should be be included in the FLAT-FILE SUBMISSION;

• Pipe Delimited (.txt) - | (Pipe is at the end of the column. Must have 35 PIPEs per row.)

Position

Name

Required Field(s)

19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35

Target Finish

Target Start Reported

Date Lead

Sched uled Start

Scheduled Finish

Modifie d Date

Modified By

PMNEXTD

UEDATE

Is Task?

Parent

WO

Work Order

Detail Location

CLIN

Customer Ref Code

Sub Work Type

Work Center

N N Y N N N Y Y N Y N N N N N N N

J-0200000-06, Page 4 of 4 (Amendment No. 0004)

J-0200000-07, Page 1 of 3 (Amendment No. 0004)

Interface: Asset Specification VERSION #: v1 Current as of: 17 May 2012

Version History v1 - Updated to reflect current interface in MAXIMO

TABS

1-Asset Specification Info This Sheet 2-Asset Specification Field List Asset Specification Template Data Format Information 3-Asset Specification - Template

ATTACHMENT J-0200000-07

MAXIMO ASSET SPECIFICATION

Sample Excel Format & Sample of file after exporting to a "|" delimited

J-0200000-07, Page 2 of 3 (Amendment No. 0004)

Interface: Asset Specification VERSION #: v1 Current as of: 17 May 2012

Position Name Required Length Limit

Field Definition Content Notes

NAVFAC

MAXIMO_FIELD

(ASSETSPEC.)

1 Asset Y 25 Asset identification number. Must match an existing value in Maximo.

ASSETNUM

2 SITEID Y 8 FEC ID. Must match existing value list If all work is done at a single FEC, recommend the correct SITEID be provided in the templay.

ASSETATTRID

3 CLASSSTRUCTUREID Y 20

Key Value used in Maximo to identify the speciificaiton/attribute record. Value is not shown on the front end (visable to a user).

Must match existing value in Maximo (example data a "1616" is an Electric Meter)

CLASSSTRUCTUREID

4 Attribute Y 300 Attribute Name (example data - the PTRATIO is attribute being set)

ASSETATTRID

5 Numeric Value N 40

Specification value with numeric value only.-only one value can be pased Numeric or AlphaNumeric; must match domain list if one exists.

NUMVALUE

6 Alphanumeric N 254

Specitication value with mixed (alpha and numeric) content. Only one value can be pased Numeric or AlphaNumeric; must match domain list if one exists.

ALNVALUE

7 Unit of Measure N 8 must match domain MEASUREUNITID

N/A Changed By Value is inserted by the System User that is running the interface

Values are not incluled in the template, information provided to explain the source of the the value created by Maximo.

CHANGEBY

N/A Change Date System Date Values are not incluled in the template, information provided to explain the source of the the value created by Maximo.

CHANGEDATE

J-0200000-07, Page 3 of 3 (Amendment No. 0004)

Interface: Asset Specification VERSION #: v1 Current as of: 17 May 2012

Position 1 2 3 4 5 6 7

Name Asset SITE ID

CLASS

STRUCTURE ID

Attribute Numeric Value Alphanumeric Unit of Measure

Required Field(s)

Y Y Y Y N N N

NOTES:

• ONLY POSITION/COLUMN 1-7, and rows containing data should be be included in the FLAT-FILE SUBMISSION;

• Pipe Delimited (.txt) - | (Pipe is at the end of the column. Must have 7 PIPEs per row.)

• If the column to the right of the last column is selected when saving (what would be the 8th position) this will provide the 7th PIPE

Interface: Characteristic Meter Reading VERSION #: v2 Current as of: 30 Sept 2016

Version History v1 - Updated to reflect current interface in MAXIMO (December 12, 2012) v2 - Updated to relect Utilities (DI) values only range from 1 to 5, not 10 (Sept 30, 2016)

TABS

1-Characteristic Meter Reading Info This Sheet

2-Characteristic Meter Reading Field List Characteristic Meter Reading Template Data Format Information

3-Characteristic Meter Reading - Template Sample Excel Format 4-Observation Values Valid Observation values as of 9/2016

ATTACHMENT J-0200000-08

MAXIMO CHARACTERISTIC METER READING INFORMATION

J-0200000-08, Page 1 of 4 (Amendment No. 0004)

Current as of: 30 Sept 2016

Position Name Required Length Limit

Data Format Note

Field Definition Content Notes

NAVFAC

MAXIMO_FIELD

(MEASUMENT /

ASSETMETER)

See Note Below

1 Site Y 8 UPPER Must match Value List in Maximo Value list in REFERENCE SPREADSHEET -or- For this contract only: XXXXX

SITEID / SITEID

2 Asset Y 25

Must match an existing

ASSETNUM in Maximo

The asset number used must exist in NAVFAC MAXIMO prior to submission, or the record will be rejected.

Value list in REFERENCE SPREADSHEET

ASSETNUM / ASSETNUM

3 Meter Y 15 UPPER The value listed in the third position must be an existing, valid Maximo

DCR or UCR meter.

Value must match existing value in Maximo. list in

REFERENCE SPREADSHEET

METER NAME /

METER NAME

4 Observation Y 254 ALN Last Reading/Observation value.

Must be a valid value in MAXIMO

Value must match existing value in Maximo list.

Current value list included on Tab 4 - Observation Values

OBSERVATION /

LASTREADING

5 Measurement Date Y 10

MM/DD/YYYY

hh:mm:ss Date Observation was recorded

MEASUREDATE /

LASTREADINGDATE

6 Inspector Y 30 Must match Value List in

Maximo

Identifies the person reporting the observation

Value list in REFERENCE SPREADSHEET -or- For this contract:

- use the following identifier "XXXX"

INSPECTOR /

LASTREADINGINSPCTR

NOTE (NAVFAC MAXIMO/FIELD):

The observation information is filed in one of two locations. If the observation is the MOST CURRENT reading (by Measurement Date) - it is filed in the MEASUREMENT Table. If the data when received is not the most current, it is filed in the ASSETMETER Table. The filing location is irrelevant to the inteface use, but this information is provided to prevent confusion when reviewing the data in Maximo.

When reviewing the data in Maximo (after processing) - If the meter reading being imported is newer than the last reading applied to the Assets record, a new meter reading entry will also be added

J-0200000-08, Page 2 of 4 (Amendment No. 0004)

Current as of: 30 Sept 2016

Position 1 2 3 4 5 6

Name Site Asset Meter Observation Measurement

Date Inspector

Required Field(s) Y Y Y Y Y Y

NOTES:

• ONLY POSITIONs 1-6, and rows containing data should be be included in the FLAT-FILE SUBMISSION;

• Pipe Delimited (.txt) - | (Pipe is at the end of the column. Must have 7 PIPEs per row. Last PIPE indicates end of line (EOL))

J-0200000-08, Page 3 of 4 (Amendment No. 0004)

Current as of: 30 Sept 2016

FACILITIES (DCR):

A (Amber) A+ (Amber Plus) A- (Amber Minus) G (Green) G+ (Green Plus) G- (Green Minus) R (Red) R+ (Red Plus) R- (Red Minus)

UTILITIES (UCR):

1 (Best/Highest CI Ranking) 5 (Worst/Lowest CI Ranking)

OBSERVATION VALUES

J-0200000-08, Page 4 of 4 (Amendment No. 0004)

J-0200000-09, Page 1 of 4 (Amendment No. 0004)

Interface: Service Provider

VERSION #: V1

Current as of: 7/7/2013

Version History V1 - Updated to reflect current interface in MAXIMO

TABS

1-Service Provider Info This Sheet 2-Service Provider Field List Service Provider Template Data

Format Information 3-Service Provider - Template Sample Excel Format

ATTACHMENT J-0200000-09

MAXIMO SERVICE PROVIDER INFORMATION

J-0200000-09, Page 2 of 4 (Amendment No. 0004)

Interface: Service Provider

VERSION #: V1

Current as of: 7/7/2013 Service Provider (BOSC1) is a pipe delimited file.

Position Name Required Length Limit

Data Format Note Field Definition Content Notes NAVFAC

MAXIMO_FIELD

1 Approved Date N 10 MM/DD/YYYY hh:mm:ss

The Date on which the Work Order was last approved. If the file contains an Approved Date, then this date will be pulled over to the record.

If the Approved Date in the file is null, then the Reported Date plus one minute will be displayed in the record.

APPROVEDDATE

2 Work Type Y 15 Must match Value List in Maximo.

(Cross-walked field.).

Must match Crosswalk

Identifies the work order's type.

Example types are: preventive maintenance, corrective maintenance, emergency maintenance, capital project, and event report.

Value list in REFERENCE SPREADSHEET -or- For this contract the following are valid work types:

CLIN XXXXXX use "XXXX"

WORKTYPE

Customer Reference Number

Y 10

Contractors internal work order tracking number.

Will update Record if Value is found in Maximo otherwise new record (Work order) will be created.

SERVPRVREFCODE

4 Description Y 150 Describes the work order.

If the Description is null, in the inbound file, then this field is defaulted to CROSSWALK value.

DESCRIPTION

5 Location Y 30 Must match Value List in Maximo

Identifies the work order's location. This is not necessarily the asset's location, however, if an asset is entered, its location will default here.

- If the Location is null, in the inbound file, then this field is defaulted to the site's base location.

Value list in REFERENCE SPREADSHEET LOCATION

6 Reported By N 62 Must match Value List in Maximo

Identifies the person reporting the work order.

Value list in REFERENCE SPREADSHEET -or- For this contract:

- use the following identifier "XXXX"

REPORTEDBY

7 Master System N N/A Not used N/A

8 Status Y 16 (Cross-walked field.)

Must match Crosswalk

Status of the work order, for example, in progress, waiting on material, waiting for approval, completed, or closed.

Value list in REFERENCE SPREADSHEET -or- For this contract:

- use the following identifier "XXXX"

STATUS

9 Status Date Y 10 MM/DD/YYYY hh:mm:ss STATUSDATE

10 Priority Y 12 (Cross-walked field.)

Must match Crosswalk

Identifies the importance of the work order, from 0-999, where 0 is the lowest priority and 999 is the highest. If the Priority is null, in the inbound file, then this field is defaulted.

Value list in REFERENCE SPREADSHEET WOPRIORITY

11 Actual Start N 10 MM/DD/YYYY hh:mm:ss ACTSTART

12 Actual Finish N 10 MM/DD/YYYY hh:mm:ss ACTFINISH

13 Supervisor N 30 Must match Value List in Maximo

Value list in REFERENCE SPREADSHEET -or- For this contract:

- use the following identifier "XXXX"

SUPERVISOR

14 Labor Hours(Actual) Y 8 Number (2 decimal places) ACTLABHRS

15 Labor Cost(Actual) Y 10 Number (2 decimal places) ACTLABCOST

J-0200000-09, Page 3 of 4 (Amendment No. 0004)

Interface: Service Provider

VERSION #: V1

Current as of: 7/7/2013 Service Provider (BOSC1) is a pipe delimited file.

Position Name Required Length Limit

Data Format Note Field Definition Content Notes

NAVFAC

MAXIMO_FIELD

16 Material Cost(Actual) Y 10 Number (2 decimal places) ACTMATCOST

17 Duration N 8 Number (2 decimal places) Estimated remaining number of hours needed to complete the work.

ESTDUR

18 Asset N 25 Must match an existing ASSETNUM in Maximo

The asset number used must exist in NAVFAC MAXIMO prior to submission, or the record will be rejected.

Value list in REFERENCE SPREADSHEET

ASSETNUM

19 Target Finish N 10 MM/DD/YYYY hh:mm:ss TARGCOMPDATE

20 Target Start N 10 MM/DD/YYYY hh:mm:ss TARGSTARTDATE

21 Reported Date Y 10 MM/DD/YYYY hh:mm:ss REPORTDATE

22 Lead N 30 Must match Value List in Maximo

Lead person responsible for the work. Value list in REFERENCE SPREADSHEET LEAD

23 Scheduled Start N 10 MM/DD/YYYY hh:mm:ss SCHEDSTART

24 Scheduled Finish N 10 MM/DD/YYYY hh:mm:ss SCHEDFINISH

25 Modified Date Y 10 LEAVE BLANK Leave blank/Do Not Use Leave blank/Do Not Use CHANGEDATE

26 Modified By Y 30 LEAVE BLANK Leave blank/Do Not Use Leave blank/Do Not Use CHANGEBY

27 PMNEXTDUEDATE N 4 MM/DD/YYYY hh:mm:ss PMNEXTDUEDATE

28 Is Task? Y 1 Yes or No ISTASK

29 Parent WO N 10 Length Limit: 250 Must exist in NAVFAC MAXIMO prior to submission or the record will be rejected.

Must exist in NAVFAC MAXIMO prior to submission or the record will be rejected.

PARENT

30 Work Order N 10 Must match Value List in Maximo

Used in updating record status on existing records.

WONUM

31 Detail Location N 250 DETAILLOC

32 CLIN N 30 Contract Line Item Number CLIN

33 Customer Ref Code N 8 Must match Value List in Maximo

Value list in REFERENCE SPREADSHEET CUSTOMERCODE

34 Sub Work Type N 15 (Cross-walked field).

Must match Crosswalk

Defaulted field based on the value of worktype SUBWORKTYPE

35 Work Center N 8 Must match Value List in Maximo

Value list in REFERENCE SPREADSHEET -or- For this contract:

- use the following identifier "XXXX"

PERSONGROUP

J-0200000-09, Page 4 of 4 (Amendment No. 0004)

Interface: Service Provider

VERSION #: V1

Current as of: 7/7/2013

Position 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

Name Approved

Date Work Type

Customer Reference

Number Description Location

Reported By

Master System

Status Status Date

Priority Actual Start

Actual Finish

Supervisor Labor Hours

(Actual)

Labor Cost (Actual)

Material Cost

(Actual) Duration Asset

Required Field(s) N Y Y Y Y N N Y Y Y N N N Y Y Y N N

19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35

Target Finish

Target Start Reported

Date Lead

Schedule d Start

Scheduled Finish

Modified Date

Modified By

PMNEXT

DUEDAT

E Is Task?

Parent

WO

Work Order

Detail Location

CLIN

Customer Ref Code

Sub Work Type

Work Center

N N Y N N N Y Y N Y N N N N N N N

NOTES:

• ONLY COLUMNs 1-35, and rows containing data should be be included in the FLAT-FILE SUBMISSION;

• Pipe Delimited (.txt) - | (Pipe is at the end of the column. Must have 35 PIPEs per row.)

ATTACHMENT J-0200000-18

NAVFAC MAXIMO DATA REPORTING

PURPOSE AND OVERVIEW

The purpose of this attachment is to provide guidance on how data is to be recorded and provided by the Contractor in reporting Service Provider, Asset, Specification, and Characteristic Meter Reading Information for NAVFAC MAXIMO. This document outlines the methods that must be utilized by the Contractor and associated NAVFAC business process and procedures for how data is to be submitted.

GENERAL TYPES OF DATA

Asset Information

Asset Information includes all necessary information for the documentation of all completed work orders, including, but not limited to, service orders, preventive maintenance (as performed under the PM program or as part of IMP), and work issued as Nonrecurring work. Specific NAVFAC MAXIMO fields required for work order data are listed on the Service Provider Information spreadsheet provided in J-0200000-06.

Asset Specification

Asset Specification includes the specific details necessary for proper identification and tracking of assets. Asset data must be updated for all completed work orders where an asset is repaired, replaced, installed, or otherwise affected.

Specific NAVFAC MAXIMO fields required for asset data are listed on the Asset Information spreadsheet provided in J-0200000-07. When replacing existing assets, the Contractor shall change the status of the current asset which will remove it from the maintenance plan and add the new asset.

Condition Assessment Data

Condition assessment data includes all necessary information for the accurate condition rating of all assets in support of the Infrastructure Condition Assessment Program (ICAP). Specific NAVFAC MAXIMO fields required for condition assessment data are listed on the Characteristic Meter Reading Information spreadsheet provided in J- 0200000-08.

METHOD FOR DATA SUBMISSION

NAVFAC MAXIMO Flat File Data Exchange

The Contractor will utilize the data formats contained in the Asset Information provided in J-0200000-06, Asset Specification provided in J-0200000-07, Characteristic Meter Reading Information provided in J-0200000-08 and Service Provider Information in J-1502000-09. The Contractor shall use their own internal systems to generate the flat file data into the format required. The Contractor is responsible for ensuring that data is correct and validated to meet the Maximo data requirements. If any data gets rejected the Contracting Officer will send the “rejected” data back to Contractor and the Contractor shall correct and resubmit the data within 24 hours. In all cases of data rejects the Contractor shall communicate with the Contracting Officer to rectify the data rejects.

Flat File Data Validation and Preparation

NAVFAC MAXIMO has several interfaces to assist in data transfer, many interfaces are used for multiple purposes to efficiently load or modify existing data in the system. Because of those multiple uses for each interface there are strict rules on how the data must be prepared for successful submission and loading.

The format required for flat files is detailed in the spreadsheets described below:

• ASSET SPECIFICATION – (Spreadsheet provided in J-0200000-07) – contains the format and data elements for submission of new or updated Asset Information.

14-17-2466 J-0200000-18, Page 1 of 3 (Amendment No. 0004)

• CHARACTERISTIC METER READING INFORMATION – (Spreadsheet provided in J-0200000-08) – contains the format and data elements for submission of updated Condition Assessment Information.

Service Provider, Asset, & Characteristic Meter Reading Information Spreadsheet Format

• Tab 1 – General Information - Version number, change log, etc.

• Tab 2 – Field Information – Field Name, Data Type, short description on field use and related information including Content Notes and NAVFAC MAXIMO Field Name.

• Tab 3 – Flat File Data Layout

The Contractor is required to validate their data prior to submission to minimize data rejects. To assist the contractor in data validation, the appropriate reference values will be provided by the Government and updated as changes occur. The reference files contain the valid data values for specific fields within MAXIMO at a specific time. Due to the frequent nature of changes for some value lists within MAXIMO (e.g., new assets added or status being changed), this file will be directly transferred from a local PW Representative to the Contractor as changes occur. The Contractor shall communicate with the Contracting Officer if any data values need to be added.

• SERVICE PROVIDER INFORMATION – (Spreadsheet provided in J-0200000-09) –contains the format and data elements for submission of Work Order Information.

Examples of data requiring validation:

• A current list of the valid Manufacturer’s (Company) Name values in NAVFAC MAXIMO. When adding a new asset, the contract will select the appropriate Company value so it will permit the successful asset record insert.

Company Description Company Type

Organization

MCQUAY McQuay International; HVAC equipment M NAVFAC

• A current list of the valid Assets for the contract. The file must be refreshed periodically to reflect assets added over the contract period. Assets must be added prior to Work Order being submitted for work on the asset or the Work Order will be rejected.

Sample Reference Value “asset”

Asset Description Location Parent Rotating Item

Work Center Site

WNY111-

AHU-05

SPLIT SYSTEM #1A WNY-111 WNY111-AHU-

CIMU-02

WCCP22 10101

• For some fields, NAVFAC MAXIMO may have many valid values such as SiteID and Work Center, however the Contractor will have only one authorized value. The Government will notify the Contractor of the specific values to be used for all records.

Flat File Submission Requirements

For data required to be submitted via flat file as specified in Section C, further detail of the format and submission requirements are detailed below. There are two different types of flat files: Pipe Delimited and Spreadsheet format.

• Pipe Delimited Flat File:

In this method the Contractor will prepare data in flat files for submission. These documents have strict requirements that must be followed to permit the successful processing by the Government to import into NAVFAC MAXIMO. Pipe Delimited Flat files are text files which are pipe delimited (the ‘|’ symbol on the keyboard) with

J-0200000-18, Page 2 of 3 (Amendment No. 0004) one record per line in the file. The Contractor is responsible to verify data against the reference values to prevent record rejects for required information.

Service Provider Information, Asset Information, Specification Information, and Characteristic Meter Reading Information Reports submitted as pipe delimited flat-files must be prepared as follows:

An individual flat file record is made up of over 30 individual fields, stored in a text file and delimited by the piping symbol ( ‘|’ ). Not all of the fields must have data. Fields that are not required to have data must still exist in the flat file record but are allowed to have no data present for that field. See below for illustration for fields not required. A flat file is a text file that contains one or more of these individual records.

Example of a single line from a Service Provider work order flat file:

04|SC|181|131: RPL FLORESCENT LIGHT COVER|ELCENT-131|ENS SUMMERS||COMP|8/31/2005

16:37:16|3|8/30/2005 0:00:00|8/30/2005 13:30:00||0.50|8.73|0|0.00|131|||8/29/2005 9:13:28|UTIL|8/30/2005

10:53:49|9/6/2005 10:55:47|8/31/2005 16:37:25|CHARLIE|

There are a couple things worth noting in this example. First, notice the places where two or three piping symbols appear in a row. Anytime two piping symbols are located next to each other, it means a NULL value is being submitted for that field. Three pipes in a row would signify two NULL fields.

The second item worth noting is the last field in the line. The line ends with “|CHARLIE|”. This is the 26th field and represents the CHANGEBY field. Since no more data are being sent with this individual record, no other piping symbols need to be included on this row. It would have been acceptable to include extra pipes to indicate the NULL values being sent for the remainder of the fields identified on the flat file format sheet.

• Spreadsheet Flat File:

In this method the Contractor will prepare data in flat files and submit in spreadsheet format to the Contracting Officer. These documents have strict requirements that must be followed to permit the successful processing by the Government to import into NAVFAC MAXIMO. The Contractor is responsible to verify data against the reference values to prevent record rejects for required information. Spreadsheet flat files shall be submitted in a Microsoft Excel file format. Upon acceptance, the Government will extract the relevant data to complete the NAVFAC MAXIMO Flat File Data Exchange.

Service Provider Information, Asset Information and Characteristic Meter Reading Information Reports submitted as spreadsheet flat-files must be prepared as follows:

The Contractor shall submit a complete work order, asset, or characteristic meter reading data spreadsheet by filling out all applicable portions of the Excel spreadsheet workbook after validating matching appropriate fields per provided reference files.

J-0200000-18, Page 3 of 3 (Amendment No. 0004)