The CATER system was designed to facilitate the many maintenance items, both Hardware and Software, which are required to keep the accelerator operating. It has been in use since January 1988 and the database is in VAX Rdb.
CATER may be used to make the initial entry of a problem, to enter one or more solutions to a problem, to modify or closeout a problem, to generate a variety of pre-defined reports giving status and statistical summaries, and to allow anyone to browse the database. The basic CATER reports are now available on the web.
Valid operators for the following fields
unless otherwise noted
Numeric: = equal to
< less than
> greater than
<= less than or equal to
>= greater than or equal to
~ not
! missing
~! not missing
string: = equal to
~ not
! missing
~! not missing
* wild card
date: = equal to
< less than
> greater than
<= less than or equal to
>= greater than or equal to
~ not
! missing
~! not missing
description:
*description string* find anywhere in description
*description string find at the end of description
description string* find at the beginning of description
description string find anywhere in description
! missing
~! not missing
Conjunction truth table (AND)
_____________________________
| | p | q | p AND q |
|-----|-----|-----|---------|
| 1. | T | T | T |
|-----|-----|-----|---------|
| 2. | T | F | F |
|-----|-----|-----|---------|
| 3. | F | T | F |
|-----|-----|-----|---------|
| 4. | F | F | F |
|_____|_____|_____|_________|
Disjunction truth table (OR)
_____________________________
| | p | q | p OR q |
|-----|-----|-----|---------|
| 1. | T | T | T |
|-----|-----|-----|---------|
| 2. | T | F | T |
|-----|-----|-----|---------|
| 3. | F | T | T |
|-----|-----|-----|---------|
| 4. | F | F | F |
|_____|_____|_____|_________|
1. (R.NUM > 45000 AND R.NUM < 46000) OR R.TIME = 2/17/95
-returns all caters greater than 45000
and less than 46000
-plus all caters reported on 2/17/95
Type
Select the type of the problem
Enter either:
Hardware or
Software
Problem Number
Enter one problem number to be searched
for. The following operators can be used
with a problem number.
less than: <
greater than: >
less than or equal to: <=
greater than or equal to: >=
not: ~ or <>
Example:
Problem Number: 40340
Problem Number: >40340
Index
Status
Enter one problem status type
to be searched for.
Valid types include:
Solved
Unsolved
Closed
Not Closed
Ongoing
Index
Urgency
Enter Urgency type to be searched for.
Valid types include:
Immediate
Later
Scheduled
ROD
Downtime
ML
Index
Report By
Enter the userid or name of the person who
reported problem to be searched for .
Wild card search permitted. Search
is not case sensitive.
example:
Reported by: RAA
Reported by: r*
Index
Problem Description
Enter keyword(s) to be searched for in
the problem Description field in the order they
appear in the actual description. The
search is not case sensitive.
Example:
String in Description: vcg 1731
Wild card search:
String: vcg* (first word in description)
String: *vcg (last word in description, may need to
enter a period)
Index
Closed By
Enter userid or name of supervisor to be
searched for who closed CATER problems.
Can use wild card. Not case sensitive.
Example:
Closed by: RAA
Index
Solution Count
Enter solution numbers or a range
to search for e.g. >2
valid operators include:
less than: <
greater than: >
less than or equal to: <=
greater than or equal to: >=
not: ~ or <>
missing: ! (Search for NULL fields)
not missing: ~! (Search for NOT NULL)
Index
Disposition
Enter one text strings to be
searched for in Disposition.
Index
Date/Time
Nota Bene! The following 2 digit date IS Y2K compliant because Oracle does
a very clever thing by looking at the 2 digit year and the current year.
At least it'll work until 2050 at which point we'll have to go to a 4 digit
year to search for CATERs that span > 50 years.
Following are examples of acceptable date/time specifications:
MM/DD/YY HH:MI:SS -date and full time (24 hour clock)
MM/DD/YY HH:MI -date and hours plus minutes
MM/DD/YY -date only
NOTE: Only ONE date can be entered in each field. Some Operators may
be used in DATE/TIME fields. However the default is set
to handel a range of times with the 'After' and
'Before' entries for each relevant time.
Index
Assigned To
Enter userid or name of one person
assigned to fix Cater problem to be
searched for. Wild card search permitted.
Search is not case sensitive.
example:
assigned to: RAA
assigned to: r*
Index
Modified By
Enter userid or name of one person
who modified the Cater Problem.
May use wild card. Not case
sensitive.
Example:
Modified by: NAN
Modified by: n*n
Modified by: ! (find all caters where
modified by is missing)
Modified by: ~! (not missing)
Modified by: ~n* (not begin with n)
Index
Ready-to-Close
Enter YES or NO to find problems with
the specified READY-TO-CLOSE status.
For example, you may search for all
SOLVED problems in your area which
have YES as a READY-TO-CLOSE status.
The missing (!) and not (~) operators
are also supported for this field.
Index
est fix
Enter the number of hours estimated to
fix a problem to be searched for. This
should be a integer. Examples:
Est Fix Hrs: < 8
Est Fix Hrs: !
Index
Beam Lost
Enter number of hours of beam time lost
related to this specific problem.
Examples:
Beam Time Lost: >=5.0
Beam Time Lost: <1.0
Index
Class Code1
Class Code2, Class Code3, Class Code4, Class Code5
Class codes 1 & 2 are a 2 digit combination used to categorize the actual
source of the problem after it has been fixed.
1. POWER SUPPLIES 2. MAGNETS 3. RF
l.1 Interlocks 2.1 DC 3.1 Linac Klystron
1.2 Controllers 2.2 Pulsed 3.2 Linac Modulator
1.3 Power Supplies 2.3 Magnet Mover 3.3 Sub Booster
1.4 Cables 3.4 Master Source-
Drive Lines
4. VACUUM 5. UTILITIES 3.5 Sub Harmonic
4.1 Pumps 5.1 Electrical Buncher
4.2 Guages & 5.2 Water 3.6 CW RF Systems-
Controllers 5.3 Compressed Air DR RF, PEP RF
4.3 Valves 5.4 VVSs etc.
4.4 Mechanical- 5.5 DC Distribution-
Beam Pipe etc. Battery System
6. CRYOGENICS
7. CONTROLS
7.1 MPS (PLICS 7.8 Workstations 7.16 SWE (Software
PICS, BIRs) 7.9 CUDs installs/changes
7.2 PPS (BSOICS, 7.10 Timing Systems that cause
Keybanks, Doors 7.11 Cable Systems downtime)
& Gates, BTMs) 7.12 BPMs 7.17 VACUUM-I&C
7.3 Micros & Crates 7.13 Wires 7.18 Slits &
7.4 Networks 7.14 Beam Monitors, Collimators
7.5 BCS TOROs, Spectrum
7.6 VAXes Foils
7.7 COWs 7.15 Profile Monitors
8. SAFETY 9. OTHER
8.1 Fire Alarms 9.1 Laser Gun
8.2 Alarms & 9.2 Thermionic Gun
Warnings 9.3 Communications-
(Annunciator) Phone, Radio etc.
8.3 Oxygen Detectors
Index
Class Code2
Class Code1, Class Code3, Class Code4, Class Code5
Class codes 1 & 2 are a 2 digit combination used to categorize the actual
source of the problem after it has been fixed.
1. POWER SUPPLIES 2. MAGNETS 3. RF
l.1 Interlocks 2.1 DC 3.1 Linac Klystron
1.2 Controllers 2.2 Pulsed 3.2 Linac Modulator
1.3 Power Supplies 2.3 Magnet Mover 3.3 Sub Booster
1.4 Cables 3.4 Master Source-
Drive Lines
4. VACUUM 5. UTILITIES 3.5 Sub Harmonic
4.1 Pumps 5.1 Electrical Buncher
4.2 Guages & 5.2 Water 3.6 CW RF Systems-
Controllers 5.3 Compressed Air DR RF, PEP RF
4.3 Valves 5.4 VVSs etc.
4.4 Mechanical- 5.5 DC Distribution-
Beam Pipe etc. Battery System
6. CRYOGENICS
7. CONTROLS
7.1 MPS (PLICS 7.8 Workstations 7.16 SWE (Software
PICS, BIRs) 7.9 CUDs installs/changes
7.2 PPS (BSOICS, 7.10 Timing Systems that cause
Keybanks, Doors 7.11 Cable Systems downtime)
& Gates, BTMs) 7.12 BPMs 7.17 VACUUM-I&C
7.3 Micros & Crates 7.13 Wires 7.18 Slits &
7.4 Networks 7.14 Beam Monitors, Collimators
7.5 BCS TOROs, Spectrum
7.6 VAXes Foils
7.7 COWs 7.15 Profile Monitors
8. SAFETY 9. OTHER
8.1 Fire Alarms 9.1 Laser Gun
8.2 Alarms & 9.2 Thermionic Gun
Warnings 9.3 Communications-
(Annunciator) Phone, Radio etc.
8.3 Oxygen Detectors
Index
Class Code3
Class Code1, Class Code2, Class Code4, Class Code5
Class code 3 is not formally used.
Index
Class Code4
Class Code1, Class Code2, Class Code3, Class Code5
Class code 4 is not formally used.
Index
Class Code5
Class Code1, Class Code2, Class Code3, Class Code4
Class code 5 is not formally used.
Index
Area
Enter one Area to be searched for e.g.
Area: NDR
Area: ~LINAC (problems not in Linac)
Area Begin End
---- ----- ---
INJ/LI01 CID guns 5 hole collimator at end
of Sector 1, NPI gun
NDR Begin NLTR End NRTL
SDR Begin SLTR End SRTL
LINAC Sector 2 50Q1
POSITRON Horiz Lambertson, Combiner magnet BAS-I
also kicker at 19-5 chicane
BSY 50Q1; includes NIT, Beginning of NARC,SARC
SIT to PEPII, A,B,C
lines.
ESA End Station A
NARC Begin NARC End NARC AG magnet
SARC Begin SARC End SARC AG magnet
NFF End NARC AG IP magnet
SFF End SARC AG IP magnet
S10 S/R S10 S/4
MCC Electronic systems in MCC building not
clearly supporting BSY functions.
PEPII-INJ PEPII Injection
HER PEPII High Energy Ring
LER PEPII Low Energy Ring
FFTB Final Focus Test Beam
NLCTA Next Linear Collider Test Assembly
OTHER None of the above. Explain in the description.
Index
Micro
Enter one micro name to be searched for.
List of micros by area:
Area Micro Names
INJ/LI01 LI00 LI01 LC00 NP25 EP05
NDR LI01 DR11-DR13 DF01
SDR LI01 DR01-DR03 DF00
LINAC LI02-LI30 FB29 FB30 FB31 AP04 AP09
AP30
POSITRON LI01 LI02 LI03 LI04 LI05 LI06 LI07
LI08 LI09 LI10 LI11 LI12 LI13 LI14
LI15 LI16 LI17 LI18 LI19 LI20 EP01
EP02 EP05 PT01
BSY LI30 AB01 CA01 CA11 CB00 CB01 CB02
PL01 MC00 FB31
ESA AB01 PL02
NARC CA11-CA13
SARC CA01-CA03
NFF FF01 FF11 FB69 FB73 FB88
SFF FF01 FF11 FB69 FB73 FB88
S10 S/R (Leave Blank)
MCC MP00 MC00 CW01 CW02 CW03 CW04 CW05
CW06 CW07 CW08 CW09 CB00 CB01 AB01
SP00 AP51 AP52
FFTB CB00 CB01 CB02 PC01 PC02 PC03 MV01
MC00
NLCTA TA01,TA02
PEPII-INJ LI04-LI30 PI00 PI11 PI01 AP04 AP09
AP30
HER PR00 PR02 PR04 PR06 PR08 PR10
LER PR00 PR02 PR04 PR06 PR08 PR10
OTHER LI31 MP01 TL00 AM00 XX02 TH04 LI32
CL01 TL01 XX00 XX04 LI33 XX05 RF00
PL02 FG00 BD01
Index
Subsystem
Enter one SUBSYSTEM display name. The following are allowed
subsystem names.
Subsystem Description
--------- -----------
BCS Beam Containment Systems
BPM BPMs, muxes, processors, strip-line monitors
CAMAC crate, power supply, modules, serial link
CATV Cable, amplifiers, Sytek, System 20 boxes
COMPUTER SLC/MCC computer systems, ethernet, terminals,
workstations, printers etc.
CRYOGENICS Spin rotators, superconducting quad
DC MAGNETS DC magnet, power supply or interface chassis
DUMPS/COLLIMATORS Slits, collim., dumps, FARCs, masks
ELECTRICITY VVSs, AC/DC wiring, breakers, switches
FIRE ALARMS Smoke detectors, heat sensors, alarms
GUNS Thermionic gun, laser gun, NPI gun, Polarization
KICKER/ DR and FF kickers, flux concentrator,
PULSED MAGNETS single beam dumpers, scav. line kicker
KLYSTRON/MODULATOR Includes DR compressors, e+ target klystron
MICRO Multibus chassis, CPU, MBCD, PNET, modem, KISNET
MOVERS Magnet movers
MPS Arc/FF, MPS, TIU, rate limiting, PIC's
PLIC, temperature detectors, VETO
PPS Doors/hatches, keybanks, interlocks, stoppers,
PPS video (XXX-rated)
PROF Profile monitors/screens & WISRD
RADIOS Tunnel and hand-held radios, paging system,
miscellaneous TV (re-runs of 8 AM mtgs)
RF DR RF, PAD's MDL, phase hardware, master source
SAFETY Any personnel safety item (excluding PPS)
SUBBOOSTER Any sector 0-30 subbooster
TIMING FIDO's, fiducial generators
TOROIDS toroids (there will be a quiz on this one)
VACUUM Guages, valves, pumps and all of their
controllers, interlocks, leaks
WATER Cooling towers, pumps, hoses/pipes,
temperature regulation, flow switches,
interlocks, filters
WIRES Wire scanners (another tough one)
OTHER Scopes, non-PPS videos & anything else
not in one of the above subsystems
Index
Unit
Enter the primary and unit number of the device
to be searched for. Enter the field as a 4 character
primary name, a space and up to 4 digits of the unit
number e.g. XCOR 23.
Index
Shop Main/Shop Alt
Enter shop to be searched for.
Valid shops and their typical duties are:
Shop Typical Duties
---- --------------
AME Power techs; magnets east of Sector 30;
AMG Area Managers General
AMRF CW RF, klystron tubes, PADs
AMSS Kickers
AMW Gallery, magnets west of Sector 30, klystrons, modulators
BDS Beam Diagnostic Systems. Marc Ross, Kieth Jobe et al.
CBL Cables
CRYO Cryogenics for spin rotators, superconducting quads
CTL Micros, BPMs, profile monitors, CATV, timing,
movers, MPS, PPS & VETO Systems, Radios
EFD Roger Gearhart's shop.
FAC General facilities, air conditioners, chillers etc.
MFD Mechanical Fabrication Deptartment
MOSG Mechanical devices (wire scanners, slits, e+ target)
OHP Bsoics, PICs, ICs, peripheral monitors
OPS CAMAC modules
PCE Power Conversion Engineering.
PEB Plumbers
PEE Electricians
PEI Instrument techs
PEU Maintenance mechanics
SCS Misc. computer equipment repair; SERVDESK@SLACVM
SWE Software Engineering
Index
Documentation
Enter YES for problems where the
documentation is OK.
Enter NO for problems needing
documentation.
Enter UNKNOWN for problems where
it is not known if the documentation is OK.
Enter DO NOT NEED for problems where
documentation was not needed.
The missing (!) and not (~) operators
are also supported for this field
Index
SLC Unavailable
Enter number of hours of SLC unavailability
Examples:
Unavailability: >=5.0
Unavailability: <1.0
Index
Display
Enter the description of one
display to be searched for. Use the
most common name for the display panel
(such as CUD, ETA, Steer Diag, etc).
Index
Facility
Enter one or more software facility names to be searched for.
The ~ NOT operator can be used with a facility name. The
following are valid facilities:
Batch This category includes the separate processes such
as History Buffer, Comfort, Feedback etc.
Database
Micro
Other Enhancements or anything not mentioned above.
PEPII Alias B-Factory
SCP This includes all the shareables referenced by it.
Touch Panels
Index
Term
Enter one terminal type to be
searched for (such as COW, CALF, WS,
VAXSTATION, etc.)
Index
Reproducible
Enter Yes or No to find problems with a
specified related problem Reproducible
status.
Index
s_err_msg
* Not a searchable field at this time
Enter items to be searched for in the
Tracking field. For example:
Tracking Msg: ERR-NO-SUCH-MICRO
Index
Solved By
Search for userid or name of person
who solved this problem.
Wild card search permitted.
Search is not case sensitive.
example:
Solved by: RAA
Solved by: r*
Index
Solve Hours
Search for the hours required to
solve. Range operators can be
used such as:
Hours required for solution >=5.0
<1.0
Index
Solution Description
Enter keyword(s) to be searched for in
the Solution Description field in the order they
appear in the actual description. The
search is not case sensitive.
Example:
String in Description: vcg 1731
Wild card search:
String: vcg* (first word in description)
String: *vcg (last word in description, may need to
enter a period)
Index
Hardware Type
Enter one of the following
solution types to search for:
Adjust/repair
Replace
Enhance/Modify
No trouble found
Index
Hardware Module
Enter a generic hardware type or field
replacement unit NUMBER to search for.
Index
New Serial Number
Search for property control (PC) or serial
number for newly installed hardware used
to fix this problem.
Index
Old Serial Number
Search for property control (PC) or serial
number for old hardware which was removed
Index
Solution Number
Search for schematic or part number used to
fix this problem. The revision number
should not be included. For example
CC-NNN-NNN-NN or SD-137-084-00
Index
Solution Documentation
Search on YES to indicate that there is
signed off documentation, such as schematics,
electrical interconnects, mechanical drawings,
etc. and it is up to date and is available for the
system(s) which were worked on.
Search on NO to indicate that the documentation
is not complete. Please provide any available
document #s and other details in the solution
section.
Search on UNKNOWN to indicate that you do not know
if the documentation is OK.
Search on DO NOT NEED to indicate that documentation
was not needed to solve the problem.
Index
Software Type
Enter combinations of the allowable responses
for which to search.
Bug fix - I really fixed something.
Enhancement - I made it better than it was.
Design - Design flaw.
Database - Database related.
Panel - Panel source or driver.
No trouble found - None found; not reproducible.
Other - Explain in the description
Index
Software Module
Enter combinations of the modules changed
for which to search.
Index
Software Display
Enter combinations of the displays changed
for which to search.
Index
Software Facility
Enter combinations of the facilities changed
for which to search.
Index
Line Mode Solutions View
Option in the Line Mode Problem Report Synopsis to view
the problem number, description of problem, and solutions.
Index