Object Type	Table
Datasource	IPMA
Database	icsa

This table contains the data quality flags assigned to an observation. It is this table that contains the information that forms the basis of the Observation Data Quality Report (DQR). A detailed description of the ISO DQR system is out of the scope of this document, and the reader is referred to SCREW 509 for further details.

Use and RelatedData

Please see SCREW 509 for a detailed description of the Data Quality Report system.

Population

Ongoing. Initial population was derived from the old prodqlty flag (still available in observations table) together with additional quality information provided by EV.

Columns

Name	Datatype	Null

obsno	int	No

flagno	numeric(3,0)	No

column obsno

Observation number

column flagno

Flag number attached to observation.

Table Usage (MB)

Distribution of Table Space

Data	1.67	Data	29.38 %
Indexes	3.94	Indexes	69.35 %
Unused	0.07	Unused	1.27 %
Total	5.68	Number of Rows	21009

Dependencies

Referencing Objects

Object Name Object Type

dbo.dqr.dqr_ix INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.dqr 
(
    obsno  int          NOT NULL,
    flagno numeric(3,0) NOT NULL
)
LOCK ALLPAGES
go