Previous Topic: ENTITY_TYPENext Topic: ENTRY_POINT


ENTITY_VIEW

The following table details various column names along with their descriptions.

Col

Column Name

Len

Coltype

Description

1

MODEL_ID

4

INTEGER

ID of the containing model

2

TBNAME

16

CHAR

ENTITY_VIEW

3

ID

4

INTEGER

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

VARCHAR

Entity view name

6

REQUIRED_
INPUT

1

CHAR

Is this a required import view?

  • Y (Yes)
  • N (No)

7

ENT_ACT_
ALLOWED

1

CHAR

Is entity action allowed?

  • Y (Yes)
  • N (No)

8

USED_AS_I_O

1

CHAR

Used as input or output:

  • Y (Yes)
  • N (No)

9

SEQH

4

INTEGER

Sequence within viewset hierarchy.

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

10

SEQ

2

SMALLINT

Sequence within parent view or view set.

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

11

PARENT_ID

4

INTEGER

Parent group view or view set.

Join with:

  • GROUP_VIEW
  • VIEW_SET

12

VIEW_SET_ID

4

INTEGER

Viewset that contains this view.

Join with VIEW_SET.

13

ENTITY_ID

4

INTEGER

Entity type or subtype for which this is an entity view.

Join with:

  • ENTITY_TYPE
  • ENTITY_SUBTYP
  • SYS_ENT_TYPE