Skip to content

USPS Reports Guide
USPS Reports by Number

Report 509 Management to Staff Ratio Report

This report displays information required by the State Auditor's Office regarding the management to staff ratios based on FTE's in addition to employee count.

Report Criteria

Category Personnel Management
Distribution Agency
Frequency Upon Request; Monthly or Quarterly
Form  
Sort Sequence

Detail – Organization Code, Management to Staff Indicator, Employee Name (Request options: D, 5, 6, 7, 8)

Summary – First Level: Organization Code (Request options: S, 1, 2, 3, 4)

Page Break Organization Code (Request options: D, 5, 6, 7, 8)
Parameters
Databases Used H0C, HNK, HNH, HID, HO9, H01, HNO, HOH
Selection Criteria All HNH records with an effective date greater than or equal to beginning of the fiscal year and less than or equal to the END DATE where the job class code is not excluded from reporting as defined on H7OU1.
Produce Output? Yes
Request Screen HNKPM – 10 Options – select one:
SSummary Information Only For The Current Quarter
1Information Only For The Previous Quarter 9/1 To 11/30
2Information Only For The Previous Quarter 12/1 To 2/28(29)
3Information Only For The Previous Quarter 3/1 To 5/31
4Information Only For The Previous Quarter 6/1 To 8/31
DDetail & Summary Information For The Current Quarter
5Detail & Summary Information For The Previous Quarter 9/1 To 11/30
6Detail & Summary Information For The Previous Quarter 12/1 To 2/28(29)
7Detail & Summary Information For The Previous Quarter 3/1 To 5/31
8Detail & Summary Information For The Previous Quarter 6/1 To 8/31
Posting Report? No
Additional Notes

Request indicators 1–8, produces information for the prior quarters. Corrections to the Management/Staff Ratio indicator can be made on HMPUE and HNHUE.

Division titles are defined on HO9U1 and are specific to each agency.

Report Headings

AS OF HNK.PMEDT
Displays the end date of the request period.
ORGANIZATION CODE HNH.PMEDT
Displays the employee's organization code.
NAME HID.RPTNAME
Displays the employee's name.
SSN HNH.EMPLOYEENO
Displays the employee's SSN.
PRIMARY POSITION HNH.POSITION, HNH.PCPOSIND
Displays the employee's position number. An * will print to the right of the position number if the employee was in multiple positions at the end of the reporting quarter. A ** will print to the right of the MSR indicator if the employee changed MSR indicators on the primary position during the reporting quarter.
JOB CLASS/FUNC JOB CLASS HNH.JOBCLASS, HNH.ACTFUNCLS
Displays the employee's state job class and (if specified) agency functional job class.
MSR HNH.MSRIND
Displays the management to staff ratio code that identifies the type of position the employee fills. The character in the field on the left side is H, M, S or N.
HAgency Head
MManagement
SSupervisory
NStaff
A second user-defined character can be used to further differentiate this indicator for Agency use.
EMP TOT HRS/WORKED/PAI HOH.HRS/WORKED/PAI
Displays the total number of hours worked/paid in the quarter for the employee in that position.
TOTAL STAFF DERIVED
Displays the number of employees in the Agency and in each Org Code and Division.
TOTAL HOURS WORKED/PAID HOH.HRS/WORKED/PAI
Displays the sum of the hours worked at the organizational level. First total shown reflects information for Total Staff. Remaining totals correlate to the MSR indicator immediately preceding the totals.
H/M/S/N DERIVED
Displays the number of employees assigned to each of the management to staff ratio indicators in the Agency and in each Org Code and Division.
M/S RATIO HNH.MSRIND
Displays the ratio of staff to management in the Agency and in each Org Code and Division.

USPS Calculations are: (N+S+M) / (S+M+H) = Ratio.

Sample Report

    REPORT:   509                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1     
    AGENCY:   XXX                                      XXXXXXXXXXXXXXXXXXXXXXXX                                  RUN DATE: 04/17/20XX
 00XXXX00000                                       MANAGEMENT TO STAFF RATIO REPORT                              RUN TIME: 15:59:56  
                                                           AS OF 02/28/20XX                                                          
                                                                                                                                     
                                                                   PRIMARY        JC/                 EMP TOT HRS                    
        NAME                                        SSN            POSITION       FJC        MSR      WORKED/PAID                    
                                                                                                                                     
        XXXXXXXXXXXXXXXXX                           XXX-XX-XXXX    12340002        5226      N               520.00                  
        XXXXXXXXXXXXXXXXX                           XXX-XX-XXXX    12340010        5226      N               520.00                  
        XXXXXXXXXXXXXXXXXXX                         XXX-XX-XXXX    12340003        5226      N                22.00 *TERM 12/31/20XX*
-ORG CODE/ORG NAME                                                                                                                   
 00XXXX00000/XXXXXXXXXXXXXX                                                                                                          
                                                                                                                                     
    TOTAL     TOTAL HOURS       H     TOTAL HOURS       M     TOTAL HOURS       S     TOTAL HOURS       N     TOTAL HOURS            
    STAFF     WORKED/PAID             WORKED/PAID             WORKED/PAID             WORKED/PAID             WORKED/PAID   M/S RATIO
                                                                                                                                     
        2        1,040.00       0            0.00       0            0.00       0            0.00       2        1,040.00        .000
                                                                                                                                     
 ORG STAFF TERMINATED DURING QUARTER                                                                                                 
                                                                                                                                     
        1           22.00       0            0.00       0            0.00       0            0.00       1           22.00        .000
                                                                                                                                     
 ORG TOTALS                                                                                                                          
                                                                                                                                     
        3        1,062.00       0            0.00       0            0.00       0            0.00       3        1,062.00        .000