J-0200000-07 Asset Information.xlsx

XLSX spreadsheet 31 KB Posted Apr 10, 2020

Attached to: AST/UST/Cathodic Protection Maintenance and Repair
Solicitation number: N40085-20-R-3006
Issued by: Department of the Navy Naval Facilities Engineering Command

About this file

Written by GovTribe AI · Dec 28, 2023

This document contains an asset information template and field list for a federal contract opportunity to provide cathodic protection, tank gauging, and fuel management system maintenance and repair services. Key details include the requirement to test, calibrate, adjust and repair cathodic protection, automatic tank gauging and fuel management systems on above-ground and underground tanks, piping, piers and quay walls at the Naval Submarine Base New London in Groton, Connecticut. The contractor shall provide all labor, materials, equipment, supervision, transportation and management necessary to perform the work. The solicitation number is N40085-20-R-3006 and was issued by the Department of the Navy Naval Facilities Engineering Command for asset information interface and management in Maximo computerized maintenance management system.

View the file

Other files

File	Type	Posted
N4008520R3006 002.pdf	PDF	May 8, 2020
J-1502000-10 UNDERGRD STORAGE TANK INSP FORM MONTHLY-ANNUAL.pdf	PDF	May 8, 2020
Amendment 1_site_visit.pdf	PDF	Apr 24, 2020
J-1502000-9 STI 6th AST Annual.pdf	PDF	Apr 10, 2020
J-150200-12 ELINS cathodic 2020.xls	XLS spreadsheet	Apr 10, 2020
J-0200000-09 Charc Meter Reading.xlsx	XLSX spreadsheet	Apr 10, 2020
1502000 F Facility Investment CATHODIC.pdf	PDF	Apr 10, 2020
J-0200000-08 Specification Information.xlsx	XLSX spreadsheet	Apr 10, 2020
20R3006_Cathodic Protection.pdf	PDF	Apr 10, 2020
J-0200000-11 SPCC Plan.pdf	PDF	Apr 10, 2020
J-020000-05A Quality Inspection and Surveillance report.xlsx	XLSX spreadsheet	Apr 10, 2020
1502000 C Facility Investment CATHODIC.pdf	PDF	Apr 10, 2020
0200000 F Management and Administration v2.8.pdf	PDF	Apr 10, 2020
J-1502000-06 Service Order Summary Report.xlsx	XLSX spreadsheet	Apr 10, 2020
J-020000-05B On site Labor Summary Report (1).xlsx	XLSX spreadsheet	Apr 10, 2020
0200000 C Management and Administration v2.9.pdf	PDF	Apr 10, 2020
J-1502000-05 CATHODIC INVENTORY.xlsx	XLSX spreadsheet	Apr 10, 2020
1502000 J Facility Investment CATHODIC.pdf	PDF	Apr 10, 2020
0100000 C General Information Cathodic Protection.pdf	PDF	Apr 10, 2020
J-1502000-03 BASE MAP 2019.pdf	PDF	Apr 10, 2020
J-1502000-08 ABOVEGROUND STORAGE TANK INSP FORM MONTHLY.pdf	PDF	Apr 10, 2020
J-0200000-04 Invoice Form.pdf	PDF	Apr 10, 2020
NEPA_AST_UST_Cathodic2020_signed.pdf	PDF	Apr 10, 2020
J-1502000-07 Maintenance Summary Report - Copy.xlsx	XLSX spreadsheet	Apr 10, 2020
J-0200000-06 - Ser Provider Info.xlsx	XLSX spreadsheet	Apr 10, 2020
1502000 FAP Facility Investment CATHODIC.pdf	PDF	Apr 10, 2020
0200000 J Management and Administration v2.6.pdf	PDF	Apr 10, 2020
J-1502000-10 STI 6th AST Monthly.pdf	PDF	Apr 10, 2020

Show all 28

On GovTribe

Work with this file

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

ASSET INFORMATION

Interface: Asset File
VERSION #:	V1
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

2-Asset File Field List

ATTACHMENT J-0200000-XX

ASSET INFORMATION

Interface: Asset File

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	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 -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			MODEL
	32	Serial #	N	25			SERIALNUM

3-Asset File Template

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

ASSET INFORMATION

Interface: Asset File

VERSION #: V1

Current as of: 7 July 2013

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 #

Required Field(s)

(on new Asset)

NOTES:

• ONLY COLUMNs 1-32, 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 32 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 Apr 10, 2020.