Object Type	Table
Datasource	IPMA
Database	icsa

The columns of this table come directly from the cglitch 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

pixnum	smallint	No

maxpix	int	No

meanpix	real	No

tint	real	Yes

column maxpix

Maximum value of a glitch pixel. Units of ADUs.

column meanpix

Mean value of all glitch pixels.

column obsno

Observation number constructed as follows:

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

Please see SCREW 385 for further details.

column pixnum

Number of pixels with glitches.

column tint

Integration time.

column utk

Time in UTK.

Table Usage (MB)

Distribution of Table Space

Data	216.21	Data	54.10 %
Indexes	183.28	Indexes	45.86 %
Unused	0.13	Unused	0.03 %
Total	399.62	Number of Rows	7195387

Dependencies

Referencing Objects

Object Name Object Type

dbo.cglitch.cglitch_ux INDEX

dbo.cglitch.cglitch_ux2 INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.cglitch 
(
    utk     int      NOT NULL,
    obsno   int      NOT NULL,
    pixnum  smallint NOT NULL,
    maxpix  int      NOT NULL,
    meanpix real     NOT NULL,
    tint    real     NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.cglitch.cglitch_ux	INDEX
dbo.cglitch.cglitch_ux2	INDEX