Skip to content
Breadcrumbs

USPS Reports Guide –
USPS Reports by Number –
Report 032 Generated Nightly Insurance Deductions & Imputed Income

This report displays additions and changes to insurance elections, including imputed income. It also produces 225 and 280 transactions used to set up a payroll deduction on H0ZUC and a special pay for imputed income on H10SP, if applicable.

This does not apply to those with job class F023, working for agency 241. Insurance frequencies will stay off because insurance premiums are not paid through USPS.

Report Criteria

Category Benefits Administration
Distribution Agency
Frequency Nightly
Form 932
Sort Sequence
Options H0XCR Sort H0XCR Break
Employee Number 885 0000
Organization Code, Employee Number 6 9999
Page Break
Options H0XCR Break
None 0000
Organization Code 9999

Note: Sort sequence option must match the Page Break option.
Parameters  
Databases Used H0C, H10, HID, HMT, HNK, HNP, HNS, H0B, HMD, HNH H0Z, HAT, H1T
Selection Criteria All employees with changes to insurance since report was last run.
Produce Output? Yes
Request Screen HPRPT – Automatically runs in maintenance cycle.
Posting Report? Yes – Updates HMTU1.
Additional Notes

Changes made to a future month prior to Month-End Clears are pending until clears are processed.

Semi-monthly employees with an employment date greater than the 15th of the current month, an HMTU1 record equal to that employment date, and whose last HNHLS reason code is 010, will have 8XX transactions generated by Report 32. These transactions are payroll deduction overrides and are designed to allow insurance deductions to be taken from the 2nd semi-monthly payroll. Imputed income will be automatically stopped when the optional life deduction is stopped.

Imputed income age calculations are based on employees age as of December 31.

Report Headings

AS OF H0I.LSTPROCDT
Displays the date for which the report was run.
PAYROLL MONTH HNK.FLAG69
Displays the current payroll month used to determine whether a transaction is processed or pended.
EMPLOYEE NAME HID.RPTNAME
Displays the employee's name.
EMP SSN HMT.EMPLOYEENO
Displays the employee's SSN.
TRANS DERIVED FROM HMTU1
Displays the transaction code.
225Deduction
280Special Pay
TYPE DERIVED FROM HMTU1
Displays the name of the deduction/special pays.
FREQ-CD DERIVED
Displays the frequency code.
01Deduct on the first pay period of the month
00Inactive
AMOUNT DERIVED FROM HMTU1
Displays the transaction amount.
DED NO DERIVED
Displays the number of the deduction/special pay.
COVERAGE DATE DERIVED FROM HMT
Displays the effective date of the deduction/special pay. This is not the effective date of the HMTU1 record. It is the effective date of the individual coverage.
ADDITIONAL NOTES
Displays the effective date of the deduction/special pay. This is not the effective date of the HMTU1 record. It is the effective date of the individual coverage.
COMMENT DERIVED
Displays ADJ may be required when the employee has already been paid for the pay period that the change is effective. This helps identify which employees may need payroll adjustments.

Sample Report

REPORT:    32                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1    
  AGENCY:   XXX                                   XXXXXXXXXXX XX XXXXXX XXXXXXXX                               RUN DATE: XX/XX/20XX
                                     GENERATED NIGHTLY INSURANCE DEDUCTIONS & IMPUTED INCOME                   RUN TIME: 19:18:02 
                                            AS OF 01/20/20XX -  PAYROLL MONTH JANUARY                                             

     EMPLOYEE NAME                EMP. SSN    TRANS  TYPE       FREQ-CD  AMOUNT    DED NO   COVERAGE DATE    COMMENT              
                                                                                                                                   
     XXXXXXXX, XXXXX X            XXXXXXXXX    225   ST PD HLTH     01    343.48     026      01/20/20XX                          
                                               225   DENTAL         01     21.03     031      01/20/20XX                          
                                               225   DIS SHORT      01      9.19     044      01/20/20XX                          
                                               225   DIS LONG       01     20.10     045      01/20/20XX