CHRS Knowledge Base

Additional Pay Entry User Guide

Updated on

Additional Pay Entry User Guide

Last Revised: 11/16/22

REVISION CONTROL

Document Title: Additional Pay Entry User Guide
Author: CHRS Project Area
File Reference: Additional Pay Entry User Guide

Revision History

Revision Date Revised By Summary of Revisions Section(s) Revised
Click here to enter
Revision Date
Click here to enter name of Person Revising. Click here to enter Summary of Revisions Click here to enter Sections Revised.

Review / Approval History

Review Date Reviewed By Action (Reviewed, Recommended or Approved)
Click here to enter
Review Date
Click here to enter
Reviewer
Click here to enter Reviewed, Recommended or Approved

1.0 Process Overview

Please refer to the Guidelines for Creating Accessible Documentation, for standards to follow when using this template to create accessible documentation. Please delete this text before starting your document. <Start text here

2.0 Process Prerequisites

Inputs and outputs, dependencies, security roles, training requirements

3.0 Process Steps

3.1 Payroll User Creates New Additional Pay Entry

  1. Sign in as Payroll User
  2. Navigate to Main Menu > Payroll for North America > Employee Pay Data USA > Create Additional Pay
  3. Enter the search criteria and click “search”
  4. OPTIONAL – Select the appropriate record from the returned results.
  5. OPTIONAL – If the current row is not blank, click the “+” icon on the Earnings Code line.
  6. Enter an Earnings Code
  7. Enter an effective date – Date should begin at the beginning of the pay period.
  8. Enter a “1” in to the Additional Sequence Number Field.
  9. OPTIONAL – Enter an End Date – Must be the last day of the final pay period which the additional pay is to be paid.
  10. Enter an amount in to the Earnings field.
  11. Check the OK to Pay box.
  12. Ensure that the “Applies to Pay Periods” box is checked.
  13. OPTIONAL – If an accounting override is required, perform the following steps:
    1. Click on the “Job Information” arrow.
    2. Click the “Edit ChartFields” link to open the edit page and define ChartField details.
    3. Click magnifying glass icon on the Combination Code field.
    4. Enter the search criteria and click Search
    5. Select the correct combination code.
    6. Click “OK” button to accept the Combination Code and return to the Additional Pay setup page.
  14. Click the “Save” button.

3.2 Payroll User Updates Existing Additional Pay Entry

  1. Sign in as Payroll User
  2. Navigate to Main Menu > Payroll for North America > Employee Pay Data USA > Create Additional Pay
  3. Check the “Correct History” box.
  4. Enter the search criteria and click “search”
  5. OPTIONAL – Select the appropriate record from the returned results.
  6. OPTIONAL – Use the navigation arrows to switch to the correct row.
  7. OPTIONAL – Update the Earnings Code
  8. OPTIONAL - Update the effective date – Date should begin at the beginning of the pay period.
  9. OPTIONAL – Update the End Date – Must be the last day of the final pay period which the additional pay is to be paid.
  10. OPTIONAL – Update the amount in to the Earnings field.
  11. Ensure that the OK to Pay box is checked.
  12. Ensure that the “Applies to Pay Periods” box is checked.
  13. OPTIONAL – If an accounting override is required, perform the following steps:
    1. Click on the “Job Information” arrow.
    2. Click the “Edit ChartFields” link to open the edit page and define ChartField details.
    3. Click magnifying glass icon on the Combination Code field.
    4. Enter the search criteria and click Search
    5. Select the correct combination code.
    6. Click “OK” button to accept the Combination Code and return to the Additional Pay setup page.
  14. Click the “Save” button.

4.0 Process Output

Where does the data go, what are the next steps?

Reporting info – Data validation steps?

5.0 Testing

Where to find the test scripts for this (UFT)

6.0 Appendix

Useful tables, glossaries, translations

6.1 Earnings Code & Earnings ID table w/ descriptions

ERNC
D
ERNCD DESCR ERNCD
EFFDT
ERNI
D
ERNID DESCR ERNID
EFFDT
TRANS
MIT
CODE
TRAN
CODE
EFFDT
SCO
PM NT
TYP
E
SCO
PMNT
SUFFIX
SCO
SALA
RY
TYPE
OK
TO SFT P?
SCO
CALCED
91 Uniform
Allowance
1/1/1901 91 Uniform
Allowance (91)
1/1/1901 676U 1/1/190
1
9 1 Y N
S1 Uniform
Allowance
1/1/1901 S1 Uniform
Allowance (S1)
1/1/1901 676U 1/1/190
1
S 1 Y
91A Uniform Allow ($57/qual month) 1/1/2013 91A Uniform Allow ($57/qual month) 1/1/2013 676U 1/1/201
3
9 1 Y
GF CSU
Automobile
Allowance M80
1/1/1901 GF Auto
Allowance,
M80H
1/1/1901 676P 1/1/190
1
G F Y N
G3A Certification
Bonus (PEPRA)
1/31/201
8
G3A Certification
Bonus (PEPRA)
1/31/2018 676P 1/31/20
18
G 3 N
GB6 Mileage reimburse less/equal 1/1/2018 GB6 Mileage reimburse less/equal 1/1/2018 676P 1/1/201
8
G B N
GB5 Trav/lodging expenses en route 1/1/2018 GB5 Trav/lodging expenses en route 10/30/201
8
676P 10/30/2
018
G B N
GB4 Moving and packing house goods 1/1/2018 GB4 Moving and packing house goods 1/1/2018 676P 1/1/201
8
G B N
GB3 Moving expenses not meet tests 1/1/2018 GB3 Moving expenses not meet tests 1/1/2018 676P 1/1/201
8
G B N
GB2 Mileage reimbursement excess 1/1/2018 GB2 Mileage reimbursemen
t excess
1/1/2018 676P 1/1/201
8
G B N
GC5 Storage 30 days after moving 1/1/2018 GC5 Storage 30 days after moving 1/1/2018 676P 1/1/201
8
G C N
GC4 Leases,
unexpired or new
1/1/2018 GC4 Leases,
unexpired or new
1/1/2018 676P 1/1/201
8
G C N
GC3 Sales or purchase residence 1/1/2018 GC3 Sales or purchase residence 1/1/2018 676P 1/1/201
8
G C N
GC2 Temporary living expenses 1/1/2018 GC2 Temporary living expenses 1/1/2018 676P 1/1/201
8
G C N
GC1 Pre-move house hunting trips 1/1/2018 GC1 Pre-move house hunting trips 1/1/2018 676P 1/1/201
8
G C N
GB1 Meals connected with the move 1/1/2018 GB1 Meals connected with the move 1/1/2018 676P 1/1/201
8
G B N
GA1 GR II WT TR OP
LC CERT (PEPRA)
1/1/2018 GA1 GR II WT TR OP
LC CERT (PEPRA)
1/1/2018 676P 1/1/201
8
G A N
GVA Var uses by
CO (Classic/PEP
RA)
1/1/2013 GVA Var uses by
CO (Classic/PE
PRA)
1/1/2013 676P 1/1/201
3
G V N
9M2 Perf/Mer Bonus
(Classic/PEPRA)
1/1/2013 9M2 Perf/Mer
Bonus
(Classic/PEPRA
)
1/1/2013 676P 1/1/201
3
9 M N
GK2 Perf Bonus
(Classic/PEPRA)
1/1/2013 GK2 Perf Bonus
(Classic/PEPRA
)
1/1/2013 676P 1/1/201
3
G K N
GPA CSU Stipend
(PEPRA Only)
1/1/2013 GPA CSU Stipend
(PEPRA Only)
1/1/2013 676P 1/1/201
3
G P N
HD2 CSU Lmp Sm
Pay
(Classic/PEPRA)
1/1/2013 HD2 CSU Lmp Sm
Pay
(Classic/PEPRA
)
1/1/2013 676P 1/1/201
3
H D N
HT4 Back/Wat Tr
Cert Renew
(PEPRA)
1/1/2013 HT4 Back/Wat Tr
Cert Renew
(PEPRA)
1/1/2013 676P 1/1/201
3
H T N
HT3 Back/Wat Tr
Cert Allow
(PEPRA)
1/1/2013 HT3 Back/Wat Tr
Cert Allow
(PEPRA)
1/1/2013 676P 1/1/201
3
H T N
HT1 Asb/Hazard
Train Allow
(PEPRA)
1/1/2013 HT1 Asb/Hazard
Train Allow
(PEPRA)
1/1/2013 676P 1/1/201
3
H T N
8AB
N
Asb/Hazard
Mat Diff
(PEPRA)
1/1/2013 8AB
N
Asb/Hazard
Mat Diff
(PEPRA)
1/1/2013 676P 1/1/201
3
8 N
HT2 Asb/Hazard
Cert Allow
(PEPRA)
1/1/2013 HT2 Asb/Hazard
Cert Allow
(PEPRA)
1/1/2013 676P 1/1/201
3
H T N
8CAR CSU
Automobile
Allowance
(M98H
1/1/1901 8CA
R
Auto
Allowance,
M98H
1/1/1901 676P 1/1/190
1
8 Y
AG P.O.S.T. Stipend from Lump Sum 1/1/1901 AG P.O.S.T.
Stipend from Lump Sum
1/1/1901 676P 1/1/190
1
A G N
SC1 Asbestos/Hazar dous Material Tr 1/1/1901 SC1 Asbestos/Haz
Training Allow
1/1/1901 676P 1/1/190
1
S C 9 Y N
SC2 Asbestos/Hazar dous Material Ce 1/1/1901 SC2 Asbestos/Haz
Training Cert
Alw
1/1/1901 676P 1/1/190
1
S C 9 Y N
8AB Asbestos Pay
Differential
1/1/2016 8AB Asbestos
HazMat
Handling Diff
1/1/1901 676P 1/1/190
1
8 N
SA Distinguished
Teaching Award
1/1/1901 SA Disting.
Teaching
Award
1/1/1901 676P 1/1/190
1
S A 9 Y
9B CSU Fellowship
Award
1/1/1901 9B CSU Fellowship
Award
1/1/1901 676P 1/1/190
1
9 B N
9M Merit/Sustaine
d Superior
Accom
1/1/1901 9M Merit/Sust
Superior
Accomp Awd
1/1/1901 676P 1/1/190
1
9 M N
SC3 Backflow Test
Lic/Water
Treatm
1/1/1901 SC3 Bck Flow/Wtr
Treat Cert
Allow
1/1/1901 676P 1/1/190
1
S C 9 Y
SC4 Backflow Test
Lic/Water
Treatm
1/1/1901 SC4 Bck Flow/Wtr
Treat Cert
Renew
1/1/1901 676P 1/1/190
1
S C 9 Y
GK PERS-Exempt
CSU Lump Sum
Bonus
1/1/1901 GK PERS-Exempt
Bonus (FLSA
Exemp)
1/1/1901 676P 1/1/190
1
G K N
GL PERS-Exempt
CSU Lump Sum
Bonus
1/1/1901 GL PERS-Exempt
Bonus (FLSA
NonEx)
1/1/1901 676P 1/1/190
1
G L N
GR Long-Term Satisfctry Svc
Bonus
1/1/1901 GR LT Satisfactory
Bonus (R04)
1/1/1901 676P 1/1/190
1
G R N
SD Certification
Bonus
1/1/1901 SD Certification
Bonus (SD)
1/1/1901 676P 1/1/190
1
S D 9 Y
S3 Commanding Officer, Training
S
1/1/1901 S3 Commanding Ofcr,Train
Shp,CMA
1/1/1901 676P 1/1/190
1
S 3 9 Y
S5 CSEA Salary
Stipend
1/1/1901 S5 CSEA Salary
Stipend
1/1/1901 676P 1/1/190
1
S 5 9 Y
ED Electronic
Devices
1/1/1901 ED Electronic
Devices
1/1/1901 676P 1/1/190
1
F E N
G3 CSU Bonus 3/1/2007 G3 CSU Bonus 3/1/2007 676P 3/1/200
7
G 3 N
G5 Educational
Stipend
1/1/1901 G5 Educational
Stipend
1/1/1901 676P 1/1/190
1
G 5 Y
G6 Critical
Response Unit
Stipend
11/1/200
9
G6 Critical
Response Unit
Stipend
11/1/2009 676P 11/1/20
09
G 6 N
GK1 Performance/M
erit Bonus
7/1/2017 GK1 Performance/
Merit Bonus
7/1/2017 676P 7/1/201
7
G K Y
GP Executive
Housing
Allowance
12/4/200
4
GP Executive
Housing
Allowance
12/4/2004 676P 12/4/20
04
G P N
GV CSU LMP SUM 5/6/2005 GV R11 $54 - One
Time Bonus
5/6/2005 676P 5/6/200
5
G V N
GW Indirect
Instructional
Payment
5/1/2006 GW Indirect
Instructional
Payment
5/1/2006 676P 5/1/200
6
G W N
GX Individual
Settlement
1/1/1901 GX Individual
Settlement
1/1/1901 676P 1/1/190
1
G X N
GY Budget
Shortfall
Mitigation Bo
1/1/1901 GY Budget
Shortfall
Mitigation Bo
1/1/1901 676P 1/1/190
1
G Y N
GZ Summer Health
Stipend
5/1/2006 GZ Summer
Health Benefit
Stipend
5/1/2006 676P 5/1/200
6
G Z N
HC SPCMP NonGF 6/1/2013 HC SPCMP NonGF 6/1/2013 676P 6/1/201
3
H C N
HD Bonus R08 $600 1/1/2014 HD Bonus R08
$600
1/1/2014 676P 1/1/201
4
H D N
HD1 MPP
Recruitment
Bonus
5/1/2014 HD1 MPP
Recruitment
Bonus
5/1/2014 676P 5/1/201
4
H D N
FIDL Industrial Dis.
(Full or Enhn)
1/1/1901 FIDL IDL Full /
Enhanced
1/1/1901 676P 1/1/190
1
6 N
IDL Industrial
Disability
(2/3's)
1/1/1901 IDL IDL (2/3) 1/1/1901 676P 1/1/190
1
N N
IDLC CSU IDL Sic
Leave
Supplementat
1/1/1901 IDLC IDL Sic Leave Supp. 1/1/1901 676P 1/1/190
1
U C N
IDLS Industrial
Disability (Full
Su
1/1/1901 IDLS IDL Full
Supllementatio
ns
1/1/1901 676P 1/1/190
1
U N N
9F Lump Sum -
Excess Payout
1/1/1901 9F Lump Sum -
Excess Payout
1/1/1901 676P 1/1/190
1
9 F N
NDI Non-Industrial
Disability Insu
1/1/1901 NDI NDI Insurance 1/1/1901 676P 1/1/190
1
T N
NDIG NDI (Requiring
Time, Salary Ra
1/1/1901 NDI
G
NDI + Time /
Rate / Gross
1/1/1901 676P 1/1/190
1
T N
NDI
W
NDI When
Working
1/1/1901 NDI
W
NDI When
Working
1/1/1901 676P 1/1/190
1
T N
95 Overtime Meal
Money
1/1/1901 95 Overtime Meal
Money
1/1/1901 676P 1/1/190
1
9 5 N N
8ST0 Intermediate
P.O.S.T. Certific
1/1/2014 8ST0 Interm POST
Cert. Stipend
$200
1/1/1901 676P 1/1/190
1
8 Y
8ST2 Advanced
P.O.S.T.
Certificatio
1/1/1901 8ST2 Interm.& Adv
Stip R08H $200
1/1/1901 676P 1/1/190
1
8 Y Y
8ST8 Intermediate &
Adv P.O.S.T. Ce
1/1/2014 8ST8 Interm Adv.
POST Stipend
$450
1/1/1901 676P 1/1/190
1
8 Y
S4 Refrigeration
Certification Al
1/1/1901 S4 Refrigeration
Cert. R06
1/1/1901 676P 1/1/190
1
S 4 9 Y Y
GE Rural Stipend 7/15/200
2
GE Rural Stipend 7/15/2002 676P 7/15/20
02
G E N
SE Exceptional
Merit Service
Awar
1/1/1901 SE Exceptional
Merit
ServiceAward
1/1/1901 676P 1/1/190
1
S E 9 Y
8ST6 CSU Salary
Stipend ($125)
1/1/1901 8ST6 Salary Stipend 1/1/1901 676P 1/1/190
1
8 N
8ST5 CSU Salary
Stipend ($80)
1/1/1901 8ST5 Stipend 1/1/1901 676P 1/1/190
1
8 N N
SU Grd II Wtr
Trtmt Op - POM
Only
1/1/1901 SU Grd II Wtr
Trtmt Op -
POM Only
1/1/1901 676P 1/1/190
1
S U 9 Y
SX Special
Assignment
Stipend R08
7/1/2006 SX R08 Stipend 7/1/2006 676P 7/1/200
6
S X 9 Y
D Final
Settlement
1/1/1901 D Final
Settlement
1/1/1901 676P 1/1/190
1
D N
9L Administrative
Leave Terminiat
1/1/1901 9L Admin Leave
Term. Pay
1/1/1901 676P 1/1/190
1
9 L N

6.2 Query to generate Earnings ID table (appendix 6.1)

SELECT S.CSU_SCO_ERNID AS "ERNCD", S.DESCR AS "ERNCD DESCR", E.EFFDT AS "ERNCD EFFDT", P.CSU_SCO_ERNID AS "ERNID", P.DESCR AS "ERNID DESCR", S.EFFDT AS "ERNID EFFDT",

S.CSU_TRAN_CODE AS "TRANSMIT CODE", S.EFFDT AS "TRAN CODE EFFDT", S.CSU_SCO_PAYMNT_TYP AS "SCO PMNT TYPE", S.CSU_SCO_PAYMNT_SUF AS "SCO PMNT SUFFIX",

S.CSU_PI_SALARY_TYPE AS "SCO SALARY TYPE", P.CSU_ELECTRONIC_OK AS "OK TO SFTP?", P.CSU_SCO_CALCULATED AS "SCO CALCULATED"

FROM PS_CSU_PIP_PRM_DTL P, PS_CSU_SCO_TBL S, PS_EARNINGS_TBL E

WHERE E.EFFDT = (SELECT MAX (E1.EFFDT) FROM PS_EARNINGS_TBL E1

WHERE E.ERNCD = E1.ERNCD

AND E1.EFFDT <= SYSDATE)

AND E.EFF_STATUS = 'A'

AND S.EFFDT = (SELECT MAX (S1.EFFDT) FROM PS_CSU_SCO_TBL S1

WHERE S.CSU_SCO_ERNID = S1.CSU_SCO_ERNID

AND S1.EFFDT <= SYSDATE)

AND S.EFF_STATUS = 'A'

AND P.EFFDT = (SELECT MAX (P1.EFFDT) FROM PS_CSU_PIP_PRM_DTL P1

WHERE P.CSU_TRAN_CODE = P1.CSU_TRAN_CODE

AND P1.EFFDT <= SYSDATE)

AND E.ERNCD = P.CSU_PIP_CODE

AND P.CSU_SCO_ERNID = S.CSU_SCO_ERNID

AND S.CSU_TRAN_CODE = P.CSU_TRAN_CODE;

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Previous Article Administrator Absence Entries User Guide
Next Article Administer Absence Calculation Process Flow