INDICES FOR TABLE  TargRunQA

The RunQA table provides information relevant to the average data quality for the objects in each field for the TARGET skyVersion (see the RunQA table for the BEST skyVersion).

This table may be joined to the rest of your query to sub-select only fields of the very highest quality, for instance, with seeing below a certain threshold, if that is desired. For example:
SELECT TOP 10 f.field, f.run, r.fieldQall
FROM Field f, TargRunQA r
WHERE
f.fieldid=r.fieldid
AND r.fieldQall IN (2,3) -- GOOD or EXCELLENT quality

If you want just one number that describes the overall quality of a field, your best bet is the fieldQall number (0=bad, 1=acceptable, 2=good, 3=excellent). This overall quality determination is based on the (dereddened) principal colors of all the stars in the field vs. the Galactic value of this quantity, the PSF quality, the difference between Aperture and PSF magnitudes for the same stars in the field, and the seeing.

Index TypeKey or Field List
primary keyfieldID