FABMOTIVATION

Table Czar(s):

Mark Dierckxsens

Description:

This is a helper table used by the FAB_"DEVICE"_LOC and FABOUTOFSERVICE tables and lists possible motivations for changing a device. The table is mainly there to prevent that each person comes up with a different description for the same reason. There is an extra column, named ALLOWED_MASK, to have the ability to restrict a motivation to a certain device type.

Usage in the offline software:

This data is currently not used in the offline software.

Validation for entering new data:

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)
MOTID	int(11)	The ID number for a motivation
ALLOWED_MASK	text	to restrict motivations to certain devices
MOTIVATION	varchar(50)	the actual motivation

Updating status:

Detector		Responsible	Frequency	Method
caldet	data	N/A	N/A	N/A
caldet	MC	N/A	N/A	N/A
neardet	data	Mark Dierckxsens	irregular	manually, gui
neardet	MC	N/A	N/A	N/A
fardet	data	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:35 2005

Send comments to: Mark Dierckxsens