Object Type	Table
Datasource	IPMA
Database	icsa

All attributes of this data entity are derived directly from the cswresvals 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

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 skewrfl

Reset frame skew level.

column utk

UTK time.

Table Usage (MB)

Distribution of Table Space

Data	19.43	Data	64.72 %
Indexes	10.49	Indexes	34.94 %
Unused	0.10	Unused	0.34 %
Total	30.02	Number of Rows	706081

Dependencies

Referencing Objects

Object Name Object Type

dbo.cswresvals.cswresvals_ucx INDEX

dbo.cswresvals.cswresvals_ux INDEX

Referenced Objects

Object Name Object Type

DDL

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

Object Name	Object Type
dbo.cswresvals.cswresvals_ucx	INDEX
dbo.cswresvals.cswresvals_ux	INDEX