Skip to content

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
Options H0XCR Sort H0XCR Break
Employee Name 864 0000
Organization Code 6 9999
Page Break
Options H0XCR Break
None 0000
Organization Code 9999
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