Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 13 Next »

Introduction

The Bruker Tracer 5 is a fully portable analyzer based on energy dispersive X-ray fluorescence (EDXRF) technology. When X-ray radiation from the handheld XRF instruments' X-ray tube (source) excites the atoms in a sample, the atoms release low-energy fluorescent X-rays detected by device's detector. The energy level of each fluorescent X-ray is characteristic of the element excited. As a result, one can tell what elements are present based on the emitted energy patterns of the X-rays. The Bruker Tracer 5 portable XRF (pXRF) allows for elemental measurements on section halves, discrete samples and prepared powder mounts. It is standard for the onboard technician to train one or more scientists in pXRF operation and sample prep. The scientists are then responsible for the work flow during the expedition. 

Before you begin: The instrument generates X-rays and should only be operated by users trained in radiation safety. Do not expose any part of your body to X-rays!

Theory of Operation

X-ray fluorescence is the production of X-rays in the electron orbits. The handheld XRF functions by bombarding the atoms of the target sample with X-rays. Some of the photons collide with K (and L) shell electrons of the sample, dislodging them from their orbits. This leaves a vacant space in the K (L) shell, which is immediately filled by an electron from the L, M, or N (M or N) shell. This is accompanied by a decrease in the atom's energy, and an X-ray photon is emitted with energy equal to this decrease. Since the energy change is uniquely defined for atoms of a given element, it is possible to predict definite frequencies for the emitted X-rays. This means that when electrons are dislodged from atoms, the emitted X-rays are always identical. These X-rays are analyzed with an X-ray detector and the quantity of K shell and/or L shell X-rays detected will be proportional to the number of atoms of the particular element or elements present in the sample.

Instrument and Accessories

Instrument

  • Bruker Tracer 5 portable XRF (pXRF) with 5 application calibrations (and associated reference check samples):
    • GeoExploration (CS-M2, Geo/Soil sample)
    • Limestone (Limestone square)
    • Mudrock (Air) (Mudrock square)
    • Mudrock (He) (Mudrock square)
    • Precious Metals 2 (Silver disk)
  • Color touch screen
  • AC power adaptor
  • 3 Lithium ion batteries and battery charger
  • 3mm and 8mm collimators
  • Filters for Cu, 200µm/Ti, 25µm/Al, 300µm (black) and Al, 76µm  (orange)
  • Prolene exam windows
  • Holding stand (IODP 3D Printed)

Accessories

  • Desktop stand
  • Benchtop stand
  • Small stage with leaded cup shield
  • Shielded holder for section half measurements (IODP 3D Printed)
  • Section half holders with ruler bracket
  • Background plate
  • Small scissor platform
  • Remote trigger cable
  • Thermometer/Clock/Humidity Monitor

Computer & Software

  • Laptop (IL-53409-XRF)
  • Bruker RemoteCTRL (mirrors device screen)
  • Bruker Instrument Tools (data management)
  • Artax Spectra (for data processing)
  • Barcode scanner to read sample labels
  • All-in-one Filehub

Laboratory Supplies

  • pXRF plastic sample cups (32mm double open ended, ring and cap)
  • SPEX Ultralene thin film for XRF or polypropylene film circles (0.16mil, 4µ)
  • Whatman filter circles (24mm, grade 540)
  • Foam plugs (24mm)
  • Spatula or scooping tool
  • Powdering equipment (depending on sample hardness)
    • Agate mortar and pestle
    • Mixer mill with alumina ceramic grinding cannisters
    • SPEX Shatterbox with tungsten carbide grinding vessels
    • X-press, hydraulic

Safety & General Precautions

The pXRF should be set up in a location that is out of the way with minimal people working nearby, but that is also easily accessible with sufficient space to scan section halves. This should be done without disrupting other workstations or without danger of dropping or mishandling section halves or core material. Typical locations have been the Downhole Lab bench, Paleo Lab bench or Correlators' station, if they are not sailing. Consult with the scientists, co-chiefs, and Lab Officer/Assistant Lab Officers for a preferred location for each expedition. Once set up and it has been established which scientists will be trained to use the device (usually two scientists per shift), a dosimeter ring will be issued to each person that will be operating the device and the training technician. Each dosimeter ring has a unique ID and is assigned to a specific person. These dosimeter rings are checked out from the Laboratory Officer.

Use the Bruker Tracer 5 pXRF Safety Presentation PowerPoint found on the desktop of pXRF laptop and the pXRF Safety Information guide on the pXRF Laboratory Manuals page to inform the operating scientists of all safety measures and procedures for the device. Also provide a demonstration of the operation of the device. Make sure to provide the pXRF Safety Information guide and the Bruker Tracer 5 pXRF Quick Start guide for their reference

Sample Preparation

Preparing section halves

If measurements are taken on a section half, of sediment or hard rock, some steps must be taken to protect the device measurement window from puncture or sediment contamination. The beam coverage is about 8 mm2 and the ideal thickness of a sample should be ~1 cm or more.

For sediment cores, the surface of the core must be covered with a thin plastic film (Fig Next, Ultralene, 0.16 mil/4 µ thick, GLAD® wrap is too thick and will interfere with measurements). Cover the area of measurement and about 4-5 cm on each side, so a 10 cm piece of Ultralene would be appropriate. This is to protect the device nose from becoming dirty from the core. If making several measurements in an area, the entire area can be covered. If the entire core section will be measured ('high' resolution measurements), cover the entire core section.  Important! Do not measure on sediment core sections without covering with film, however, do not waste Ultralene® to cover areas that will not be measured (it costs about $1 USD/meter). Tape the film on the sides of the liner and use a Kimwipe on the film to remove any trapped air bubbles under the film in the area of measurement. Cover the rest of the section in GLAD® Plastic Wrap so the instrument and holder does not get dirty. Make sure the top of the plastic is clean, dry, air-free and mud-free, especially the Ultralene®-covered locations. Important! Even a small amount of sediment on top of the thin film from a measurement will affect the next measurement of the core section half.

Figure Next. Ultralene® polypropylene plastic covering the sediment surface.

For hard rock cores, following the procedure at the onshore XRF laboratory in College Station (Texas), no film is put on hard rock sections. The surface is cleaned with DI and Kimwipe. When dried, the core surface is brushed to remove any remaining dust/contaminating particles. The pXRF device is then placed on top of the hard rock core section for measurement.

Preparing powdered samples

Discrete samples are dried, ground to powder, and loaded into a XRF sample cup. Powdered samples allow the analysis of a specific interval or feature on a section half. This process is more involved, time-consuming, and invasive (destructive) compared to the section half measurement. However, powdered samples can be run along with powdered standard reference materials and the data can therefore be reduced for quantitative elemental data. Powdering a sample also creates a homogeneous sample. If the powder is fully homogeneous and the sample cup is loaded to sufficient thickness (~1cm) and uniform powder density, quantitative error should be low.

Drying Samples

It is important to dry discrete samples prior to grinding them. Freeze-dry samples for 12 hours. For details on how to operate the Freeze Dryer refer to the X-Ray Diffraction (XRD) sample preparation

Grinding Samples

Once dry, samples are ground into a talc-like powder. Grinding is accomplished by three methods: agate mortar and pestle, SPEX Mixer/Mill®, or SPEX Shatterbox®. The specific grinding method used is dependent on sample hardness. For more details on grinding methods refer to the X-Ray Diffraction (XRD) Sample Preparation and ICP Hard Rock Prep User Guide.

Loading Samples into an XRF Sample Cup

To create a powdered XRF sample, assemble the following components shown in Figure Aloha:

  • Powdered & dried sample
  • Scoopula
  • XRF sample cups (32 mm Double Open Ended)
  • SPEX Ultralene® thin film (0.16 mil; 4 µm thick) OR Polypropylene pre-cut circles (0.16 mil; 4 µm thick)
  • Whatman Filter Paper Circles (32mm) or Parafilm M® film
  • Foam plug
  • Scalpel for trimming foam plug

Figure Aloha. Mortar and pestle along with scoopula. XRF Sample Cup components denoted with red arrows A. Open-end Ring B. Cup C. Cap D. Ultralene® film box E. Whatman Filter Paper F. Foam plug inserts

1. A XRF Sample cup has three components: cup, ring, and cap. Take a piece of Ultralene® film or polypropylene pre-cut circle and stretch it over one end of the cup. Place the open ring over the film and cup and snap it firmly onto the cup. This will create a tight window on one end of the sample cup (Fig. 16, step 1). Ultralene® is very thin and prone to ripping. Check for rips before and after sample powder is added.

2. Flip this unit upside down (film side down) and begin to load the sample into the cup. Remember that the powdered sample will be back loaded. An ideal depth of sample is ~1.5 cm or more, if possible, with the goal being ~1 cm of pressed material. The sample layer cannot be too thin, or X-ray penetration (and the results) will be inconsistent. Make sure the powder is evenly dispersed, maintaining a relatively flat, even surface.

3. Next place a barrier layer on top of the powder, either Whatman Filter Paper or Parafilm®. This creates a seal that prevents contamination and keeps powder secured in place. Take a piece of Whatman filter paper and put it on the powder or cut a square of parafilm, wrap it over the end of the foam plug and push it down inside the cup. Press down evenly until it is firmly on the powder.

4. Insert the foam plug (if not already inserted). Take care not to insert it too quickly and cause air displacement that might disturb the powder. Depending on how much sample has been loaded into the sample cup; a couple centimeters of the foam may need to be chopped off.

5. Once you have filled the unit properly, place another piece of Ultralene® film or a polypropylene pre-cut circle across the back of the sample cup and snap the closed cap on the cup. If you have over-filled the sample cup, this is the point where the film will break, so examine both sides of the cup after you snap the lid on. Tip: place the cap on most of the way as in step 5, but then flip the sample cup over and, holding only the edges, push the sample cup down into the cap until it snaps firmly in place. Holding the sample cup toward the edges allows the film covered surface of the sediment to bulge out as seen in step 6.

6. It is important to create some outward "bulging" of the film so that the powder stays well-packed and stationary. Cracks, gaps, tears in the film or inconsistent filling of the powder will create inconsistent results. Be careful, however, not to pack too tightly or the Ultralene® film will break and you will have to start over.

Your finished product should look like the cup in Figure 16, step 6.

7. Put a sample label onto the cup. Remove excess Ultralene® to help the label stick. The powdered sample is now ready for analysis.

Figure 16: Sample preparation steps for powdered pXRF sample. Note the slight bulge of the sample when correctly filled.

Do not forget to remove the sample from the pXRF sample cup after analysis. A 3D-printed tools exist to help disassemble the sample cup. Put powder back into it's original container or put it in a labeled jar (shipboard residue). Wash and clean the pXRF sample cup components before reusing.

Sample Measurement Set Up

Shielded Holder for section halves - the Tracer must be picked up and moved, do not slide the nose of the device along the core surface!

Desktop Stand

Benchtop Chamber

Instrument Set Up

Begin by installing a fully charged battery or powering the device using an AC power adaptor. Note: The batteries cannot be 'hot swapped'. If a battery is running low, either shut off the Tracer, switch batteries and power it back on again, or plug the AC power in, change the battery, and then unplug the device again. No loss of data will occur when the device is powered off.

If the Tracer has not been used in a while, check that the date and time are correct by going to , then , and select Date/Time.

The Tracer 5 can be operated alone or connected to a laptop. Using Bruker RemoteCTRL , the device screen is mirrored on the laptop. This will be necessary if using the benchtop chamber or the desktop stand.

If using the device alone, skip ahead to 'Login'.

Computer connection

Login to the computer using the login information on top of the computer keyboard.

Username: daq

Password: daq

Power on the instrument by pressing and holding the button above the device screen for a second or so (Figure 1); release the button when it lights up green. The lights under the rail will flash orange and red and there will be some motorized noises. An initialization screen will appear showing the start up progress.

Figure 1. Power button (Left, arrow) and ports, A) Remote port, for connection to optional accessories, B) Power port, C) USB-A port with storage device installed, D) USB Mini-B port, for connection to a computer or laptop. 

Click on Bruker RemoteCtrl shortcut on the desktop (Figure 2). This program simply mirrors the device screen. You will use it to control the device from the computer while measuring your samples. 

Figure 2. Bruker RemoteCtrl program shortcut

Go to File Connect. A window will appear that will show the device serial number, 900G7838. Select it and click Ok (Figure 3). It may take up to 10 seconds or so to connect, then the current device screen will be displayed.

Figure 3. Connecting the device to the computer.

Login

After the device has initialized, a login window will appear (Figure 4). The User login is 12345.

Figure 4. Login screen in Bruker Remote Control

A radiation warning will appear on the screen, press and release the trigger to acknowledge this message. Next, a pop up message will appear that tells you the current configuration; click OK (Figure 5).

Figure 5. Configuration window when initializing the device.

The main device screen contains a large box at the top displaying the status of the X-ray tube. The device will say Not Armed when the X-ray is not armed and the device will say Ready to Test when the X-ray is armed. The X-ray will be disarmed if any of the blue buttons are selected. The device will not be armed until a sample is placed in front of the measurement window or the device is placed against sample material. If the proximity sensor is disabled, the X-ray will still be armed if a sample is removed. Remember the trigger is active! Be aware of where the device is pointed if the proximity sensor is disabled!












Figure 6. The Tracer's main screen display. Left: X-ray is not armed. Right: X-ray is armed and ready to measure.

Application and Settings

The current application can be changed by selecting , choosing a different application type and selecting ‘OK’. This device has 5 applications installed (See Appendix for details). The best application for our purposes is GeoExploration. Each application has different scanning parameters which preferentially pick up some elements better than others. The device will keep the chosen application until manually changed.

Some application settings, such as beam scan duration, can be adjusted by selecting on the main display screen. Three settings can be adjusted (Fig. 1):

  • Duration: This screen will display the number of phases used by the current application. The time in seconds spent on each phase can be adjusted or set to unlimited (ending when the trigger is released). Note: The longer the scan time, the greater the accuracy and precision and the lower the error. For geological samples, 1 minute per phase or longer is not uncommon, but not required.
  • First Result/Test: This is the number of seconds before results will be shown on the display once a measurement has been triggered.
  • Trigger Active: The trigger can be set to ‘Auto’ or ‘Manual’ by selecting this button.
    • Auto: The measurement proceeds by pressing and releasing the trigger. Preferred.
    • Manual: The trigger must be pressed for the duration of the measurement. If the trigger is released at any time during the measurement, measuring will stop.

Figure 1. Settings display screen.

Select ‘Ok’ when finished adjusting or 'Cancel' to return to the previous screen.

Making a Measurement

Edit Sample Information

On the main display, click the ‘Edit Info’ button in the middle of the bottom row of buttons. This screen (Figure 4) is where the sample information is entered. All fields in the right column are editable by double clicking and should be reviewed and changed for each sample:

  • Sample Type:
    • Standard – a powdered standard in a sample cup
    • SHLF – a measurement taken directly on a section half or of a piece from a section half
    • Sample – a powdered sample in a sample cup
  • Expedition: The current expedition
    • Example: 397
  • Site & Hole: The site and hole the sample was taken from
    • Example: U1586A
  • Core/Section: The core number with letter indicating the core type and the section in that core that is being measured or that the sample was taken from. If measuring a standard, enter the standard name.
    • Sample example: 1H/6 or 32X/1
    • Standard example: BCR 2 or BHVO 2
  • TextID: The unique sample number for every sample. This is found on the lower right corner of the typical sample label, example: SHLF11754181. If measuring a standard, use the information from the appropriate QAQC label provided. If a standard does not have a QAQC label, leave this field blank. Note: If the device is connected to the laptop and using Bruker RemoteCtrl software, use the barcode scanner to enter the TextID by scanning the QR code on the section half or sample label.
    • Example: SHLF11744181
  • Top Offset (cm):
    • For a section half or piece from a section half, this is the distance in cm from the top of the core section, example: 34 or 101.5 (Do not put a range!).
    • For powdered samples and standards, use 0.
  • Comment: Use this to provide any additional information, such as a physical description for reference or to indicate a replicate measurement.

Figure 5. The Edit Info display screen.

Select 'OK' in the lower left corner of the screen. The display will return to the main display screen.

Once a measurement is complete, returning to the 'Edit Info' screen will advance the run number in preparation for the next measurement.

Fill out the Log Sheet 

Remember to fill out the Log Sheet as you are editing the sample information. For the current version of the log sheet, do not worry about the Run#, this will be automatically assigned and you can fill that in after the measurement starts. It is important to fill in the Time (in UTC) as this will help the X-Ray technician match up the sample with the measurement and correct any errors, if any, before uploading the data. The most important information is the sample TextID and the Offset (if from a SHLF) as these are unique values needed to upload the data to LIMS.

Execute a Scan

There are 2 ways to initiate a scan:

If the device is connected to the laptop selectTrigger Pull (F6)’ along the top of the RemoteCtrl program window or press F6. The measurement will begin and continue until finished. Note: If the device is moved away from the sample, the measurement will stop!

If you are not connected the laptop press the device to the sample, the proximity sensor will detect a sample and the device will be armed for measurement. Press and release the trigger. The measurement will begin and continue until finished. Note: If the device is moved away from the sample, the measurement will stop!

A beep will sound when the device has finished measuring and the device can be moved away from the sample or repositioned for the next measurement. At this point, the previous measurement’s data has been stored and added to the results file.

The Tracer updates the ‘Data’ folder after each new measurement with an associated .pdz file and also adds the data to the appropriate application .tsv file and .csv ‘Results’ file. Highlight the files you want to download and then select the ‘Download’ option in the toolbar of the program window. A smaller window will appear and here you can select the location you wish to download the files to. Download all data files (.tsv, .csv, and .pdz) to C:\DATA\IN. The .tsv and .csv files will have all measurements that have been taken since the most recent internal memory clean-up, which will typically be done after each site or more frequently depending on the number of measurements executed. After further measurements, downloading again will add only the new measurements, but will replace the .tsv and .csv files with updated versions that will include the new measurements. 

Downloading the Data

To export the results, connect the device to the computer if not already connected. Also, log into the OES using your personal credentials.

Open the Bruker Instrument Tools found on the desktop. Go to Device, then Connect  and select 900G7838. Click Connect (Fig. 6 and 7).

Figure 6. Menu bar of Bruker Instrument Tools.

Figure 7. Connection window of Bruker Instrument Tools.

After connection, a file tree will appear on the left side of the program window (Fig. NN). Select the folder ‘Bruker’ and double click to open it. Then select the ‘Data’ folder and double click to open. 

Figure NN. File tree for the Tracer 5 in Bruker Instrument Tools.

Inside the Data folder is:

  • A .pdz file (spectra files) for each measurement
  • A .tsv file for each application used (i.e. GeoExploration.tsv)
  • A .csv results file named Results.csv

If a USB stick is installed, the data is automatically written to the 'Data' folder on the USB. The Tracer is also set up to save each data measurement to the internal memory as a back up in case the USB stick should fail. The Tracer automatically updates the ‘Data’ folders in the Bruker and USB folders after each new measurement with an associated .pdz file and also adds the data to the appropriate application .tsv file and .csv ‘Results’ file.

Highlight all the files and then select the ‘Download’ option in the toolbar of the program window (Fig. LOL, Box). A smaller window will appear and here you can select the location you wish to download the files to. Download all data files (.tsv, .csv, and .pdz) to C:\DATA\IN (Fig. LOL, Arrow). The .tsv and .csv files will have all measurements that have been taken since the last internal memory clean-up, which will typically be done after each site or more frequently depending on the number of measurements executed. The data can be copied from this folder for data processing.

Figure LOL. Downloading data with Bruker Instrument Tools. The box indicates the download button. The arrow indicates the location to save the data to.

Note: If a set of data is downloaded, then more measurements are created, and then another download is performed to the same file location before the internal memory is cleared, the new .pdz files will be added and a new version of the .tsv  and Results.csv will replace the previous version. No data will be overwritten or lost!

Opening the .tsv file in Excel

The .csv file is not set up well for further data processing, however, the .tsv file can be opened in Excel in a more user-friendly set up.

Open a new workbook and go to the Data tab and select .

You will be prompted to navigate to the folder containing the GeoExploration.tsv file.

Once you find the folder, select All Files from the drop down menu at the bottom right (Fig. 8, Box). Then select the GeoExploration.tsv file and click Import. (Fig. 8).

Figure 8. Importing data from the .tsv files into Excel. The red box indicates where to select 'All Files'.

A window will open showing you a preview of the file. Select 'Tab' from the 'Delimiter' drop down menu options, if it is not already selected. Click Load. (Fig. 9)

Figure 9. Data Preview in Excel of the .tsv file. The red box indicates the correct 'Tab' should be selected as the delimiter.

The data will be imported to Excel in a more useable format (Fig. 10). The columns with the sample information will be the last columns to the right.

Figure 10. Exported file from pXRF device.

This file can then be saved in Uservol (when logged into the OES) to access for data processing. The file may contain repeat data from an earlier download, simply delete the rows of unwanted data.

Uploading data to LIMS

!!! Clearing data from the internal memory and USB!!!

Note: The internal memory of the device is only 512MB (~1200 scans)! Therefore, the internal memory needs to be cleaned up several times an expedition to prevent locking up the device’s onboard computer.  The X-ray technician will take care of this, but keep this in mind if you are performing a lot of measurements!

To clear the internal memory of the device, from the main display screen select , then . Select the 'Delete' option along the top (Fig. 11, Green Box). To keep the run numbers consecutive through the expedition, deselect the 'Reset Assay filename counter' option (Fig. 11, Purple Box). If it is the end of the expedition, leave this option selected and the run number (the same as the file number), will revert back to '1'. Then select .

Figure 11. Backup Data screen. Green box, the Delete option. Purple box, option to select/deselect if you want to reset the run number back to 1.

Additionally, it is important to keep the number of files in the Data folder of the USB low as well. This should also be done each time the internal memory is cleared.

With the device connected to the laptop, open Bruker Instrument Tools and connect to the Tracer. 

Setting Date & Time

Note: If the device is powered off for a significant period of time, it is possible for the internal battery to discharge. The only affect of this will be that the date and time are reset. If the device has not been used for an expedition, check that the date and time are correct before proceeding to measurements.

To set the time, select on the main display screen. Then select and then select Date/Time from the available list. A stylus or fine pointed tool (non-metal, such as a wooden applicator stick) is helpful to access the small buttons involved in setting the date and time.

In the screen that displays (Fig. XX), change the date by selecting on year, month and the numerical day. The time can be changed by using the selecting the hour, minute, second and AM/PM and using the small arrows to the right of the box to adjust the number. Please set the device to UTC time (NOT the same as ship operation time). If unsure what UTC time is, check the time on the nearest lab computer.

Once the correct date and time is shown (as close as possible), select ‘Apply’ and then ‘OK’ to exit the screen.

Figure XX. The date and time setup screen.

Disconnecting and Closing Programs


Appendix

Application Calibration Information

GeoExploration/GeoMining

Limestone

Precious Metals 2

Mudrock 2 Air

Mudrock 2 He

LIMS Component Table


PLACEHOLDER until the new PXRF components and data structure is defined
ANALYSISTABLENAMEABOUT TEXT
PXRFSAMPLEExpExp: expedition number
PXRFSAMPLESiteSite: site number
PXRFSAMPLEHoleHole: hole number
PXRFSAMPLECoreCore: core number
PXRFSAMPLETypeType: type indicates the coring tool used to recover the core (typical types are F, H, R, X).
PXRFSAMPLESectSect: section number
PXRFSAMPLEA/WA/W: archive (A) or working (W) section half.
PXRFSAMPLEtext_idText_ID: automatically generated database identifier for a sample, also carried on the printed labels. This identifier is guaranteed to be unique across all samples.
PXRFSAMPLEsample_numberSample Number: automatically generated database identifier for a sample. This is the primary key of the SAMPLE table.
PXRFSAMPLElabel_idLabel identifier: automatically generated, human readable name for a sample that is printed on labels. This name is not guaranteed unique across all samples.
PXRFSAMPLEsample_nameSample name: short name that may be specified for a sample. You can use an advanced filter to narrow your search by this parameter.
PXRFSAMPLEx_sample_stateSample state: Single-character identifier always set to "W" for samples; standards can vary.
PXRFSAMPLEx_projectProject: similar in scope to the expedition number, the difference being that the project is the current cruise, whereas expedition could refer to material/results obtained on previous cruises
PXRFSAMPLEx_capt_locCaptured location: "captured location," this field is usually null and is unnecessary because any sample captured on the JR has a sample_number ending in 1, and GCR ending in 2
PXRFSAMPLElocationLocation: location that sample was taken; this field is usually null and is unnecessary because any sample captured on the JR has a sample_number ending in 1, and GCR ending in 2
PXRFSAMPLEx_sampling_toolSampling tool: sampling tool used to take the sample (e.g., syringe, spatula)
PXRFSAMPLEchanged_byChanged by: username of account used to make a change to a sample record
PXRFSAMPLEchanged_onChanged on: date/time stamp for change made to a sample record
PXRFSAMPLEsample_typeSample type: type of sample from a predefined list (e.g., HOLE, CORE, LIQ)
PXRFSAMPLEx_offsetOffset (m): top offset of sample from top of parent sample, expressed in meters.
PXRFSAMPLEx_offset_cmOffset (cm): top offset of sample from top of parent sample, expressed in centimeters. This is a calculated field (offset, converted to cm)
PXRFSAMPLEx_bottom_offset_cmBottom offset (cm): bottom offset of sample from top of parent sample, expressed in centimeters. This is a calculated field (offset + length, converted to cm)
PXRFSAMPLEx_diameterDiameter (cm): diameter of sample, usually applied only to CORE, SECT, SHLF, and WRND samples; however this field is null on both Exp. 390 and 393, so it is no longer populated by Sample Master
PXRFSAMPLEx_orig_lenOriginal length (m): field for the original length of a sample; not always (or reliably) populated
PXRFSAMPLEx_lengthLength (m): field for the length of a sample [as entered upon creation]
PXRFSAMPLEx_length_cmLength (cm): field for the length of a sample. This is a calculated field (length, converted to cm).
PXRFSAMPLEstatusStatus: single-character code for the current status of a sample (e.g., active, canceled)
PXRFSAMPLEold_statusOld status: single-character code for the previous status of a sample; used by the LIME program to restore a canceled sample
PXRFSAMPLEoriginal_sampleOriginal sample: field tying a sample below the CORE level to its parent HOLE sample
PXRFSAMPLEparent_sampleParent sample: the sample from which this sample was taken (e.g., for PWDR samples, this might be a SHLF or possibly another PWDR)
PXRFSAMPLEstandardStandard: T/F field to differentiate between samples (standard=F) and QAQC standards (standard=T)
PXRFSAMPLElogin_byLogin by: username of account used to create the sample (can be the LIMS itself [e.g., SHLFs created when a SECT is created])
PXRFSAMPLElogin_dateLogin date: creation date of the sample
PXRFSAMPLElegacyLegacy flag: T/F indicator for when a sample is from a previous expedition and is locked/uneditable on this expedition
PXRFTESTtest changed_onTEST changed on: date/time stamp for a change to a test record.
PXRFTESTtest statusTEST status: single-character code for the current status of a test (e.g., active, in process, canceled)
PXRFTESTtest old_statusTEST old status: single-character code for the previous status of a test; used by the LIME program to restore a canceled test
PXRFTESTtest test_numberTEST test number: automatically generated database identifier for a test record. This is the primary key of the TEST table.
PXRFTESTtest date_receivedTEST date received: date/time stamp for the creation of the test record.
PXRFTESTtest instrumentTEST instrument [instrument group]: field that describes the instrument group (most often this applies to loggers with multiple sensors); often obscure (e.g., user_input)
PXRFTESTtest analysisTEST analysis: analysis code associated with this test (foreign key to the ANALYSIS table)
PXRFTESTtest x_projectTEST project: similar in scope to the expedition number, the difference being that the project is the current cruise, whereas expedition could refer to material/results obtained on previous cruises
PXRFTESTtest sample_numberTEST sample number: the sample_number of the sample to which this test record is attached; a foreign key to the SAMPLE table
PXRFTESTTop depth CSF-A (m)Top depth CSF-A (m): position of observation expressed relative to the top of the hole.
PXRFTESTBottom depth CSF-A (m)Bottom depth CSF-A (m): position of observation expressed relative to the top of the hole.
PXRFTESTTop depth CSF-B (m)Top depth [other] (m): position of observation expressed relative to the top of the hole. The location is presented in a scale selected by the science party or the report user.
PXRFTESTBottom depth CSF-B (m)Bottom depth [other] (m): position of observation expressed relative to the top of the hole. The location is presented in a scale selected by the science party or the report user.
PXRFRESULTdatetimeRESULT datetime: date/time stamp for each run
PXRFRESULTmodeRESULT mode: the calibration selected for the run (e.g., Geochem, Mudrock)
PXRFRESULTrun_numberRESULT run number: serial number of the run (incremented by the instrument for each sample)
PXRFSAMPLEsample_nameSAMPLE sample name: repeated display of the sample label ID from the SAMPLE table
PXRFRESULTreadingRESULT reading number: human-input run number for each sample
PXRFRESULTrun_spm_asman_idRESULT spectrum file ASMAN_ID: serial number of the ASMAN link for the spectral raw data (.SPM) file
PXRFRESULTrun_spm_filenameRESULT spectrum filename: file name for the spectral raw data (.SPM) file
PXRFRESULTrun_main_asman_idRESULT main report ASMAN_ID: serial number of the ASMAN link for the reduced data table (.CSV) file
PXRFRESULTrun_main_filenameRESULT main report filename: file name for the reduced data table (.CSV) file
PXRFRESULToffset (cm)RESULT offset (cm): position of the observation made, measured relative to the top of a section half.
PXRFRESULTresult commentsRESULT comment: contents of a result parameter with name = "comment," usually shown on reports as "Result comments"


ARCHIVE


LN-BrukerpXRFHandheld-270922-1259-68.pdf - September 27, 2022




  • No labels