The descriptive flexfield view into the underlying table contains a column for each segment in your descriptive flexfield structure. Since this view contains columns for all the segments of all structures of the descriptive flexfield, the view also includes a copy of the structure defining column to differentiate among rows for different structures.
The view uses each structure's segment names as view column names. The context (structure) column uses the context prompt as the view column name (this may be something like "Context_Value" or "Client_Type"). In the view column names, underscores ( _ ) replace all non-alphanumeric characters. For example, "Context Value" becomes "CONTEXT_VALUE" and "Manager's Title" becomes "MANAGER_S_TITLE".
If segments in different structures (contexts) have identical names, these segments share the same view column. If two or more segments share a view column, then these segments should use value sets of the same format type.
The Descriptive Flexfield View also shows the concatenated segment values in the flexfield as a single column in the view. That column also contains the context value as a "segment" value. The CONCATENATED_SEGMENTS column contains global segments (if any are enabled), the context value, and any context-sensitive segments, in that order. The view does not contain any other columns from the underlying table except a ROW_ID (not ROWID) column, the context column and the columns that are used by enabled segments. The ROW_ID column in the view corresponds to ROWID in the actual table.
Overview of Flexfield Views
Key Flexfield Concatenated Segment View
Key Flexfield Structure View
Creating a Flexfield View
Segment Naming Conventions
Using Flexfield Views to Write a Report
Descriptive Flexfield View Example