dbo.lwscaldetails

 

Object Type

Table

Datasource

IPMA

Database

icsa

 


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

Use and Related Data

The LWS calibration details table contains references to the following files contained on disk:
 
 
Instrument
Code
Description
LWS COB
COIF
Co_list		 Calibration Observation Batch
Calibration Observation Interface File
Calibration Observation List

Population

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

The lwscaldetails.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
coif varchar(64) No
cob varchar(64) Yes
co_list varchar(64) Yes


column co_list
column cob
column coif

     Reference to LWS calibration details files on disk.

column obsno

     Observation number constructed as follows:

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

Table Usage (MB)

Distribution of Table Space

 

Data

0.03

Data

40.00 %

Indexes

0.01

Indexes

12.50 %

Unused

0.04

Unused

47.50 %

Total

0.08

Number of Rows

571

Dependencies
Referencing Objects
Object Name Object Type
dbo.lwscaldetails.lwscaldetails_pk INDEX
Referenced Objects
Object Name Object Type

DDL 

CREATE TABLE dbo.lwscaldetails 
(
    obsno   int         NOT NULL,
    coif    varchar(64) NOT NULL,
    cob     varchar(64) NULL,
    co_list varchar(64) NULL
)
LOCK ALLPAGES
go