Understanding Sequence Numbers

The sequence number controls the order in which the table rows are read into the program. For example, a taxable wage base table might look like this:

Sequence Number	Year	Wage Base
5	1930	1938
10	1931	2000
15	1932	4938

If instead this table used sequence number 15 for 1931 and 10 for 1932, the table lookup might give unexpected results.

WARNING:

You must explicitly order your table values using the Sequence Number field. The table lookup utility relies on this sequence number and does not otherwise sort the lookup values.

Note:

PeopleSoft recommends that you leave gaps between the sequence numbers. Then if it becomes necessary to insert new rows between existing rows, you do not have to alter the sequence numbers in the subsequent rows.