ATTACHMENT_B.docx

DOCX document 34 KB Posted

Attached to
Lube Oil Testing & Analysis
Solicitation number
N6449819R4002
Issued by

About this file

Not Listed

View the file

Other files

Show all 12

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

ATTACHMENT (B): PRESCRIBED XML FORMAT

Lube oil sample data shall be transmitted to the Government’s designated server site using the format below. This Attachment contains the required data fields used for new and used oil analysis test results and a narrative description in each field, where information is not self-explanatory.

Each equipment registration number element is composed of identifying information for a specific sampling point. The one attribute is the 7 digit PFA number. PFA number is a Government provided equipment registration or unit identification number. The PFA number is a combination of vessel registration id (4 digits) and equipment registration id (3 digits). There is one unique PFA number for each sampling point on a vessel.

<REGNUMBER PFA="0300123">

Date of equipment registration. Provide in YYYY-MM-DD format.

<DATEEQUIPREG>2003-10-23</DATEEQUIPREG>

Unique 4 digit ID number of the vessel from which the sample was taken. It is provided on lube oil label on each sample bottle.

<VESSELREGID>0030</VESSELREGID>

The vessel unique 3 digit ID of the sample point from which the samples will be taken. Provided on lube oil label on each sample bottle.

<EQUIPREGID>123</EQUIPREGID>

Government specified name for the sample point from which samples will be taken. Provided on the lube oil label on each sample bottle.

<EQUIPNAME>PORT MAIN ENGINE</EQUIPNAME>

Name of the lubricant that should be in use at the sample point.

Assigned by Government officials. Verified from the lube oil label on each sample bottle.

<PRODNAME>130015W40</PRODNAME>

The company product number of the lubricant that should be in use at the sample point. Assigned by Government officials. Corresponds to the product name.

<PRODID>34567</PRODID>

Government specified test slate assigned to each sample. Verified from the lube oil label on each sample bottle.

<SLATEID>001</SLATEID>

Name of the test slate assigned to each sample. Assigned by Government officials. Verified from the lube oil label on each sample bottle.

<SLATENAME>DIESEL ENGINE SLATE</SLATENAME>

The units of measurement for system capacity of the sample point.

<SYSCAPACITYUNITS>G</SYSCAPACITYUNITS>

The system capacity for the sample point.

<SYSCAPACITY>2000</SYSCAPACITY>

Each complete sample includes information, data and comments grouped inside SampleID tags. The one attribute is a YYMMDD### LabSampleID tag where ### is sequential starting with 001.

- <SAMPLE ID="170101123">

The sample information element contains site data, equipment identification, lubricant identification, important tracking dates, engine and oil hours, overall lab assessment and the lube oil label number.

- <INFORMATION>

Sample Information

The name of the laboratory handling the sample.

<LABNAME>Expert Oil Labs, Inc.</LABNAME>

The 8 digit ID number of the laboratory handling the sample. Assigned by Government officials after contract award.

<LABID>001234</LABID>

The date the oil was taken from the equipment on the vessel. The value is written by vessel personnel on the lube oil label on the sample bottle.

Provide in YYYY-MM-DD format.

<DATETAKEN>2003-10-18</DATETAKEN>

The date the oil sample bottle arrived at the laboratory. Provide in YYYY-MM-DD format.

<DATELANDEDLAB>2003-10-25</DATELANDEDLAB>

The date sample data were posted to the ftp site by the contractor. Provide in YYYY-MM-DD format.

<DATEREPORTED>2003-10-27</DATEREPORTED>

The hours the oil has been in service at the sample point. Taken from the lube oil label.

<OILHOURS>1234</OILHOURS>

The number of hours the engine has been operating since last major overhaul. Taken from the lube oil label.

<ENGINEHOURS>1234</ENGINEHOURS>

The overall oil rating as determined by the lab analysts.

Two numbers provided. One for oil condition and one for wear metals found. 0 = Normal 1 = Monitor 2 = Abnormal 3= Critical.

<LABASSESSMENT>1,1</LABASSESSMENT>

The 10 character number on lube oil label on the sample bottle. The number has been coded so that it can be used to derive registration and sampling information if other data are smeared on the label.

<LUBEOILLABELNUMBER>0301234567</LUBEOILLABELNUMBER>

</INFORMATION>

The sample result element contains line items for each physical or chemical attribute measured or observed.

- <RESULTS>

Sample Results

One element for each physical or chemical result determined for each sample.

- <RESULT>

Test Result

One of a set of test identification numbers provided by the Government at the time of contract award.

<TESTID>8159</TESTID>

One of a set of test identification numbers provided by the Government at the time of contract award. Should correspond with test identification number.

<TEST>VISCOSITY</TEST>

The physical or chemical measurement in the units listed on the next element.

<VALUE>124</VALUE>

One of a set of test units provided by the Government at the time of contract award.

<UNITS>CST</UNITS>

Critical high alarm level for the test reported on as determined by the lab analysts for the units of measure.

<LABHH>200</LABHH>

High alarm level for the test reported on as determined by the lab analysts for the units of measure.

<LABH>150</LABH>

N00033-14-D-8024

Low alarm level for the test reported on as determined by the lab analysts for the units of measure.

<LABL>100</LABL>

Critical low alarm level for the test reported on as defined by NSWCPD for the units of measure.

<LABLL>75</LABLL>

Alarm level determined for this test by the laboratory.

One of three levels. void - none '+' - high or low '*' - critical high or low.

<TESTALARMLEVEL />

</RESULT>

And so on. One for each result.

</RESULTS>

The sample comments element contains text provided by vessel personnel, lab analysts, or automated computer software analysts.

- <COMMENTS>

Sample Comments Any lab analyst comments or automated comments provided by lab software.

<LABCOMMENTS>Oil out of limits. The viscosity is below the lower limit for this lubricant grade. The charge should be changed. The Lead level in his sample exceeds the normal range of similar equipment. Inspect lead containing components for excessive wear.</LABCOMMENTS>

Any comments provided by vessel personnel on the lube oil label.

<VESSELCOMMENTS>Engine sounds unusual. Oil purified March 2002.</VESSELCOMMENTS>

</COMMENTS>

</SAMPLE>

And so on. One for each sample.

Each complete unregisterable sample includes information, data and comments grouped inside UnregSampleID tags. The one attribute is a YYMMDD### LabSampleID tag where ### is sequential starting with 001. Any fields that can't be filled in should be added as empty fields.

- <UNREGSAMPLE ID="170101123">

File details come from the government source that posted it.