Object Type	Table
Datasource	IPMA
Database	icsa

This is a static table containing the data quality flag definitions.

Use and RelatedData

The flagno's referenced in the dqr table relate to the flags defined in this table.

Various utilities are available to IDC members for data quality flag and comment manipulation.
Please see the DQR table for further information.

Population

Populated from the following static info:

flagno      inst flag
----------- ---- ----------------------------------------------------------------------
           1 CLPS Telemetry Drop
           2 CLPS Pointing Problem
           3 CLPS High glitch rate
           4 CLPS Pipeline Problem
           5 CLPS Suspicious Pointing
           6 CPS Wrong instrument configuration
           7 CPS Instrument disabled/failed
           8 CL   Saturation
           9 C    Bad Dark Subtraction
          10 C    Bad flat-fielding
          11 C    Bad deglitching
          12 C    Remnant pattern
          13 L    Significant transient effects
          14 L    Strong mismatch between detectors
          15 L    Presence of strong fringes
          16 L    Known extended source
          17 L    Significant strong-source effects present
          18 L    Near-infrared leak features
          19 L    57.16 micron feature in SW2
          20 L    Detector warm-up features
          21 L    Abnormally high dark current
          22 L    Low number of scans
          23 L    Low sampling
          24 L    Slow scanning
          25 L    Large number of negative fluxes
          26 L    Wheel Position Problem
          27 L    Original pipeline data affected by scan-numbering problem
          28 P    Off-centre pointing
          29 P    Default responsivity used
          30 P    Zero Signals
          31 P    Incomplete Raster Maps
          32 P    Exposure time reduced due to TM drop
          33 P    Saturation Sky Measurement
          34 P    Saturation FCS Measurement
          35 P    Flat-field Features
          36 P    Systematic Flux Offsets
          37 P    Possible Cirrus Confusion
          38 P    Source in Off-beam
          39 P    Temperature out of range
          40 P    Static Default RSRF applied
          41 P    Memory Effects
          42 P    FCS signal not stable
          43 P    Signals not stable
          44 P    Only 1 FCS measurement for map
          45 P    Straylight Feature
          46 P    Responsivity Offset due to By-passing Skylight
          47 P    Latch-up
          48 P    Wrong Chopper Angle
          49 P    Fatal glitch event
          50 P    Less efficient deglitching
          51 P    Inconsistent filter combinations
          52 S    Glitch tails identified in band 1
          53 S    Glitch tails identified in band 2
          54 S    Glitch tails identified in band 3
          55 S    Glitch tails identified in band 4
          56 S    Glitch tails identified in band 5
          57 S    Glitch tails identified in band 6
          58 S    Detector jumps identified in band 1
          59 S    Detector jumps identified in band 2
          60 S    Detector jumps identified in band 3
          61 S    Detector jumps identified in band 4
          62 S    Detector jumps identified in band 5
          63 S    Detector jumps identified in band 6
          64 S    Scan jumps identified in band 1
          65 S    Scan jumps identified in band 2
          66 S    Scan jumps identified in band 3
          67 S    Scan jumps identified in band 4
          68 S    Scan jumps identified in band 5
          69 S    Scan jumps identified in band 6
          70 S    Fringe residuals identified in band 1
          71 S    Fringe residuals identified in band 2
          72 S    Fringe residuals identified in band 3
          73 S    Fringe residuals identified in band 4
          74 S    Fringe residuals identified in band 5
          75 S    Fringe residuals identified in band 6
          76 S    Check dark subtraction
          77 S    Light leakage at 28 microns
          78 S    Increased noise due to preceeding CAM-CVF observation
          79 S    Extended source: check photometry
          80 S    No simultaneous SW grating scan
          81 S    Post-helium observation
          82 CLPS No science data
          83 CLPS Never executed
          84 CLPS Unknown
          85 CLPS Helium boil-off

Columns

Name	Datatype	Null

flagno	int	No

instruments	varchar(4)	No

flag	varchar(70)	No

help_anchor	varchar(16)	Yes

related_url	varchar(80)	Yes

column flagno

The flag number.

column instruments

A character string consisting of the letters 'C', 'L', 'P', 'S', indicating the instruments to which the flag applies.

column flag

A single line text description of the flag.

column help_anchor

The anchor name for the help on the flag in the flag help html page.

column related_url

A URL containing further help information on the flag.

Table Usage (MB)

Distribution of Table Space

Data	0.01	Data	16.67 %
Indexes	0.00	Indexes	4.17 %
Unused	0.04	Unused	79.17 %
Total	0.05	Number of Rows	85

Dependencies

Referencing Objects

Object Name Object Type

dbo.dqrflags.dqrflags_ux INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.dqrflags 
(
    flagno      int         NOT NULL,
    instruments varchar(4)  NOT NULL,
    flag        varchar(70) NOT NULL,
    help_anchor varchar(16) NULL,
    related_url varchar(80) NULL
)
LOCK ALLPAGES
go