Object Type	Table
Datasource	IPMA
Database	icsa

This table contains the criteria to follow to decide when a fixed time or periodic observation can be performed.

This information can be taken directly from the uplink MDB aot_fix_time table.

Use and Related Data

Related to fixed time (pre-empted) observations located in the observations table. See uplink mdb.ddl file for further details.

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

criteria	text	Yes

column criteria

Fixed time criteria.

column obsno

Observation number constructed as follows:

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

Please see SCREW 385 for further details.

Table Usage (MB)

Distribution of Table Space

Data	0.29	Data	1.43 %
Indexes	19.86	Indexes	98.36 %
Unused	0.04	Unused	0.21 %
Total	20.19	Number of Rows	10108

Dependencies

Referencing Objects

Object Name Object Type

dbo.fixed_time_criteria.fixed_time_criteria_pk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.fixed_time_criteria 
(
    obsno    int  NOT NULL,
    criteria text NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.fixed_time_criteria.fixed_time_criteria_pk	INDEX