FABOUTOFSERVICE

Table Czar(s):

Mark Dierckxsens

Description:

This table holds the location of a specific device when it is not in the detector. The MID in this table refers to the SEQNO in the main table FABCOMPONENT. The location of the device is indicated by the WHERE_ID column that points to the column with the same name in the FABWHERE table. The reason for removing this device is given by OUT_MOTID which points to MOTID in the FABMOTIVATION table. An extra column is available to record comments about this change.

Usage in the offline software:

This data is currently not used in the offline software.

Validation for entering new data:

Validation is done by the underlying classes of the user interface.

Process for automated filling:

Table not updated automatically or info not available.

Additional information:

More details about the HWDB tables and their development can be found here.

Structure:

Field	Type	Description
SEQNO	int(11)	the sequence number
ROW_COUNTER	int(11)
MID	int(11)	points to the SEQNO in FABCOMPONENT table
WHERE_ID	int(11)	out-of-service location, points to WHERE_ID in FABWHERE
OUT_MOTID	int(11)	motivation for taking out, points to MOTID from FABMOTIVATION
OUT_COMMENT	text	comment field

Updating status:

Detector		Responsible	Frequency	Method
caldet	data	N/A	N/A	N/A
caldet	MC	N/A	N/A	N/A
neardet	data	Dave Boehnlein, Mark Dierckxsens	irregular	manually, gui
neardet	MC	N/A	N/A	N/A
fardet	data	Bill Miller, Mark Dierckxsens	irregular	manually, gui
fardet	MC	N/A	N/A	N/A

This information was provided by Mark Dierckxsens and last updated on Fri Feb 25 05:03:36 2005

Send comments to: Mark Dierckxsens