dbo.cus4_validity

 

Object Type

Table

Datasource

IPMA

Database

icsa

 


This table contains the validity of CUS4 files that are also known as CUS16 files; there are four CUS4 files per instrument. The CUS4 files change over time and their configuration control has been maintained by each ISG.

Use and Related Data

Directly related to the CUS4 files that are kept as files in the ISO Data Archive. See the CUS4 files chapter for further information.

Population

This table is populated by the script cus16.csh. 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
inst char(1) No
filetype int No
version int No
revstart int No
revend int No
column filetype

     The following integer values are used to represent the CUS-4 file types:

column inst

     Character representing the instrument:


column revend

     Revolution number until which CUS4 files are valid.

column revstart

     Revolution number from which CUS4 files are valid.

column version

     CUS4 configuration control version number.
 

Table Usage (MB)

Distribution of Table Space

 

Data

0.00

Data

8.33 %

Indexes

0.00

Indexes

4.17 %

Unused

0.04

Unused

87.50 %

Total

0.05

Number of Rows

56

Dependencies
Referencing Objects
Object Name Object Type
dbo.cus4_validity.cus4_validity_pk INDEX
Referenced Objects
Object Name Object Type

DDL

CREATE TABLE dbo.cus4_validity 
(
    inst     char(1) NOT NULL,
    filetype int     NOT NULL,
    version  int     NOT NULL,
    revstart int     NOT NULL,
    revend   int     NOT NULL
)
LOCK ALLPAGES
go