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 |
|
||||
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