Offline Run Database Query
(updated 6/7/02)

Offline Run Database Query
NOTE: use % as wildcard, strings are case sensitive
Run Number
Run Duration Hours
Start Time
(YYYY-MM-DD)
End Time
(YYYY-MM-DD)
Run Type
Status
Trigger List
Name Hints
Version Type
L3 Type
Prescale File Name
Physics
Recording
Solenoid Polarity Current
Toroid Polarity Current
Store
Shifter Name
Down Log
Reason
Comment
Run Comments
Begin Run
End Run
Evaluations
Run
Cal
CFT
Muon
SMT
CPS
FPS
ICD
FPD
Run Database Info and Hints

Feedback:
Please send all comments or suggestions (good or bad) regarding this page to d0db-support@fnal.gov. Please reference the URL in the subject. We need your feedback to make this a useful tool. Thank You!

Overview:
This page queries the Offline Runs Database.

You can filter your queries based on a large number of selection criteria. These filters are all based on AND condition logic. To assist in you in determining the value sets, many of the filters have links which will list the distinct value sets contained for that column in the database. Wildcards (%) can be used in most cases, but remember the data in these columns is case sensitive.

The result of your inital query will produce run details with a button on the run number. This button takes you to the trigger details for that run. On the tigger details page clicking the run number button will give you crate details 

RUN DETAILS
      |
      |---->TRIGGER DETAILS
                     |
                     |------->CRATE DETAILS

Other Queries:

  • Run Quality Queries
  • Other Offline Run Database Queries
    1. Other Parameters Per Run
    2. Luminosity Block Ranges (LBN) Per Run
    3. Luminosity Block (LBN) Lookup
    4. Run Triggers
    5. Run Crates
    6. Run Crate Attributes
    7. Exposure Groups Per Run
    8. Streams Per Run
    9. L1 Framework Terms
    10. L1 Framework EG Terms
    11. L1 Framework Bit Terms

  • Latest 20 Runs in the runs database

Query Tips:
  • Many of the column filters contain links that display the distinct value sets for that column contained in the database. Remember that all text strings are case sensitive.
  • Additional tips and hints on MISWEB usage can be found here
Column Descriptions
Run Number Run number assign by COOR. You can select a specific run (=) or query on a range using > and <.
(NO WILDCARDS)
Start Time - Time the run started (I.E. 2001-06-19 for June 19,2001).
- Time is in Central Time (either Daylight Savings (CDT) or Standard (CDT) depending on the time of year.
- You can select a specific date (=) or query on a range using > and <.
- (NO WILDCARDS MUST BE FULL DATE)
End Time - Time the run ended (I.E. 2001-06-19 for June 19,2001).
- Time is in Central Time (either Daylight Savings (CDT) or Standard (CDT) depending on the time of year.
- You can select a specific date (=) or query on a range using > and <.
- (NO WILDCARDS MUST BE FULL DATE)
Run Duration Length of the run in hours
Run TypeType of run (Test,Calibration,Physics,Cosmics)
Status Whether the run is COMPLETE, PARTIAL(no end run yet), EXPORTED (complete and sent to offline). Offline query should always show COMPLETE.
Trigger List
NameName of the trigger configuration file
VersionVersion number of the trigger config file
TypeType of trigger config used (test,calib, etc..)
L3 TypeType of Level 3 trigger used (REGULAR)
Prescale NameName of prescale used (eg-4Hz30%minbias)
PhysicsEither on (1) or off (0), depending on whether this configuration has the physics flag set
RecordingEither on (1) or off (0), depending on whether recording is enabled for this run
Solenoid
On OffWas the solenoid on (1.0) or off (0.0)
PolarityWas the solenoid forward(B Field points South) or reverse(B Field points North)
CurrentCurrent measurement of the solenoid /td>
Toroid
On OffWas the toroid on (1.0) or off (0.0)
PolarityWas the toroid forward or reverse
CurrentCurrent measurement of the toroid
StoreCurrent store number, only present if store is in progress
Shifter NameName of Shifter
Down Log
ReasonThe reason a previous run was stopped or killed
CommentComment on downlog reason
Run Comments
Begin RunComments at the beginning of a run
End RunEnd of the run comment
Evaluations
- Run in general
- Calibrations
- CFT Evaluation
- Muon Evaluation
- SMT Evaluation
- CPS Evaluation
- FPS Evaluation
- ICD Evaluation
- FPD Evaluation