The common library report, FOC4003 identifies your current R06 employees who are at the maximum rate for their class and range. Usually, this type of report is generated by identifying employees whose anniversary date is equal to 'MAX'. However, if anniversary date is not accurate, the report request below provides an alternative method by comparing the maximum rate for a class and range to the employee's base pay amount.
A join (JACPS) is used to retrieve records at the class and range level from both the Active Current Status (AC) file and the Payscales (PS) file, and a match is required because separate approaches are needed for the each of the class record types, C and F, for this CBID. The report request can be executed 'as is' from the common library, or it can be copied to your library and modified for your reporting needs. A sample of the final report is shown below.
report of r06 employees at max
employee ssa class rng basepay
-------------- ----- ---- --- -------
baboon, jon 555-66-1111 6265 1 $5,744.00
camel, linda 111-33-4444 6536 1 $4,086.00
turtle, rudy 333-00-0000 6251 1 $4,335.00
For employees with record type C, step-rate classes, a comparison is needed between the employee's base pay and the rate of the maximum step for that class and range. Because the maximum step is a code, not an amount, a defined field is needed to identify the corresponding rate of pay. Since there are only a few maximum steps for record type C classes, they were identified by a separate report that is not included in the common library report request. The define (MAXRATE) is as follows:
DEFINE FILE AC ADD
MAXRATE/P12.2 = IF PS:STEPMAX EQ '01' THEN PS:ST1 ELSE
IF PS:STEPMAX EQ '04' THEN PS:ST4 ELSE
iF PS:STEPMAX EQ '06' THEN PS:ST6 ELSE
IF PS:STEPMAX EQ '07' THEN PS:ST7 ELSE
IF PS:STEPMAX EQ '08' THEN PS:ST8 ELSE
IF PS:STEPMAX EQ '15' THEN PS:ST15 ELSE 0;
The first (old) portion of the match request retrieves data for your R06 employees in step-rate classes (certified apprentices). A WHERE statement is used to compare the employee's base pay and the maximum rate (defined above) and select only those records where the amount is equal. Note: Some of the fields are only printed for verification purposes and do not appear in the final report.
MATCH FILE AC
PRINT PS:STEPMAX MAXrate
BY AC:SSA BY AC:WNAME BY AC:CLASS BY AC:RANGE BY PS:RECTYPE BY ac:BASEPAY
IF PS:CBID EQ R06
IF PS:RECTYPE EQ C
WHERE AC:BASEPAY EQ MAXRATE
The second (new) portion of the report request retrieves data for your R06 employees with record type F, min-max classes. A WHERE statement is used to compare the employee's base pay and the maximum rate (PS:MAX) and select only those records where the amount is equal. The matched data is placed in the hold file named PERMRPT and is a displayed using a wildcard command (*) for verification. Note: The lines for verification are commented out in the common library report request.
IF PS:RECTYPE EQ f
WHERE AC:BASEPAY EQ ps:max
after match hold as permrpt old-or-new
table file permrpt
The resulting hold file, PERMRPT, contains only those R06 employees whose base pay equals the maximum rate for their class and range. This portion of the report request generates a printed report.
TABLE FILE PERMRPT
"report of r06 employees at max"
print ac:wname/a20 as 'employee'
ac:ssa as 'ssa'
ac:class as 'class'
ac:range as 'rng'
ac:basepay as 'basepay'
by ac:wname noprint
For more information on defines and matching, refer to your FOCUS documentation. For more information and instructions on accessing the common library refer to your CIRS User Manual.
Last Updated: June 2, 2004