Object Type	Table
Datasource	IPMA
Database	icsa

The attributes of this entity have been derived directly from the uplink MDB table lws_measure and contain the planned measurement details for an LWS observation (i.e. those entered by the observer using the PGA system).

Use and Related Data

Each LWS measurement contained in this table is traceable to an LWS observation in the observations table through the lws_common table. Each lws_common entry may have several measurements. 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

count_index smallint No

wave float Yes

sgnr float Yes

e_sgnr float Yes

cflx float Yes

lflx float Yes

lwidth float Yes

fast tinyint No

nspel tinyint No

interval tinyint No

inttime float Yes

e_inttime float Yes

compflag tinyint Yes

column cflx

Continuum Flux. Units: Jy.

column compflag

Item entered by the user in PGA:

1 - User entered integration time (column inttime), e_sgnr is calculated.

2 - User entered signal to noise ratio (column sgnr), e_inttime is calculated.

column count_index

Index to distinguish between entries.

column e_inttime

Achieved (calculated) intergration time per step. Units: seconds.

column e_sgnr

Achieved (calculated) signal to noise ratio.

column fast

Fast scans:

0 - False

1 - True.

column interval

Spectral sampling interval (steps):

1, 2, 4 or 8

column inttime

Requested intergration time per step. Units: seconds.

column lflx

Line flux. Units: Wm-2*E-17.

column lwidth

Line width.

column nspel

Spectral scan width (resolution elements):

0, 2, 3, 4 or 5

column obsno

Observation number constructed as follows:

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

Please see SCREW 385.

column sgnr

Requested signal to noise ratio.

column wave

Line or reference wavelength.

Table Usage (MB)

Distribution of Table Space

Data	0.69	Data	73.54 %
Indexes	0.19	Indexes	19.79 %
Unused	0.06	Unused	6.67 %
Total	0.94	Number of Rows	7729

Dependencies

Referencing Objects

Object Name Object Type

dbo.lws_measurement.lws_common_meas_fk INDEX

dbo.lws_measurement.lws_measurement_pk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.lws_measurement 
(
    obsno       int      NOT NULL,
    count_index smallint NOT NULL,
    wave        float    NULL,
    sgnr        float    NULL,
    e_sgnr      float    NULL,
    cflx        float    NULL,
    lflx        float    NULL,
    lwidth      float    NULL,
    fast        tinyint  NOT NULL,
    nspel       tinyint  NOT NULL,
    interval    tinyint  NOT NULL,
    inttime     float    NULL,
    e_inttime   float    NULL,
    compflag    tinyint  NULL
)
LOCK ALLPAGES
go

Name	Datatype	Null

obsno	int	No

count_index	smallint	No

wave	float	Yes

sgnr	float	Yes

e_sgnr	float	Yes

cflx	float	Yes

lflx	float	Yes

lwidth	float	Yes

fast	tinyint	No

nspel	tinyint	No

interval	tinyint	No

inttime	float	Yes

e_inttime	float	Yes

compflag	tinyint	Yes

Object Name	Object Type
dbo.lws_measurement.lws_common_meas_fk	INDEX
dbo.lws_measurement.lws_measurement_pk	INDEX