Object Type	Table
Datasource	IPMA
Database	icsa

Information extracted from the ICSF. This consists of the instrument mnemonics with associated parameters used for each ICS.

Use and Related Data

Linked directly to the POF extract.

Population

This table is populated by the script pof_icsf.csh. The script extracts information from the ICSF to populate this table. 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

ics	char(12)	No

pcount	int	No

mnemonic	char(12)	No

params	varchar(96)	Yes

column ics

ICS name.

column mnemonic

Mnemonic.

column obsno

Observation number constructed as follows:

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

Please see SCREW 385.

column params

Parameters.

column pcount

Parameter count. Used to order ICS commands.

Table Usage (MB)

Distribution of Table Space

Data	299.69	Data	63.04 %
Indexes	175.20	Indexes	36.85 %
Unused	0.54	Unused	0.11 %
Total	475.43	Number of Rows	6444992

Dependencies

Referencing Objects

Object Name Object Type

dbo.ics_extract.ics_extract_pk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.ics_extract 
(
    obsno    int         NOT NULL,
    ics      char(12)    NOT NULL,
    pcount   int         NOT NULL,
    mnemonic char(12)    NOT NULL,
    params   varchar(96) NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.ics_extract.ics_extract_pk	INDEX