1

MODEL_ID

4

INTEGER

ID of the containing model

2

TBNAME

16

CHAR

GROUP_VIEW

3

ID

4

INTEGER

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

VARCHAR

Group view name

6

SEQH

4

INTEGER

Sequence within viewset hierarchy.

Use ORDER_BY_SEQH to return the views in the same order as specified in toolset.

7

SEQ

2

SMALLINT

Sequence within parent view or activity.

Use ORDER_BY_SEQ to return children in the same order as specified in toolset.

8

CARD

1

CHAR

Cardinality:

• 1 (One)
• M (One or many)

9

MIN_CARD

4

INTEGER

Cardinality - at least

10

MAX_CARD

4

INTEGER

Cardinality - at most

11

AVG_CARD

4

INTEGER

Cardinality - on average

12

ABS_EST_MIN

1

CHAR

Absolute or estimated minimum cardinality:

• E (Estimated)
• A (Absolute)

13

ABS_EST_MAX

1

CHAR

Absolute or estimated maximum cardinality:

• E (Estimated)
• A (Absolute)

14

REQUIRED_
INPUT

1

CHAR

Is this a required import view?

• Y (Yes)
• N (No)

15

ENT_ACT_
ALLOWED

1

CHAR

Is entity action allowed?

• Y (Yes)
• N (No)

16

USED_AS_I_O

1

CHAR

Used as input or output:

• Y (Yes)
• N (No)

17

PARENT_ID

4

INTEGER

Parent group view or view set.

Join with:

• GROUP_VIEW
• VIEW_SET

18

VIEW_SET_ID

4

INTEGER

Viewset that contains this view.

Join with VIEW_SET.