Skip to content

USPS Reports Guide
USPS Reports by Number

Report 166 Employee by Salary Group

This report displays all employees as of the request date by pay table and salary group, SSN, name, position title, job class, position number, classification date, salary and step. The report also displays a total by salary group, pay table, division, and agency.

Report Criteria

Category Personnel Management
Distribution Agency
Frequency Upon Request
Form 111
Sort Sequence
Options H0XCR Sort
First Level - Organization Code, Pay Table, Pay Group, Employee Name, Employee Number 922
Page Break First Level - Organization Code, Pay Table, Pay Group
Parameters HNKPM – END DATE
Databases Used H0C, HNK, H7O, HNP, H0B, HID, HNH, HML
Selection Criteria All Active and on-leave employees as of the HNK date.
Produce Output? Yes
Request Screen HSRPT
Posting Report? No
Additional Notes  

Report Headings

DIVISION HNH.ORGCODE
Displays the first three positions of the employee's organization code.
EMPLOYEE SALARY GROUP AS OF HNK.PCEDT
Displays the end date used to run this report.
TABLE HNH.SALTBLTYP
Displays the employee's pay table as defined by their job class code.
GROUP HNH.ACTPAYGRP
Displays the employee's pay group.
EMPLOYEE SSN HNH.EMPLOYEENO
Displays the employee's SSN.
EMPLOYEE NAME HID.RPTNAME
Displays the employee's name.
TITLE HML.FCTITLE.HNP.JOBDESC
Displays the functional job class title that corresponds to the employee's position. If a functional job class was not assigned, the job class title will display.
JOB CLASS HNH.JOBCLASS
Displays the employee's job class code.
POSITION HNP.POSITION
Displays the position number.
CLASS DATE HNH.HPROMDATE
Displays the date of the employee's last promotion, merit increase, or demotion. If the employee is not classified or has not received one of the above salary actions, this date will be the employee's hire date. This classification date is used to track the twelve months lapse required for awarding merit increases. Effective 09/01/1999, this twelve month lapse will be replaced by a six month lapse.
SALARY/HOURLY HNH.HSALARY, HNH.HHRLYRATE
Displays the employee's current or hourly salary.
STEP HNH.ACTUALSTEP
Displays the employee's pay step, if applicable.
SALARY GROUP EMPLOYEE COUNT Derived
Displays the number of employees in a salary group.
PAY TABLE EMPLOYEE COUNT Derived
Displays the number of employees in a pay group.
DIVISION EMPLOYEE COUNT Derived
Displays the number of employees in a division.
AGENCY EMPLOYEE COUNT Derived
Displays the number of employees in the agency.

Sample Report

 
  REPORT:   166 
DIVISION:	000                 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                            PAGE:    1
  AGENCY:   XXX                        XXXX XXXXX XXXXXXXXXXX XXXXX                                RUN DATE: XX/XX/20XX
                                     EMPLOYEE BY JOB CLASSIFICATION                               RUN TIME: 2:00:00
                                   EMPLOYEE SALARY GROUP AS OF 09/01/05                                 

TABLE 00 GROUP 00

                                                                        JOB                                   SALARY/
       EMPLOYEE SSN   EMPLOYEE NAME          TITLE                      CLASS      POSITION    CLASS DATE      HOURLY      STEP

       XXX-XX-XXXX    XXXX, XXXXXXXX         CARTOON ARTIST             A123       01010101    02/13/20XX        30.00      03
       XXX-XX-XXXX    XXXXXXXXX, XXX         BOARD MEMBER               C456       02020202    06/15/20XX     4,992.00      01

SALARY GROUP EMPLOYEE COUNT            2

   PAY TABLE EMPLOYEE COUNT            2