Object Type	Table
Datasource	IPMA
Database	icsa

The columns of this table are derived directly from the clwresvals table in the IPA database.

Use and Related Data

See the ISO Data Product Document, IDPD SAI/94-1266/Dc for a further description of the columns in this table.

Population

This table has been populated during BKRP by db-import.

Columns

Name	Datatype	Null

utk	int	No

obsno	int	No

meanrfl	real	No

medirfl	real	No

rmsrfl	real	No

skewrfl	real	No

rowdiff	real	No

colrms	real	No

column colrms

RMS of columns.

column meanrfl

Reset frame mean level.

column medirfl

Reset frame median level.

column obsno

Observation number constructed as follows:

revolution number * 1000000 + target number * 1000 + observation sequence number * 10 + type.

Please see SCREW 385.

column rmsrfl

Reset frame RMS level.

column rowdiff

Mean of dofference in odd and even rows.

column skewrfl

Reset frame skew level.

column utk

UTK time.

Table Usage (MB)

Distribution of Table Space

Data	143.85	Data	70.42 %
Indexes	60.27	Indexes	29.50 %
Unused	0.16	Unused	0.08 %
Total	204.28	Number of Rows	4050828

Dependencies

Referencing Objects

Object Name Object Type

dbo.clwresvals.clwresvals_ucx INDEX

dbo.clwresvals.clwresvals_ux INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.clwresvals 
(
    utk     int  NOT NULL,
    obsno   int  NOT NULL,
    meanrfl real NOT NULL,
    medirfl real NOT NULL,
    rmsrfl  real NOT NULL,
    skewrfl real NOT NULL,
    rowdiff real NOT NULL,
    colrms  real NOT NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.clwresvals.clwresvals_ucx	INDEX
dbo.clwresvals.clwresvals_ux	INDEX