_J-0200000-07_ASSET_INFORMATION.xlsx

XLSX spreadsheet 30 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 an asset data template and field definitions for federal contractors to populate with asset information and submit to the Naval Facilities Engineering Command. The template includes 35 required and optional fields to provide details on assets such as identification numbers, descriptions, locations, purchase prices, and maintenance plans. Contractors must submit the asset data in a pipe-delimited flat file formatted according to the position and formatting of the specified fields. The template indicates the asset file interface relates to solicitation N62470-19-R-2001 for base operations support services at U.S. Naval Station Rota, Spain to be awarded by the Department of the Navy Naval Facilities Engineering Command. Relevant assets must be included to transfer information as part of the solicitation response by the specified due date.

From the source

Attachment J-0200000-07

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_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-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-1503030_Integrated_Solid_Waste_Management_(ISWM)_(Amendment_0004).pdf	PDF	Oct 17, 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-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-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-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-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-0200000-06_SERVICE_PROVIDER_INFORMATION.xlsx	XLSX spreadsheet	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-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-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-Asset File Into

ATTACHMENT J-0200000-07

ASSET INFORMATION

Interface: Asset File
VERSION #:	V2
Current as of:	26 April 2017

Version History

V1 - Updated to reflect current interface in MAXIMO

V2 - Added 3 additional fields (OPT): Asset Comment, PM Program & PM Plan

TABS
1-Asset File Info	This Sheet
2-Asset File Field List	Asset Template Data Format Information
3-Asset File - Template	Sample Excel Format

2-Asset File Field List

ATTACHMENT J-0200000-07

ASSET INFORMATION

Interface: Asset File

VERSION #:V2

Current as of: 26 April 2017

	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.	MASTERSYSTEM
	6	System	Y		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET.	SYSTEM
	7	Sub-System	Y		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET.	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.	SITEID
	10	Work Center (Person Group)	Y		Must match Value List in Maximo	Value list in REFERENCE SPREADSHEET.	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
	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.	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 Number	N	25			MODEL
	32	Serial Number	N	25			SERIALNUM
	33	Asset Comment	N	100			ASSETCOMMENT
	34	Standard Eval Results
(PM Plan)	N	15	Values Depend on Asset Type (i.e. UTILITIES, FACILITIES)	Not required, but will default to N/A or NTE if left blank. Valid values determined by Asset Type (Position 11)	STANDARDEVAL
	35	PM Standard Applies
(PM Program)	N	15	Values Depend on Asset Type (i.e. UTILITIES, FACILITIES)	Not required, but will default to N/A or NTE if left blank. Valid values determined by Asset Type (Position 11)	PMSTANDARD
	N/A

3-Asset File Template

	ATTACHMENT J-0200000-07
ASSET INFORMATION		ATTACHMENT J-0200000-XX

ASSET INFORMATION

Interface: Asset File

VERSION #: V2

Current as of: 26 April 2017

Position

Name

AssetNum

Changed Date

Description

Long Description

Master System

System

Sub-System

Location

Site ID

Work Center (Person Group)

Asset Type

Asset Quantity

Inventory Category

Purchase Price

Budgeted Cost

Replacement Cost

Meter Group

Belongs To (Parent)

Contract Number

Task/Delivery Order Number

Drawing Reference ID

Warranty Expiration Date

Status Date

Installation Date

Asset Status

CLASSSTRUCTUREID

Job Plan Code

Equipment Tag Number

Additional Loc Info

Manufacturer

Model

Serial #

Asset Comment

PM Plan

PM Program

Required Field(s)

(on new Asset)

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, before the return. Must have 35 PIPEs per row.)

• New assets & asset updates (to different assets) can be completed at the same time. An asset can't be created and updated at the same time.

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