MC&A Software Assistance to Ukraine
ABSTRACT
AIMAS (Automated
Inventory/Material Accounting System) is a PC-based application that is
being developed as part the US assistance program to Ukraine in Nuclear
Material Protection, Control, and Accounting (MPC&A). The AIMAS software
prototype was designed to provide a starting point for joint US/Ukraine
system development. Computer systems with AIMAS prototypes have been installed
at Kiev Institute of Nuclear Research (KINR), South Ukraine Nuclear Power
Plant (SUNPP), Kharkiv Institute of Physics and Technology (KIPT), Sevastopol
Institute of Nuclear Energy & Industry (SINEI) and the Ministry of
Environmental Protection and Nuclear Safety (MEPNS). AIMAS is being developed
using Microsoft Access 2.0, a windows-based relational database management
system (RDBMS) and application development environment. It has been
designed to be highly flexible and configurable, and to support a wide
range of computing infrastructure needs and facility requirements. AIMAS
functions include basic physical inventory tracking, transaction histories,
reporting, and system administration functions (system configuration and
security). Security measures include multilevel password access controls,
all transactions logged with the user ID, and system administration controls.
Interfaces to external modules are being designed to provide nuclear fuel
burn-up adjustment and bar code scanning capabilities for physical inventory
taking.
OVERVIEW
AIMAS (Automated
Inventory/Material Accounting System) is a PC-based application for nuclear
material control and accountability, which runs under Microsoft Windows.
It is being developed as part of the US Department of Energy Assistance
Program to Ukraine in Material Protection, Control, and Accounting (MPC&A).
This is a cooperative effort involving specialists from the United States
and Ukraine. The first AIMAS software prototype was installed on computers
delivered to Kiev Institute of Nuclear Research (KINR) and the South Ukraine
Nuclear Power Plant (SUNPP) in June 1995. The prototype was designed to
provide a starting point for joint US/UkTaine system development. Subsequently,
AIMAS prototypes have been installed at Kharkiv Institute of Physics and
Technology (KIPT), Sevastopal Institute of Nuclear Energy & Industry
(SINEI), and the Ministry of Environmental Protection and Nuclear Safety
(MEPNS).
The features
of AIMAS include:
AIMAS is
being developed using Microsoft Access 2.0, a relational database management
system (RDBMS) and application development environment designed specifically
for MS Windows, which supports standalone, networked, and client/server
platforms. Access has recently become the most widely used PC Windows-based
RDBMS, which should help insure a long product life for AIMAS. Although
Access 95/97 has been released for the Windows 95/NT operating system,
AIMAS has continued to be developed with Access 2.0 to provide operability
within both Windows 3.1 and Windows 95. Access 95/97 is not compatible
with Windows 3.1, which is still in widespread use in the United States
and FSU.
A primary
objective of the AIMAS project has been to work cooperatively to achieve
an MC&A capability that meets the needs of the facilities and the state-level
IAEA reporting requirements. The approach taken to achieve this objective
has been to field an initial software prototype early and take an evolutionary
approach (build a little, test a little). US and Ukrainian MC&A experts
and developers have been involved in the prototype iterations.
In order
to support a wide range of computing infrastructure needs to meet a variety
of FSU nuclear facility requirements, AIMAS has been designed to be highly
flexible and configurable. AIMAS takes a Material Balance Area (MBA) concentric
view of a facility, and permits Material Control and Accountability (MC&A)
inventory databases to be distributed over one or more computer systems.
AIMAS design functions include basic physical inventory tracking, transaction
histories, reporting, and system administration functions (system configuration
and security). External applications that interface with AIMAS provide
burn-up adjustment capability and bar code data entry.
Simplicity,
redundancy, and security have been major design goals. For example, a standalone
PC can be assigned one or more KMPs, with inventory transfers between PCs
synchronized with diskette data transfers. A transaction verification process
is enforced by the software design to insure that items transferred to
another PC are properly entered on the correct destination computer system.
Any PC can assume the duties of a failed PC to maintain high system availability.
Security measures include multilevel password access controls, all transactions
logged with the user ID, and system administration controls.
The security
and redundancy is further enhanced by the system hardware specification,
which makes use of computers with all removable media, including high performance
removable SCSI disk drives. The standard system hardware configuration
calls for a single drive bay, which accommodates a removable SCSI disk
with a key lock to permit all MC&A activity to be isolated from general
purpose computing. Two SCSI boot disks are used with each system, one for
general purpose computing and one for MC&A application only. With management
controls (limiting access to the MC&A disk to authorized personnel,
and limiting use of this disk for MC&A application only), this limits
the possibility of unauthorized access to the MC&A data and the possibility
of virus contamination from general-purpose users of the system. In case
of a computer system failure (not involving a disk failure), the removable
MC&A drive may be used in any other MC&A computer configured for
removable media. In the case of disk failure, the tables for the failed
system can be moved to another MC&A computer from backup data.
BASIC FUNCTIONALITY
Before
running AIMAS for the first time, a set-up wizard is run to create an initialization
disk used to configure the AIMAS computers. The set-up wizard is run by
the system administrator to specify the MBAs, which make up the material
and accounting system, and to specify how the MBAs are distributed (if
divided among more than one PC). In addition, the set-up allows the system
administrator to specify the item locations within each MBA and the standard
item descriptions common to all MBAs. This insures that the locations and
descriptions, which are used in the drop down lists of the AIMAS data input
form, are specified in a consistent manner on all AIMAS computers. In addition,
the system administrator can customize the database for their facility
through the implementation of User Defined Fields (UDFs) and reports.
AIMAS has
four major functional areas: inventory browser and updates forms, reports,
material transfers, and system administration utilities. Each of these
functional areas may be selected from the AIMAS main switchboard panel.
The AIMAS graphical user interface showing the main switchboard panel,
browser form, and import/export form is shown in Fig. 1.
Inventory
Forms
The main
browser form displays the fields for a particular item. Navigation buttons
permit moving through records (forward, back, first, last, find). A historical
transaction subform may be opened to view all transactions for a particular
item (listed with most recent transactions at the top). Currently there
are 21 different transactions, including domestic receipt or shipment,
accidental gain or loss, discrepancy between shipper and recipient, nuclear
losses or production, etc. The records in the historical data subform are
automatically generated and provide an audit trail of all transactions
involving Items in the inventory.
Data entry
functions are also available from the main browser form for import, transfer,
edit, and new item creation. A filter can be applied to change the order
of records (sorted on a specified field) or to display a subset of the
inventory (e.g., view only fuel assemblies of a certain type). The inventory
can also be viewed in a data table (spreadsheet) view which allows scrolling,
rearranging and/or hiding columns, and creating ad hoc reports. The table
view also permits records to be easily copied and pasted into other applications,
such as a word processor or spreadsheet.
DESIGN APPROACH

Reporting
Currently,
AIMAS can generate the following reports: physical inventory, general ledger,
inventory change document, material balance report, and any custom reports
added by the facility. As noted, ad hoc reports can also be made in table
view of the physical inventory. Microsoft Access provides many powerful
reporting tools, which permit a wide range of other reports to be made.
Material Transfers
AIMAS has
the capability to handle single or multiple item transfers within an MBA
(intra-MBA transfer) or between MBAs (inter-MBA transfer). For a multiple
item transfer, the user can either check off which items to transfer or
use a select query to define the transfer set. If a transfer is made to
a location corresponding to a database table on the same PC, the transfer
is performed immediately and the physical inventory and historical data
tables are updated. If the transferred is made to an MBA or KMP corresponding
to a database on a different PC, then the item information must be transferred
to the destination PC by creating an MBA Transfer Disk. AIMAS will
prompt the user to insert a floppy diskette into the originating PC and
generate the transfer file. The MBA transfer diskette must be inserted
into the receiving PC to transfer the records. After the records have been
transferred, the MBA transfer diskette must be returned to the originating
PC to close out the transaction. Until the transaction is closed, the items
are marked IN TRANSIT to indicate that the transfer transaction has not
been verified.
AIMAS also
has import and export capabilities to transfer records between other (non-AIMAS)
computer systems. These capabilities are described in the section External
Interface Support below.
Templates
can be reused later to simplify the process of performing periodic data
imports or exports. For example, this feature could be used to make periodic
burn-up adjustments, which are calculated by another computer program.
Another common use of the import is to transfer records to AIMAS from another
MC&A system due to the receipt of a shipment of items from another
facility.
Bar Code Entry
An example
of an external application used with AIMAS is a bar code reader. Bar code
entry is a fast alternative to keyboard entry and is not susceptible to
transcription errors. Modern bar code readers are actually microcomputers,
so they can be programmed to prompt users and record data for use with
AIMAS.
The bar
code reader is programmed to display a menu on its liquid crystal display
(LCD). The user selects an option from the menu and the bar code reader
prompts the next action until the transaction is complete. In a typical
transaction, the user will select a transaction type (new material, internal
or external transfer). The item, location, and seal identifiers will be
scanned to complete the transaction record. Data entry can be done as single
transactions, or an entire room can be inventoried at once. Data is stored
in an ASCII format and imported into the AIMAS database.
Burn-up Adjustments
A nuclear
reactor operating under IAEA Safeguards is required to report the isotopic
content of its fuel. Periodic burn-up calculations provide the means to
obtain predicted partially burned and spent fuel isotopics. First, neutron
cross sections must be generated in few-group form, accounting for basic
fuel design parameters and prior exposure history. The AIMAS database provides
necessary information for this step. Second, those cross sections are used
in a multidimensional reactor neutronics solution for instantaneous flux
and power distributions. Third, a burn-up calculation is made to account
for neutron-induced reactions such as fission and capture, which lead to
buildup and decay of fission products and transuranics.
The PSU-LEOPARD
code has been selected for 4-group cross sections and modified to produce
a standard output binary library usable by the neutronics/burn-up code
VENTURE-PC. VENTURE-PC has been upgraded by eliminating problem size restrictions,
benchmarked for validity, and modified to create output data files for
interfacing to AIMAS, which in turn provides the end-of-step fuel isotopic
composition and energy production information to AIMAS. Since cross section
generation takes such little computation time, the above sequence of calculations
are performed at nominally monthly intervals throughout the life of a reactor
core loading, thereby obtaining burn-up-dependent cross sections.
FUTURE DIRECTIONS
It was
recognized early during the MPC&A Assistance Program that Ukrainian
participation in the development efforts was needed to ensure success.
AIMAS was designed to provide a starting point for joint US/Ukraine system
development. The initial prototypes were delivered to sites in Ukraine
to elicit comments and help direct subsequent effort. As the work continues
the Ukrainian MC&A specialists are becoming more involved in customizing
AIMAS to the needs of their facilities.
Additional
training in automated data processing was an area identified by the MPC&A
Assistance Program as valuable to Ukraine. The degree of computer literacy
of the Ukrainian MC&A specialists who will be operating the nuclear
material accounting systems varies widely. In order to prepare the MC&A
specialists to work with a computerized accounting system, DOE is offering
courses in automated data processing in Ukraine. These courses range from
basic MS Windows operation to programming in MS Access. This training,
together with that provided by LANL in MC&A systems and Measurement
Statistics, will help prepare Ukrainian specialists for the automated MC&A
systems used in the international community.
Ukrainian
specialists are working to adapt AIMAS for the Ukrainian environment. Documentation
and screens have been translated from English to Russian. The product is
then reviewed by US and Ukrainian specialists to insure that the translations
are correct and can be understood by MC&A specialists. Ukrainian specialists
are also testing and evaluating AIMAS against the needs of the facilities
to track nuclear material and to provide reports for the state regulatory
agency. Ukrainian and US specialists will work together to produce a production
version of the code which can be used by the facilities in routine operation.
AUTHORS
T. Ewing,
C. McWilliams, A. Olson,
System
Administration Utilities
AIMAS
provides the system administrator with several features for system configuration
management and security. AIMAS has support for users that require different
levels of access. The system administrator is a special user that has privileges
to create other user accounts and configure the AIMAS systems. Below the
system administrator are two classes of users: read/write user (has the
ability to view, enter, modify, report, and transfer data), and the read/only
user (can only view data and generate reports). The system administrator
can also configure the drop-down lists that appear in AIMAS, as well as
perform functions previously described during the initial setup.
EXTERNAL
INTERFACE SUPPORT
AIMAS
provides a generalized import/export feature to provide an external interface
to other applications. The import feature permits users to read data and
effect transactions from a file. Imports can be made from character delimited
or fixed field-width ASCII files. Exports can be additionally made to a
DBF (dBase) file. AIMAS permits the user to create and store templates
describing the format of the import/export file. Items that are imported
are held in a temporary table and examined by AIMAS for format errors (for
example, does a date field contain a valid date?) and may be previewed
in a data sheet before committing to the AIMAS database.
C. Roche,
H. Forsmann, and G. Walters
Argonne
National Laboratory
R. Chen
and Gary Sheppard
Los Alamos
National Laboratory
R. Ceo
and K. Thompson
Oak Ridge
National Laboratory
George
Kuzmycz
US Department
of Energy Headquarters
NIS Nuclear Profiles Database
© 1998, 1999; All Rights Reserved
Center for Nonproliferation Studies
Monterey Institute of International Studies
Monterey, CA 93940
(831) 647-4154
Comments or questions? Contact Michael Jasinski at MIIS
CNS: Michael.Jasinski@miis.edu