Inventory and Status of the Offline Database Tables

The tables in the offline database are assigned to one of the following categories:
(1) Detector Construction & Configuration Tables
(2) Calibration Tables
(3) Data Collection & Processing Tables
(4) Database Logging & Support Tables
(5) Physical Properties & Monte Carlo Tables
(6) Software Configuration
(7) Run & Beam Info

Tables from an unknown category or for which the information is not available are listed at the end.

If you want to design your own offline table, you might want to have a look here.

If you are responsible for a table in the offline database, there are some guidelines for providing information about that table.


Detector Construction & Configuration Tables

Table Name Table Czar Info file avail.
BFIELDCOILCURRENT Erik Beall/Brian Bock yes
BFIELDMAPDATA Erik Beall yes
BFIELDMAPHEADER Erik Beall yes
FABCOMPONENT Mark Dierckxsens yes
FABDEVICETYPE Mark Dierckxsens yes
FABMOTIVATION Mark Dierckxsens yes
FABOUTOFSERVICE Mark Dierckxsens yes
FABPLNINSTALL Dave Boehnlein yes
FABWHERE Mark Dierckxsens yes
FAB_M16_PMT_BASE_LOC Mark Dierckxsens yes
FAB_M16_PMT_LOC Mark Dierckxsens yes
FAB_M64_PMT_LOC Mark Dierckxsens yes
FAB_MASTER_CRATE_LOC Mark Dierckxsens yes
FAB_ROP_LOC Mark Dierckxsens yes
FAB_VARC_LOC Mark Dierckxsens yes
FAB_VA_CHIP_LOC Mark Dierckxsens yes
FAB_VFB_LOC Mark Dierckxsens yes
FAB_VMM_LOC Mark Dierckxsens yes
PLEXPINDIODETOLED Robert Hatcher yes
PLEXPIXELTORAWCHANNEL Robert Hatcher yes
PLEXRAWCHANNELREADOUTTYPE Robert Hatcher yes
PLEXRAWCHANNELTOPINDIODE Robert Hatcher yes
PLEXSTRIPENDTOLED Robert Hatcher yes
PULSERTIMINGCARDSETTING Nathaniel Tagg yes

Calibration Tables

Table Name Table Czar Info file avail.
CALMAPPERFITS Leon Muralem yes
CALNDMAPPERFITS Leon Muralem yes
CALSTRIPATTEN Nathaniel Tagg yes
CALSTRIPTOSTRIP Phil Symes yes
CALTEMPCALIBRATION Chris Smith yes
CALTIMEJUMP Nathaniel Tagg yes
PULSERTIMEDRIFT Simona yes

Data Collection & Processing Tables

Table Name Table Czar Info file avail.
BFLDDBICOILSTATE Alec Habig yes
CALDETBEAMMOMENTUM Mike Kordosky, Patricia Vahle yes
CALDETCERRANGE Mike Kordosky, Patricia Vahle yes
CALDETCERTIMEWIN Mike Kordosky, Patricia Vahle yes
CALDETOVERLAPWIN Mike Kordosky, Patricia Vahle yes
CALDETTOFRANGE Mike Kordosky, Patricia Vahle yes
DCS_CAN Brian Bock yes
DCS_CHILLER_FAR Brian Bock yes
DCS_ENV_CAL Brian Bock yes
DCS_ENV_FAR Brian Bock yes
DCS_ENV_NEAR Brian Bock yes
DCS_HV Brian Bock yes
DCS_MAG_CAL Brian Bock yes
DCS_MAG_FAR Brian Bock yes
DCS_MAG_NEAR Brian Bock yes
DCS_RPS Brian Bock yes
SPILLTIMEND Nathaniel Tagg yes

Database Logging & Support Tables

Table Name Table Czar Info file avail.
DBILOGENTRY Nick West yes
GLOBALSEQNO Nick West yes

Physical Properties & Monte Carlo Tables

Table Name Table Czar Info file avail.
PHOTONBLUESPECTRUM Nathaniel Tagg yes
PHOTONELECTRONRANGE Nathaniel Tagg yes
PHOTONFASTBLUESPECTRUM Nathaniel Tagg yes
PHOTONFIBREABSORB Nathaniel Tagg yes
PHOTONGREENSPECTRUM Nathaniel Tagg yes
PHOTONPMTQUANTUMEFFICIENCY Nathaniel Tagg yes
PHOTONPROTONRANGE Nathaniel Tagg yes
PHOTONSCINTATTEN Nathaniel Tagg yes
PHOTONTIO2PAINTREFLEC Nathaniel Tagg yes
SIMPMTM16CROSSTALK Nathaniel Tagg yes
SIMPMTM64CROSSTALK Nathaniel Tagg yes

Software Configuration

Table Name Table Czar Info file avail.
SOFTWARE_CONFIGURATION Nick West yes

Run & Beam Info

Table Name Table Czar Info file avail.
DBUSUBRUNSUMMARY Robert Hatcher yes
DBUDAQCONFIGFILESTEXT Robert Hatcher yes
DBUDAQFILESUMMARY Robert Hatcher yes
DBURUNSUMMARY Robert Hatcher yes
DBUSUBRUNSUMMARY Robert Hatcher yes

Uncategorized Tables

Table Name Table Czar(s) Info file avail.
BEAMMONCUTS unknown no
BEAMMONFILESUMMARY unknown no
BEAMMONSPILL unknown no
BEAMMONSWICMASK unknown no
BEAMMONSWICPEDS unknown no
BEAMMONSWICREL unknown no
BFLDDBICOILLIMITS unknown no
BFLDDBIPLANEMAP unknown no
CALADCTOPE unknown no
CALADCTOPES unknown no
CALCHARGEINJECT unknown no
CALDRIFT unknown no
CALLINEARITY unknown no
CALMIPCALIBRATION unknown no
CALMUONCALIBRATION unknown no
CALMUONSTATS unknown no
CALPMTDRIFT unknown no
CALPULSERFITS unknown no
CALTIMECALIBRATION unknown no
CALVALINEARITY unknown no
CANDDIGITBADCHANNELS unknown no
CHANNELNOISERATES unknown no
DBUFARRUNQUALITY unknown no
DBUHVFROMSINGLES unknown no
DBUVACHIPPEDS unknown no
DBUVACHIPPEDS_OLD unknown no
DBUVACHIPSPARS unknown no
DBUVACHIPSPARS_OLD unknown no
DB_TABLE_ATTRIBUTES unknown no
FABNDTHICKNESS unknown no
FABSTEELPLATE unknown no
FAB_6_VOLT_PS_LOC unknown no
FAB_BRIDGE_DAUGHTER_DIFF_PVIC_LOC unknown no
FAB_BRIDGE_DAUGHTER_OPT_PVIC_LOC unknown no
FAB_BRIDGE_PVIC_LOC unknown no
FAB_HV_CARD_1443_LOC unknown no
FAB_LANTRONIX_SERIAL_UDS_LOC unknown no
FAB_PULSER_PS_LOC unknown no
FAB_PULSER_TIME_BOARD_LOC unknown no
FAB_ROP_DAUGHTER_DIFF_PVIC_LOC unknown no
FAB_TRC_LOC unknown no
FAB_VFB_CONTROL_CABLE_LOC unknown no
FAB_VFB_SIGNAL_CABLE_LOC unknown no
LOCALSEQNO unknown no
PLEXPIXELSPOTTOSTRIPEND unknown no
PLEXVETOSHIELDMUXTOMDL unknown no
PULSERDRIFT unknown no
PULSERDRIFTPIN unknown no
PULSERGAIN unknown no
PULSERGAINLOG unknown no
PULSERGAINPIN unknown no
PULSERPINSCALE unknown no
PULSERRAWDRIFT unknown no
PULSERRAWDRIFTF unknown no
PULSERRAWDRIFTPIN unknown no
PULSERRAWGAIN unknown no
PULSERRAWGAINF unknown no
PULSERRAWGAINPIN unknown no
PULSERREFDRIFT unknown no
PULSERREFDRIFTF unknown no
PULSERREFDRIFTPIN unknown no
PULSERXSCALE unknown no
RANGE_MU_FE_CSDA unknown no
SPILLSERVERMON unknown no
SPILLTIMECALIBRATION unknown no
UGLIDBIGEOMETRY unknown no
UGLIDBISCINTMDL unknown no
UGLIDBISCINTMDLSTRUCT unknown no
UGLIDBISCINTPLN unknown no
UGLIDBISCINTPLNSTRUCT unknown no
UGLIDBISTEELPLN unknown no
UGLIDBISTRIP unknown no
UGLIDBISTRIPSTRUCT unknown no
DBUHVFROMSINGLES unknown no
DBUVACHIPPEDS unknown no
DBUVACHIPSPARS unknown no


Comments: Mark Dierckxsens