Attachment B_Daily Data Transfer_XML Format_PWS.pdf

Reference 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 file header in order to output data from the contract labs server and ingest it into the government database.

Lube Oil Lab Data File Format – This data applies to all files sent from the lab/labs for import into the MSC database

FILE NAMING

LO-20170530111 – “LO” indicates file type followed by a dash then YYYYMMDDIII

File Type <?xml version="1.0"?>

File Data <LUBEOILSAMPLES> - Header

Lab Assigned Sample ID - Each complete sample includes information, data and comments grouped inside SampleID tags. The specified format should be LLLLLLLLYYY. LLLLLLLL being the unique lab sample ID supplied the lab, YYY being the year. The front can filled with 0s if needed to total 11 chars, including the three characters for the year.

<SAMPLE ID="22274435017">

Information Section Header - 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>

LABNAME - The name of the laboratory handling the sample.

<LABNAME>Lab Name</LABNAME>

LABID - The 8 digit (this is an integer in the database. Current labs are max 6) ID number of the laboratory handling the sample. Assigned by Government officials after contract award.

<LABID>3</LABID>

DATEREPORTED – Date of analysis in format YYYY-MM-DD

<DATEREPORTED>2017-05-23</DATEREPORTED>

VESSELREGID - Unique 4 digit ID number of the vessel from which the sample was taken. Defined in the Lab Registration Files provided by the MSC.

<VESSELREGID>0008</VESSELREGID>

VESSELNAME - Name of the vessel from which samples will be taken. This must match the data provided to the lab in the Lab Registration Files provided by the MSC.

<VESSELNAME>USNS Vessel</VESSELNAME>

EQUIPREGID - The vessel unique 3 digit ID of the sample point from which the samples will be taken. Defined in the Lab Registration Files provided by the MSC.

<EQUIPREGID>025</EQUIPREGID>

EQUIPNAME - Government specified name for the sample point from which samples will be taken. Defined in the Lab Registration Files provided by the MSC.

<EQUIPNAME>NO. 5 SS-EDG ENGINE</EQUIPNAME>

SPID (Sample Point ID) - 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 each vessel. It is defined in the Lab Registration Files provided by the MSC.

<SPID>0008025</SPID>

SLATENAME - Name of the test slate defining which tests are to be conducted that is assigned to each sample point.

Defined in the Lab Registration Files provided by the MSC.

<SLATENAME>TEST SLATE 1</SLATENAME>

LUBID - The MSC ID number of the lubricant that should be in use at the sample point. Defined in the Lab Registration Files provided by the MSC. Corresponds to the product name.

<LUBID>10272</LUBID>

LUBNAME – Name of the lubricant sampled. Corresponds to the LUBID. Defined in the Lab Registration Files provided by the MSC.

<LUBNAME>SHELL SIRIUS X 40</LUBNAME>

CAPGALLONS - The system capacity for the sample point.

<CAPGALLONS>0</CAPGALLONS>

DATETAKEN – Sample date from the Lube Oil Sample Label. Format YYYY-MM-DD.

<DATETAKEN>2017-04-28</DATETAKEN>

DATELANDEDLAB – Date Sample was received by the Lab. Format YYYY-MM-DD.

<DATELANDEDLAB>2017-05-16</DATELANDEDLAB>

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

<OILHOURS>0</OILHOURS>

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

<ENGINEHOURS>64914</ENGINEHOURS>

LABASSESSMENT - 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 = Problem noted 2 = Severe problem noted.

<LABASSESSMENT>0,0</LABASSESSMENT>

LUBEOILLABELNUMBER - The 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>00080250690035355</LUBEOILLABELNUMBER>

<RESULTS> - Results Section Header

<RESULT> - Individual Variable Result Header

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

<TESTID>8159</TESTID>

TEST - One of a set of test variables provided by the Government at the time of contract award. Should correspond with TestID.

<TEST>VISCOSITY</TEST>

UNITS - One of a set of test units assigned to the test variable provided by the Government at the time of contract award.

<UNITS>CST</UNITS>

VALUE - The physical or chemical measurement results for the specified test variable in the units listed in UNITS.

<VALUE>143.06</VALUE>

LABH - High alarm level for the test reported on as determined by the lab analysts for the units of measure. Defined in the Lab Registration Files provided by the MSC.

<LABH>165</LABH>

LABHH - Critical high alarm level for the test reported on as determined by the lab analysts for the units of measure. Defined in the Lab Registration Files provided by the MSC.

<LABHH>175</LABHH>

LABL - Low alarm level for the test reported on as determined by the lab analysts for the units of measure. Defined in the Lab Registration Files provided by the MSC.

<LABL>125</LABL>

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

Defined in the Lab Registration Files provided by the MSC.

<LABLL>100</LABLL>

TESTALARMLEVEL - Alarm level determined for this test by the laboratory. One of three levels. void – none; '+'

- high or low; '*' - critical high or low.

<TESTALARMLEVEL/>

</RESULT> - End of Result Set

LAB SAMPLE POINT REGISTRATION FILES – These files will be provided to the Lab by the MSC periodically to define and maintain the Vessel, Equipment, Measurement Point, Lubricant, Test Slate and Alert Levels for each vessel sample point. These files should be applied to the lab database in an automated fashion

File Type <?xml version="1.0"?>

<EQUIPMENT> - Section Header

<EQUIPITEM> - Equipment Header

SPID - 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 each vessel.

<SPID>5608002</SPID>

REGDATE – Date the Registration File was created

<REGDATE>2017-02-17</REGDATE>

VESSELREGID - Unique 4 digit ID number of the vessel from which the sample was taken.

<VESSELREGID>5608</VESSELREGID>

VESSELNAME - Name of the vessel from which samples will be taken.

<VESSELNAME>NOAA Okeanos Explorer</VESSELNAME>

EQUIPREGID - The vessel unique 3 digit ID of the sample point from which the samples will be taken

<EQUIPREGID>002</EQUIPREGID>

EQUIPNAME - Government specified name for the sample point from which samples will be taken.

<EQUIPNAME>NO.2 MAIN PROPULSION MOTOR</EQUIPNAME>

LUBID - The MSC ID Number of the lubricant that should be in use at the sample point. Provided by the MSC.

<LUBID>7</LUBID>

LUBNAME - Name of the lubricant sampled. Corresponds to the LUBID. Provided by the MSC.

<LUBNAME>MOBIL DTE OIL HEAVY MED</LUBNAME>

SLATENAME - Name of the test slate defining which tests are to be conducted that is assigned to each sample point.

Slate Definitions are provided by the MSC.

<SLATENAME>TEST SLATE 4</SLATENAME>

SYSCAPACITY - The system capacity for the sample point.

<SYSCAPACITY>0</SYSCAPACITY>

<ALARMLEVELS> - Variable Section Header

<LABTEST> - Test Variable Header

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

<TESTID>8401</TESTID>

TEST - One of a set of test variables provided by the Government at the time of contract award. Should correspond with TestID.

<TEST>ALUMINUM</TEST>

UNITS - One of a set of test units assigned to the test variable provided by the Government at the time of contract award.

<UNITS>PPM</UNITS>

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

<MSCH>8</MSCH>

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

<MSCHH>14</MSCHH>

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

<MSCL>40</MSCL>

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

<MSCLL>34</MSCLL>

</LABTEST> - End of Variable Test Section

Slate information defining which set of test variables will be for each sample point will be provided by the MSC.