------------------------------------------------------------------------ Request #48 (D. Neuhauser): =========================== Add field in waveform table to indicate SEED waveform quality (R,D,Q). The only way to currently find out the SEED waveform quality is to retrieve the waveform record. ------------------------------------------------------------------------ ==> Approved. Doug N. to come up with a field name (qc_level). Field will be VARCHAR(1) with NON NULL constraint & default of 'D'. ------------------------------------------------------------------------ Request #107 (D. Given): ======================== Add RFLAG column to MagPrefPriority. RFLAG VARCHAR(2) Constraint rflag IN ('a','h','f','r','A','H','F','R') This field is needed as an additional criterion to match the NetMag.rflag value of magnitudes that a human wants used regardless of their type, source, and quality. Other fields, e.g. subsource, magalgo, quality, uncertainty, are not suitable for this purpose because they contain other information about the magnitude. The MagPrefPriority is not yet used in production. Code in the MagPref package will be changed to use this new field. No other code changes are required. Note: this change depends on a constraint change to RFLAG in other tables, especially NetMag. ------------------------------------------------------------------------ ==> Not discussed. ------------------------------------------------------------------------ Request #108 (D. Given & A. Walter): ==================================== Change constraint of all RFLAG columns from ('a','h','f','A','H','F') to ('a','h','f','r','A','H','F','R'). Allows a new RFLAG value "R": A = automatic H = human reviewed F = final R = require * RFLAG = R means a parameter will be used regardless of any of its attributes (e.g. quality, source). This allows a human operator to force use of some data item. For example, if NetMag.flag = 'R' use this mag as preferred event though it has no supporting amps. Another example: if Amplitude.rflag = 'R' use this amp in the summary magnitude even if other trimming criteria would reject it. ------------------------------------------------------------------------ ==> Not discussed. ------------------------------------------------------------------------