Show TOC

New Structure for Cumulation Tables CRT, TCRT, UTIPS and GRCUM 

Use

From Release 4.6C forward, out-of-sequence check processing is supported by the standard system. The structural changes described in this release note were made to enable this new functionality. We recommend that you first read the release note on out-of-sequence check processing before reviewing the present release note.

Within cumulation tables CRT, TCRT, and UTIPS, the cumulated values for the current month, the current quarter and the current year are stored per payroll result. In prior releases, when a new cumulation interval would start, the corresponding CRT values would be refreshed and the cumulation would begin again for the next interval. Consequently, until now, it was not possible to cumulate amounts into previous intervals.

Four new fields have been added to cumulation tables CRT, TCRT, and UTIPS. These fields now enable the system to cumulate into previous intervals. The new fields are as follows:

The addition of these fields makes it possible to store several entries in the CRT per cumulation type (e.g. month, quarter, year) - in particular, month-to-dates and year-to-dates for the last six months. This information is required to support out-of-sequence check processing.

Aside from the changed structure of cumulation tables CRT, TCRT, and UTIPS, Release 4.6C features one new cumulation table, GRCUM, which supports garnishments requirements for out-of-sequence check processing. This technical table is similar in structure to the tables described above. However, since GRCUM is a background table with the sole purpose of supporting out-of-sequence processing, users need not concern themselves with its exact structure and function.

Effects on Existing Data

Existing entries in cumulation tables CRT, TCRT and UTIPS are not affected by these structural changes. However, in order to process out-of-sequence checks, you must convert existing cumulations tables entries to make them compatible with the new structure, as specified under Effects on Data Transfer.

Effects on Data Transfer

A conversion program must be executed to assign the appropriate values to these new fields within existing payroll results. For additional information on this program, refer to the release note on the conversion of payroll results for out-of-sequence check processing.

Effects on System Administration

These structural changes will result in a minor increase in system memory requirements.

Effects on Customizing

As stated in the release note on out-of-sequence check processing, you must perform the following two steps in the Payroll Implementation Guide (IMG) before you prepare to begin using the new functionality for out-of-sequence checks.

For detailed information on the new configuration tables that enable out-of-sequence check processing, refer to the release note on new Data Dictionary cumulation tables .