Corporate Personnel Data Warehouse
Personnel Data
Warehouse Home
Examples of how Salary Reductions are Reflected in CPS
Employees who have had the salary reduction applied are supposed to have a Personnel Action code of ‘43’ in one
of the four Personnel Action codes in the employee segment of CPS. Most of them actually do have this personnel
action code, but a few do not. “43” is translated as “Other pay rate change”, so it is not unique to the salary
reduction/furlough program. Therefore, it is recommended that you do not use the personnel action code to identify
the population which has had the salary reduction applied.
Employees who have had their salaries reduced due to the furlough program will have an additional distribution
pay line for each base pay line. If the employee is paid a stipend, there will also be an additional line for each stipend
pay line for the applicable title.
The PPS DOS codes used for the base pay reduction is “SRB” and “SRS” for the stipend reduction.
Here are some examples of distribution records for this
population:
|
Eff Date |
Location 1 |
Employee Number |
Title Code |
Dos Code Cps |
Dos Code Pps |
Gross Earnings Pay Per |
Hours Paid Pay Per |
Time Distrib Actual |
Explanation |
|
SEP2009 |
01 |
010000000 |
0547 |
AV |
REG |
7,250.00 |
184.0000 |
1.0000 |
Regular Pay - original distribution |
The normal distribution record will appear, unchanged, with a base pay DOS code.
|
Eff Date |
Location 1 |
Employee Number |
Title Code |
Dos Code Cps |
Dos Code Pps |
Gross Earnings Pay Per |
Hours Paid Pay Per |
Time Distrib Actual |
Explanation |
|
SEP2009 |
01 |
010000000 |
0547 |
DB |
SRB |
-507.50 |
12.8800 |
-0.0700 |
Reduction-Base - 7% cut |
A second distribution record will reduce the base earnings, hours, and FTE by the appropriate percent. The PPS
DOS code will be “SRB” and the CPS DOS code will be “DB”.
|
Eff Date |
Location 1 |
Employee Number |
Title Code |
Dos Code Cps |
Dos Code Pps |
Gross Earnings Pay Per |
Hours Paid Pay Per |
Time Distrib Actual |
Explanation |
|
SEP2009 |
02 |
020000000 |
4355 |
AB |
SAS |
73.48 |
0.0000 |
0.0000 |
Stipend - original |
|
SEP2009 |
02 |
020000000 |
4355 |
DS |
SRS |
-7.34 |
0.0000 |
0.0000 |
Stipend - 10% cut |
If the employee has a stipend, the stipend will also be
reduced by the same percent. The PPS DOS code for a
Stipend Reduction is SRS and the CPS DOS code is DS.
Coding for Reports
Typically, reports screen employees for selection by determining whether the employee has base pay, using CPS DOS codes AV,
AM, AW, AX, HD, and HR. If the FTE is to be calculated, HY is also included. Since adjustments may have occurred which could
result in total earnings of 0, it is a good idea to also
check whether TOTAL earnings add up to more than 0. DO NOT exclude records
with base pay DOS codes where the earnings are less than 0, since those are
adjustments.
If this code is unchanged, only the pre-reduction earnings, hours, and FTE will be included in the report.
|
Eff Date |
Location 1 |
Employee Number |
Title Code |
Dos Code Cps |
Dos Code Pps |
Gross Earnings Pay Per |
Hours Paid Pay Per |
Time Distrib Actual |
Explanation |
|
SEP2009 |
02 |
020000000 |
4355 |
AB |
SAS |
73.48 |
0.0000 |
0.0000 |
Stipend - original |
|
SEP2009 |
02 |
020000000 |
4355 |
AV |
REG |
734.81 |
24.0100 |
0.1364 |
Regular Pay - original distribution |
|
|
|
|
|
|
|
808.29 |
24.0100 |
0.1364 |
Subtotal |
|
SEP2009 |
01 |
010000000 |
0547 |
AV |
REG |
7,250.00 |
184.0000 |
1.0000 |
Regular Pay - original distribution |
|
|
|
|
|
|
|
7,250.00 |
184.0000 |
1.0000 |
Subtotal |
When reports do not include selection criteria based on base pay DOS codes, but they do sum hours, FTE, or earnings, the
post-reduction totals will be displayed, as shown below.
|
Eff Date |
Location 1 |
Employee Number |
Title Code |
Dos Code Cps |
Dos Code Pps |
Gross Earnings Pay Per |
Hours Paid Pay Per |
Time Distrib Actual |
Explanation |
|
SEP2009 |
02 |
020000000 |
4355 |
AB |
SAS |
73.48 |
0 |
0 |
Stipend - original |
|
SEP2009 |
02 |
020000000 |
4355 |
DS |
SRS |
-7.34 |
0 |
0 |
Stipend - 10% cut |
|
|
|
|
|
|
|
66.14 |
0 |
0 |
Subtotal |
|
SEP2009 |
02 |
020000000 |
4355 |
AV |
REG |
734.81 |
24.01 |
0.1364 |
Regular Pay - original distribution |
|
SEP2009 |
02 |
020000000 |
4355 |
DB |
SRB |
-73.48 |
-2.401 |
-0.0136 |
Reduction-Base - 10% cut |
|
|
|
|
|
|
|
661.33 |
21.609 |
0.1228 |
Subtotal |
|
|
|
|
|
|
|
727.47 |
21.609 |
0.1228 |
Grand Total |
|
SEP2009 |
01 |
010000000 |
0547 |
AV |
REG |
7,250.00 |
184 |
1 |
Regular Pay - original distribution |
|
SEP2009 |
01 |
010000000 |
0547 |
DB |
SRB |
-507.5 |
-12.88 |
-0.07 |
Reduction-Base - 7% cut |
|
|
|
|
|
|
|
6,742.50 |
171.12 |
0.93 |
Grand Total |
You need to decide whether you want to display the full salary or the reduced salary on your report, and select records
based on that decision.
How Furlough Hour Usage is Recorded in CPS
|
Eff Date |
Location 1 |
Employee Number |
Title Code |
Dos Code Cps |
Dos Code Pps |
Gross Earnings Pay Per |
Hours Paid Pay Per |
Time Distrib Actual |
|
SEP2009 |
03 |
522337344 |
7287 |
LV |
FUT |
0. |
8.0000 |
0.0455 |
|
SEP2009 |
03 |
689268100 |
7285 |
LV |
FUT |
0. |
8.0000 |
0.0455 |
|
SEP2009 |
03 |
259485191 |
4002 |
LV |
FUT |
0. |
8.0000 |
0.0455 |
|
SEP2009 |
03 |
559428636 |
7285 |
LV |
FUT |
0. |
8.0000 |
0.0455 |
|
SEP2009 |
03 |
026160457 |
6312 |
LV |
FUT |
0. |
24.0000 |
0.1364 |
|
SEP2009 |
03 |
739263929 |
9615 |
LV |
FUT |
0. |
8.0000 |
0.0455 |
|
SEP2009 |
03 |
703992818 |
7683 |
LV |
FUT |
0. |
8.0000 |
0.0455 |
|
SEP2009 |
03 |
687798843 |
7633 |
LV |
FUT |
0. |
7.5000 |
0.0426 |
PPS DOS code “FUT” is used to record furlough hours that the employee has used. It is mapped
to CPS DOS code “LV”. Like other leave hours, these
hours are likely to be reported after the pay
cycle has ended, so they will generally appear in the final CPS snapshot rather
than the preliminary
snapshot.
There is a new DOS code “FUA” for furlough hours accrued, but since each furloughed employee is
assigned a “bucket” of hours in advance, ir is likely
that most campuses will not report furlough hours
accrual in this way.