NOSC ST J-0200000-07 - Service Provider Info.pdf

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-XX

SERVICE PROVIDER INFORMATION

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

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

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

ATTACHMENT J-0200000-XX

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

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

ATTACHMENT J-0200000-XX

SERVICE PROVIDER INFORMATION

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.)

Current as of: 7/7/2013

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