Object Type	Table
Datasource	IPMA
Database	icsa

The data attributes of this entity are derived directly from the uplink MDB table lws_common.

Use and Related Data

An entity of this type exists for each LWS observation (except LWS paralllel) . The details of the measurement can be found in the LWS measurement table. See the uplink mdb.ddl file for further details.

Population

This table is populated by the script uplink_data.csh. The script uses bcp dump files produced by the utility programs dump_mdb and dump_isolog.

The script can take one or more of the following arguments:

no args:      This assumes that all tables have been created in the database
     icsa, and that all temporary tables have been built and populated
     with the necessary uplink data.

-build: Forces the building of the ICSA tables in the icsa database

-build_all: Forces the building and population of all temporary tables needed.

-compress:      Is used to indicate that the datafiles have been compressed with
     the UNIX utility 'compress'. The data files will be re-compressed
     after use.

-nodrop: Indicates that temporary tables should not be dropped after use.

Columns

Name Datatype Null

obsno int No

nmes int Yes

wlstart float Yes

wlend float Yes

column nmes

Number of measurements.

column obsno

Observation number constructed as follows:

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

Please see SCREW 385.

column wlend

End wavelength.

column wlstart

Start wavelength.

Table Usage (MB)

Distribution of Table Space

Data	0.13	Data	63.46 %
Indexes	0.04	Indexes	21.15 %
Unused	0.03	Unused	15.38 %
Total	0.20	Number of Rows	3696

Dependencies

Referencing Objects

Object Name Object Type

dbo.lws_common.lws_common_pk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.lws_common 
(
    obsno   int   NOT NULL,
    nmes    int   NULL,
    wlstart float NULL,
    wlend   float NULL
)
LOCK ALLPAGES
go

Name	Datatype	Null

obsno	int	No

nmes	int	Yes

wlstart	float	Yes

wlend	float	Yes

Object Name	Object Type
dbo.lws_common.lws_common_pk	INDEX