MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

FIELD_FGN_KEY_I

ID

NUMERIC

Unique identifier

ORG_ENCY_ID

NUMERIC

Original encyclopedia identifier

ORG_ID

NUMERIC

Original object identifier

NAME

STRING

Field name

MACRO_NAME

STRING

Macro name

SEQ

NUMERIC

Sequence within record.

Use ORDER BY SEQ to return foreign key fields in the same order as specified in the toolset.

FIELD_ROLE

CHARACTER

Role:

F-Foreign key

FORMAT

CHARACTER

Format:

• P-Packed
• X-Text
• F-Float
• S-Small
• I-Integer
• V-Varchar
• Q-Timestamp
• B-BLOB

OCCURS

NUMERIC

Number of occurrences, if repeating

LENGTH

NUMERIC

Length

DEC_PLACES

NUMERIC

Number of decimal places

OPT

CHARACTER

DB2 optionality:

• O-Optional
• M-Mandatory

UNITS

CHAR

Units (for BLOB only):

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

RECORD_IS_IN_ID

NUMERIC

ID of the record that contains this field.

Join with RECORD.

ATTRIBUTE_ID

NUMERIC

ID of the attribute that this field implements.

Join with ATTRIBUTE.