Previous Topic: ENTITY_SUBTYPNext Topic: ENTITY_VIEW


ENTITY_TYPE

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_TYPE

3

ID

4

INTEGER

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

VARCHAR

Entity type name

6

DSD_NAME

32

VARCHAR

Data Structure Illustration name

7

MIN_OCCUR

4

INTEGER

Minimum number of occurrences

8

MAX_OCCUR

4

INTEGER

Maximum number of occurrences

9

AVG_OCCUR

4

INTEGER

Average number of occurrences

10

GROWTH_RATE

4

INTEGER

Growth rate (percent)

11

GROWTH_RATE_
PER

1

CHAR

Growth rate period:

  • Y (Year)
  • M (Month)
  • W (Week)
  • D (Day)

12

SUBJECT_AREA_
ID

4

INTEGER

ID of subject area that contains this entity type

13

TYPE

1

CHAR

Type of entity:

  • B (Persistent)
  • D (Transient)

14

NO_INSTANCE

1

CHAR

No instances?

  • space (Instances supported)
  • Y (No instances)

15

CATEGORY

1

CHAR

Category:

  • space (generic)
  • B (Business object type)
  • T (Task object type)

16

VIEWABLE

1

CHAR

Viewable?

  • space (No)
  • Y (Yes)

17

ENCAP_LEVEL

1

CHAR

Level of encapsulation:

  • space | O (Open)
  • R (Restricted)
  • E (Encapsulated)

18

CBD_TYPE

1

CHAR

CBD type:

  • space (Regular entity type)
  • I (Interface type)
  • S (Specification type)
  • P (Component specification)
  • M (Component implementation)