J-0200000 -07 Attachment Service Provider.xlsx
XLSX spreadsheet 41 KB Posted
- Solicitation number
- N40085_23_R_2526
About this file
This document contains a template and instructions for submitting work order information to the Naval Facilities Engineering Command (NAVFAC) through their MAXIMO system. Key details include:
The template provides guidance on 35 data fields required to submit work orders through a pipe-delimited file format. Critical fields include an approved date, work type, customer reference number, description, location, reported date, status, priority, actual start and finish dates, labor hours and costs, material costs, asset, target dates, reported date, and work order number. Acceptable values for fields like work type, location, and asset must be drawn from reference spreadsheets maintained by NAVFAC to ensure data standardization. The related federal contract opportunity is solicitation number N40085-23-R-2526 for maintenance and repair of railroad trackage at Naval Weapon Station Earle and other areas of responsibility, issued by the Department of the Navy Naval Facilities Engineering Command.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| J-0200000-05 Attachment Contractor Safety Self-Evaluation Checklist 08-05-22.xlsx | XLSX spreadsheet | |
| J-0200000-09 Attachment Specification Information 08-05-22.xlsx | XLSX spreadsheet | |
| RFP N4008523R2526.pdf | ||
| WD 2015-4195 REV 23.pdf | ||
| Section J- 0200000 _J-1502000_Annexes.pdf | ||
| J-1502000 ELIN.xlsx | XLSX spreadsheet | |
| Section C Annexes -1-2-15.pdf | ||
| J-1502000-03 Turnout Inventory.xlsx | XLSX spreadsheet | |
| J-0200000-10- CHARACTERISTIC METER READING INFORMATION v2 - 2016-09-30.xlsx | XLSX spreadsheet | |
| J-1502000-05A Crossing Inventory.xlsx | XLSX spreadsheet | |
| General Decision Number NJ20230058 01-06-2023.pdf | ||
| J-0200000 -08 Attachment Asset Information 08-05-22.xlsx | XLSX spreadsheet | |
| Section F- Annexes 0200000 F.pdf |
Show all 13
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
1 Service Provider Info
ATTACHMENT J-0200000-07
SERVICE PROVIDER INFORMATION
| Interface: Service Provider |
| VERSION #: V1 |
| Current as of: 07 Jul 2013 |
| Version History |
| V1 - Updated to reflect current interface in MAXIMO |
| Version History |
| V1 - Updated to reflect current interface in MAXIMO |
Service Provider Field Lst Attachment J-0200000-07 Service Provider Information
| Interface: Service Provider | ||||
| VERSION #: V1 | ||||
| Current as of: 07 Jul 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 | |||||||
| 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 | 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
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
Service Provider Template Attachment J-0200000-07 Service Provider Information
| Interface: Service Provider | ||||||||||||
| VERSION #: V1 | ||||||||||||
| Current as of: 07 Jul 2013 | ||||||||||||
| Position | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Name | Approved Date | Work Type | Customer Reference Number | Description | Location | Reported By | Master System | Status | Status Date | Priority | Actual Start | Actual Finish |
| Required Field(s) | N | Y | Y | Y | Y | N | N | Y | Y | Y | N | N |
| Position | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | |
| Name | Supervisor | Labor Hours | |||||||||||
| (Actual) | Labor Cost | ||||||||||||
| (Actual) | Material Cost | ||||||||||||
| (Actual) | Duration | Asset | Target Finish | Target Start | Reported Date | Lead | Scheduled Start | Scheduled Finish | |||||
| Required Field(s) | N | Y | Y | Y | N | N | N | N | Y | N | N | N |
| Position | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 |
| Name | Modified Date | Modified By | PMNEXTDUEDATE | Is Task? | Parent WO | Work Order | Detail Location | CLIN | Customer Ref Code | Sub Work Type | Work Center |
| Required Field(s) | 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.) |
image1.png
File details come from the government source that posted it. Updated .