Previous Topic: SUBJECT_AREANext Topic: SYS_ENT_TYPE (Work Attribute Set)


SYS_ATTRIBUTE

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

SYS_ATTRIBUTE

3

ID

4

INTEGER

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

VARCHAR

Name of the system‑defined attribute for the system‑defined entity type $IEF.

6

TYPE

1

CHAR

B (Basic)

7

DOMAIN

1

CHAR

Domain of the system‑defined attribute

8

LENGTH

4

INTEGER

Length of the system‑defined attribute

9

DEC_PLACES

4

INTEGER

0 (zero)

10

INPUT

1

CHAR

Can this attribute be input?

  • Y (Yes)
  • N (No)

11

OUTPUT

1

CHAR

Can this attribute be output?

  • Y (Yes)
  • N (No)

12

ENTITY_TYPE_
ID

4

INTEGER

ID of the system‑defined entity type.

Join with SYS_ENT_TYPE.

13

DESCRIPTION

2000

LONGVAR

Description of the system‑defined attribute