Previous  Next          Contents  Index  Navigation  Glossary  Library

Key Flexfield Concatenated Segment View

The key flexfield concatenated segment view name is obtained by adding "_KFV" to the code combination table name. The code combination table name is truncated if necessary so that the view name does not exceed the maximum permissible length of SQL object names (30).

The view shows the concatenated segment values of all the structures in the key flexfield as a single column in the view. This column is called "CONCATENATED_SEGMENTS". The view also includes a copy of the structure defining column to differentiate among combinations for different structures. There exist no columns for individual segments.

The view also contains a column called "PADDED_ CONCATENATED_SEGMENTS", which is similar to the CONCATENATED_SEGMENTS column except that all numeric segment values are right-justified and all other segments values are left justified (that is, the numeric segment values are left padded with blanks and the other values right padded with blanks to the maximum size specified in the value set definition). You can use this column to order by the concatenated segment values.

For example, if you have a 5-segment code combination where the maximum sizes of the segments are 2, 4, 4, 1 and 4, the values in the two columns would look something like this:

2.20.ABCD.4.5000		 2.  20.ABCD.4.5000
32.150.ST.4.300		32. 150.ST  .4.3000
2.1230.1000.6.300		 2.1230.1000.6. 300
32.20.TGW.4.300		32.  20.TGW .4.3000		 2.  30.10  .6. 300

In this example, the third segment uses character format, so the 10 in the last row is left justified like the alphabetic values for that segment.

See Also

Overview of Reporting on Flexfields Data

Overview of Flexfield Views

Key Flexfield Structure View

Descriptive Flexfield View

Creating a Flexfield View

Segment Naming Conventions

Using Flexfield Views to Write a Report

Key Flexfield Views Examples

         Previous  Next          Contents  Index  Navigation  Glossary  Library