Object Type	Table
Datasource	IPMA
Database	icsa

These are planned SWS instrument parameters entered by the user using PGA. The data columns of this entry are derived directly from the uplink MDB table sws_common. The values in this table relate to general parameters used by all SWS AOTs. There is one row per observation using a SWS AOT.

Use and Related Data

Specific information relating to the measurements of a SWS observation can be found in the sws_measurements table.

Population

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

nmes	int	Yes

nmessw	int	Yes

speed	int	Yes

radial_velocity	float	Yes

column nmes

Number of measurements. In case this observation is an AOT S07, this column conatins the number of FP measurements.

column nmessw

Number of SW measurements for AOT S07.

column obsno

Observation number constructed as follows:
revolution number * 1000000 + target number * 1000 + observation sequence number * 10 + type.
Please see SCREW 385 for more information.

column radial_velocity

Radial velocity of the source.

column speed

Number of telemetry frames per grating step.

Table Usage (MB)

Distribution of Table Space

Data	0.14	Data	67.31 %
Indexes	0.04	Indexes	22.12 %
Unused	0.02	Unused	10.58 %
Total	0.20	Number of Rows	3847

Dependencies

Referencing Objects

Object Name Object Type

dbo.sws_common.sws_common_pk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.sws_common 
(
    obsno           int   NOT NULL,
    nmes            int   NULL,
    nmessw          int   NULL,
    speed           int   NULL,
    radial_velocity float NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.sws_common.sws_common_pk	INDEX