Object Type	Table
Datasource	IPMA
Database	icsa

Validity period of Permanent Command Sequences (PCS) on a revolution interval basis.

All that is provided is configuration control information as to which PCSs are installed for each revolution and a link to the actual PCSs. No information about which PCS was actually uplinked is available, it is possible somehow to extract this information from TChistory, but this seemed to be too difficult. A very limited set of PCSs is actually used, excepting activation, deactivation and saturation related.

Use and Related Data

Contains file location of actual PCS. NSO Events contain information on what PCSs have been uplinked, derived from the real time revolution reports, but this information is not considered complete, only contains planned PCSs.

Population

This information is available from uplink configuration control. A script called pcs_validity.csh has been developed to create and populate this table. The script can take one or more of the following arguments:

no args: This assumes that the observers table has been created in the database
icsa, and that all temporary tables have been built and populated
with the necessary data.

-build: Forces the building of the observers table 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

instrument char(3) No

version int No

revstart int Yes

revend int Yes

column instrument

     Instrument, onr of:
         CAM
         LWS
         PHT
         SWS

column revend

Revolution number to which PCS is valid.

column revstart

Revolution number from which PCS is valid.

column version

PCS 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	23

Dependencies

Referencing Objects

Object Name Object Type

dbo.pcs_validity.pcs_validity_pk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.pcs_validity 
(
    instrument char(3) NOT NULL,
    version    int     NOT NULL,
    revstart   int     NULL,
    revend     int     NULL
)
LOCK ALLPAGES
go

Name	Datatype	Null

instrument	char(3)	No

version	int	No

revstart	int	Yes

revend	int	Yes

Object Name	Object Type
dbo.pcs_validity.pcs_validity_pk	INDEX