Object Type	Table
Datasource	IPMA
Database	icsa

This table contains the data quality flag assignement history for each observation.
See the DQR entity for further information.

Use and RelatedData

See DQR table.

Population

Ongoing. An entry is added to this table each time a data quality flag is added to or removed from an observation.

Columns

Name	Datatype	Null

date	datetime	No

username	varchar(16)	No

obsno	int	No

flagno	numeric(3,0)	No

action	varchar(7)	No

column date

The date of the action indicated.

column username

The user who invoked the action.

column obsno

The observation number affected.

column flagno

The flag number of the action performed.

column action

The action taken: this is one of INITIAL, ADDED, REMOVED

Table Usage (MB)

Distribution of Table Space

Data	5.98	Data	29.17 %
Indexes	14.47	Indexes	70.52 %
Unused	0.06	Unused	0.31 %
Total	20.52	Number of Rows	156232

Dependencies

Referencing Objects

Object Name Object Type

dbo.dqr_history.dqr_history_ix1 INDEX

dbo.dqr_history.dqr_history_ix2 INDEX

dbo.dqr_history.dqr_history_ix3 INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.dqr_history 
(
    date     datetime     NOT NULL,
    username varchar(16)  NOT NULL,
    obsno    int          NOT NULL,
    flagno   numeric(3,0) NOT NULL,
    action   varchar(7)   NOT NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.dqr_history.dqr_history_ix1	INDEX
dbo.dqr_history.dqr_history_ix2	INDEX
dbo.dqr_history.dqr_history_ix3	INDEX