USPS Reports Guide –
USPS Reports by Number –
Report 3011 Employee Compensation Information
This report displays out of balance conditions or negative values found in an employee's master file. Not all errors listed are problems; however, each needs to be researched to determine what caused the report to generate.
Report Criteria
| Category | Payroll Administration |
|---|---|
| Distribution | Agency |
| Frequency | Monthly |
| Form | |
| Sort Sequence | Employee Number |
| Page Break | Employee Number |
| Parameters | |
| Databases Used | H0C, HID, H7M, H0A, H0B, H09, H0Z, H10 |
| Selection Criteria | All employees with current calendar year data, including those terminated and on-leave. |
| Produce Output? | Yes |
| Request Screen | Not requestable by the agencies. Requested by USPS Personnel. |
| Posting Report? | No |
| Additional Notes | Runs automatically and generates with month end reports. |
Report Headings
- EMPLOYEE NUMBER H0B.EMPLOYEENO
- Displays the employee's SSN.
- EMPLOYEE NAME HID.RPTNAME
- Displays the employee's name.
- DETAIL RECORDS
- Displays the page number and databases associated with each.
Page Database Screen 1 H0B H0BUN, H0BUS, and H0BUI H7M H7MLS 2 H0B H0BPA H10 H10SP H0Z H0ZUC 3 H0B H0BUT and H0BUD 4 H0A H0ATB, H0ATC, and H0ATX H09 H09U1 - ERROR REPORT
- Displays the problem found.
Sample Report
REPORT: 3011 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXX XXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
EMPLOYEE COMPENSATION INFORMATION RUN TIME: 08:42:34
EMPLOYEE NUMBER XXXXXXXX-X XXXXXX, XXXXXXX X
------------------PAY INFORMATION (H0B)----------------- ------------------ PAY INFORMATION (H7M)-------------------------------
SOCIAL PAY EMP OT OT T/C OVERTIME . SALARY RATE PAY ----OVERTIME 1---- ----OVERTIME 2---
SEC. NO. FREQ ST ST TYP ST THOLD1 THOLD2 . PAY PERIOD HOURLY TYPE RATE FACTOR RATE FACTOR
XXX-XX-XXX 90 01 3 3 0 0.00 0.00 . .00 6.91154 1 0.000 1.500 0.000 1.000
.
-STANDARD HOURS- SPEC-PAY-PRCNT . SHFT SHFT RT ----SHIFT 2---- ----SHIFT 3---- --LAST INCREASE--
POSITION STD-HRS PER DAY FIT SIT LOC . CODE LOC FAC RATE FACTOR RATE FACTOR RATE AMOUNT
03331 176.00 8.0 .000 .000 .000 . 1 0 0 0.000 .000 0.000 .000 .00000 0.00
----------------- PAY DISTRIBUTION INFORMATION (H0B)---------------------
.
ANNUALIZED REASON TERM -WEEKS WORKED- . EMPLOYEE -----CHECKING/SAVINGS/LOAN ACCOUNT NUMBERS----- MAIL
SALARY ABSENT CODE TOTAL LIMIT . BANK NUMBERS (1) (6) CHECK
14376.00 0 0 . (1) 000000000 (2) (7) 0
. (2) 000000000 (3) (8)
. (3) 000000000 (4) (9)
. (5)
.
.
.
--------------------------STATUS FLAGS (H0B)------------------- -----STATUS FLAGS (H7M)-----
DESCRIPTION VALUE DESCRIPTION VALUE DESCRIPTION VALUE
TRANSFER FLAG 0 NUMBER OF INTERIM W2S 0 TRAINEE STATUS
COMPANY WAGE PLAN S DIST CATEGORY 1 SALARY CHANGE REASON
NUMBER OF WORK DAYS 5 PENSION PLAN 0 WORKSHEET LIST SWITCH
START DAY OF WEEK 2
------------------------------------------------DATES (H0B)--------------------------------------- ---------DATES (H7M)----------
ADJUSTED EMPLOYMENT 11/15/20XX LAST STATUS CHANGE 05/15/20XX RETIREMENT XX/XX/20XX LAST SALARY ACTION XX/XX/20XX
START PAY DATE XX/XX/20XX LAST PAYMENT 08/10/20XX RETURN FROM LEAVE XX/XX/20XX TRANSFER DATE XX/XX/20XX
CONTINUOUS SERVICE 11/14/20XX ON LEAVE XX/XX/20XX TERMINATION XX/XX/20XX LAST PROMOTION 05/15/20XX
EMPLOYMENT 05/15/20XX PRENOTIFICATION XX/XX/20XX RETURN DUE DATE XX/XX/20XX
----------VACATION ACCRUAL INFORMATION (H0B)-----------------SICK LEAVE ACCRUAL INFORMATION (H0B)-------------INSURANCE INFO (H0B)--
USED BALANCE ACCRUED TABLE . USED BALANCE ACCRUED TABLE . INSURANCE
YTD TO DATE YTD METH FACTOR . YTD TO DATE YTD METH FACT . AMOUNT
HOURS .00 .00 .00 0 . HOURS .00 .00 0 . ..............
-------------------------------------------------MISCELLANEOUS INFORMATION (H0B)---------------ADDITIONAL PAY RATES (H0B)-----------
------PRIMARY LABOR DISTRIBUTION----- . --------DATES--------- . --TIME STAMP INFO.---.
LABOR CODE EXTENSION PERCENT . ACTION CREATE . DATE TIME . (1) 0.00000 (3) 0.00000
P06402 .999 . 09/07/20XX 07/24/20XX . 09040004 06:37:45 . (2) 0.00000 (4) 0.00000
. .
--------------------------------------------------USER-DEFINED INFORMATION (H0B)----------------------------------------------------
----FLAGS---- --------DATES--------- ----PERSONNEL CONSTANTS---- -----------------PAY CONSTANTS------------------
(A) W (E) (1) AGY SERV 11/15/20XX (1) (5) (1) .00 (5) .00 (9) .00
REPORT: 3011 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 2
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
EMPLOYEE COMPENSATION INFORMATION RUN TIME: 08:42:34
EMPLOYEE NUMBER XXXXXXXX-X XXXXXX, XXXXXXX X
----------------------------------------------------CUMULATIVE INFORMATION (H0B)----------------------------------------------------
NAME AMOUNT HOURS NAME AMOUNT HOURS
GROSS PAY YTD 6,690.37 NET PAY YTD 5,751.55
QTD 2,266.99 QTD 1,956.02
MTD .00 MTD .00
REGULAR YTD 6,690.37 968.00 OVERTIME 1 YTD .00 .00
QTD 2,266.99 QTD .00
MTD .00 .00 MTD .00 .00
OVERTIME 2 YTD .00 .00
MTD .00 .00
SHIFT 2 YTD .00 .00 SHIFT 3 YTD .00 .00
QTD .00 QTD .00
MTD .00 .00 MTD .00 .00
SICK PAY YTD .00 PENSION PAY YTD .00
QTD .00 QTD .00
MTD .00
VACATION YTD .00 BONUS PAY YTD .00
MTD .00 MTD .00
TOTAL DEDS. YTD 3.32-
QTD .00
MTD .00
-------------------------------------------------AUTOMATIC SPECIAL PAYS (H10)-------------------------------------------------------
CHECK TAX DED CHECK TAX DED
NO. NAME RATE AMOUNT HOURS IND IND IND FREQ NO. NAME RATE AMOUNT HOURS IND IND IND FREQ
6 LONGEVTY .00000 .00 .00 0 0 0 1
-------------------------------------------------SPECIAL PAY INFORMATION (H10)------------------------------------------------------
NO. NAME AMOUNT HOURS NO. NAME AMOUNT HOURS
NO RECORDS FOUND
----------------------------------------------EMPLOYEE DEDUCTION INFORMATION (H0Z)--------------------------------------------------
MTD YTD
NO. NAME FREQUENCY AMOUNT FACTOR START DATE END DATE GOAL DAYS GOAL AMOUNT UTILITY AMOUNT AMOUNT
5 ERS RET 9 .00 0000.060 09/01/20XX XX/XX/20XX 0 0.00 3122200 .00 3.32-
24 STRETFEE 1 3.00 0000.000 09/01/20XX XX/XX/20XX 0 3.00 0000100 .00 3.00
25 STRETIRE 9 .00 0000.060 09/01/20XX XX/XX/20XX 0 0.00 3000000 .00 3.32-
REPORT: 3011 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 3
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: 12/13/2019
EMPLOYEE COMPENSATION INFORMATION RUN TIME: 11:04:00
EMPLOYEE NUMBER XXXXXXXX-X XXXXXXX, XXXXX X
--------------------------------------------------------TAX INFORMATION (H0B)-------------------------------------------------------
FIL FIT STEP FIT DEP OTHER DEDUCT FIT-EXTRA FICA SUI SUI FUTA TAX COUNTRY --RESIDENT-- PQ WAGE
STAT ST 2 BOX EXEMP CREDIT INCOME AMOUNT AMOUNT ST ST STATE ST UNIT RES/WORK STATE/LOCAL CODE
1 9 0 0 0 0 0 4 1 44 1 1 USA 1 44 0 S
--AUTOMATIC TAXING INFO--.-----PENSION DISTRIBUTION INFORMATION------.
STATE LOCAL PCT . DISTRIB AMT LTD CONTRIBUTION .
(1) 44 TX 0 .999 . .00 .00 .
(2) 0 0 .000 . .
(3) 0 0 .000 . PLAN BEGIN PLAN END DISTRIB LUMP SUM .
(4) 0 0 .000 . DATE DATE PCT. IND .
(5) 0 0 .000 . 00/00/0000 00/00/0000 000.00 0 .
---------------------------------------------CUMULATIVE TAX INFORMATION (H0B)-------------------------------------------------------
NAME TAX TAXABLE NAME TAX TAXABLE NON-TAXABLE
FIT YTD 4,199.70 141,364.96 OASDI YTD 8,537.40 137,700.00
SIT YTD .00 .00 HI YTD 2,270.40 156,579.38
SUI YTD .00 .00 MED HI YTD .00 .00
LOCAL YTD .00 .00 CO OASDI YTD 8,537.40 137,700.00
SP LOCAL YTD .00 .00 CO HI YTD 2,270.40 156,579.38
DI YTD .00 .00 CO MED HI YTD .00 .00
CO. PAID DI YTD .00 UNC OASDI YTD .00
FUTA YTD .00 .00 UNC HI YTD .00
FIT PENSION YTD .00 .00 FIT PENSION QTD .00 .00
3RD PARTY OASDI YTD .00 .00 3RD PARTY FIT YTD .00
3RD PARTY HI YTD .00 .00 3RD PARTY SIT YTD .00
3RD PARTY MED HI YTD .00 .00 3RD PARTY NTXBL YTD .00
EIC PAYMENT YTD .00 STATE AEIC YTD .00
SUPPL WAGES YTD .00 SS HIRE CREDIT YTD .00
---------------------------------------------MISCELLANEOUS TAX ACCUMULATIONS (H0B)--------------------------------------------------
NAME AMOUNT NAME AMOUNT
TOTAL TIPS YTD .00 401(K) YTD 341.29
EMP TIPS OASDI YTD .00 CO TIPS OASDI YTD .00
EMP TIPS HI YTD .00 CO TIPS HI YTD .00
REPORT: 3011 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 4
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
EMPLOYEE COMPENSATION INFORMATION RUN TIME: 08:42:34
EMPLOYEE NUMBER XXXXXXXX-X XXXXXX, XXXXXXX X
--------------------TAX INFORMATION (H0A) FOR COUNTRY 1 ( ) TAX-UNIT 1 STATE 44 (TX ) LOCAL 0 ( )--------------------
MAR STATE --------STATE-------- ----STATE EXTRA--- --LOCAL--- LOCAL --------LOCAL-------- ---LOCAL EXTRA---
ST SIT DI EXM PERCENT AMOUNT AMOUNT PERCENT LOC SP/LOC NAME EXM PERCENT AMOUNT AMOUNT PERCENT
1 1 1 0 0.000 0 0 0.000 1 1 0.000 0 0 0.000
GROSS FIT FIT FIT SIT SIT OASDI OASDI HI HI SUI
AMOUNT NON-TAXABLE AMOUNT TAXABLE AMOUNT TAXABLE AMOUNT TAXABLE AMOUNT TAXABLE AMOUNT
Y 6690.37 3.32- 430.33 6693.69 .00 .00 414.80 6690.37 97.01 6690.37 .00
Q 2266.99 .00 137.55 2266.99 .00 .00 140.55 2266.99 32.87 2266.99 .00
M .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00
PQ 829.38 .00 35.02 829.38 .00 .00 51.42 829.38 12.03 829.38 .00
SUI SUI GROSS LOCAL LOCAL LOCAL-SP LOCAL-SP DI DI CO-PD-DI CO-FUTA FUTA
TAXABLE TAXABLE AMOUNT TAXABLE AMOUNT TAXABLE AMOUNT TAXABLE AMOUNT AMOUNT TAXABLE
Y .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00
Q .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00
M .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00
PQ .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00
CO-OASDI CO-OASDI CO-HI CO-HI MED HI MED HI CO-MED CO-MED UNC OASDI UNC HI TIPS
AMOUNT TAXABLE AMOUNT TAXABLE AMOUNT TAXABLE HI TAX HI TXBL AMOUNT AMOUNT AMOUNT
Y 414.80 6690.37 97.01 6690.37 .00 .00 .00 .00 .00 .00 .00
Q 140.55 2266.99 32.87 2266.99 .00 .00 .00 .00 .00
M .00 .00 .00 .00 .00 .00 .00 .00
PQ 51.42 829.38 12.03 829.38 .00 .00 .00 .00 .00
OASDI TIPS CO-OASDI EMP TIPS CO TIPS EIC 3RD PARTY 3RD PARTY 3RD PARTY 3RD PARTY 3RD PARTY 3RD PARTY
TAXABLE TIPS TXBL HI TXBL HI TXBL PAYMENT FIT AMT SIT AMT NON TXBL OASDI AMT OASDI TXBL HI AMT
Y .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00
Q .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00
M .00
PQ .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00
3RD PARTY 3RD PARTY 3RD PARTY WEEKS WEEKS WORKED
HI TXBL MED HI AMT MED HI TXBL WORKED UNDER LIMIT
Y .00 .00 .00 00.0 00.0
Q .00 .00 .00 00.0 00.0
M 00.0 00.0
PQ .00 .00 .00 04.3 00.0
------------------------------------------------------------ERROR REPORT------------------------------------------------------------
***************************** WARNING - H0A TABLE CONTAINS ONE OR MORE FIELDS WITH A NEGATIVE VALUE *****************************
------------------------------------------------------------------------------------------------------------------------------------
************************** WARNING - H0B TABLE CONTAINS ONE OR MORE FIELDS WITH A NEGATIVE VALUE ***************************
------------------------------------------------------------------------------------------------------------------------------------
INSPECTION OF H0B, H0Z AND H10 TABLES:
DED-YTD ( 3.32-)IS LESS THAN DED- MTD ( 0.00 )FOR DEDUCTION NUMBER 5