Object Type	Table
Datasource	IPMA
Database	icsa

The columns of this table are derived directly from the clweoivals table of 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

cispmean	real	No

cisprms	real	No

cispmedi	real	No

imagmean	real	No

imagrms	real	No

eminpix	int	No

emaxpix	int	No

eoimaxpix	int	Yes

eoimax_i	smallint	Yes

eoimax_j	smallint	Yes

f2_adc_gain	smallint	Yes

f2_im_proc	smallint	Yes

f2_acc_ima	smallint	Yes

column cispmean

EOI less reset frame.

column cispmedi

EOI less reset frame median.

column cisprms

EOI less reset frame rms.

column emaxpix

EOI less reset maximum pixel in units of ADUs.

column eminpix

EOI less reset minimum pixel in units of ADUs.

column eoimax_I

EOI maximum pixel level abscisse.

column eoimax_j

EOI maximum pixel level ordinate.

column eoimaxpix

EOI maximum pixel level in units of ADUs.

column f2_acc_ima

Number of accumulated images.

column f2_adc_gain

ADC gain.

column f2_im_proc

On-board processing mode.

column imagmean

Mean of two consecutive images.

column imagrms

RMS of two consecutive images.

column obsno

Observation number constructed as follows:

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

Please see SCREW 385.

column utk

UTK time.

Table Usage (MB)

Distribution of Table Space

Data	456.46	Data	60.88 %
Indexes	293.17	Indexes	39.10 %
Unused	0.16	Unused	0.02 %
Total	749.79	Number of Rows	7244865

Dependencies

Referencing Objects

Object Name Object Type

dbo.clweoivals.clweoivals_ux INDEX

dbo.clweoivals.clweoivals_ix INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.clweoivals 
(
    utk         int      NOT NULL,
    obsno       int      NOT NULL,
    cispmean    real     NOT NULL,
    cisprms     real     NOT NULL,
    cispmedi    real     NOT NULL,
    imagmean    real     NOT NULL,
    imagrms     real     NOT NULL,
    eminpix     int      NOT NULL,
    emaxpix     int      NOT NULL,
    eoimaxpix   int      NULL,
    eoimax_i    smallint NULL,
    eoimax_j    smallint NULL,
    f2_adc_gain smallint NULL,
    f2_im_proc  smallint NULL,
    f2_acc_ima  smallint NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.clweoivals.clweoivals_ux	INDEX
dbo.clweoivals.clweoivals_ix	INDEX