Skip to content

USPS Reports Guide
USPS Reports by Number

Report 189 Payroll Detail Report

This report displays payment data for each employee for the current payroll. Adjustments within a document are sorted to the bottom of each fund. Totals are calculated by each organization code, labor code, and comp object code. Agency and document totals are also listed at the end of the report. History records are updated after each final payroll run. Builds the extract file used to build USAS records.

Report Criteria

Category Payroll Administration
Distribution Agency
Frequency Runs with payroll.
Form 113
Sort Sequence
Options H0XCR Sort
Document Number, Fund Number, Adjustments, Organization Code, Position Number, Employee Number 882
Page Break
Options H0XCR Break
None 0000
Organization Code 9999
First Level - Organization Code 1000
First and Second - Level Organization Code 1200
First, Second, and Third Level - Organization Code 1230
Parameters  
Databases Used H0M, H0H, HID, H70, H0C, H0B, H0W, H0Z, H0N, HO0, HNO, HNH, H1T, HMP, HPS
Selection Criteria All employees on the current payroll.
Produce Output? Yes
Request Screen HPRPT – Set up to run automatically with each payroll.
Posting Report? No
Additional Notes *** EDIT/REPORT RUN *** will display in the top left corner of the report if the report was produced from a trial/edit payroll. This report will generate twice only when a final payroll is rejected. Use the latest RUN TIME/DATE, which is found in the top right corner of the report.

Report Headings

ORGANIZATION CODE H0H.ORGCODE
Displays the employee's organization code if the organization code sort is being used.
PAYROLL FOR WARRANT DATE OF H0H.CHKDATE
Displays the warrant date of the current payroll.
BATCH H0H.ALPHACONS5
Displays the batch number assigned by the USAS interface.
DOCUMENT NUMBER H0H.ALPHACONS1
Displays the USAS document number assigned to the payroll.
RUN TYPE H0H.ALPHAC0NS2
Displays the type of payroll being processed:
EREdit Regular
ESEdit Supplemental
ECEdit Consitutional Per Deim
EAEdit Automatic Supplemental
ENEdit New Hire Supplemental
TRTrial Regular
TSTrial Supplemental
TCTrial Constitutional Per Diem
TATrial Automatic Supplemental
TNTrial New Hire Supplemental
FRFinal Regular
FSFinal Supplemental
FCFinal Constitutional Per Diem
FAFinal Automatic Supplemental
FNFinal New Hire Supplemental
FUND/AY H0H.ALPHACONS2/H0H.ALPHACONS3
Displays the USAS fund number and the appropriation year from which the payment is being posted.
CHG HNH.HRISREASCD
Displays an asterisk (*) and an HRIS reason code for employees who had personnel changes in the current pay period.
EMPLOYEE SSN H0B.EMPLOYEENO/DERIVED
Displays the employee's SSN.
PRD END DT H0H.PERIODEND
Displays the last day of the employee's pay period.
PCA/I H0H.LABORCD
Displays the labor code to which the payment was charged.
OBJC H0H.LABORCDEXT
Displays the USAS expenditure code assigned to each type of pay the employee receives.
GROSS AMOUNTS H0H.REG, H0H.DT1, H0H.DT2, H0M.SPECAMT
Displays the employee's gross pay broken down by object code.
NET H0H.NET + H0M.DEDAMT(69)
Displays the employee's take home pay after all deductions have been taken. Any direct deposit deduction is considered net pay.
W/H H0H.FITTAX
Displays the federal income tax deducted from the employee's pay.
INS H0M.DEDAMT
Displays the sum of all short-term and long-term disability and dependent life insurance that was deducted.
DEF COMP H0M.DEDAMT(54)
Displays the 457 compensation that was deducted.
MISC H0M.DEDAMT, H1TZZ (TABLE 885)
Displays the deduction’s three-character abbreviation and the amount deducted. Deduction names are in Appendix A: “Deduction Numbers” of the USPS Process Guide.
ORG CODE H0H.ORGCODE
Displays the employee's organization code.
NAME HID.RPTNAME
Displays the employee's name.
ST PHC H0M.DEDAMT(23)
Displays the Payroll Health Insurance Contribution
OASDI H0H.OASDITAX
Displays the OASDI tax that was deducted.
RETIR H0M.DEDAMT(5-10)
Displays the retirement contribution that was deducted.
TXSVER H0M.DEDAMT(53)
Displays the 401(k) contribution that was deducted.
PAYMENT NO H0H.CHECKNO
Displays the warrant or direct deposit advise number.
JCLS H0H.JOBCLASS
Displays the employee's job class code.
TB/GR/ST HNH.AGYCOMMENT/HNH.POSPAYGRP/HNH.ACTUALSTEP
Displays the pay table and group associated with the employee's job class code. Displays the employee's pay step, if applicable.
JS H0H.WKCMPCODE
Displays the employee's job schedule.
LV H0B.FLAGA
Displays whether or not the employee is leveling benefit replacement pay.
YLevel
NDo Not Level
WNot Eligible for BRP
POSITION H0H.POSITION
Displays the employee's position number for this payment.
NONCASH DERIVED H0M.SPECPAY
Displays the non-cash compensation that was added to the employee's taxable wages. For example, IMPUT will display when imputed income is calculated for the employee.
MED H0H.HITAX
Displays the HI/Medicare taxes that was deducted.
ST RET H0M.DEDAMT(25)
Displays the state-paid retirement for the employee.
ST INS H0M.DEDAMT(26,43)
Displays the state-paid health insurance and state-paid health savings account for the employee.
ST PRC H0M.DEDAMT (22)
Displays the agency paid retirement contribution.
PCA/I TOTALS DERIVED
Displays the total gross pay, including BRP and longevity for each PCA or index.
ORG TOT DERIVED
Displays the totals of gross pay, net, taxes, and all other deductions associated with the organization code.
TOTAL ORG CODE EXPENDITURES BY OBJECT CODE DERIVED
Displays the total of all object codes associated with the organization code.
FUND TOTALS DERIVED
Displays the totals of gross pay, net, taxes, and all other deductions associated with the fund number.
DOCUMENT TOTALS DERIVED
Displays the totals of gross pay, net, taxes, and all other deductions associated with this document.
TOTAL DOCUMENT EXPENDITURES BY OBJECT CODE DERIVED
Displays the total of all expenditure codes associated with this document.
TOTAL AGENCY EXPENDITURES BY OBJECT CODE DERIVED
Displays the total of all object codes on the payroll.
TOTAL EMPLOYEES WITH PAYROLL ACTIVITY BY ORG DERIVED
Displays the number of employees paid by organization code.
NUMBER OF EMPLOYEES PAID DERIVED
Displays the number of employees paid on this document.

Sample Report

   REPORT:   189                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1     
   AGENCY:   XXX                                     XXXXXXXXXXXXXXXXXXXXXXXXX                                  RUN DATE: XX/XX/20XX
                                               PAYROLL FOR WARRANT DATE OF 11/04/20XX                           RUN TIME: 10:38:35  
            
 BATCH  810   DOCUMENT NUMBER  XXXXXXXX  RUN TYPE  FS                                                                               
                                                                                                D E D U C T I O N S                 
------------------------------------------------------------------------------------------------------------------------------------
FUND/AY CHG  EMPLOYEE SSN     PRD END DT PCA/I OBJC       GROSS            NET           W/H           INS      DEFCOMP     MISC  
ORG CODE     NAME             L                         AMOUNTS          ST PHC        OASDI         RETIR       TXSVER     MISC    
PAYMENT NO   JCLS TB/GR/ST JS V POSITION                                 NONCASH         MED         ST RET      ST INS     MISC   
                                                                                                     ST PRC                 MISC
------------------------------------------------------------------------------------------------------------------------------------

0001/12 *010 XXX-XX-XXXX      10/31/20XX P00001 7002   2,638.88       2,056.06        262.19          0.00         0.00 STF     3.00
00002000100  XXXXX, XXXXXXXX                               0.00           0.00        110.83        171.53         0.00  
XXXXXXXXXXX  0156 00/15/      W 30653I                                                 38.27        183.40         0.00 
                                                                                                      0.00
                     152.00 HOURS AT  17.36105/HR  NEW HIRE                             

  P00001      PCA/I TOTALS                             2,638.88                    

  00002000100 STAFF                     ORG TOT        2,638.88        2,056.06        262.19          0.00         0.00        3.00
                                                                           0.00        110.83        171.53         0.00 
                                                                           0.00         38.27        183.40         0.00  
                                             TOTAL ORG CODE EXPENDITURES BY OBJECT CODE
                        
  7002          2,638.88  7032            186.40  7043            201.88     

         0001 FUND TOTALS                              2,638.88      2,056.06        262.19          0.00         0.00          3.00
                                                                         0.00        110.83        171.53         0.00  
                                                                         0.00         38.27        183.40         0.00  

     XXXXXXXX DOCUMENT TOTALS                          2,638.88       2,056.06       262.19          0.00         0.00          3.00
                                                                         0.00        110.83        171.53         0.00 
                                                                         0.00         38.27        183.40         0.00  

                                            TOTAL DOCUMENT EXPENDITURES BY OBJECT CODE                          
                                              
 7002          2,638.88  7032            186.40  7043            201.88                                                             

              AGENCY TOTAL                             2,638.88       2,056.06        262.19          0.00         0.00         3.00
                                                                          0.00        110.83        171.53         0.00             
                                                                          0.00         38.27        183.40         0.00             

                                              TOTAL AGENCY EXPENDITURES BY OBJECT CODE                                                
                                                 
 7002          2,638.88  7032            186.40  7043            201.88