Object Type	Table
Datasource	IPMA
Database	icsa

The information in this table is extracted from the LWS LSPD SPD FITS product file data for each observation.

Use and Related Data

The following notes can be made about the following columns in this table:
lspdglvp (for L01 and L02 only)
lspdpdfpos (for L03 and L04 only).

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

gpsctkey_utk	int	No

gpsctkey	int	No

lspdfpos	int	Yes

lspdadet	int	Yes

lspdglvp	float	Yes

column gpsctkey

General prefix: ITK.

column gpsctkey_utk

General prefix: UTK.

column lspdadet

Active detector flags. Bit 0 = SW1, bit 1 = SW2... (bit 0=LSB).

column lspdfpos

FP position.

column lspdglvp

Grating LVDT position (average over mechanism position).

column obsno

Observation number constructed as follows:

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

Please see SCREW 385.

Table Usage (MB)

Distribution of Table Space

Data	412.72	Data	99.31 %
Indexes	2.70	Indexes	0.65 %
Unused	0.15	Unused	0.04 %
Total	415.57	Number of Rows	10776841

Dependencies

Referencing Objects

Object Name Object Type

dbo.lspd.lspd_ucx INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.lspd 
(
    obsno        int   NOT NULL,
    gpsctkey_utk int   NOT NULL,
    gpsctkey     int   NOT NULL,
    lspdfpos     int   NULL,
    lspdadet     int   NULL,
    lspdglvp     float NULL
)
LOCK ALLPAGES
go