Moller Results Database
From Hall A Wiki
Here is a link to a database for Moller runs information compiled for PREXII [1]
This is an sqlite3 database. To run it type at the command line
$sqlite3 MollerRunsDB.sql sqlite>
There are 3 tables available:
- moller_output: information output by the analysis script
- moller_settings: configuration setting and EPICS readbacks taken at the beginning of each run
- moller_quality: general information about the type of run and quality
To see what is available type .schema at the sqlite prompt
sqlite>.schema CREATE TABLE moller_output( run INTEGER PRIMARY KEY, -- run number left_singles INTEGER DEFAULT 0, -- average left detector singles rate (per helicity) right_singles INTEGER DEFAULT 0, -- average right detector singles rate (per helicity) coinc INTEGER DEFAULT 0, -- average coincidence rate (per helicity) accid INTEGER DEFAULT 0, -- average accidental rate (per helicity) bcm INTEGER DEFAULT 0, -- average bcm scalar counts per helicity clock INTEGER DEFAULT 0, -- average clock counts per helicity corrected_asym REAL DEFAULT 0, -- corrected asymmetry corrected_asym_err REAL DEFAULT 0, -- corrected asymmetry error pol REAL DEFAULT 0, -- calculated polarization pol_err REAL DEFAULT 0, -- calculated polarization error analyzing_pow REAL DEFAULT 0, -- effective analyzing power Azz target_pol REAL DEFAULT 0, -- target polarization pol_left REAL DEFAULT 0, -- left detector only asymmetry pol_right REAL DEFAULT 0, -- right detector only asymmetry bcm_asym REAL DEFAULT 0, -- bcm asymmetry bcm_asym_err REAL DEFAULT 0 -- bcm asymmetry error ); CREATE TABLE moller_settings( run INTEGER PRIMARY KEY, -- run number run_type TEXT DEFAULT , -- run type eg. beam_pol run_start TEXT DEFAULT , -- run start date and time run_end TEXT DEFAULT , -- run end date and time run_length REAL DEFAULT 0, -- run duration (seconds) trig_thresh_ch0 REAL DEFAULT 0, -- ch 0 (left) detector discriminator threshold (mV) trig_thresh_ch1 REAL DEFAULT 0, -- ch 1 (right) detector discriminator threshold (mV) ihwp_in INTEGER DEFAULT -1, -- insertable half-wave plate IN=1; OUT=0 target INTEGER DEFAULT 0, -- target 0=not on any target; 1=Cu 11um; 2=Fe 10um; 3=Fe 4um; 4=Fe 1um; E_beam REAL DEFAULT 0, -- Beam energy, MeV Hall A E_inj REAL DEFAULT 0, -- Injector energy, MeV E_Slinac REAL DEFAULT 0, -- South linac energy, MeV E_Nlinac REAL DEFAULT 0, -- North linac energy, MeV n_pass REAL DEFAULT 0, -- Passes Hall A bcm_avg REAL DEFAULT 0, -- Beam Current Average unser REAL DEFAULT 0, -- Current on Unser monitor bcm_us REAL DEFAULT 0, -- Current on Upstream bcm bcm_ds REAL DEFAULT 0, -- Current on Downstream bcm inj_bcm_tot REAL DEFAULT 0, -- Injector Full Current Monitor 02 inj_bcm_halla REAL DEFAULT 0, -- Injector Current Monitor Hall A bpm01_X REAL DEFAULT 0, -- Beam Position BPM01 X, mm bpm01_Y REAL DEFAULT 0, -- Beam Position BPM01 Y, mm bpm04_X REAL DEFAULT 0, -- Beam Position BPM04 X, mm bpm04_Y REAL DEFAULT 0, -- Beam Position BPM04 Y, mm bpm04a_X REAL DEFAULT 0, -- Beam Position BPM04A X, mm bpm04a_Y REAL DEFAULT 0, -- Beam Position BPM04A Y, mm q1_cur REAL DEFAULT 0, -- Quad Q1 (Amps) q2_cur REAL DEFAULT 0, -- Quad Q2 (Amps) q3_cur REAL DEFAULT 0, -- Quad Q3 (Amps) q4_cur REAL DEFAULT 0, -- Quad Q4 (Amps) dip_cur REAL DEFAULT 0, -- Dipole (Amps) tgt_angle REAL DEFAULT 0, -- Target Rotary Position(V) tgt_angle_deg REAL DEFAULT 0, -- Rotary Position in deg tgt_lin_pos REAL DEFAULT 0, -- Target Linear Position(V) tgt_lin_pos_mm REAL DEFAULT 0, -- Linear Position in mm ihwp TEXT DEFAULT , -- Laser 1/2 wave plate rhwp REAL DEFAULT 0, -- Rotating 1/2 wave plate vwien_angle REAL DEFAULT 0, -- VWien filter angle, deg sol_phi_fg REAL DEFAULT 0, -- Solenoids angle, deg hwien_angle REAL DEFAULT 0, -- HWien filter angle, deg hel_pattern TEXT DEFAULT , -- Helicity mode/pattern hel_freq REAL DEFAULT 0, -- Helicity frequency hel_delay TEXT DEFAULT , -- Helicity delay t_settle REAL DEFAULT 0, -- MPS signal, usec t_stable REAL DEFAULT 0, -- Helicity window, usec bpm02a_X REAL DEFAULT 0, -- Beam Position BPM02A X, mm bpm02a_Y REAL DEFAULT 0, -- Beam Position BPM02A Y, mm mol_mag_cur_set REAL DEFAULT 0, -- AM430 Current Setpoint (A) mol_mag_cur_meas REAL DEFAULT 0, -- AM430 Measured Current (A) mol_mag_v_meas REAL DEFAULT 0, -- AM430 Measured Voltage (A) mol_mag_field_meas REAL DEFAULT 0, -- AM430 Measured Field (T) mol_mag_ramp_state REAL DEFAULT 0, -- AMS430 Ramp State mol_cooler_temp REAL DEFAULT 0, -- Cryocooler Temperature (K) mol_mag_T2temp REAL DEFAULT 0, -- Magnet(T2) Temperature(K) mol_mag_lead1_temp REAL DEFAULT 0, -- Magnet Lead #1 (T6) Temperature mol_mag_lead2_temp REAL DEFAULT 0, -- Magnet Lead #2 (T7) Temperature det_hv_ch1 REAL DEFAULT 0, -- Moller Detector measured HV ch 1 det_hv_ch2 REAL DEFAULT 0, -- Moller Detector measured HV ch 2 det_hv_ch3 REAL DEFAULT 0, -- Moller Detector measured HV ch 3 det_hv_ch4 REAL DEFAULT 0, -- Moller Detector measured HV ch 4 det_hv_ch5 REAL DEFAULT 0, -- Moller Detector measured HV ch 5 det_hv_ch6 REAL DEFAULT 0, -- Moller Detector measured HV ch 6 det_hv_ch7 REAL DEFAULT 0, -- Moller Detector measured HV ch 7 det_hv_ch8 REAL DEFAULT 0, -- Moller Detector measured HV ch 8 det_ap_ch1 REAL DEFAULT 0, -- Moller Detector measured HV Ap 1 det_ap_ch2 REAL DEFAULT 0, -- Moller Detector measured HV Ap 2 det_ap_ch3 REAL DEFAULT 0, -- Moller Detector measured HV Ap 3 det_ap_ch4 REAL DEFAULT 0, -- Moller Detector measured HV Ap 4 det_ap_ch5 REAL DEFAULT 0, -- Moller Detector measured HV Ap 5 det_ap_ch6 REAL DEFAULT 0, -- Moller Detector measured HV Ap 6 det_ap_ch7 REAL DEFAULT 0, -- Moller Detector measured HV Ap 7 det_ap_ch8 REAL DEFAULT 0, -- Moller Detector measured HV Ap 8' trig_thresh REAL DEFAULT 0, -- trigger threshold in mV trig_type TEXT DEFAULT , -- trigger type: 'left', 'right' or 'coinc' mol_pow_sup_cur REAL DEFAULT 0, -- Moller power supply current (A) FOREIGN KEY(run) REFERENCES moller_output(run) ); CREATE TABLE moller_quality( run INTEGER PRIMARY KEY, -- run number task TEXT DEFAULT , -- 'pol'=polarization, 'qsc'=quad scan, 'dsc'=dipole scan, 'thr'=threshold study, 'trg'=trigger study, 'hv'=high voltage study, 'ped'=pedestal, 'oth'=other quality TEXT DEFAULT , -- 'good', 'suspect', 'bad' comment TEXT DEFAULT , -- user input comment about run FOREIGN KEY(run) REFERENCES moller_output(run) );
