Object Type	Table
Datasource	IPMA
Database	icsa

Source of Quality Control (QC) information for an observation.

This table contains the text of Quality Control comments about an observation. This can come from one of several sources:

QC Comment
Suspect Pointing List
PHT QCL2 parts 1 & 2
LWS Quality check files
OFRP QC
LWS Parallel QC (lwswarning)

Several different comments (from different sources) may be available for a single observation.

A single comment may be contained in multiple table entries: the comment text is restricted to 255 characters and so longer comments must be split into multiple entries of this table. The 'line' column is used to distinguish the lines of a single comment.

Use and Related Data

The information contained in this table is linkjed directly to the observations table through the obsno column. More specifically, the prodwlty, qltyver, ofrp_prodqlty and ofrp_qltyver columns contain information relating to the quality of an observation. The comment_available field of an observation (in the observations table) specifies whether an observation has a quality comment in this table or not.

These commens are displayed in the UI under the 'Details' of an observation.

Population

See SPR 2818 for population details.

Also note that this table is regularly updated as new information on the quality of observations is discovered.

Columns

Name Datatype Null

obsno int No

source tinyint No

line int No

comment varchar(255) No

column obsno

Observation number.

column source

An integer value indicating the source (origin) of the comment. This is one of:
1    QC Comment
2    Suspect Pointing List
4    PHT QCL2 parts 1 & 2
5    LWS Quality check files
6    OFRP QC
7    LWS Parallel QC (lwswarning table)

column line

Indicates the line number of a comment for comments that span multiple lines (i.e. more than 255 characters).

column comment

The comment text.

Table Usage (MB)

Distribution of Table Space

Data	2.15	Data	70.81 %
Indexes	0.74	Indexes	24.48 %
Unused	0.14	Unused	4.70 %
Total	3.03	Number of Rows	31595

Dependencies

Referencing Objects

Object Name Object Type

dbo.comments.comments_ux INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.comments 
(
    obsno   int          NOT NULL,
    source  tinyint      NOT NULL,
    line    int          NOT NULL,
    comment varchar(255) NOT NULL
)
LOCK ALLPAGES
go

Name	Datatype	Null

obsno	int	No

source	tinyint	No

line	int	No

comment	varchar(255)	No