------------------------------------------------------------------------ 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. ------------------------------------------------------------------------ ==> 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. ------------------------------------------------------------------------ ==> Discussed. ------------------------------------------------------------------------ Request #110 (A. Walter): ========================= Add to AmpType column constraint the type "WASF". New type needed to discriminate the maximum amps measured from a standard Wood-Anderson synthetic (WAS) from those measured from Wood-Anderson synthetic that has had extra filtering (WASF), like a highpass Butterworth to remove microseismic energy. ------------------------------------------------------------------------ ==> Approved. ------------------------------------------------------------------------