Object Type	Table
Datasource	IPMA
Database	icsa

The information in this table is extracted from the following LWS FITS file binary extension headers:

Compact Status	ERD Products	SPD Products	AA Products
LSAT	LGER	LSPD	LSNR
	LSER	LWGH	LSAN
	LLER		LIAC
	LIER		LSCA
	LXER		LGIF
	LWHK

Note that the values for the columns specifying the number of records in each FITS file (e.g. lstano) are extracted from the NAXIS2 field in the specific files (e.g. lstano will be extracted from the NAXIS2 field in the LWS LSTA FITS file). In the case where a certain FITS file was not produced for this observation, then the corresponding column should be zero.

Use and Related Data

See the ISO Data Product Document, IDPD SAI/94-1266/Dc for a further description of the NAXIS2 fields in the specific files.

Population

This table has been populated during BKRP by db-import.

Columns

Name	Datatype	Null

obsno	int	No

lstano	int	No

lgerno	int	No

lserno	int	No

llerno	int	No

lierno	int	No

lxerno	int	No

lwhkno	int	No

lspdno	int	No

lwghno	int	No

lsnrno	int	No

lsanno	int	No

liacno	int	No

lscano	int	No

lgifno	int	No

column lgerno

Number of records in LGER FITS product file.

column lgifno

Number of records in LGIF FITS product file.

column liacno

Number of records in LIAC FITS product file.

column lierno

Number of records in LIER FITS product file.

column llerno

Number of records in LLER FITS product file.

column lsanno

Number of records in LSAN FITS product file.

column lscano

Number of records in LSCA FITS product file.

column lserno

Number of records in LSER FITS product file.

column lsnrno

Number of records in LSNR FITS product file.

column lspdno

Number of records in LSPD FITS product file.

column lstano

Number of records in LSTA FITS product file.

column lwghno

Number of records in LWGH FITS product file.

column lwhkno

Number of records in LWHK FITS product file.

column lxerno

Number of records in LXER FITS product file.

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.

Table Usage (MB)

Distribution of Table Space

Data	0.56	Data	90.25 %
Indexes	0.01	Indexes	1.26 %
Unused	0.05	Unused	8.49 %
Total	0.62	Number of Rows	8842

Dependencies

Referencing Objects

Object Name Object Type

dbo.lsizes.lsizes_ucx INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.lsizes 
(
    obsno  int NOT NULL,
    lstano int NOT NULL,
    lgerno int NOT NULL,
    lserno int NOT NULL,
    llerno int NOT NULL,
    lierno int NOT NULL,
    lxerno int NOT NULL,
    lwhkno int NOT NULL,
    lspdno int NOT NULL,
    lwghno int NOT NULL,
    lsnrno int NOT NULL,
    lsanno int NOT NULL,
    liacno int NOT NULL,
    lscano int NOT NULL,
    lgifno int NOT NULL
)
LOCK ALLPAGES
go