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