Previous Topic: Text StringsNext Topic: When the Column Name is Not Text


Views With a Column For Associated Text

In some instances, the view contains a column (often named “Text”) in which it stores associated text strings. For example, the PROMPT view stores the text of prompts in its Text column, as shown in the following table:

Column Name

Column Type

Description

MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

PROMPT

ID

NUMERIC

Unique identifier

ORG_ENCY_ID

NUMERIC

Original encyclopedia identifier

ORG_ID

NUMERIC

Original object identifier

ATTRIBUTE_ID

NUMERIC

ID of the attribute to which the prompt applies. Join with ATTRIBUTE.

TEXT

VARYING LENGTH STRING

Text of the prompt

Other Public Interface views having a column for text strings include: