Previous	Next		Contents	Index	Navigation	Glossary	Library

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:

CONCATENATED_SEGMENTS	PADDED_CONCATENATED_SEGMENTS
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		 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 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