Skip to content

USPS Reports Guide
USPS Reports by Number

Report 540 Staffing Summary Report

This report will display all positions that were created for the current fiscal year. It includes the position number, employee name's that occupies the position, SSN, job class code or functional job class code if one exists, class title, salary table, group and step, EEO of employee in position, actual monthly salary or hourly rate, employment date, last reason code for the employee in the position, effective date of the last reason code, sequence number on the last reason code and whether the position is full time, part time, vacant, or closed.

Report Criteria

Category Position Control
Distribution Agency
Frequency Monthly; Upon Request
Form  
Sort Sequence
  1. Employee name (alpha) – no break
  2. Organization code, employee name – break and total by organization, agency total on separate page.
  3. New options to run reports with month end reports on HPRPTscreen include:
    • Employee, no break (Sort 3)
    • Organization code, employee name, break and total by organization, with agency total on separate page (Sort 4)

    Note: Agencies will need to send a letter of authorization (LOA) to their USPS representative to set up sort options 3 or 4 to run Report 540 with month-end reports.

Page Break
  1. No page break – agency total at the end of report
  2. Break and total by organization code – Agency total on separate page
Parameters HNKPC – END DATE
Databases Used HNH, HID, HNK, HNP, H7O, HML
Selection Criteria Display all positions with FY begin date, inactive date > HNK END DATE
Produce Output? Yes
Request Screen HNKPC; add HPRPT option so agencies can set up to run automatically.
Posting Report? No
Additional Notes

Total count of positions, total actual salaries, total vacant budgeted salaries, and total closed budgeted salaries will be totaled by organization code and then grand total for agency at the end of the report on separate page. The report will look at the actual FTE Instead of the authorized FTE to determine If an employee Is In the position on a particular date.

If the position was active but vacant during the ''as of'' date on the report, show the position as vacant. If the position was actually closed during the ''as of'' date the report shows the position as closed.

Report Headings

Column One

POS NO HNH.POSITION
This field displays the employee's position number.

Column Two

EMPLOYEE NAME HID.RPTNAME
This field displays the employee's name. (Last name, first name, middle name – spell out as much as possible.)

Column Three

SSN HNH.EMPLOYEENO
This field displays the employee's Social Security number (xxx-xx-xxxx). Put leading zeros if necessary.

Column Four

JB-CLS CD HNH.JOBCLASS or HNH.ACTFUNCLS
This field displays the employee's job class or if one exists functional job class number.

Column Five

JB-CLS or FUNC JB-CLS TITLE HNH. H7O.JCTITLE or HML.FCTITLE
This field displays the employee's job class title or if one exists Functional Job Class Title.

Column Six

TBL/GRP/STP HNH (AGENCY COMMENT BYTES 3-4)/HNH.POSPAYGRP/HNH.ACTUALSTEP
For active positions:

This field displays the employee's salary table, salary group and step.

For vacant positions displayed after all active positions:
TBL/GRP/STP HNP.PAYGROUP/HNP.PAY STP
This field displays the position's budgeted salary table, salary group and step.

For closed positions displayed after all vacant positions:

This field displays a zero salary since the position is closed.

Column Seven

EEO HNH.JCEEOCODE
This field displays the employee's EEO category code type.

Column Eight

MON-SAL/HRLY-RTE HNH. HSALARY, HNH.HHRLYRATE
For active positions:

This field displays the employee's current actual monthly salary or hourly rate. Display whichever applies. (xx,xxx.xx) or (xxx.xxxxx – hourly displays to the 5th decimal place).

For vacant positions:

This field displays the position's budgeted monthly salary or hourly rate. Display whichever applies. (xx,xxx.xx) or (xxx.xxxxx – hourly displays to the 5th decimal place).

For closed positions:

This field displays a zero (0.00) salary since the position is closed.

Column Nine

EMPLOY DATE HN8.EMPLOYDATE
This field displays the employee's employment date (mm/dd/yy).

Column Ten

LST RS HNH.HRISREASCD or HNH.EXTRSNCD
This field displays the reason code, or if one exists functional reason code, for the latest transaction, referenced in the effective date field.

Column Eleven

INCR-EFF DATE HNH.HLSTINCRDT
This field displays the last date a change to the employee's salary or hourly rate was effective (mm/dd/yy).

Column Twelve

FT DERIVED
Displays a '1' if the position is full-time, otherwise displays blank.

Column Thirteen

PT DERIVED
Displays a '1' if the position is part-time, otherwise displays blank.

Column Fourteen

VT DERIVED
Displays a '1' if the position is vacant, otherwise displays blank.

Column Fifteen

CL DERIVED
Displays a '1' if the position is closed, otherwise displays blank.
AGENCY TOTAL
For sort sequence 2, organization number and description should be displayed.

Organization number is on the HNH (for active) / HNP (vacant or closed) records. Description of organization code on HNORG.
TOT-ACT SALARIES
Part time employees salary calculation: (hourly rate x 2080 x FTE/12). ONLY FOR THE TOTAL LINE.

Total salaries for actual (active) salary for the month of the 'as of date' of the report.
TOT-VACANT BUDGETED SALARIES
Is the budgeted monthly salary or rate.
TOTAL POSITIONS
Total positions should be an accumulation of the Position Count field. (Suppress left zeros.)
POSITION COUNT
Total the count of each position column. If the position column equals zero (0), then display the zero (0).

Sample Report

    REPORT:   540                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1    
    AGENCY:   XXX                                       XXXXXXXXXXXXXXXXXXXXX                                    RUN DATE: XX/XX/20XX
                                                       STAFFING SUMMARY REPORT                                   RUN TIME: 21:47:33 
                                                           AS OF 08/31/20XX
                                                         
                                                JB-CL  JB-CLS OR FUNC       TBL/        MON-SAL/ EMPLOY   LST INCR-EFF  F   P   V  C  
  POS NO        EMPLOYEE NAME            SSN #    CD    JB-CLS TITLE       GRP/STP EEO  HRLY-RTE  DATE     RC  DATE     T   T   T  L
                                                                                                                                    
 995BM009 XXXXXXXX, XXX XXXXXXX      XXX-XX-XXXX CP25 COMP BD MEMBER/COMMI 02/01/01 A       0.04 10/14/98 038 04/01/04      1       
 995BM001 XXXXXXX, XXX XXXXXX        XXX-XX-XXXX CP25 COMP BD MEMBER/COMMI 02/01/01 A       0.04 08/11/97 038 04/01/04      1       
 995BM002 XXXXXX, XXXX XXXXXXXXX     XXX-XX-XXXX CP25 COMP BD MEMBER/COMMI 02/01/01 A       0.04 08/11/97 038 04/01/04      1       
 995BM030 XXXXXX, XXXX               XXX-XX-XXXX CP25 COMP BD MEMBER/COMMI 02/01/01 A       0.04 09/24/01 038 04/01/04      1       
 995BM008 XXXXXX, XXXXX XXXXX        XXX-XX-XXXX P134 BOARD MEMBER         02/01/01 A       0.04 11/13/03 038 04/01/04      1       
 99500002 XXXXXX, XXXX X             XXX-XX-XXXX 0160 EXECUTIVE ASST I     1B/09    P   3,415.25 04/01/01 035 08/01/02  1           
 995BM040 XXXXXXX, XXXXXXXX          XXX-XX-XXXX CP25 COMP BD MEMBER/COMMI 02/01/01 A       0.04 12/14/01 038 04/01/04      1       
 99500008 XXXXXXX, XXXXXXXXXXX XXXX  XXX-XX-XXXX E180 EXECUTIVE DIRECTOR   03/00/01 P   5,000.00 10/15/99 F04 10/01/01  1           
 99500007 XXXXX, XXXXXX X            XXX-XX-XXXX 1014 ACCOUNTANT III       1B/08    P   2,589.00 12/15/03 010           1           
 995BM006 XXXXX, XXXX X              XXX-XX-XXXX P134 BOARD MEMBER         02/01/01 A       0.04 05/02/96 038 04/01/04      1       
 99500055 XXXXXXXXX, XXX XXXXX       XXX-XX-XXXX 0255 SYS ANALYST II       1B/10    T   3,500.00 10/10/01 020 11/01/03  1           
 99500058 XXXX, XXXXXXX              XXX-XX-XXXX 0152 ADMINISTRATIVE ASST  1A/11    C   1,515.75 07/01/04 014               1       
 995BM007 XXXXXXX, XXXXXXX X         XXX-XX-XXXX P134 BOARD MEMBER         02/01/01 A       0.04 11/13/03 038 04/01/04      1       
 995BM005 XXXXX, XXXX                XXX-XX-XXXX P134 BOARD MEMBER         02/01/01 A       0.04 11/13/03 038 04/01/04      1       
 99500004 XXXXXXXX, XXXXX X          XXX-XX-XXXX 0154 ADMINISTRATIVE ASST  1A/13    C   2,327.00 07/01/04 010           1           
 99500056 XXXXX, XXXXX X             XXX-XX-XXXX 1352 INVESTIGATOR III     1B/08    R   2,771.00 09/21/02 035           1           
 AGENCY TOTAL                                                        TOTAL POSITIONS:       16       POSITION COUNT    6   10   0 
 TOT-ACT SALARIES:      21,118.36 TOT-VACANT BUDGETED SALARIES:           0.00