FABPLNINSTALL

Table Czar(s):

Dave Boehnlein

Description:

This table contains the ID and location of each piece of steel and scintillator module in the detectors.

Usage in the offline software:

Use to study physical characteristics of the detector where properties of individual components may matter, e.g. module mapping, steel heats, etc.

Validation for entering new data:

construction records and physical checks of the detectors.

Process for automated filling:

Table not updated automatically or info not available.

Additional information:

An example of how FabPlnInstall was used in conjunction with steel records (table FabSteelPlate) is in NuMI-NOTE-STEEL-1061.

Structure:

Field Type Description
SEQNO int(11)  
ROW_COUNTER int(11)  
INSTALLDATE datetime Date that the plane was erected.
MODULEID1 tinytext Factory ID for the scintillator module in position 1; the column is repeated for eight scintillator modules (MODULEID1 - MODULEID8).
MODULEID2 tinytext  
MODULEID3 tinytext  
MODULEID4 tinytext  
MODULEID5 tinytext  
MODULEID6 tinytext  
MODULEID7 tinytext  
MODULEID8 tinytext  
STEELID1 tinytext Factory ID for the steel slab in position 1; the column is repeated for eight slabs (SteelID1-SteelID8).
STEELID2 tinytext  
STEELID3 tinytext  
STEELID4 tinytext  
STEELID5 tinytext  
STEELID6 tinytext  
STEELID7 tinytext  
STEELID8 tinytext  
PLANENUM smallint(5) plane number; each row represents one plane of a detector.

Updating status:

Detector Responsible Frequency Method
caldet data N/A N/A N/A
MC N/A N/A N/A
neardet data Dave Boehnlein once by hand
MC N/A N/A N/A
fardet data Dave Boehnlein once by hand
MC N/A N/A N/A

This information was provided by Dave Boehnlein and last updated on Wed Mar 2 19:13:43 2005
Send comments to: Mark Dierckxsens