Object Type	Table
Datasource	IPMA
Database	icsa

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

Use and Related Data

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

Instrument	Code	Description
PHT	COB COIF Co_list Timeline IPF	Calibration Observation Batch Calibration Observation Interface File Calibration Observation List Calibration Observation scheduling instructions Output file of the program PHTAOT

Population

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

The phtcaldetails.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)	Yes

cob	varchar(64)	Yes

co_list	varchar(64)	Yes

iocrd	varchar(16)	Yes

timeline	varchar(64)	Yes

ipf	varchar(64)	Yes

naot	varchar(64)	Yes

column co_list
column cob
column coif

Reference to PHT calibration details files on disk.

column iocrd

Requirement number from IOCRD (ISO-SSD-9003) related to the calibration observation.

column ipf

Reference to PHT 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.

column timeline

Reference to PHT calibration details file on disk.

Table Usage (MB)

Distribution of Table Space

Data	0.38	Data	76.80 %
Indexes	0.07	Indexes	14.80 %
Unused	0.04	Unused	8.40 %
Total	0.49	Number of Rows	3954

Dependencies

Referencing Objects

Object Name Object Type

dbo.phtcaldetails.phtcaldetails_pk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.phtcaldetails 
(
    obsno    int         NOT NULL,
    coif     varchar(64) NULL,
    cob      varchar(64) NULL,
    co_list  varchar(64) NULL,
    iocrd    varchar(16) NULL,
    timeline varchar(64) NULL,
    ipf      varchar(64) NULL,
    naot     varchar(64) NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.phtcaldetails.phtcaldetails_pk	INDEX