The key flexfield structure view contains a column for each segment in your flexfield structure, and it uses the segment names, not the segment prompts, as view column names. In the view column names, underscores ( _ ) replace all non-alphanumeric characters. For example, "Segment Value" becomes "SEGMENT_VALUE" and "Manager's Title" becomes "MANAGER_S_TITLE".
If the code combinations table contains columns for segment qualifiers, the segment qualifier columns will use the segment qualifier names as view column names, for example GL_ACCOUNT_TYPE.
In addition to the segment and qualifier columns, the view also contains the code combination ID column, START_DATE_ACTIVE, END_DATE_ACTIVE, SUMMARY_FLAG, ENABLED_FLAG, ROW_ID (not ROWID), and all other columns in the code combination table that are not enabled as flexfield columns. The Structure view does not have the structure defining column as all the information in this view pertains to one structure of the flexfield.
Overview of Flexfield Views
Key Flexfield Concatenated Segment View
Descriptive Flexfield View
Creating a Flexfield View
Segment Naming Conventions
Using Flexfield Views to Write a Report
Key Flexfield Views Examples