Table: Logger.Run_Logger

Description:

This table contains the list of all the runs taken during the life of the experiment.

Fields:

NameTypeCan be nullDescription
Run_NrPKIinteger No Run number
Run_Type_IdIinteger FKNo Run type
Start_Timetimestamp No Run active period
End_Time can be used to check if a run is still active or not (NULL value).
End_TimeYes
Zero_Supinteger
(as boolean)
No Was zero suppression in use?
On_DiskIinteger
(as boolean)
No Was data written to disk?
Normal_Endinteger
(as boolean)
Yes Run ended on error? (not of the value)
Total_Eventsinteger Yes Number of physics events acquired during the run
Reconstruct_Idinteger FKYes Vote given by the operator
\italics;(0 - trash, 100 - good physics)\italics;
Commentvarchar(40) No Operator comment
Calib_Wordinteger
(32 bit)
Yes Bit pattern indicating the current status of the calibration for the run
Magnet_Currentdouble Yes Current (in A) in the KLOE magnet solenoid (at start of run)
Trgmon_Luminositydouble Yes Average luminosity (in cm-2 s-1) of the run, estimated by the L3 filters and the Trigger Monitors
L3_Luminosity
Trgmon_Int_Lumdouble Yes Luminosity (in cm-2 or 10-33 nb-1) integrated during the run, estimated by the L3 filters and the Trigger Monitors
L3_Int_Lum
Trgmon_Bhabhainteger Yes BhaBhas found during the run by the L3 filters and by the Trigger Monitors
L3_Bhabha
DAFNE_Fillinteger Yes DAFNE fill number at start of run
DAFNE_Imdouble Yes DAFNE beam currents (in mA) at start of run
(Im = e-, Ip = e+)
DAFNE_Ip
DAFNE_Ltminteger Yes DAFNE beam lifetimes (in secs) at start of run
(LTm = e-, LTp = e+)
DAFNE_Ltp
DAFNE_Tsw1integer
(32 bit)
Yes Bit pattern of the DAFNE beam (bunch crossing)
Use as a 128 bit value
DAFNE_Tsw2
DAFNE_Tsw3
DAFNE_Tsw4
DAFNE_Vacuumdouble Yes Vacuum in the KLOE interaction region at start of run
User_Idinteger FKNo Not significant at the moment
DAFNE_Luminositydouble Yes

Primary key:

  • Run_Nr

Foreign keys:

Local field(s)Foreign tableForeign field(s)
Reconstruct_Iddescript.reconstruct_descrreconstruct_id

Run_Type_Iddescript.run_type_descriptrun_type_id

User_Idusermaps.user_mapuser_id

Index:

  • On_Disk

Index:

  • Run_Type_Id