I am sure this can be done, and I am sure the answer is somewhere on this forum. I am just not sure of the terminology so I am having trouble searching for a solution.

I have a report that returns 12 different pay codes in columns and totals the hours worked under each code for each employee.

It works great. If anybody took any time off it list the date and pay code they used.
The report is 12 columns wide.

We are changing the pay codes and now there are over 60. Instead of just choosing FML (Family Medical Leave) and
adding a comment like FML - Child. You now choose FM2. Payroll knows FM2 is FML - Child. No more comments required.
Our new payroll system does not have a field for comments.

The are 6 of these new pay codes for FML. FM1 - FM6. But we want them all to still show in a column titled FML.
We do not need 6 across columns to represent these codes, they can share a column. I need all 60 of these new pay codes to display in just 12 columns.

Just use a (INCLUDE) define?

IF PAYCODE EQ FM* THEN FML;
IF PAYCODE EQ B0* THEN FNL;
IF PAYCODE EQ FLO THEN FLH;

etc, etc, for all of them?

This message has been edited. Last edited by: Greg,

sounds like you are on the right track.

You need 6 defines. Put all the PAYCODE types for each in each define with IF THEN ELSE logic.
In your report print the 6 new codes.

You could also use a decode to translate the payroll codes to something you wish to sort on. Like:

SORT_PAYROLL/A3 = DECODE ('FM1' 'FML'
                          'FM2' 'FML'
                          'FM3' 'FML'
                          ... etc ...
                          ELSE '???');

and then do the across on this new SORT_PAYROLL field.

Or:

PAYCODE=IF EDIT(PAYCODE, '99$) EQ 'FM' THEN 'FML' ELSE ..... 

I already have a define on the paycode field that reads a comment filed to tell if the day off was scheduled or unscheduled.

 -* DEFINE BEGIN PAYCODE
PAYCODE/A20 = IF PS_KV_PNCH_ANA_VW.PS_KV_PNCH_ANA_VW.COMMENTTEXT
EQ 'PL - Scheduled' AND PS_KV_PNCH_ANA_VW.PS_KV_PNCH_ANA_VW.PAYCODENAME EQ 'PER' OR 'PTO'
THEN 'PERS'
ELSE  IF PS_KV_PNCH_ANA_VW.PS_KV_PNCH_ANA_VW.COMMENTTEXT
EQ 'PL - Unscheduled' AND PS_KV_PNCH_ANA_VW.PS_KV_PNCH_ANA_VW.PAYCODENAME EQ 'PER' OR 'PTO'
THEN 'PERU'
ELSE PS_KV_PNCH_ANA_VW.PS_KV_PNCH_ANA_VW.PAYCODENAME; 

Should I make a new define or just expand this one to handle converting the new paycodes to old codes?

I added the new codes to the current define statement and got it working.