Activity table (DSN8C10.ACT)

The activity table describes the activities that can be performed during a project.

Begin general-use programming interface information.

The activity table resides in database DSN8D12A and is created with the following statement:

CREATE TABLE DSN8C10.ACT
      (ACTNO    SMALLINT       NOT NULL,
       ACTKWD   CHAR(6)        NOT NULL,
       ACTDESC  VARCHAR(20)    NOT NULL,
       PRIMARY KEY (ACTNO)             )
  IN DSN8D12A.DSN8S12P
  CCSID EBCDIC;

End general-use programming interface information.

Content of the activity table

The following table shows the content of the columns in the activity table.

Table 1. Columns of the activity table
Column	Column name	Description
1	ACTNO	Activity ID (the primary key)
2	ACTKWD	Activity keyword (up to six characters)
3	ACTDESC	Activity description

The activity table has the following indexes.

Table 2. Indexes of the activity table
Name	On column	Type of index
DSN8C10.XACT1	ACTNO	Primary, ascending
DSN8C10.XACT2	ACTKWD	Unique, ascending

Relationship to other tables

The activity table is a parent table of the project activity table, through a foreign key on column ACTNO.