# Presentation: 871614

## LANL Laser Inventory Database

**LANL Laser Inventory Database**

**Scott R. Greenfield**
**Los Alamos National Laboratory**
**4****th**** Annual LSO Workshop**
**July 17, 2008**
**Albuquerque, NM**

## History

**History**

**14 July 2004: Laser eye accident and subsequent LANL shutdown.**
**December 2004: Chemistry Division starts work on database for division’s lasers (one of conditions for restart of laser ops).**
**January 2005: Chemistry Laser Database becomes operational.**
**March 2005: LANL LSO expresses interest in taking Chemistry database institution-wide.**
**November 2005: Beta testing of LANL Laser Database.**
**April 2006: LANL Laser Database goes operational; Chemistry shuts its down.**
**November 2006: Phase II development commences.**
**September 2008: Target for Phase II completion.**

## Why Are We Doing This?

**Accurate tracking of lasers is *****not***** a requirement of ANSI Z136.1, however...**
**At times over the last several years, LANL, LANS, and DOE have asked about the number of lasers at LANL, their locations, classification, etc.  Prompt, accurate responses have heretofore not been possible.**
**February 2005 DOE “Special Operations Report: Laser Safety” (aka “Brooks memo”) dictates that:**
**   “****LSOs maintain a comprehensive, accurate inventory of lasers in use onsite.”**
**Ongoing database enhancement will replace the use of our standard laser registration form (1552); this and other enhancements will make it a useful tool for laser users and LSOs alike.**
- Absolutely imperative that this is perceived as value-added, rather than yet another useless impediment to getting work done.

*Slide *

## Historical “Registration”

**Historical ****“Registration”**

**Form was a manual way to get info to LSO for Hazard Evaluation, and provide needed info back to laser users.**
**No serious effort ever made to consolidate records. **
- Coming and going of LSOs made gathering records nearly impossible.

*Slide *

## What Are We Tracking?

**Only Class 3B and Class 4 lasers.**
- Embedded lasers are *not* being tracked.
- Only operational lasers are *required* to be tracked.
- If a laser goes inactive, it is marked as such rather than being removed from the database.
**Four main groups of information:**
- Whose, what, where, status
- Safety (IWM)
- Hazard Evaluation input (i.e., performance parameters)
- Hazard Evaluation output (e.g., eyewear OD requirement)

## Start Page

*Slide *

**Comes up with a sortable list of all Class 3B and Class 4 lasers at LANL.**

## Can Search Under a Number of Criteria and Find Lasers

*Slide *

- ...e.g., who else has your laser.

## Laser Main Page

**Shows three sections:**
- Ownership, Property, Status(can handle up to 3 locations).
- Safety (IWM)
- Hazard Evaluation Input Information

## Operational Mode

**Many lasers can have multiple sets of performance characteristics.  Rather than creating a unique entry in database for each, restricted entries to unique physical entities.**
**Created ability to have one or more “operational modes” to handle multiple sets of performance characteristics.**
- Each operational mode has corresponding independent set of Hazard Evaluation output data fields.

*Slide *

## Beam Spatial Mode Options

**Can choose between four standard free-space beam spatial modes, or two fiber modes.**
**Lens-on-laser is not yet implemented.**

*Slide *

## Hazard Evaluation Input

**Contains all information needed about laser needed to perform hazard evaluation.**

*Slide *

## Hazard Evaluation Output

**Database has fields for the most important output parameters of the hazard analysis.**

*Slide *

## Permissions / Security

**Database access is restricted by CryptoCard authentication.**
**Anyone (with CrytoCard) can create new entry in the database.**
**Existing entries can be modified by only the laser owner, PIC, IWD author, or LSO.**
**LSOs can modify any laser.**
**Hazard Evaluation *****output***** fields may be entered **_***only***_** by an LSO, with that LSO’s identity recorded.**
**Future enhancement will lock all fields for a given entry in case some data might be sensitive or classified, preventing others unknowingly entering data and compromising security.**

*Slide *

## I/O with Commercial Hazard Analysis Software

**Communication is currently available only with EasyHaz from Laser-Professionals Inc.**
- I/O is done with simple text files (same format for both directions).
**Database (beta) can write file that is read by EasyHaz.**
**Current effort is to close loop and create capability for database to read file created by EasyHaz, and parse info into appropriate fields.**
- This upload capability will be limited to LSOs.
- Actual text file will need to be stored in database as “attachment,” permanently documenting full details of analysis.

*Slide *

## Laser Lab Summary Sheet

**Desire is to create summary sheet that condenses the most important info from many lasers (each potentially with many operational modes) for a given lab or IWD  into one simple tabular sheet.**
- User will interactively choose which lasers (and operational modes thereof) are to be summarized.
**This will be a significant enhancement to existing safety documentation, which might have a scores of pages of detailed analysis sheets that are largely incomprehensible to laser users.**
- Those already manually condensing into tables risk transcription errors, and must spend nontrivial effort generating these tables.
**Format of summary sheet not yet decided, but will likely be based on LLNL “Laser Table” form.**

*Slide *

## Slide <number>

## IT Details

**Application originally written in .ASP with a SQL Server database**
**Converted to .NET; data migrated to an enterprise Oracle 10g database**
**CryptoCard authentication and electronic authorization**
**Runs on a Windows 2003 Server, Internet Information Services (IIS) 6.0**
**Record of all changes are permanently archived**

*Slide *

## Path Forward of Database

**Database enhancements scheduled to be completed by end of FY08.**
**Estimated effort to clean up code for maximum portability to other DOE sites: 0.75 FTE in FY09.**
- Thereafter, would be fairly straightforward for sites’ local IT folks to get operational on local systems.
- By-product of effort would be to make “look & feel” of database more modern.

*Slide *

## Conclusions

**LANL Laser Database has been operational for two years, fulfilling local and  DOE mandates.**
**Phase II augmentations will be of significant benefit to LSOs and laser users, providing**
- Convenience.
- Avoidance of transcription errors/typos that could compromise safety.
- Ability to trivially generate lab summary sheets for multi-laser labs, which will be a vast improvement over existing practices.
**Moderate effort level required to make portable for use throughout DOE complex.**
**Key element to success will be to make users and LSOs feel this is value-added for them.**
**After initial database population, should be low effort by users and LSOs to keep up-to-date.**

## Acknowledgements

**Programmers:**
- Amy Herrera
- Michael Montoya
- Shawn Rivera
- Roger Anaya
**Funding:**
- LANL overhead through the Industrial Hygiene and Safety organization (Theresa Cull)

*Slide *