ML20211Q197

Radiography Repts 10CFR34.30:Database for Cataloging & Analysis of Repts Submitted to USNRC & Agreement State Per 10CFR34.30 or Similar Provisions of Agreement State, Version 2.0

ML20211Q197
Person / Time
Issue date:	08/31/1994
From:	Perkins M NRC
To:
References
SSD, NUDOCS 9710220175
Download: ML20211Q197 (17)

Text

_.

(,

Radiography Renorts 34.30 v-2 A Datalusefor the Cataloging and Analysis of Reports Sulnnitted to the USNRC and Agreement States pursuant to 10 CFR 34.30 or similar provisions of an Agreement State Version 2.0 Michael J. Perkins Sealed Source Safety Section August 1994 9710220175 940831 m"

unws d8* SE' ~

/SS

/3

i TABLE OF CONTENTS

1. Introduction 1

11. Included in This Binder 1

111. 5 ;ucture 1

IV. Database Structure 2

V. Installation 4

VI. Directions for Running Reports 34.30 6

Welcome Screen 7

Main Menu 8

Browse Menu 9

Repons Menu 10 Quitting Reports 34.30 11 Appendix A: Description Codes 12 Appendix B: Cause Codes 13 Appendix C: Files on Reports 34.30 Prograr:. Diskettes 14 Appendix D: Changes Since Last Version 15 Appendix E: Samples of Reports 16 Appendix F: Source Code Listing 17

1. INTRODUCTION On January 10,1990,10 CFR 34.30 was enacted, to become effective on January 10, 1991. It requires that certain incidents involving radiographic equipment be reported to the USNRC within thiny days of the incident, such as when the source assembly becomes disconnected, the source is not able to be retracted into its fully shielded position, or when any component critical to the safety of the device fails.

The Scaled Source Safety Section, which receives these reports, decided that the reports should be cataloged and analyzed to determine if cenain commonalities exist between the reports, such as certain devices or sources being involved in a disproportionate number of incidents or a certain cause occurring too often for a given model of equipment or manufacturer so that any problems this analysis may illuminate could be addressed.

Reports 34.30 was created to fill this role in November of 1991. This second edition of the program was complied and created in August 1994.

11. INCLUDED IN THIS BfNDER In this binder, you should have:

• one 3.5" program diskette

• two 5.25" program diskettes

• this manual The diskette: should be found in the clear plastic diskette protector sheet at the back of this binder. Check to be certain that they are there. If something is missing, or if a diskette is faulty, contact the Scaled Source Safety Section at (301) 415 7273 to obtain a replacement.

III. STRUCTURE Repons 34.30 and its associated files require two application programs: dBase Ill Plus (version 1.1 or later) and RPTS34. dBase 111 Plus is required to edit the database file itself. RPTS34 is a stand-alone application written and compiled in CA Clipper 5.2. It is used to view and analyze the database records. These records are stored in a database file created and edited using dBase 111 Plus. A list of files required to rtm the Reports 34.30 program can be found in Figure Ill 1 (next page).

The RPTS34.EXE file contains the application Reports 34.30. The.DBF and.DBT files are dBase 111 Plus files. The database information accessed by the RPTS34 application is in the.DBF and.DBT files, which contain the data and memo fields, respectively. The

.SCR and.FMT files on the list are dBase 111 Plus files that combine to make up a screen format used for entering and editing individual records, 1

Figure 1111. A list of Reports 34.30 files RPTS34.EXE Main application file RPTS34.DBF Database file RPTS34.DBT Database memo field file ENTRDATA.SCR Screen file for entry / editing ENTRDATA.FMT Format file for ENTRDATA.SCR IV. DATABASE STRUCTURE T

The RPTS34.DBF database file is where the actual information used in the Reports 34.30 program is stored. T1.is file has twenty seven tields, or pieces of information stored, in each record. There is one record for each repon submitted to USNRC under 10 CFR 34.30. A list of these fields can be found in Figure IV-1 (next page).

Repon information is stored in the fields as follows. Fields 15 contain the name and address information for the reporting company. Field 6 contains the name of the person at the company to contact for more information about the incident. Field 7 contains the telephone number of the company's office (as a ten-digit number). Fields 8 and 9 contain the date and time (in 24 hr. format) the incident occurred. Field 10 contains the date the incident was reported. Fields 1115 contain the site and address, if known, of tl.e incident site. Fields 16 and 17 contain the manufacturer and model number of the equipment involved in the incident. Fields 18 and 19 contain the manufacturer and model number of the source involved in the incident. Fields 21 and 22 are, respectively, a letter code for the general description of the incident and a memo field containing a more detailed description of the incident. Fields 23 and 24 store equivalent information relating _

to the cause of the incident. Field 24 is a memo field containing the action (s) taken on site to normalize operations after the incident. Field 25 is a memo field containing the action (s) taken by the company to prevent a reoccurrence of the incident. Fields 26 and 27 contain letter codes giving the title of the people involved in the incident and the titles of the people responsible for the incident.

2

FIELD FIELD NAhtE FIELD TYPE WIDTil 1

CO_NAhiE Character 30 2

CO_ ADDRESS Character 30 3

CO_ TOWN Character 15 4

CO_ STATE Character 2

5 CO_ ZIP Character 9

6 CONTACT Character 25 7

PilONE Numeric to 8

INCIDATE Date 8

9 INCITIME Character 5

10 DATERPRTD Date 8

11 INCL _ SITE Character 30 12 INC_ADRES Character 30 13 INC_ TOWN Character 15 14 INC_ STATE Character 2

15 INC_ ZIP Character 9

16 MANUPACTR Character 20 17 MODEL_NO Character 15 18 SRCE_MFR Character 20 19 SRCE_ CODE Character 15 20 DESCRIPTN Character 1

21 DESC_DETL Memo 10 22 CAUSE Character 1

23 CAUS_DETL Memo 10 24 NORM _ACTN Memo 10 25 CORR _ACTN Memo 10 26 TITLEINVLV Character 1

27 PPLRSPNSBL Character 1

Figure IV l. A list of the fields in Reports 34.30 database file L

3

u V. INSTALLATION A. System Requirements:

1. IBh1 or compatible

2. 512 kB RAM 3.1 MB hard drive storage B. Install Reports 34.30 Using 3.5" diskette

1. If you are upgrading from a previous version of Reports 34.30, skip to step 5,

2. Type C: and press the RETURN key to get to your hard drive's directory.

3. Type CD\\ and press the RETURN key to be certain you are in the root directory of your hard drive.

4. Type MKDIR \\RPTS34 and press the RETURN key to make a new directory on your computer's hard drive called RPTS34.

5. Enter the RPTS34 directory by typing CD\\RPTS34 and pressing the RETURN key at the DOS prompt.

6. Insert the 3.5" program diskette into your B: disk drive.

NOTE: It has been assumed for these instructions that your HARD DRIVE is the C drive, your 5.25" floppy drive is your A drive, and that your 3.5" floppy drive is your B drive.

If these are not true, please be sure to use the correct drive specifier for your computer. For example, if your 3.5" drive is your A drive, type A: whenever you see B: in the instnictions.

7. Type DIR B: and press the RETURN key to display the files on the disk.

8. Compare this list against Figure III 1 to be certain all the files are present.

9. Type COPY B:*.* and press the RETURN key to copy all of the files to the RPTS34 directory on your computer's hard drive.

10, Type DIR and press the RETURN key to display the files now residing in the RPTS34 directory.

11. Check this list against Figure Ill 1 to be certain installation was successful.

C. Install Reports 34.30 Using 5.25" diskettes 1.-If you are upgrading from a previous version of Reports 34.30, skip to step 5,

2. Type C: and press the key RETURN key to get to your hard drive's directory.

3. Type CD\\ 'and press the RETURN key to be certain you are in the root directory of your hard drive.

4. Type MKDIR \\RPTS34 and press the RETURN key to create a new 4

directory on your computer's hard drive called RPTS34.

5. Enter the new directory by typing CD\\RPTS34 and pressing the RETURN key at the DOS prompt.

6. Insert the 5.25" diskette titled " Program Disk 1" into your A floppy drive.

7. Type DIR A: and press the RETURN key to display the files on Program Disk 1. There should be two files: RPTS34.EXE and RPTS34.OBj.

8. Type COPY A:RPTS34.EXE and press the RETURN key to copy the

.EXE file into the RPTS34 directory on your computer's hard drive. The

.OBJ file is unnecessary.

9. Remove Program Disk 1 from your computer's A floppy drive.

10. Insert the 5.25" diskette titled " Program Disk 2" into your A floppy drive.

11. Type DIR A: and press the RETURN key to display the files on Program Disk 2. There should be seven files: RPTS34.PRG, RPTS34.DBF.

RPTS34.DBT, RPTS34.BAK. RPTS34.TBK. ENTRDATA.SCR, and ENTRDATA.FMT.

12. Type COPY A:RPTS.DBF and press the RETURN key to copy the database file into the RPTS34 directory on your computer's hard drive.

13. Type COPY A:RPTS.DBT and press the RETURN key to copy the databve memo field file into the RPTS34 directory on your computer's hard drive.

14. Type COPY A:ENTRDATA.* and press the RETURN key to copy the ENTRDATA screen and format files into the RPTS34 directory on your computer's hani drive.

15. Type DIR and press the RETURN key to display the files now residing in the RPTS34 directory.

16. Check this list against Figure Ill 1 to be cenain installation was successful.

NOTE: Not all of the files on the program disk (s) were copied because the uncopied files are not crucial to the operation of Repons 34.30. They are used instead foi backup and archival purposes. See Appendix C for details.

D. Setting Up Reports 34.30 for use with Windows" 3.1

1. Follow the instructio ls in either B or C above to install Reports 34.30 on your hard drive.

- 2. Start Windows" 3.1 'or bring up the Program Manager if Windows" 3.1 is aheady active.

3. Select New from the File menu in the Program Manager.

4. Select Program Item from the dialog box, then click on the OK button.

5. In the dialog box that pops up:

a. Type Reports 34.30 in the Description blank, then press the TAB key.

5

b. Type C:\\RPTS34\\RPTS34 in the Command Line blank, then press the TAB key.

c. Type C:\\RPTS34 in the Working Directory blank,

d. Click on the Change Icon button. Select an icon from the dialog box that pops up with the mouse. Press RETURN or click on the OK button.

e. Press RETURN or click on the OK button to finish setting up Repons 34.30 in Windows" 3.1. The icon you chose will now appear in the Program Group you placed it in. Be sure to save the changes in settings when quitting Windows" 3.1.

VI. DIRECTIONS FOR RUNNING Reports 34.30 To start Reports 34.30 from DOSi

1. Type C: and press the RETURN key to set the directory to your hard drive.

2. Type CD\\hPTS34 and press the RETURN key to enter the RPTS34 directory, which contains the Reports 34.30 program and associated files.

3. Type RPTS34 at the DOS prompt and press the RETURN key to launch the Reports 34.30 program.

To Stan Repons 34.30 from Windows" 3.1

1. Start Windows" 3.1, or bring up the Program Manager if Windows" 3.1 is already active.

2. Double-clici. the icon you chose for Reports 34.30 to launch the Reports 34.30 1

program.

6

WELCOME SCREEN When the program is staned, the welcome screen comes up. This screen has a green background. The screen is shown in Figure VI 1, below. The screen informs you that you have launched the Repons 34.30 program. To enter the program and bring up the Main Menu, press any letter key on the keyboard or RETURN.

l<uch..ac oI1 t o n, p.,, t. 11 w,.

(

c. s in,

'h cra ted by t he sea ira : onn e sotety :,ci t inn l rt5 Y n r'.

< uit i i t', nu,n nottr, Jui. ;

i 1

r e-9

/

9 PHESS ANY krY To Ef1TLH THL P N.Hnf1.

Figure VI l. Welcome Screen 7

MAIN MENU After pressing a key from the keyboard, a box pops up flashing the message "NOW ENTERING REPORTS 34.30". Then, the hiain hienu (see Figure VI.2, below) appears.

The hiain hienu has three choices. They are:

Browse Records Print Reports Quit Reports 34.30 e

f i,

r n, n. ;

i li i sw.e r t,s e st d '.

g t

k rrint imports i

i Quit ht-[ Mar i s.li.H I s

e o

s:,

\\

d Figure VI-2. Main Menu Choosing " Browse Records" branches you to a screen where you can view the reports in the database according to various criteria (see below). Choosing " Print Reports" branches you to another menu, the Reports Menu, where you can choose from among fourte:n reports to send to the printer (see below). Choosing " Quit Reports 34.30" closes and deletes all runtime files created by Reports 34.30, then clears the screen and returns control to DOS.

To choose one of these options

1. Use the UP ARROW (t) and DOWN ARROW (4) keys to highlight an option.

2. To execute a highlighted option, press the RETURN key while that option is highlighted.

8

i 4

1 i

i l

NOTE: This procedure for j

selecting and executing a menu l

t choice is also used for the Repons j

Menu.

j 4

i BROWSE SCREEN l

If you select the " Browse Records" option of the Main Menu, Reports 34.30 will j

then transport you to this screen (see Figure VI 3, below). This screen has five columns, not all of which are displayed at the same time. The columns contain the following i

information:

l Name of Reporting Company l

Date (ol Occurrence)

Equipment Manufacturer Equipment Model Nun:ber Source Manufacturer

• Source Model Number t + p inw-Py ne up 1 p.up -

(tii ryop top of li.t down um Pylin down 1 pmp-tiii ryDu tint t om ot it t i solit le It o ur iolonn Ii He l u i n t ii ti.i i n N, no o.

Reporting, Company Date flanuf acturer ikwic i flo. '

lintu[tries

'.utary S Alaska Indugtr ia l X rais.

L v18/91

. anna Alonso 11 Garus Iron Works

'L './05/92

'assia Industries entury SA Applied Standards liespection i /26/32 ana industries

-.utury Sn BlX Testing Laboratories it 12/92 1:wtust r ies

'.nturg 5 Barinett Industrial X Ray l i : /111/93

- rshan

.iB Barnett ladustrial X-Ray

- 16/93

- rshan iB Rasin ladustrial X-Ray

,10/30/92

- ' ili fluclear 00 m

Basin Industrial X-Ray it3/17/92 i l f,ftu-lear GU Sasin Industrtal X-Ray is3/22/92 If thiclear OU Caluart Testing krvices. Inc. Lt./17/9'l

.rshan iB

.Conan inspectton Inc.

1i /01/92

- rshan s

Deggr.tnent of the Air Force

• i 43/93 - *

• Tort m

Departaent-of the 4ir Force i3/07/91

tssfort RS Department or i flawg

.. ei./20/94

- rshan iB Eagle X Ray 12/16/92

. anna industries

.nturg l

Ehesco Services, incorporated 11/11M1

.rshan i60 Ednaards FipeIine Testlag. Inc. :i /16/91

• TEc

-f EduaN s Fi, line Testing. Inc. 10/21/91 3 ' Ec

-f l

Figure VI-3. firowse Screen l

The current row and column is highlighted at all times. The row of the highlighted cell gives the information from the current record / report. The column of the highlighted cell controls the index, the order the records are listed in. If the cell is in the "Name of i

l 9

l

Repo: ting Company" column, the records are in order of the name of the company who reponed the incident. If the highlighted cell is in the "Date" column, the records are I

ordered by the date on which they occurred, and sa on.

You can move around the browse screen using the keys defined in the instructions area at the top of the screen. Briefly, the arrow keys move one cell or column in the direction the arrow points in. The PgUp and PgDn keys move the highlighted cell up or down by one window (18 records). The Ctrl-PgUp and Ctrl PgDn keystrokes move to the first or last record according to the present index, respectively.

NOTE: You cannot edit the records using RPTS34. You may only browse them. To edit the records, use dBase 111 Plus, or a utility that works with dBase III Plus files.

REPORTS MENU If you select the " Print Reports" option from the Main Menu, Reports 34.30 will then transport you to this menu (ree Figure VI 4). There are seventeen choices on this menu: sixteen choices that generate reports and send them to the printer, and an option to return to the Main Menu. See Figure VI-4 for a list of the options.

};::lh 'O \\;

,]. ;<.. T C

.T'~

'~ *

' ':..}_..

.}

0:. 7 7,;< +;. g..

q,w. n.

,,o

..y 7

0 s..'

. f. 7

- ~.

-.. - -.. - -. ~. -.

~.- -

.,g;-

7.n.,..-

.,t.

r t.

i'

' I' 4,' '. ?

.C Conpamj l

.] V State of Occurcium

- ' 9 '. 't g.

.y

.1

~

$ 7.: -

Descrlytion Code 3,

-'?...

Cause Code

'. !i h,[.I'7.(( [ y. O.;

Equipnesit knuiacturer '

7. [.;

i,,f.[.I Equipment,hdel Naher

?....y.

~ '

... ;e b'

Source knuf acturer 4l'v :.. %... /.L

~f4

'.{p. <p;._

yig? :: c soun:e nodei nuawr

.g r.

- n f. < 1 ~.

ModeI Minnber a Veer of Itieideint g.;

,.7..'

nadel thimber & Drsr.rlytlom Cote 1

ml 3 a.; A

('c - - '

4,

' 'f s -

flodel Naher a Cause Code

..1 Q:6;4. w.7.

Saurte nodei a Descript ton Code Mcy %,j, M a.. * :

Source flode14 Cause Code

,g:

J.;.{./ G '..,; '..,....)'

e.:.

Campang a Cause Code

..a

...t-1 7.;,,,..,.

.. ; y.,.f j.:

Company a Ygar a

Cause Code a Demyiption Code N' s,.. 7.. f. x... : 5:- f.....

. MRM M WM M

,a

...y

.e' n,-....,....

. /.,.. ; :;...~:p

. f( '. ; L. '..~ z.,. ; 4 V.Q.;v-<:..J:].;.giy y [ Q ;jy y_,^ g y Q Q.;,j"; y.L.f.}:?::.9;.4 3 Figure VI-.l. Reports Menu 10 3

Follow the same procedure you followed in the Main Menu to select and execute a t

menu choice from the Repons Menu.

When a report choice is executed, a message will appear on your screen asking you to wait momentarily while the report is being printed. While this message is being displayed, the computer will format the repon and send the commands to the printer to print out the report. When this is finished, the Repons Menu will return to the screen, allowing you to either print another repon or return to the Main Menu.

NOTE: The Repons 34.30 program automatically routes the printer output to the LPT2 pon, because that is the port our network printer is attached to. If your printer is attached to another pon, you will have to reroute the information.

QUITTING Reports 34.30 To auit Reports 34.30:

1. If you are not in the Main Menu, return to the Main Menu. If you are currently in the " Browse Records" screen, press the Esc key. If you are currently in the " Print Reports" menu, select and execute the " RETURN TO MAIN MENU" option.

2. Choose the " Quit Repons 34.30" option on the Main Menu.

i 4

11-1

. J

i Appendix A: Description Codes CODE DEFINITION i

A Source Disconnect: This usually describes a break in the source assembly to control cable connection, it also can describe one end of q

the connector pulling off the cable or the pigtail.

B Source Hangup Guide Tube /S Tube: This can describe a kinked or crushed guide tube which prevented retraction of in exposed source. It can also be'a kink or jam in the source assembly to control cable connection which prevented retraction by hanging up the source j

while in the guide tube or S-Tube, but not while passing. d rough the i

outlet fitting of the camera.

C Source' Hangup Fittings: This usually describes the source or l

control cable catching on the fittings or connectors for the guide tube.

l This can also describe a connector becoming jammed in the outlet fitting of a camera by bending too much.

D Failure of Automatic Lock: This describes an incident where a source does not automatically lock upon being retracted into the l

shielded position, as required by 10 CFR 34.20. Another case falling in this category is if the automatic lock required by 10 CFR 34.20 releases before the radiographer deliberately releases the lock.

E Failure of Manual Lock: This describes a failure of the manual lock used to lock the camera down between operations and overnight. An l

example is the failure of the key locks on the Amersham 660s, which has since been rectified.

F Break in Guide Tube: This describes a situation where the guide tube, or the cable crankout tube physically breaks, or at least pull out of its crimped sleeve.

j G

Stop Malfunction: This describes an incident in which the mechanisms or barriers intended to prevent the source from exiting i

either the end of the guide tube or the back (crankout) side of the camera fail, allowing the source to become exposed.

H OTHER: Anything else falls into this category. A description of the incident will be found in the corresponding memo field (DESC_DETL).

4 i

i-1 12

APPENDIX B: Cause Code Definitions CODE DEFINITION A

Human Error B

Part wore out its useful life C

Manufacturing defect / error

.D Device not being used according to instructions E

Inherent design flaw F

Foreign material entered apparatus causing it to malfunction

G Device experienced unusual conditions (extreme heat, dropped, etc.) _

H OTHER 4-1

+

13

Appendix C: Files on Reports 34.30 Program Diskettes FILE NAME RPTS34.EXE This is the execute file containing the RPTS34 application.

It uses the other required files during its operation.

RPTS34.OBJ This is the object file used for compiling RPTS34. It is kept around for use in future updates.

RPTS34.PRG This file is a text file containing the source code used in compiling RPTS34.EXE. Adjustments in the program are made here, then the file is recompiled using Clipper.

RPTS34.DBF This is a dBase Ill Plus file that contains the records RPTS34 uses to execute its functions.

RPTS34.DBT This is a companion dBase III Plus file to RPTS34.DBF. It contains the memo fields from the records in RPTS34.DBF.

RPTS34.BAK This is the backup file for RPTS34.DBF, created by dBase Ill Plus.

RPTS34.TBK This is the backup file for RPTS34.DBT, created by dBase 111 Plus.

ENTRDATA.SCR This is a dBase III Plus screen file, containing the screen layout for the Reports 34.30 data entry and editing screen.

ENTRDATA.FMT This is a dBase III Plus companion file for ENTRDATA.SCR. It contains the formatting information for the screen file.

14 l

Appendix D: Revision History of Reports 34.30 Version No.

Date 1.0 1/92 Initial Program Release 1.1 5/92 Change SSSS phone number and add new description code 1.11 6/92 Remove extra messages from print routines 2.0 7/94 Edit report printing routines for new description code definitions.

Give countdown of number records left to scan during a report.

Provide limited color support user cannot set color preferences.

Rewrite Browse section of program to use TBrowse instead of MEMOEDIT. Also, Include all information on one screen with varying indexes.

Remake ENTRDATA.FMT and ENTRDATA.SCR to allow for new description codes and new method of classifying people involved.

Add two new report types: by Source Model and Description, by Source Model and Cause Code 15

.