Object Type	Table
Datasource	IPMA
Database	icsa

The SWS compact status table, giving the instrument parameters, e.g. wheel positions, integration times, observation modes, etc. There is a single entry per measurement - when any instrument setting changes, a new measurement is started and hence a new row in this table is present.

All columns of this table are derived directly from the sws-csta table of the IPA, which in turn was derived from the similarily named SWS product file (from where this table is populated).

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

obsno	int	No

utc_start_1	int	No

utc_start_2	int	No

utc_end_1	int	No

utc_end_2	int	No

csgpukst	int	No

csgpuken	int	No

csgpikst	int	No

csgpiken	int	No

sstashut	smallint	No

sstagain1	smallint	No

sstagain2	smallint	No

sstagain3	smallint	No

sstagain4	smallint	No

sstagain5	smallint	No

sstagain6	smallint	No

sstacals1	smallint	No

sstacals2	smallint	No

sstacals3	smallint	No

sstacals4	smallint	No

sstaresp1	smallint	No

sstaresp2	smallint	No

sstahkmd	smallint	No

sstafps	smallint	No

filename	char(12)	No

version	char(4)	No

column csgpiken

Observation end ITK.

column csgpikst

Observation start ITK.

column csgpuken

Observation end UTK.

column csgpukst

Observation start UTK.

column filename

FITS filename.

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 sstacals1

Calibration source status grating.

column sstacals2

Calibration source status status flusher.

column sstacals3

Calibration source status FP.

column sstacals4

Calibration source status diffuse.

column sstafps

FP selection.

column sstagain1
column sstagain2
column sstagain3
column sstagain4
column sstagain5
column sstagain6

Normal gain in band 1 to 6.

column sstahkmd

House keeping mode.

column sstaresp1

SW reset pulse interval (frames).

column sstaresp2

LW reset pulse interval (frames).

column sstashut

Shutter position.

column utc_end_1

UTC time of the end of the observation truncated to a whole number of seconds after the beginning of the year 1989.

column utc_end_2

Remaining fraction of a second that had been truncated from the preceding UTC value (utc_end_1).

column utc_start_1

UTC time of the start of the observation truncated to a whole number of seconds after the beginning of the year 1989.

column utc_start_2

Remaining fraction of a second that had been truncated from the preceding UTC value (utc_start_1).

column version

Version of FITS file. Version is obtained from the keyword FILEVERS.

Table Usage (MB)

Distribution of Table Space

Data	8.63	Data	75.65 %
Indexes	2.66	Indexes	23.33 %
Unused	0.12	Unused	1.03 %
Total	11.40	Number of Rows	101582

Dependencies

Referencing Objects

Object Name Object Type

dbo.sws_cstat.sws_cstat_ucx INDEX

dbo.sws_cstat.sws_cstat_ux INDEX

dbo.sws_cstat.sws_cstat_x INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.sws_cstat 
(
    obsno       int      NOT NULL,
    utc_start_1 int      NOT NULL,
    utc_start_2 int      NOT NULL,
    utc_end_1   int      NOT NULL,
    utc_end_2   int      NOT NULL,
    csgpukst    int      NOT NULL,
    csgpuken    int      NOT NULL,
    csgpikst    int      NOT NULL,
    csgpiken    int      NOT NULL,
    sstashut    smallint NOT NULL,
    sstagain1   smallint NOT NULL,
    sstagain2   smallint NOT NULL,
    sstagain3   smallint NOT NULL,
    sstagain4   smallint NOT NULL,
    sstagain5   smallint NOT NULL,
    sstagain6   smallint NOT NULL,
    sstacals1   smallint NOT NULL,
    sstacals2   smallint NOT NULL,
    sstacals3   smallint NOT NULL,
    sstacals4   smallint NOT NULL,
    sstaresp1   smallint NOT NULL,
    sstaresp2   smallint NOT NULL,
    sstahkmd    smallint NOT NULL,
    sstafps     smallint NOT NULL,
    filename    char(12) NOT NULL,
    version     char(4)  NOT NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.sws_cstat.sws_cstat_ucx	INDEX
dbo.sws_cstat.sws_cstat_ux	INDEX
dbo.sws_cstat.sws_cstat_x	INDEX