2

TBNAME

16

CHAR

ACTIV_USAGE

3

ID

4

INTEGER

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

SEQH

4

INTEGER

Sequence of child within activity hierarchy. Use ORDER_BY_SEQH to return the activity hierarchy as specified in toolset.

6

SEQ

2

SMALLINT

Sequence within parent activity. Use ORDER_BY_SEQ to return children in the same order as specified in toolset.

7

MIN_FREQ

4

INTEGER

Minimum frequency of execution

8

MAX_FREQ

4

INTEGER

Maximum frequency of execution

9

AVG_FREQ

4

INTEGER

Average frequency of execution

10

FREQ_UNITS

1

CHAR

Frequency units:

Y (Year)

M (Month)

W (Week)

D (Day)

11

GROWTH_RATE

4

INTEGER

Growth rate (percent)

12

GROWTH_RATE_
PER

1

CHAR

Growth rate period:

Y (Year)

M (Month)

W (Week)

D (Day)

13

PARENT_ACTIV_ID

4

INTEGER

Parent activity ID. Join with:

FUNCTION_DEF

PROCESS_DEF

Zero for root function

14

CHILD_ACTIV_ID

4

INTEGER

Child activity ID. Join with:

FUNCTION_DEF

PROCESS_DEF