MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

VIEW_IMPLEMENT

ID

NUMERIC

Unique identifier

ORG_ENCY_ID

NUMERIC

Original encyclopedia identifier

ORG_ID

NUMERIC

Original object identifier

NAME

STRING

Field name

NAME_TYPE

CHARACTER

Field name type:

• N-Name base
• R-Row or column based, space

IMPLEMENT_TYPE

CHARACTER

Field implementation type:

• P-Packed
• X-Test
• F-Float
• S-Small
• I-Integer
• Q-Timestamp
• D-Date
• T-Time
• V-Varchar
• Z-Zoned
• G-Graphic
• U-Vargraphic
• M-Long Vargraphic
• L-Long Varchar

FIELD_LENGTH

NUMERIC

Field length

DEC_PLACES

NUMERIC

Field decimal places

STRUCTURE_TYPE

CHARACTER

Field structure type

ROW_OR_COL_WISE

CHARACTER

Field repeats columnwise or rowwise:

• R-Row
• C-Column, space

REPET_OFFSET

NUMERIC

Field repeating offset from start of field to the start of next

MISSING_FLAG

CHARACTER

Missing flag passed:

• Y-Yes
• N-No

ATTR_VIEW_ID

NUMERIC

ID of the attribute view.

Join with ATTR_VIEW.