Search/Navigation:
Related:
SLAC
/EPP/HPS Public
Jefferson Lab/Hall B/HPS Run Wiki
S30XL-LESA/LDMX
Note, the EPICS PV column is not part of the database table, but just inserted here for reference.
mysql> describe run_log_begin; +--------------------------+--------------+------+-----+---------+-------+----------+ | Field | Type | Null | Key | Default | Extra | EPICS PV | +--------------------------+--------------+------+-----+---------+-------+----------+ | session_name | varchar(20) | YES | | NULL | | | run | int(11) | YES | MUL | NULL | | | start_date | datetime | YES | | NULL | | | configuration | varchar(20) | YES | | NULL | | | trigger_config | varchar(80) | YES | | NULL | | | prescale_1 | int(11) | YES | | NULL | | | prescale_2 | int(11) | YES | | NULL | | | prescale_3 | int(11) | YES | | NULL | | | prescale_4 | int(11) | YES | | NULL | | | prescale_5 | int(11) | YES | | NULL | | | prescale_6 | int(11) | YES | | NULL | | | beam_energy | float | YES | | NULL | | MBSY2C_energy | a_slit_position | float | YES | | NULL | | SMRPOSA | b_slit_position | float | YES | | NULL | | SMRPOSB | c_slit_position | float | YES | | NULL | | SMRPOSC | mini_current | float | YES | | NULL | | MTDACRBCK | pspec_current | float | YES | | NULL | | PSPECIRBCK | tagger_beam_vac | float | YES | | NULL | | VCG2C24ATr | upstream_beam_vac | float | YES | | NULL | | VCG2H00ATr | dnstream_beam_vac | float | YES | | NULL | | VGC2H02ATr | target_vac | float | YES | | NULL | | HPS_SVT:PLC:i:Vacuum-Value | halo_up_left | float | YES | | NULL | | scaler_cS3b.VAL | halo_up_right | float | YES | | NULL | | scaler_cS4b.VAL | halo_down_up | float | YES | | NULL | | scalerS8b.VAL | halo_down_down | float | YES | | NULL | | scalerS10b.VAL | halo_down_left | float | YES | | NULL | | scalerS9b.VAL | halo_down_right | float | YES | | NULL | | scalerS11b.VAL | halo_hps_left | float | YES | | NULL | | scalerS12b.VAL | halo_hps_right | float | YES | | NULL | | scalerS13b.VAL | halo_hps_top | float | YES | | NULL | | scalerS14b.VAL | halo_hps_sc | float | YES | | NULL | | scalerS15b.VAL | bpm_2c21a_x | float | YES | | NULL | | hallb_IPM2C21A_XPOS | bpm_2c21a_y | float | YES | | NULL | | hallb_IPM2C21A_YPOS | bpm_2c21a_i | float | YES | | NULL | | hallb_IPM2C21A_CUR | bpm_2c24a_x | float | YES | | NULL | | hallb_IPM2C24A_XPOS | bpm_2c24a_y | float | YES | | NULL | | hallb_IPM2C24A_YPOS | bpm_2c24a_i | float | YES | | NULL | | hallb_IPM2C24A_CUR | bpm_2h00_x | float | YES | | NULL | | hallb_IPM2H00_XPOS | bpm_2h00_y | float | YES | | NULL | | hallb_IPM2H00_YPOS | bpm_2h01_x | float | YES | | NULL | | hallb_IPM2H01_XPOS | bpm_2h01_y | float | YES | | NULL | | hallb_IPM2H01_YPOS | bpm_2h01_i | float | YES | | NULL | | hallb_IPM2H01_CUR | bpm_2h02_x | float | YES | | NULL | | hallb_IPM2H02_XPOS | bpm_2h02_y | float | YES | | NULL | | hallb_IMP2H02_YPOS +--------------------------+--------------+------+-----+---------+-------+ mysql> describe run_log_end; +------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+-------------+------+-----+---------+-------+ | session_name | varchar(20) | YES | | NULL | | | run | int(11) | YES | MUL | NULL | | | end_date | datetime | YES | | NULL | | | end_ok | char(1) | YES | | NULL | | | nfile | int(11) | YES | | NULL | | | nevent | int(11) | YES | | NULL | | | nerror | int(11) | YES | | NULL | | | fcup | int(11) | YES | | NULL | | | fcup_active | int(11) | YES | | NULL | | | fcup_live | int(11) | YES | | NULL | | | clock | int(11) | YES | | NULL | | | clock_active | int(11) | YES | | NULL | | | clock_live | int(11) | YES | | NULL | | | trig_event_bit1 | int(11) | YES | | NULL | | | trig_event_bit2 | int(11) | YES | | NULL | | | trig_event_bit3 | int(11) | YES | | NULL | | | trig_event_bit4 | int(11) | YES | | NULL | | | trig_event_bit5 | int(11) | YES | | NULL | | | trig_event_bit6 | int(11) | YES | | NULL | | +------------------+-------------+------+-----+---------+-------+ mysql> describe run_log_comment; +----------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------------+--------------+------+-----+---------+-------+ | session_name | varchar(20) | YES | | NULL | | | run | int(11) | YES | MUL | NULL | | | entry_date | datetime | YES | | NULL | | | run_type | varchar(20) | YES | | NULL | | | target | varchar(25) | YES | | NULL | | | beam_current_request | float | YES | | NULL | | | operators | varchar(100) | YES | | NULL | | | comment | text | YES | | NULL | | | ignore_run | char(1) | YES | | NULL | | +----------------------+--------------+------+-----+---------+-------+
Overview
Content Tools