MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

ATTRIBUTE

ID

NUMERIC

Unique identifier

ORG_ENCY_ID

NUMERIC

Original encyclopedia identifier

ORG_ID

NUMERIC

Original object identifier

NAME

STRING

Attribute name

DSD_NAME

STRING

Data Structure Diagram name

SEQ

NUMERIC

Sequence within entity type or subtype.

Use ORDER BY SEQ to return attributes in the same order as specified in the toolset.

OPT

CHARACTER

Optionality:

• M-Mandatory
• O-Optional

TYPE

CHARACTER

Type of attribute:

• B-Basic
• D-Derived
• S-Designed

DOMAIN

CHARACTER

Domain of attribute:

• T-Text
• D-Date
• M-Time
• N-Number
• Q-Timestamp
• B-BLOB

VARYING_LENGTH

CHARACTER

Varying length string?

• Y-Yes
• N-No

LENGTH

NUMERIC

Number of characters

DEC_PLACES

NUMERIC

Number of decimal places, if number

CASE_SENSITIVE

CHARACTER

Case sensitive?

• Y-Yes
• N-No

ENCAP_LEVEL

CHAR

Level of encapsulation:

• Space-Public
• P-Protected

UNITS

CHAR

Units (for BLOB only):

• K-KB
• M-MB
• G-GB
• Space-Bytes

PARENT_ENTITY_ID

NUMERIC

ID of the entity type or subtype for which this is an attribute.

Join with:

ENTITY_TYPE

ENTITY_SUBTYP

SYS_ENT_TYPE