Object Type	Table
Datasource	IPMA
Database	icsa

Contains SWS specific references and information related to Calibration Observations (Calibration Observations Documentation).

Use and Related Data

The SWS calibration details table contains references to the following files contained on disk:

Instrument

Code

Description

SWS

COB

COIF

Co_param

Calibration Observation Batch

Calibration Observation Interface File

Calibration Observation Parameters

The SIDT has provided +/- 2000 documentation text files that document calibration observations. These documentation files are linked & viewable to a calibration observation through two relations that are specified below. There are seven types of files as can be seen below. The filenames are all unique and can contain a version number at the end.

For CUS observations, a table CAL_CUS has been delivered as an ascii file containing the following columns:

Filename	Description
CO_FILE	Parameter file
VERBS_FILE	CAL_VERBS.SWS file used to generate the command sequence
ICS_FILE	CAL_ICS.SWS file used to generate the command sequence
IDSDB_FILE	CAL_IDSDB.SWS file used to generate the command sequence
ICPT_FILE	CAL_ICPT.SWS file used to generate the command sequence
DESC_FILE	Text description

For AOT observations, a table CAL_AOT has been delivered as an ascii file containing the following columns:

Filename	Description
CO_FILE	AOT parameter file with in- & output of tuning with standalone logic

Population

The table is populated by the script swscaldetails.csh using the bcp character dump file swscaldetails.bcp created by the script caldetails.pl.

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

no args:

This assumes that the table has been created in the database icsa, and that any temporary tables needed have been built and populated with the necessary data.

-build:

Forces the building of the table 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

co_param	varchar(64)	Yes

coif	varchar(64)	No

cob	varchar(64)	Yes

cus4_verbs	varchar(64)	Yes

cus4_idsdb	varchar(64)	Yes

cus4_ics	varchar(64)	Yes

cus4_icpt	varchar(64)	Yes

column co_param
column cob
column coif

Reference to SWS calibration details files on disk.

column cus4_icpt
column cus4_ics
column cus4_idsdb
column cus4_verbs

Reference to SWS CUS4 (16) files on disk.

column obsno

Observation number constructed as follows:

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

Please see SCREW 385.

Table Usage (MB)

Distribution of Table Space

Data	0.14	Data	72.92 %
Indexes	0.02	Indexes	9.38 %
Unused	0.03	Unused	17.71 %
Total	0.19	Number of Rows	1444

Dependencies

Referencing Objects

Object Name Object Type

dbo.swscaldetails.swscaldetails_pk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.swscaldetails 
(
    obsno      int         NOT NULL,
    co_param   varchar(64) NULL,
    coif       varchar(64) NOT NULL,
    cob        varchar(64) NULL,
    cus4_verbs varchar(64) NULL,
    cus4_idsdb varchar(64) NULL,
    cus4_ics   varchar(64) NULL,
    cus4_icpt  varchar(64) NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.swscaldetails.swscaldetails_pk	INDEX