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.

 

Return to Personnel Data
Warehouse Home Page