DBURUNSUMMARY

Table Czar(s):

Robert Hatcher

Description:

Describes overall information about runs generated by the DAQ

Usage in the offline software:

blah blah

Validation for entering new data:

To be completed...

Process for automated filling:

Table not updated automatically or info not available.

Additional information:

To be completed...

Structure:

Field Type Description
SEQNO int(11) int
ROW_COUNTER int(11) (not yet there)
DETECTOR varchar(10) "Near", "Far" or "CalDet"
RUN int(11) run #
LAST_SUBRUN smallint(6) last subrun for the run
RUNTYPE smallint(6) run type value (set by DAQ)
RUNTYPE_NAME varchar(24) run type name (interpreted by offline)
STARTTIME datetime start of run as determined by first DaqMonitor or DaqSnarl record timestamp or RawRunEndBlock::GetStartTime(); RawRunEndBlock trumps if available
ENDTIME datetime end of run as determined by last DaqMonitor or DaqSnarl record timestamp or RawRunEndBlock::GetEndTime(); RawRunEndBlock trumps if available
TERMCODE int(11) RawRunEndBlock::GetTerminationCode()
RUNEND_SNARLS int(11) RawRunEndBlock::GetNumberOfSnarls()
RUNEND_NONSNARLS int(11) RawRunEndBlock::GetNumberOfNonSnarls()
NERRS int(11) RawRunEndBlock::GetNumberOfErrors()
NTIMEFRAMES int(11) RawRunEndBlock::GetTotalTimeFrames()
NDROPPEDFRAMES int(11) RawRunEndBlock::GetDroppedTimeFrames()
CONSISTENCY_BITS int(11) see DatabaseUpdater/DbuBits.h
RUN_COMMENT text RawRunCommentBlock::GetRunComment()
RUNPREPARE_STRING text RawRunConfigBlock::GetRunConfig()
AUX_CONFIG_TEXT text DAQ liStartTimes.config data
CONFIGFILES_MD5 text MD5 signature for entry in DBUDAQCONFIGFILESTEXT table
CONFIGFILES_SEQNO int(11) SEQNO entry in DBUDAQCONFIGFILESTEXT table

Updating status:

Detector Responsible Frequency Method
caldet data ? ? ?
MC ? ? ?
neardet data ? ? ?
MC ? ? ?
fardet data ? ? ?
MC ? ? ?


This information was provided by Robert Hatcher and last updated on Fri Oct 7 22:46:42 2005
Send comments to: Mark Dierckxsens