SSD DB tables

Geometry/ssd

1) slsCtrl             : control parameters/constants.
--> no need to update

2) clusterControl : control parameters/constants.
--> no need to update

3) ssdBarrelPosition : seems not to be used in SSD code
--> no need to update

4) ssdConfiguration : # of sectors, ladders, wafers and an array of present/active ladders. The last entry is valid up to 2007-08-08 where 5 ladders were disabled (see below)
| 2007-08-08 19:22:29 | 2007-01-01 00:00:01 | 0000000001,0000000001,0000000002,0000000002,0000000002,0000000000,0000000000,0000000000,0000000002,0000000003,0000000003,0000000003,0000000004,0000000004,0000000004,0000000004,0000000004,0000000004,0000000004,0000000001 |
-->It should be updated for y2014 with all ladders active

5) ssdDimensions : control parameters/constants.
--> no need to update

6) ssdLaddersPosition : seems not to be used in SSD code
--> no need to update

7) ssdSectorPosition :seems not to be used in SSD code
--> no need to update

8) ssdPedStrip : internal table used in SSD code 
--> no need to update

9) SsdOnGlobal : place the SSD on global/frame (unitary matrix)
Last entry is 2007-05-02
+---------------------+---------------------+
| entryTime           | beginTime           |
+---------------------+---------------------+
| 2004-10-30 00:00:00 | 2004-10-30 00:00:00 |
| 2004-12-01 00:00:00 | 2004-10-29 00:00:00 |
| 2007-03-21 18:14:23 | 2005-01-01 00:00:00 |
| 2007-03-21 18:14:23 | 2005-01-20 00:00:00 |
| 2007-03-21 18:14:24 | 2005-02-17 00:00:00 |
| 2007-03-21 18:14:24 | 2005-03-10 00:00:00 |
| 2007-12-18 17:15:18 | 2007-03-21 00:00:31 |
| 2007-12-05 20:28:00 | 2007-05-24 00:00:31 
| 2007-05-02 21:49:59 | 2019-01-01 00:00:04 |
+---------------------+---------------------+
--> will be renamed OscOnGlobal
--> need to be initialized for y2014

10) SsdLaddersOnSectors : place the SSD ladders on Sectors (4).
Last entry is 2007-05-02
--> will not be used anymore

11) SsdSectorsOnGlobal : place the SSD sectors on Global (unitary matrix)
Last entry is 2007-05-02
--> will not be used anymore

12) SsdWafersOnLadders : place the SSD wafers on the ladder (along Z axis)
Last entry is 2007-05-02
--> need to be updated with Jim's survey
--> to be renamed SsdSensorsOnLadder (so need to be created in StarDb)

Tables 10 and 11 will be merged in 1 table : SsdLaddersOnOsc
--> need to be created in StarDb
--> need to be initialized with Jim's survey


13) ssdWafersPosition :
internal table used in SSD code 
--> no need to update because it is created each time StSsdDbMaker is run to built the Global-to-Local matrix


Calibration/ssd

1) ssdStripCalib : old table to store strip data (pedestal, rms, signal)
--> should not be used because it crashed StarDB

2) ssdGainCalibWafer : ratio of side-N cluster charge over side-P cluster charge.
320 rows (1 per wafer)
Last entry is  2007-08-06
| 2007-01-01 00:00:05 | 2007-08-06 22:25:02 | 1.0000000000 |
+---------------------+---------------------+--------------+
1600 rows in set (0.01 sec)
--> should be initialized with 1 for y2014

3) ssdNoise : new table to store strip data (pedestal, rms, signal)
--> will be updated with pedestal runs

4) ssdWaferConfiguration : table used to active/de-active reconstruction in a given wafer.
320 rows
Last entry is 2008-01-11 with nStatus =1 for all wafers
--> need to be re-initialized with nStatus =1 but with updated beginTime