Publications

The Monitoring Systems Technology Center (MSTC) at Sandia National Laboratories has recently upgraded its Satellite Parts Inventory Forms 3.0 application to Developer/2000 for the web. This involved changing from a character based Forms 3.0 system on an HP-UX 9000 database and forms server to a GUI forms 4.5 web- based system on Windows NT 4.0 Forms Serve. The need to migrate the MSTC Satellite Parts Inventory System to a newer supported software environment, that was easy to access and use, and was year 2000 compliant, drove the migration from forms 3.0. This paper will examine the steps of this successful migration to a web environment in detail. The MSTC Satellite Parts Inventory System includes a parts inventory application for inventory management of flight qualified electronic parts. This application tracks parts from receipt to fabrication, including manufacturer information such as lot and date, and quantities data such as lot totals, quantity on order and reorder levels. The system keeps a current count of parts that are used in kitting modules/assemblies for fabrication, does automated picks of the oldest parts, and allows suggested parts to be pulled or put back in stock and the required part pulled in place of the system suggested part. The system also flags and notifies component engineers of parts that fall below a certain level and includes traceability of parts to module record of assembly (ROA), module ROA repairs, drawings definition, CAD queue scheduling, purchase requisition records, and module action and document management.

A comprehensive environmental sample management program allocates much of its resources to collecting, managing, and manipulating information. A computerized system that collects information at the field sampling point, tracks the sample to analytical labs and loads electronic data deliverables from these labs, while maintaining chain of custody and data integrity, is efficient and cost effective for providing consistent and accurate, legally defensible sample data. In June 1993, a team was formed to gather Sample Management Office requirements and begin development of a sample tracking system. This paper is an overview of experiences encountered when Sandia transferred and implemented sample software from the Waste Area Group (WAG6) at ORNL.

Hazardous materials management includes interactions among materials, personnel, facilities, hazards, and processes of various groups within a DOE site`s environmental, safety & health (ES&H) and line organizations. Although each group is charged with addressing a particular aspect of these properties and interactions, the information it requires must be gathered into a coherent set of common data for accurate and consistent hazardous material management and regulatory reporting. It is these common data requirements which the Cradle-to-Grave Tracking and Information System (CGTIS) is designed to satisfy. CGTIS collects information at the point at which a process begins or a material enters a facility, and maintains that information, for hazards management and regulatory reporting, throughout the entire life-cycle by providing direct on-line links to a site`s multitude of data bases to bring information together into one common data model.