Object Type	Table
Datasource	IPMA
Database	icsa

This table contains information about LWS observations. This information was deemed 'extra' information as it only came to light when the LWS 'expert panels' (see UI) were defined. This table contains the following information for each LWS
observation (excluding parallel):

Observation type
Stepsize
Number of resets
Number of spectral resolution elements (or Spectral scan width)
Integration time

The information contained in this table was extracted (or calculated) from the POF files.

Use and Related Data

Linked directly to an LWS observation via the observation number. This table is used by the UI for searches involving the LWS "expert panels".

Population

Populated by bespoke scripts that extracted the necessary values from the POF files. This was a 'one-off' activity and the table will not be re-populated.

Columns

Name	Datatype	Null

obsno	int	No

type	char(3)	No

stepsize	int	No

int_time	float	No

resets	int	No

nspecres	int	No

column obsno

Observation number

column type

Defines the type of observation. Must be one of:
FPL
FPS
GR

column stepsize

Step sized used.

column int_time

Integration time.

column resets

Number of resets

column nspecres

Number of spectral resolution elements

Table Usage (MB)

Distribution of Table Space

Data	0.90	Data	71.88 %
Indexes	0.32	Indexes	25.94 %
Unused	0.03	Unused	2.19 %
Total	1.25	Number of Rows	29782

Dependencies

Referencing Objects

Object Name Object Type

dbo.lws_extras.lws_extras_ix INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.lws_extras 
(
    obsno    int     NOT NULL,
    type     char(3) NOT NULL,
    stepsize int     NOT NULL,
    int_time float   NOT NULL,
    resets   int     NOT NULL,
    nspecres int     NOT NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.lws_extras.lws_extras_ix	INDEX