USPS Reports Guide –
USPS Reports by Number –
Report 097 Monthly Longevity/Hazardous Duty Report
This report displays the new longevity and hazardous duty pay rates for employees when either rate will change in the next period.
*** There are no employees scheduled to change status next Month *** will print if no changes are found.
Report Criteria
Category | Payroll Administration | |||||||||
---|---|---|---|---|---|---|---|---|---|---|
Distribution | Agency | |||||||||
Frequency | Monthly | |||||||||
Form | 111 | |||||||||
Sort Sequence |
|
|||||||||
Page Break |
|
|||||||||
Parameters | HNKU7 – Month Begin Date | |||||||||
Databases Used | HID, HMP, H0C, H0B, HNK | |||||||||
Selection Criteria | All employees with longevity or hazardous duty rate changes with the H10 Frequency turned on. | |||||||||
Produce Output? | Yes | |||||||||
Request Screen | HSRPT; HPRPT – Set up to run automatically with each final payroll or with Month-End Reports. | |||||||||
Posting Report? | No | |||||||||
Additional Notes | The rates will not actually change until a payroll is run. If the organization code sort is selected, the organization code will appear in the header. |
Report Headings
- ORGANIZATION CODE HNP.ORGCODE
- Displays the organization code as defined by the employee's position.
- FOR MM/DD/YY EMPLOYEE CHANGING PAY RATES NEXT MONTH HNK.DATE01
- Displays the effective date of the pay rate change.
- EMPLOYEE SSN H0B.EMPLOYEENO
- Displays the employee's SSN.
- EMPLOYEE NAME HID.RPTNAME
- Displays the employee's name.
- POSITION H0B.POSITION
- Displays the employee's position number.
- MONTHLY SALARY DERIVED
- Displays the employee's monthly salary (H0B.annsalary divided by 12).
- ADJUSTED EMP-DATE H0B.ADJEMPLDAT
- Displays the employee's state effective service date (current date plus prior state service minus LWOP months).
- YEAR/MONTH DERIVED
- Displays the employee's longevity time in years and months.
- NEW LONG PAY DERIVED
- Displays the employee's new longevity pay amount.
Note: If YEAR/MONTH PAYRL and YEAR/MONTH PERSNL YEAR/MONTH PERSNL are not equal, HD will print between the NEW LONG PAY and IN HAZ POS columns to flag the discrepancy.
- IN HAZ POS HMP.HAZDTYIND
- Displays Y or N to indicate eligibility for hazardous duty pay.
Note: An employee will continue to receive longevity increases while they are in the 12 month waiting period for hazardous duty pay. However, once they have 12 hazardous duty months, longevity will be based only on non-hazardous duty months of service.
- HAZ DUTY MOS H0B.DATEELIG2
- Displays the number of months of hazardous duty time based on the employee's hazardous duty effective date to the report request date.
- YEAR/MONTH PERSNL H0B.PAYCONST5
- Displays the amount of hazardous duty time based on the employee's number of months in a hazardous duty position.
- NEW HAZD PAY DERIVED
- Displays the employee's new hazardous duty pay amount.
Sample Report
REPORT: 97 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1 AGENCY: XXX XXXXXXXX XXXXXXXXX XXXXXXXXXX RUN DATE: XX/XX/20XX MONTHLY LONGEVITY/HAZARDOUS DUTY REPORT RUN TIME: 23:20:44 FOR 02/01/20XX EMPLOYEE CHANGING PAY RATES NEXT MONTH EMPLOYEE MONTHLY ADJUSTED NEW IN HAZ HAZ DUTY NEW HAZ DUTY SSN EMPLOYEE NAME POSITION SALARY EMP-DATE YEAR/MONTH LONG PAY POS MOS HAZD PAY EFF SRV D ---------- --------------------------- -------- --------- ---------- ---------- -------- --- -------- -------- --------- XXX-XX-XXXX XXXXXXX, XXXXXXXXXX 04080003 4,524.00 02/01/20XX 6 60.00 N XXX-XX-XXXX XXXXXXXXXX, XXXXXXXX 04890632 2,667.60 01/10/20XX 8 80.00 N XXX-XX-XXXX XXXXXX, XXXXXXXX 04840714 2,692.58 01/05/20XX 2 20.00 N XXX-XX-XXXX XXXXXXXXX, XXXXXXXXX 04080043 3,293.68 01/23/20XX 14 140.00 N XXX-XX-XXXX XXXXXX, XXXXXX 04010630 2,785.00 02/01/20XX 6 60.00 N XXX-XX-XXXX XXXXXXX, XXXXXXXXXXX 04220650 5,626.40 02/01/20XX 8 80.00 N XXX-XX-XXXX XXXX, XXXXXXX 04010623 2,895.00 02/01/20XX 6 60.00 N XXX-XX-XXXX XXXXX, XXXXXXXXXXXX 04330289 3,114.80 01/08/20XX 18 180.00 N XXX-XX-XXXX XXXXX, XXXXXXXX 04220204 4,160.00 01/08/20XX 10 100.00 N XXX-XX-XXXX XXXXXX XX, XXXXXXXXXXX 04010628 2,692.58 02/01/20XX 4 40.00 N XXX-XX-XXXX XXXXXXXX, XXXXXXXXXXX 04840705 4,059.12 01/21/20XX 18 180.00 N XXX-XX-XXXX XXXXXX, XXXXXXXX 04510403 2,745.60 01/13/20XX 20 200.00 N XXX-XX-XXXX XXXXXXX, XXXXXXXXXXXXXX 04080006 2,361.00 01/29/20XX 8 80.00 N XXX-XX-XXXX XXXXXXXXX XX, XXXXXX 04080046 2,086.00 01/18/20XX 2 20.00 N XXX-XX-XXXX-XXXXXXXXXX, XXXXXXXXXX 04010686 2,720.00 01/02/20XX 4 40.00 N XXX-XX-XXXX XXXXXXX, XXXXXX 04080039 2,236.00 01/13/20XX 6 60.00 N