Object Type	Table
Datasource	IPMA
Database	icsa

Table to hold general information used by all CAM AOTs: CAM01, CAM03 and CAM04.

The data attributes of this entity are derived directly from the uplink MDB table cam_common.

Use and Related Data

Every CAM observation (except CAM parallel) should have planning information. The details of the measurements are stored in the CAM measurement table. See the 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 ISO Data Archive 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

nmes	int	Yes

nref	int	Yes

column nmes

Number of measurements.

column nref

Number of reference fields for C03.

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.17	Data	59.03 %
Indexes	0.08	Indexes	29.86 %
Unused	0.03	Unused	11.11 %
Total	0.28	Number of Rows	7605

Dependencies

Referencing Objects

Object Name Object Type

dbo.cam_common.cam_common_pk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.cam_common 
(
    obsno int NOT NULL,
    nmes  int NULL,
    nref  int NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.cam_common.cam_common_pk	INDEX