1

MODEL_ID

4

INTEGER

ID of the containing model

2

TBNAME

16

CHAR

ATTRIBUTE

3

ID

4

INTEGER

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

VARCHAR

Attribute name

6

DSD_NAME

32

VARCHAR

Data Structure Illustration name

7

SEQ

2

SMALLINT

Sequence within entity type or subtype. Use ORDER_BY_SEQ to return attributes in the same order as specified in the toolset.

8

OPT

1

CHAR

Optionality:

M (Mandatory)

O (Optional)

9

TYPE

1

CHAR

Type of attribute:

B (Basic)

D (Derived)

S (Designed)

A (Auto Number)

10

DOMAIN

1

CHAR

Domain of attribute:

T (Text)

D (Date)

M (Time)

N (Number)

Q (Timestamp)

G (Graphic [DBCS])

Y (Text | Mixed)
(for system‑supplied functions only)

Z (Mixed)

B (BLOB)

11

VARYING_LENGTH

1

CHAR

Varying length string?

Y (Yes)

N (No)

12

LENGTH

4

INTEGER

Number of characters

13

DEC_PLACES

4

INTEGER

Number of decimal places.

14

CASE_SENSITIVE

4

CHAR

Case sensitive?

Y (Yes)

N (No)

15

UNITS

1

CHAR

Units (for BLOB only):

• K (KB)
• M (MB)
• G (GB)
• Space (Bytes)

16

PARENT_ENTITY_
ID

4

INTEGER

Entity type or subtype for which this is an attribute. Join with:

ENTITY_TYPE

ENTITY_SUBTYP

SYS_ENT_TYPE

17

ACTION_BLOCK_
ID

4

INTEGER

ID of algorithm action block for an attribute.

(zero if algorithm does not exist).

18

DEF_PERM_VAL_
ID

4

INTEGER

ID of default permitted value.

Join with PERMIT_VALUE.

(zero if default value does not exist)

19

ENCAP_LEVEL

1

CHAR

Level of encapsulation:

space (Public)

P (Protected)