Object Type	Table
Datasource	IPMA
Database	icsa

This table contains information on linked and concatinated observations. This information has been taken directly from the uplink MDB aot_link_criteria table.

Use and Related Data

Related to observations that are part of a concatinated chain or a link.

Population

This table is populated by the script uplink_data.csh. 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 ICSA 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

link_criteria text Yes

column link_criteria

Contains the criteria to select a follow up observation in a link on the basis of the result of a pilot observation.

column obsno

Observation number constructed as follows:
revolution number * 1000000 + target number * 1000 + observation sequence number * 10 + type.
See SCREW 385 for further details.

Table Usage (MB)

Distribution of Table Space

Data	0.00	Data	3.57 %
Indexes	0.05	Indexes	50.00 %
Unused	0.05	Unused	46.43 %
Total	0.11	Number of Rows	26

Dependencies

Referencing Objects

Object Name Object Type

dbo.linked_obs_info.linked_obs_info_pk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.linked_obs_info 
(
    obsno         int  NOT NULL,
    link_criteria text NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.linked_obs_info.linked_obs_info_pk	INDEX