_J-0200000-06_SERVICE_PROVIDER_INFORMATION.xlsx

XLSX spreadsheet 26 KB Posted Sep 18, 2019

Attached to: BASE OPERATIONS SUPPORT (BOS) SERVICES AT U. S. NAVAL STATION ROTA, SPAIN Federal contract opportunity
Solicitation number: N62470-19-R-2001
Issued by: Department of the Navy Naval Facilities Engineering Command

About this file

Written by GovTribe AI · Dec 30, 2023

This document contains a template and field list for service provider information submissions relating to base operations support services at U.S. Naval Station Rota, Spain. The template outlines 35 required data fields for work orders to be submitted via a pipe-delimited file format. Key details include: work type, customer reference number, location, status, priority, labor hours and costs, asset number, target and actual start/finish dates, parent work order, and CLIN. The field list defines each data field and identifies those that must match existing values in Maximo, the Navy's work and asset management system. It also notes required field lengths and formats. The related federal contract opportunity is for base operations support services at Naval Station Rota, Spain to be awarded by the Department of the Navy Naval Facilities Engineering Command.

From the source

Attachment J-0200000-06

View the file

Other files for this federal contract opportunity

Other files attached to BASE OPERATIONS SUPPORT (BOS) SERVICES AT U. S. NAVAL STATION ROTA, SPAIN, newest first.
File	Type	Posted
J-0200000-13_Exhibit_Line_Item_Numbers_(ELINs)_(Amendment_0007).xlsx	XLSX spreadsheet	Oct 30, 2019
N62470-19-R-2001_Rota_BOS_Amendment_0006.pdf	PDF	Oct 25, 2019
J-1502000-00-04_Equipment_and_Systems_Inventory_(Amendment_0005).xlsx	XLSX spreadsheet	Oct 24, 2019
J-1502000-01-04_Equipment_and_Systems_Inventory-BUMED_(Amend_0005).xlsx	XLSX spreadsheet	Oct 24, 2019
F_Section_F_Deliverables_(Amendment_0005).pdf	PDF	Oct 24, 2019
J-1502000-00_Facility_Investment_(Amendment_0005).pdf	PDF	Oct 24, 2019
J-1503030_Integrated_Solid_Waste_Management_(ISWM)_(Amendment_0005).pdf	PDF	Oct 24, 2019
J-0200000-13_Exhibit_Line_Item_Numbers_(ELINS)_(Amendment_0005).xlsx	XLSX spreadsheet	Oct 24, 2019
J-1502000-01_Facility_Investment_-_BUMED_(Amendment_0004).pdf	PDF	Oct 17, 2019
J-1502000-01-04_Equipment_and_Systems_Inventory_-_BUMED_(Amendment_0004).xlsx	XLSX spreadsheet	Oct 17, 2019
J-1503030_Integrated_Solid_Waste_Management_(ISWM)_(Amendment_0004).pdf	PDF	Oct 17, 2019
J-1503010-05_Custodial_Service_Classes_and_Frequencies_(Amendment_0003).xlsx	XLSX spreadsheet	Oct 15, 2019
J-1502000-01_Facility_Investment-BUMED_(Amendment_0003).pdf	PDF	Oct 15, 2019
J-1502000-00-07_Equipment_and_Systems_Inventory_-_DoDEA_(Amendment_0003).xlsx	XLSX spreadsheet	Oct 15, 2019
J-1502000-01-05.a_Service_Orders_Summary-BUMED.XLSX	XLSX spreadsheet	Oct 15, 2019
N62470-19-R-2001_Rota_BOS_Amendment_0003.pdf	PDF	Oct 15, 2019
J-1503030-05_Location_and_Frequency_Historical_Data_(Amendment_0003).xlsx	XLSX spreadsheet	Oct 15, 2019
J-10_Site_Visit_Sign-In_Sheet.pdf	PDF	Oct 4, 2019
N62470-19-R-2001_Rota_BOS_Amendment_0001.pdf	PDF	Oct 3, 2019
J-1503010_Custodial_(Amendment_0001).pdf	PDF	Oct 3, 2019
J-1503020_Pest_Control_(Amendment_0001).pdf	PDF	Oct 3, 2019
_J-1503010_Custodial.pdf	PDF	Sep 18, 2019
_J-0200000-08_SPECIFICATION_INFORMATION.xlsx	XLSX spreadsheet	Sep 18, 2019
_J-6_Basis_of_Estimate_(BOE)_(Sample).pdf	PDF	Sep 18, 2019
_F_Section_F_Deliverables.pdf	PDF	Sep 18, 2019
_J-1503020-04_Integrated_Pest_Management_Plan.pdf	PDF	Sep 18, 2019
_J-0200000_Management_and_Administration.pdf	PDF	Sep 18, 2019
_J-1401000-08_Cable_TV_System.pdf	PDF	Sep 18, 2019
_J-1503030_Integrated_Solid_Waste_Management.pdf	PDF	Sep 18, 2019
_J-0200000-11.b_Spill_Prevention_and_Response_Plan.pdf	PDF	Sep 18, 2019
_J-1502000-00-03_Facility_Inventory.xlsx	XLSX spreadsheet	Sep 18, 2019
_J-1503050-03.a_Grounds_Maintenance_Inventory.xls	XLS spreadsheet	Sep 18, 2019
_J-1_Past_Performance_Questionnaire.docx	DOCX document	Sep 18, 2019
_J-0200000-07_ASSET_INFORMATION.xlsx	XLSX spreadsheet	Sep 18, 2019
_J-1503030-04_Solid_Waste_Disposal_Historical_Data.pdf	PDF	Sep 18, 2019
_J-3_Section_B,_Supplies_or_Services_and_Prices.docx	DOCX document	Sep 18, 2019
_J-1503010-07.a_Floor_Plans_BUMED.pdf	PDF	Sep 18, 2019
_J-1800000_Environmental.pdf	PDF	Sep 18, 2019
_J-1503020-07.a_Housing_Bait_Control_Points.pdf	PDF	Sep 18, 2019
_J-7_Work_Pass_Format_Form.pdf	PDF	Sep 18, 2019
_J-1501000-04_Characteristic_Meter_Reading_Information.xlsx	XLSX spreadsheet	Sep 18, 2019
_J-1700000_Transportation.pdf	PDF	Sep 18, 2019
_J-0200000-13_Exhibit_Line_Item_Number_(ELINs).xlsx	XLSX spreadsheet	Sep 18, 2019
_J-1401000-03C_FH_Painting_Measurements.xlsx	XLSX spreadsheet	Sep 18, 2019
_J-1502000-00-04_Equipment_and_Systems_Inventory.xlsx	XLSX spreadsheet	Sep 18, 2019
_J-1401000-07_FH_Street_Lighting.pdf	PDF	Sep 18, 2019
_J-1401000-03_FH_Facility_Property_and_Systems_Equipment_Inventory.xlsx	XLSX spreadsheet	Sep 18, 2019
_J-2_Corporate_Experience_Project_Data_Sheet.docx	DOCX document	Sep 18, 2019
_J-1402000_Unaccompanied_Housing.pdf	PDF	Sep 18, 2019
N62470-19-R-2001_Pre-Solicitation_Notice.pdf	PDF	Sep 3, 2019

Show all 50

BASE OPERATIONS SUPPORT (BOS) SERVICES AT U. S. NAVAL STATION ROTA, SPAIN has more files on GovTribe.

On GovTribe

Work with this file on GovTribe

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

1-Service Provider Info

ATTACHMENT J-0200000-06

SERVICE PROVIDER INFORMATION

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

2-Service Provider Field List

ATTACHMENT J-0200000-06

SERVICE PROVIDER INFORMATION

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

3-Service Provider-Template

	ATTACHMENT J-0200000-06
SERVICE PROVIDER INFORMATION		ATTACHMENT J-0200000-XX

SERVICE PROVIDER INFORMATION

Interface: Service Provider

VERSION #: V1

Current as of: 7/7/2013

Position

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

Target Finish

Target Start

Reported Date

Lead

Scheduled Start

Scheduled Finish

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)

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

File details come from the government source that posted it. Updated Dec 30, 2023.