FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

USPS Reports Guide
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 HØXCR Sort
Employee Name, Employee Number, Warrant Date 852
Page Break Document No.
Parameters HNKPA – START DATE, END DATE (Pay Period, Dates)
Databases Used HØH, HØB, HØM, HID, HØZ, HØC, HNK, H1Ø, HNH, HØV
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. HØH.ALPHACONS1
Displays the USAS document number assigned to the payroll.
BASE PAY HØH.REG
Displays the regular base pay for the employee.
FIT TXBL HØH.FEDTXBL
Displays the amount of payroll wages that were taxable for federal income tax (FIT).
FIT TAX HØH.FITTAX
Displays the FIT tax that was deducted.
FSA HLTH CARE HØM.DEDAMT(36)
Displays the FSA health care reimbursement that was deducted.
401(K) HØM.DEDAMT(53)
Displays the 401(k) contribution that was deducted.
EMP INS HØM.DEDAMT
Displays the sum of all short-term and long-term disability and dependent life insurance deductions that was deducted.
EMPLOYEE SSN HØB.EMPLOYEENO
Displays the employee's SSN.
PYMT NO HOH.CHECKNG
Displays the nine-digit warrant or seven-digit direct deposit transaction number.
O/T HØH.OTIME1 + HØH.OTIME2
Displays the total amount paid for overtime worked.
OASDI TXBL HØH.OASDITXBL
Displays the amount of payroll wages that were taxable for OASDI tax.
EMP OASDI HØH.OASDITAX
Displays the OASDI tax that was deducted.
FSA DAY CARE HØM.DEDAMT(37)
Displays the FSA day care reimbursement that was deducted.
457 HØM.DEDAMT(54)
Displays the 457 contribution that was deducted.
PREM CONV HØM.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 HØB.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 HØH.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 HØH.HITXBL
Displays the amount of payroll wages that were taxable for HI/Medicare tax.
EMP MED HØH.HITAX
Displays the HI/Medicare tax that was deducted.
LIMITED FLEX HØM.DEDAMT (40)
Displays the amount of the limited flexible spending account that was deducted.
403(B) HØM.DEDAMT (55)
Displays the 403(b) contribution that was deducted.
IMP INC HØM.SPECPAY (10)
Displays the taxable amount of life insurance over $50,000 (imputed income).
MISC DEDUCTIONS HØM.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 HØH.EICMENT
Displays the earned income credit that was posted.
SIT TXBL HØA.YSITTXBL
Displays the amount of payroll wages that were taxable for state income tax.
RET HØM.DEDAMT(5-7, 9-10)
Displays the retirement contribution that was deducted.
SPECIAL PAYS HØM.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 HØM.DEDAMT(42)
Displays the amount of employee health savings account that was deducted.
ST PHC HØM.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 HØM.SPECPAY(95, 96)
LONGEVITY DERIVED HØM.SPECPAY(06)
HAZARDOUS DUTY DERIVED HØM.SPECPAY(05)
OVERTIME DERIVED HØH.OTIME1 + HØH.OTIME2
SALARY PAYMENTS DERIVED HØH.REG + HØM.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 HØM.SPECPAY (10)
Displays the amount of imputed income.
NON CASH SPECIAL PAYS DERIVED HØM.SPECPAY
Displays all non-cash special payments (except imputed income).
TOTAL GROSS PAY DERIVED HØM.SPECPAY
Displays the total of all the gross pays for the period, both cash and non-cash.
FIT TAXABLE WAGES DERIVED HØH.FEDTXBL
OASDI TAXABLE DERIVED HØH.OASDITXBL
MEDICARE TAXABLE WAGES DERIVED HØH.HITXBL
SIT TAXABLE WAGES HOH.SITTAXBL
FIT TAX DERIVED HØH.FITTAX
EMPLOYEE OASDI TAX DERIVED HOH.OASDITAX
EMPLOYEE MEDICARE TAX DERIVED HØH.HITAX
SIT TAX HOH.SITTAX
EARNED INCOME CREDIT DERIVED HØH.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 HØM.DEDAMT(5-7, 9-11)
TEXA$AVER (401K) DERIVED HØM.DEDAMT(53)
DEFERRED COMP DERIVED HØM.DEDAMT(54)
TAX SHELTERED ANNUITY (403B) DERIVED HØM.DEDAMT(55)
FSA HEALTH CARE DERIVED HØM.DEDAMT(36)
FSA DAY CARE DERIVED HØM.DEDAMT(37)
PREMIUM CONVERSION AMOUNT DERIVED HØM.DEDAMT(30-35)
STATE OPT OUT DERIVED HØM.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 HØM.DEDAMT(52)
457 LOAN REPAYMENT HØM.DEDAMT (56)
BANKRUPTCY DERIVED HØM.DEDAMT(16)
BONDS DERIVED HØM.DEDAMT(62-66)
CHARITABLE CONTRIBUTIONS DERIVED HØM.DEDAMT(60)
CHILD SUPPORT DERIVED HØM.DEDAMT(14)
CREDIT UNION DERIVED HØM.DEDAMT(67)
CREDIT UNION FEE DERIVED HØM.DEDAMT(68)
EMPLOYEE INSURANCE DERIVED HØM.DEDAMT(44-46)
MEMBERSHIP DUES DERIVED HØM.DEDAMT(50)
PAYABLES DERIVED HØM.DEDAMT(48)
SERVICE PURCHASE BUY BACK DERIVED HØM.DEDAMT(58)
FEDERAL GARNISHMENT DERIVED HØM.DEDAMT (21)
TAX LEVY DERIVED HØM.DEDAMT(19)
TX TOMORROW FUND/COLL SAVINGS PLAN DERIVED HØM.DEDAMT(59)
RETIREMENT (JR1) DERIVED HØM.DEDAMT(08)
RETIREMENT FEE (TAXABLE) DERIVED HØM.DEDAMT(04)
TEXAS PROTECTS DERIVED HØM.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 HØH.NET – HØM.DEDAMT(70)
Displays the total of all the monies paid via a warrant for the requested date range.
DIRECT DEPOSIT SAVINGS DERIVED HØM.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 HØM.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 HØH.NET
Displays the total for all monies paid for the requested date range.
STATE PAID INSURANCE DERIVED HØM.DEDAMT(27)
Displays the total of the state-paid insurance contributions for the requested date range.
STATE PAID PAYROLL HEALTH INS CONTRIBUTION DERIVED HØM.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 HØM.DEDAMT(43)
Displays the total of state-paid health savings account deduction for the requested date range.
STATE PAID RETIREMENT DERIVED HØM.DEDAMT(25 and 29)
Displays the total of the state-paid retirement contributions for the requested date range.
STATE PAYROLL RETIREMENT CONTRIBUTION DERIVED HØM.DEDAMT (22)
Displays the total of the agency paid retirement contributions for the requested date range.
STATE PAID RETIREMENT FEE DERIVED HØM.DEDAMT(24)
Displays the total of the state-paid retirement fees for the requested date range.
STATE PAID OASDI DERIVED HØH.OASDICOTAX
Displays the total of the state-paid OASDI tax for the requested date range.
STATE PAID MED DERIVED HØH.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                                                    
Glenn Hegar
Texas Comptroller of Public Accounts
Questions? Contact statewide.accounting@cpa.texas.gov
Comptroller.Texas.Gov | FMX
FMX Sitemap | Contact FM
Accessibility Policy | Privacy and Security Policy