9-1-Section_J_0200000.pdf

ATTACHMENT NUMBER ATTACHMENT TITLE

J-0200000-01 Acronyms J-0200000-02 CPAR Form J-0200000-03 Instructions, Directions and References J-0200000-04 Government Furnished Property and Services J-0200000-05 Site Maps J-0200000-06 Historical Service Calls J-0200000-07 Invoice Example J-0200000-08 General Security Requirements J-0200000-09 White House Communications Agency Security Requirements J-0200000-10 Partnering Instructions

J-0200000-11 ELINS

J-0200000-12 Wage Determination

J-0200000-13A Service Provider J-0200000-13B Asset File Information J-0200000-13C Asset File Field List

J-0200000-13CD Asset File Template

SECTION J 0200000

MANAGEMENT & ADMINISTRATION ATTACHMENTS

TABLE OF CONTENTS

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 <<Note to Spec Writer: Only the "Content Notes" field should be modified on this TAB, Delete this text box prior to publising, no other changes to this document should be made.>>

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

3 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 Y 10 MM/DD/YYYY hh:mm:ss ACTSTART

12 Actual Finish Y 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

ATTACHMENT J-0200000-13A

SERVICE PROVIDER INFORMATION

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

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

Interface: Asset File

Current as of: 7 July 2013

Version History V1 - Updated to reflect current interface in MAXIMO

TABS

1-Asset File Info This Sheet

2-Asset File Field List Asset Template Data Format Information 3-Asset File - Template Sample Excel Format

ATTACHMENT J-0200000-13B

ASSET INFORMATION

VERSION #:V1

Current as of: 7 July 2013

Position Name Required Length Limit Data Format Note

Content Notes <<Note to Spec Writer: Only the "Content Notes" field should be modified on this TAB, Delete this text box prior to publising, no other changes to this document should be made.>>

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 Y 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. Required for INVENTORY CATEGORY of RPIE. 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. Required for INVENTORY CATEGORY of RPIE.

PARENT

ATTACHMENT J-0200000-13C

19 Contract Number N 25 Appended to

LONGDESCRIPTION

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 Required for INVENTORY CATEGORY of RPIE and BOTH MODEL 32 Serial # N 25 Required for INVENTORY CATEGORY of RPIE and BOTH SERIALNUM

Current as of: 7 July 2013 Position 1 2 3 4 5 6 7 Name

AssetNum Changed Date Description Long

Description Master System System Sub-System

Required Field(s) (on new Asset) Y N Y N Y Y Y

8 9 10 11 12 13 14 15 16 17 18

Location Site ID Work Center (Person Group)

Asset Type

Asset Quantity

Inventory Category

Purchase Price

Budgeted Cost

Replacement Cost

Meter Group

Belongs To (Parent)

Y Y Y Y Y Y N N Y N N

ATTACHMENT J-0200000-13D

19 20 21 22 23 24 25 26 27 28

Contract Number

Task/Delivery Order Number

Drawing Reference ID

Warranty Expiration Date

Status Date

Installation Date

Asset Status

CLASSSTR

UCTUREID

Job Plan Code

Equipment Tag Number

N N N N N Y N N N N

ATTACHMENT J-0200000-13C

29 30 31 32

Additional Loc Info Manufacturer Model Serial #

N N N N