Object Type	Table
Datasource	IPMA
Database	icsa

This table contains data relating to the details of the specific measurements made by the SWS instrument for each observation. The data relate to the variable parameters that were input, directly or indirectly, using the PGA subsystem. The columns of this table have been derived directly from those of the sws_measure table in the uplink MDB.

Use and Related Data

Each SWS measurement relates directly to a SWS observation in the observations entity through the sws_common table. See the uplink mdb.ddl file for further details.

Population

This table is populated by the script uplink_data.csh, together with other uplink-derived data entities. 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 IDA 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

wlstart	float	Yes

wlend	float	Yes

wlref	float	Yes

delta_v	float	Yes

sflx	float	Yes

fd_peak	float	Yes

sgnr_req	float	Yes

sgnr_exp	float	Yes

inttime	float	Yes

column count_index

Index to distinguish between entries.

column delta_v

Velocity range to scan.

column fd_peak

Expected peak flux density.

column inttime

Measurement integration time.

column obsno

Observation number constructed as follows:

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

Please see SCREW 385 for further information.

column sflx

Expected source flux density.

column sgnr_exp

Expected signal to noise ratio.

column sgnr_req

Requested signal to noise ratio.

column wlend

End wavelength for ranges.

column wlref

Reference wavelength for scans.

column wlstart

Start wavelength for ranges or central wavelength for lines.

Table Usage (MB)

Distribution of Table Space

Data	1.88	Data	78.17 %
Indexes	0.48	Indexes	19.97 %
Unused	0.04	Unused	1.87 %
Total	2.41	Number of Rows	20196

Dependencies

Referencing Objects

Object Name Object Type

dbo.sws_measurement.sws_common_meas_fk INDEX

dbo.sws_measurement.sws_measurement_pk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.sws_measurement 
(
    obsno       int      NOT NULL,
    count_index smallint NOT NULL,
    wlstart     float    NULL,
    wlend       float    NULL,
    wlref       float    NULL,
    delta_v     float    NULL,
    sflx        float    NULL,
    fd_peak     float    NULL,
    sgnr_req    float    NULL,
    sgnr_exp    float    NULL,
    inttime     float    NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.sws_measurement.sws_common_meas_fk	INDEX
dbo.sws_measurement.sws_measurement_pk	INDEX