FPost DB tables

• fpostConstant.idl (1 row) : Basic constants
  struct fpostConstant {
  unsigned short nQuad; /* 2 (South/North) */
  unsigned short nLayer; /* 6 */
  unsigned short maxSlat; /* 43 */
  unsigned short maxQTaddr; /* 8 */
  unsigned short maxQTch; /* 32 */
  };
• fpostChannelGeometry.idl (12 rows) : Number of slats for each Quad & Layer
  struct fpostChannelGeometry {
  unsigned short quad; /* 1=Q1(South), 2=Q2(North) */
  unsigned short layer; /* 1=layer1, 2=layer2, 3=layer3 4=layer4 5=layer5 6=layer6 */
  unsigned short nslat; /* # of slat (9,14,25,43, or 34) */
  };
• fpostSlatId.idl (241 rows) : Slat Id to Quad & Layer & Slat#
  struct fpostSlatId {
  unsigned short slatid; /* 0-240: slat Id */
  unsigned short quad; /* 1-2, 0 for none-exsistant slat */
  unsigned short layer; /* 1-6, 0 for none-exsistant slat */
  unsigned short slat; /* 1-43, 0 for none-exsistant slat */
  };
• fpostPosition.idl (241 rows) : Detector dimensions and positions
  struct fpostPosition {
  unsigned short slatid; /* 0-240: slat Id */
  float length; /* length ( Depends on S1,S2,etc. cm) */
  float width; /* width (5 cm) */
  float thickness; /* thickness (1 cm) */
  float angle_xy /* angle in the xy plan measured with respect to the positive x-axis (45 South, 135 North)*/
  float xoffset; /* xoffset from beam line to center of detector (cm) */
  float yoffset; /* yoffset from beam line to center of detector (cm) */
  float zoffset; /* z position from IR (cm) */
  };
• fpostMap.idl : QT map (241 rows) :
  struct fpostMap {
  unsigned short slatid; /* 0-240: slat Id */
  short QTaddr; /* 0-7 : QT Address */
  short QTch; /* 0-31 : QT channel */
  };

• fpostGain.idl : Gain (241 rows) :
  struct fpostGain {
  unsigned short slatid; /* 0-240: slat Id */
  float MIP; /* Single MIP ADC ch */
  };
• fpostStatus.idl : Status (241 rows) :
  struct fpostStatus {
  unsigned short slatid; /* 0-240: slat Id */
  unsigned short status; /* 0=Good, 1=bad, 9=Unused */
  };
• fpostPed.idl : Pedestals(241 rows) :
  struct fpostPed {
  unsigned short slatid; /* 0-240: slat Id */
  float Mean; /* Mean of Gaussian Fit for ADC [ch] */
  float Sigma; /* Sigma of Guassian Fit for ADC [ch] */
  };