Enumerated Strings (Relational Model)

Figure 1 shows an example of an opened ENUMERATIONS folder:

Hierarchy including the enumerations folder — Figure 1. ENUMERATIONS Folder

Each query subject represents an enumerated string that has been defined for that object. These enumerated strings can be either single or multivalued.

Figure 2 shows an example of an opened query subject:

Hierarchy including the enumerated string query items — Figure 2. Enumerated String Query Items

The following table lists query items found in an enumerated string:

Table 1. Multivalued Enumerated String
Query Subject	Description
ENUMVALID	ID of the enumerated string value.
ENUMTYPEID	ID of the type of variable returned. All records in an enumerated string will return the same value.
VALUE	Value returned for each record.
NAME	Name of this record in the enumerate string returned in RDL.
DISPLAY_ORDER	Numeric value indicating the order in which the value is displayed to the user.
FLAG_IS_HIDDEN	True or false value indicating whether the value is displayed to the user.
I18N_LOCALE_ID	Locale of the returned value.
RI_DOMAN	Localized name of this record in the enumerated string.

These query subjects can be used only for creating prompts. You would use the ENUMVALID as the returned value and the RI_DOMAIN as the display value, because it is localized. Other parameters can be used for filtering.