MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

FIELD

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 fields in the same order as specified in the toolset.

FORMAT

CHARACTER

Format:

• P-Packed
• X-Text
• F-Float
• S-Small
• I-Integer
• V-Varchar
• Q-Timestamp
• G-Graphic
• U-Vargraphic
• M-Long Vargraphic
• L-Longvarchar
• B-BLOB

OCCURS

NUMERIC

Number of occurrences, if repeating.
Not used.

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

FIELDPROC_NAME

STRING

Fieldproc routine name

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.