Object Type	Table
Datasource	IPMA
Database	icsa

The data in this table have been derived directly from the sphotchk table formerly located 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

itk_start	int	No

itk_end	int	No

obsno	int	Yes

detector	smallint	No

flux	real	No

noise	real	No

gain	smallint	No

flag	tinyint	No

re_set	smallint	No

gratstat	smallint	No

diffstat	smallint	No

column detector

Detector number.

column diffstat

Diffuse calibrator status.

column flag

Was check data applied.

column flux

Mean photometric check flux.

column gain

Gain factor per detector.

column gratstat

Grating calibrator source status.

column itk_end

End time in ITK.

column itk_start

Start time in ITK.

column noise

Photometric check noise.

column obsno

Observation number constructed as follows:

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

Please see SCREW 385 for further information.

column reset

Reset time per grating.

Table Usage (MB)

Distribution of Table Space

Data	11.54	Data	74.48 %
Indexes	3.88	Indexes	25.03 %
Unused	0.08	Unused	0.49 %
Total	15.50	Number of Rows	295464

Dependencies

Referencing Objects

Object Name Object Type

dbo.sphotchk.sphotchk_ucx INDEX

dbo.sphotchk.sphotchk_ux INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.sphotchk 
(
    itk_start int      NOT NULL,
    itk_end   int      NOT NULL,
    obsno     int      NULL,
    detector  smallint NOT NULL,
    flux      real     NOT NULL,
    noise     real     NOT NULL,
    gain      smallint NOT NULL,
    flag      tinyint  NOT NULL,
    re_set    smallint NOT NULL,
    gratstat  smallint NOT NULL,
    diffstat  smallint NOT NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.sphotchk.sphotchk_ucx	INDEX
dbo.sphotchk.sphotchk_ux	INDEX