Skip to content

USPS Reports Guide
USPS Reports by Number

Report 190 Consolidated History Detail

This report displays all payments and adjustments for each employee for the requested time frame. It also displays employee totals and agency totals. This report can be very large depending on the payment date range requested and number of employees in the agency.

The summary page without the detail or employee totals, or the summary page with employee detail, but without the employee totals, can be specified using HNKPA.

Report Criteria

Category Payroll Administration
Distribution Agency
Frequency Upon request.
Form 111
Sort Sequence
Options H0XCR Sort
Employee Name, Employee Number, Warrant Date 852
Page Break Document No.
Parameters HNKPA – START DATE, END DATE (Pay Period, Dates)
Databases Used H0H, H0B, H0M, HID, H0Z, H0C, HNK, H10, HNH, H0V
Selection Criteria All history records with warrant dates within the requested HSRPQ date range.
Produce Output? Yes
Request Screen
Posting Report? No
Additional Notes This report can be very useful in quarterly reconciliations (Form 941) and annual W-2 reconciliations. Once the files are moved to option 14 (USPS file split), the YTD fields will not populate if run in the new calendar year using the prior calendar year dates.

Report Headings

PAY PERIOD DATES FROM/THRU HNK.RPTSDT/HNK.RPTEDT
Displays the pay period date range used.
EMPLOYEE NAME HID.RPTNAME
Displays the employee's name.
DOC NO. H0H.ALPHACONS1
Displays the USAS document number assigned to the payroll.
BASE PAY H0H.REG
Displays the regular base pay for the employee.
FIT TXBL H0H.FEDTXBL
Displays the amount of payroll wages that were taxable for federal income tax (FIT).
FIT TAX H0H.FITTAX
Displays the FIT tax that was deducted.
FSA HLTH CARE H0M.DEDAMT(36)
Displays the FSA health care reimbursement that was deducted.
401(K) H0M.DEDAMT(53)
Displays the 401(k) contribution that was deducted.
EMP INS H0M.DEDAMT
Displays the sum of all short-term and long-term disability and dependent life insurance deductions that was deducted.
EMPLOYEE SSN H0B.EMPLOYEENO
Displays the employee's SSN.
PYMT NO HOH.CHECKNG
Displays the nine-digit warrant or seven-digit direct deposit transaction number.
O/T H0H.OTIME1 + H0H.OTIME2
Displays the total amount paid for overtime worked.
OASDI TXBL H0H.OASDITXBL
Displays the amount of payroll wages that were taxable for OASDI tax.
EMP OASDI H0H.OASDITAX
Displays the OASDI tax that was deducted.
FSA DAY CARE H0M.DEDAMT(37)
Displays the FSA day care reimbursement that was deducted.
457 H0M.DEDAMT(54)
Displays the 457 contribution that was deducted.
PREM CONV H0M.DEDAMT(30-35)
Displays the sum of all AD&D, dental, employee health insurance, optional life, tobacco and vision deductions that was deducted.
TERM DATE H0B.TERMDATE
Displays the date the employee was terminated, if applicable.
PYMT DT HOH.CHKDATE
Displays the payment date of the warrant or direct deposit.
NET H0H.NET
Displays the employee's take home pay after all deductions have been taken. A direct deposit to a checking account is considered net pay.
MED TXBL H0H.HITXBL
Displays the amount of payroll wages that were taxable for HI/Medicare tax.
EMP MED H0H.HITAX
Displays the HI/Medicare tax that was deducted.
LIMITED FLEX H0M.DEDAMT (40)
Displays the amount of the limited flexible spending account that was deducted.
403(B) H0M.DEDAMT (55)
Displays the 403(b) contribution that was deducted.
IMP INC H0M.SPECPAY (10)
Displays the taxable amount of life insurance over $50,000 (imputed income).
MISC DEDUCTIONS H0M.DEDAMT, H1TZZ (TABLE 885)
Displays the deduction’s three-character abbreviation and the amount deducted. There are two columns to display miscellaneous deductions that are titled DED/AMT. Deduction names are in Appendix A: “Deduction Numbers” of the USPS Process Guide.
EIC H0H.EICMENT
Displays the earned income credit that was posted.
SIT TXBL H0A.YSITTXBL
Displays the amount of payroll wages that were taxable for state income tax.
RET H0M.DEDAMT(5-7, 9-10)
Displays the retirement contribution that was deducted.
SPECIAL PAYS H0M.SPECPAY, H1TZZ (TABLE 983)
Displays the special pay’s three character abbreviation and the amount paid. This can include BRP, longevity (LON), and hazardous duty (HAZ). LWOP is not included.
EMPLOYEE HSA H0M.DEDAMT(42)
Displays the amount of employee health savings account that was deducted.
ST PHC H0M.DEDAMT(23)
Displays the Payroll Health Insurance Contribution paid by the agency that was posted.
EMPLOYEE TOTAL DERIVED
Displays the total of all the pay records listed for the employee.
YTD TOTAL DERIVED
Displays year-to-date summary totals for the employee.

Summary Page Report Headings

BENEFIT REPLACEMENT PAY DERIVED H0M.SPECPAY(95, 96)
LONGEVITY DERIVED H0M.SPECPAY(06)
HAZARDOUS DUTY DERIVED H0M.SPECPAY(05)
OVERTIME DERIVED H0H.OTIME1 + H0H.OTIME2
SALARY PAYMENTS DERIVED H0H.REG + H0M.SPECPAY
Displays the total of each special payment for the requested date range.
GROSS PAY DERIVED
Displays the total of all the cash pays for the requested date range.
IMPUTED INCOME DERIVED H0M.SPECPAY (10)
Displays the amount of imputed income.
NON CASH SPECIAL PAYS DERIVED H0M.SPECPAY
Displays all non-cash special payments (except imputed income).
TOTAL GROSS PAY DERIVED H0M.SPECPAY
Displays the total of all the gross pays for the period, both cash and non-cash.
FIT TAXABLE WAGES DERIVED H0H.FEDTXBL
OASDI TAXABLE DERIVED H0H.OASDITXBL
MEDICARE TAXABLE WAGES DERIVED H0H.HITXBL
SIT TAXABLE WAGES HOH.SITTAXBL
FIT TAX DERIVED H0H.FITTAX
EMPLOYEE OASDI TAX DERIVED HOH.OASDITAX
EMPLOYEE MEDICARE TAX DERIVED H0H.HITAX
SIT TAX HOH.SITTAX
EARNED INCOME CREDIT DERIVED H0H.EICMENT
Displays the total of each tax type for the requested date range.
TOTAL EMPLOYEE TAX LIABILITY DERIVED
Displays the total of the employee tax liability for the period (FIT, OASDI, and HI/Medicare less EIC).
RETIREMENT DERIVED H0M.DEDAMT(5-7, 9-11)
TEXA$AVER (401K) DERIVED H0M.DEDAMT(53)
DEFERRED COMP DERIVED H0M.DEDAMT(54)
TAX SHELTERED ANNUITY (403B) DERIVED H0M.DEDAMT(55)
FSA HEALTH CARE DERIVED H0M.DEDAMT(36)
FSA DAY CARE DERIVED H0M.DEDAMT(37)
PREMIUM CONVERSION AMOUNT DERIVED H0M.DEDAMT(30-35)
STATE OPT OUT DERIVED H0M.DEDAMT(28)
MISCELLANEOUS NON TAXABLE
Displays the total of each non-taxable deduction for the requested date range.
TOTAL NON TAXABLES DERIVED
Displays total of all the non-taxable deductions for the requested date range.
401(K) LOAN REPAYMENT DERIVED H0M.DEDAMT(52)
457 LOAN REPAYMENT H0M.DEDAMT (56)
BANKRUPTCY DERIVED H0M.DEDAMT(16)
BONDS DERIVED H0M.DEDAMT(62-66)
CHARITABLE CONTRIBUTIONS DERIVED H0M.DEDAMT(60)
CHILD SUPPORT DERIVED H0M.DEDAMT(14)
CREDIT UNION DERIVED H0M.DEDAMT(67)
CREDIT UNION FEE DERIVED H0M.DEDAMT(68)
EMPLOYEE INSURANCE DERIVED H0M.DEDAMT(44-46)
MEMBERSHIP DUES DERIVED H0M.DEDAMT(50)
PAYABLES DERIVED H0M.DEDAMT(48)
SERVICE PURCHASE BUY BACK DERIVED H0M.DEDAMT(58)
FEDERAL GARNISHMENT DERIVED H0M.DEDAMT (21)
TAX LEVY DERIVED H0M.DEDAMT(19)
TX TOMORROW FUND/COLL SAVINGS PLAN DERIVED H0M.DEDAMT(59)
RETIREMENT (JR1) DERIVED H0M.DEDAMT(08)
RETIREMENT FEE (TAXABLE) DERIVED H0M.DEDAMT(04)
TEXAS PROTECTS DERIVED H0M.DEDAMT (47)
TRS BUYBACKS DERIVED HM.DEDAMT (57)
MISCELLANEOUS TAXABLE DEDUCTION
Displays the total of each taxable deduction not in a stand-alone category for the requested date range.
TOTAL TAXABLE DEDUCTIONS DERIVED
Displays the total of all the taxable deductions for the requested date range.
WARRANTS DERIVED H0H.NET – H0M.DEDAMT(70)
Displays the total of all the monies paid via a warrant for the requested date range.
DIRECT DEPOSIT SAVINGS DERIVED H0M.DEDAMT(69)
Displays the total of all the monies paid via a direct deposit into a savings account for the requested date range.
DIRECT DEPOSIT CHECKING DERIVED H0M.DEDAMT(70)
Displays the total of all the monies paid via a direct deposit into a checking account for the requested date range.
NET PAY DERIVED H0H.NET
Displays the total for all monies paid for the requested date range.
STATE PAID INSURANCE DERIVED H0M.DEDAMT(27)
Displays the total of the state-paid insurance contributions for the requested date range.
STATE PAID PAYROLL HEALTH INS CONTRIBUTION DERIVED H0M.DEDAMT(23)
Displays the total of the agency paid payroll health insurance contributions for the requested date range.
STATE PAID HEALTH SAVINGS ACCOUNT CONTRIBUTION DERIVED H0M.DEDAMT(43)
Displays the total of state-paid health savings account deduction for the requested date range.
STATE PAID RETIREMENT DERIVED H0M.DEDAMT(25 and 29)
Displays the total of the state-paid retirement contributions for the requested date range.
STATE PAYROLL RETIREMENT CONTRIBUTION DERIVED H0M.DEDAMT (22)
Displays the total of the agency paid retirement contributions for the requested date range.
STATE PAID RETIREMENT FEE DERIVED H0M.DEDAMT(24)
Displays the total of the state-paid retirement fees for the requested date range.
STATE PAID OASDI DERIVED H0H.OASDICOTAX
Displays the total of the state-paid OASDI tax for the requested date range.
STATE PAID MED DERIVED H0H.HICOTAX
Displays the total of the state-paid HI/Medicare tax for the requested date range.

Sample Report

   
   REPORT:   190                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1     
   AGENCY:   XXX                                      XXXXXXXXXXXXXXXXXXXXXXXX                                  RUN DATE: XX/XX/20XX
                                                    CONSOLIDATED HISTORY DETAIL                                 RUN TIME: 11:31:45  
                                          PAY PERIOD DATES FROM 09/01/20XX THRU 08/31/20XX                                          
----------------------------------------------------------------------------------------------------------------------------------- 
EMPLOYEE NAME      DOC NO.    BASE PAY   FIT TXBL    FIT TAX             FSA HLTH CARE  401(K)    EMP INS                           
EMPLOYEE SSN       PYMT NO.        O/T OASDI TXBL  EMP OASDI              FSA DAY CARE     457  PREM CONV                           
TERM DATE          PYMT DT.        NET   MED TXBL    EMP MED              LIMITED FLEX  403(B)    IMP INC  ---MISC DEDUCTIONS----
                                   EIC   SIT TXBL        RET SPECIAL PAYS EMPLOYEE HSA            ST PHC     DED/AMT    DED/AMT    
----------------------------------------------------------------------------------------------------------------------------------- 

XXXXXXXX, XXXXXX   XXXXXXXX   5,126.00   4,961.11     873.61 LON    180.00       .00       .00        .00 CHK 3,787.72              
XXX-XX-XXXX     XXXXXXXXXXX        .00   5,306.00     222.85                     .00       .00        .00                            
                 07/15/20XX   3,787.72   5,306.00      76.93                     .00       .00        .00                           
                                   .00        .00     344.89                     .00                51.26                           


     EMPLOYEE TOTAL           5,126.00   4,961.11     873.61 LON    180.00       .00       .00        .00                           
                                   .00   5,306.00     222.85                     .00       .00        .00                           
                              3,787.72   5,306.00      76.93                     .00       .00        .00                           
                                   .00        .00     344.89                     .00                51.26                           

          YTD TOTAL           5,126.00   4,961.11     873.61 LON    180.00       .00       .00        .00                           
                                   .00   5,306.00     222.85                     .00       .00        .00                           
                              3,787.72   5,306.00      76.93                     .00       .00        .00                           
                                   .00        .00     344.89                     .00                51.26                           
   
   REPORT:   190                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                         PAGE:   2     
   AGENCY:   XXX                                       XXXXXXXXXXXXXXXXXXXX                                     RUN DATE: XX/XX/20XX
                                                    CONSOLIDATED HISTORY SUMMARY                                RUN TIME: 11:31:45  
                                          PAY PERIOD DATES FROM 09/01/20XX THRU 08/31/20XX                                          
------------------------------------------------------------------------------------------------------------------------------------
  DESCRIPTION                                                      TAXABLE WAGES                 AMOUNT                 TOTALS      
------------------------------------------------------------------------------------------------------------------------------------
                                                                                                                                    
  BENEFIT REPLACEMENT PAY                                                                     11,979.93                             
  LONGEVITY                                                                                   36,560.00                             
  HAZARDOUS DUTY                                                                                   0.00                             
  OVERTIME                                                                                         0.00                             
  SALARY PAYMENTS  (BASE PAY & OTHER CASH PAYS NOT ABOVE)                                  1,395,327.40                             
                                                                                                                                    
       GROSS PAY                                                                                                  1,443,867.33      
  IMPUTED INCOME                                                                               2,844.18                             
                                                                                                                                    
  NON CASH SPECIAL PAYS                                                                            0.00                             
       TOTAL GROSS PAY                                                                                            1,446,711.51      
  FIT TAXABLE WAGES                                                 1,258,748.85                                                    
  OASDI TAXABLE WAGES                                               1,382,708.87                                                  
  MEDICARE TAXABLE WAGES                                            1,382,708.87                                                  
  SIT TAXABLE WAGES                                                         0.00                                                  
  FIT TAX                                                                                    141,191.72                           
  EMPLOYEE OASDI TAX                                                                          57,989.75                           
  EMPLOYEE MEDICARE TAX                                                                       20,020.26                           
  SIT TAX                                                                                          0.00                           
  EARNED INCOME CREDIT                                                                             0.00                           
       TOTAL EMPLOYEE TAX LIABILITY                                                                                 219,201.73    
  RETIREMENT                                                                                  91,690.85                           
  TEXASAVER (401K)                                                                            27,038.84                           
  DEFERRED COMP (457)                                                                          5,230.33                           
  TAX SHELTERED ANNUITY (403B)                                                                     0.00                           
  FSA HEALTH CARE                                                                             13,414.00                           
  FSA DAY CARE                                                                                 3,625.00                           
  LIMITED FLEX                                                                                     0.00                             
  EMPLOYEE HSA                                                                                     0.00                           
  PREMIUM CONVERSION AMOUNT                                                                   46,963.64                           
  STATE OPT OUT                                                                                  240.00                           
  MISCELLANEOUS NONTAXABLE DEDUCTIONS                                                            676.30                           
       TOTAL NON TAXABLES                                                                                           187,962.66     
  
   
REPORT:   190                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     3     
   AGENCY:   XXX                                      XXXXXXXXXXXXXXXXXXXXXXXX                                  RUN DATE: XX/XX/20XX
                                                    CONSOLIDATED HISTORY SUMMARY                                RUN TIME: 11:31:45  
                                          PAY PERIOD DATES FROM 09/01/20XX THRU 08/31/20XX                                          
------------------------------------------------------------------------------------------------------------------------------------
  DESCRIPTION                                                       MEMO AMOUNTS                 AMOUNT                 TOTALS      
------------------------------------------------------------------------------------------------------------------------------------
                                                                                                                                    
  401(K) LOAN REPAYMENT                                                                            0.00                             
  457 LOAN REPAYMENT                                                                               0.00                             
  BANKRUPTCY                                                                                       0.00                             
  BONDS                                                                                            0.00                             
  CHARITABLE CONTRIBUTIONS                                                                         0.00                             
  CHILD SUPPORT                                                                                    0.00                             
  CREDIT UNION                                                                                     0.00                             
  CREDIT UNION FEE                                                                                 0.00                             
  EMPLOYEE INSURANCE                                                                              75.72                             
  MEMBERSHIP DUES                                                                                 30.00                             
  PAYABLES                                                                                         0.00                             
  SERVICE PURCHASE BUY BACK                                                                        0.00                             
  FEDERAL GARNISHMENTS                                                                             0.00                             
  TAX LEVY                                                                                         0.00                             
  TX TOMORROW FUND/COLL SAVINGS PLAN                                                               0.00                             
  RETIREMENT (JR1)                                                                                 0.00                             
  RETIREMENT FEE (TAXABLE)                                                                         0.00                             
  TEXAS PROTECTS                                                                                   0.00                             
  TRS BUYBACKS                                                                                     0.00                             
  MISCELLANEOUS TAXABLE DEDUCTIONS                                                                 0.00                             

       TOTAL TAXABLE DEDUCTIONS                                                                                         105.72      

  WARRANTS                                                                                         0.00                             
  DIRECT DEPOSIT SAVINGS                                                                           0.00                             
  DIRECT DEPOSIT CHECKING                                                                     74,848.62                             

       NET PAY                                                                                                       74,848.62      

  STATE PAID INSURANCE                                                  5,662.11                                                    
  STATE PAID PAYROLL HEALTH INS CONTRIBUTION                              412.73  
  STATE PAID HEALTH SAVINGS ACCOUNT CONTRIBUTION                            0.00                                                  
  STATE PAID RETIREMENT                                                 5,047.97 
  STATE PAYROLL RETIREMENT CONTRIBUTION                                     0.00             
  STATE PAID RETIREMENT FEE                                                 0.00                                                    
  STATE PAID OASDI                                                      4,761.79                                                    
  STATE PAID MED                                                        1,539.63