USPS Reports Guide –
USPS Reports by Number –
Report 024 Statement of Earnings
This report produces the employee's statement of earnings. It includes both current and year-to-date totals for gross pay, net pay, certain special pays, deductions and adjustments to net pay.
This report MUST be set up on HPRPT, H0XCR and HPDES for payroll processing.
Report Criteria
Category | Payroll Administration | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Distribution | Agency | ||||||||||||||||||||||||||||||||||||||||
Frequency | Runs with final payrolls. | ||||||||||||||||||||||||||||||||||||||||
Form | 333 | ||||||||||||||||||||||||||||||||||||||||
Sort Sequence |
Notes: To display sub-deduction except buybacks (050) and savings bond detail, a 1 must be in the 4th position of the H0XCR Break field. This option could result in two-page earnings statements. See Report 666, after each payroll, for a list of employees this pertains to. |
||||||||||||||||||||||||||||||||||||||||
Page Break | Employee Number | ||||||||||||||||||||||||||||||||||||||||
Parameters | |||||||||||||||||||||||||||||||||||||||||
Databases Used | H0H, H0B, H0C, HNP, HID, HMP, H7O, H10, HNJ, HO0, H0N, HNH, H0V, H0W, H0Z, H0M, HNO | ||||||||||||||||||||||||||||||||||||||||
Selection Criteria | All employees who received a warrant or direct deposit on the current final payroll being run. | ||||||||||||||||||||||||||||||||||||||||
Produce Output? | Yes | ||||||||||||||||||||||||||||||||||||||||
Request Screen | HPRPT – Set up to run automatically with each final payroll. | ||||||||||||||||||||||||||||||||||||||||
Posting Report? | No |
Report Headings
- PAYROLL PERIOD H0H.PERIODEND, H0H.BEGINDATE
- Displays the dates the payroll period covers.
- PAYMENT NUMBER H0H.CHECKNO
- Displays the warrant or direct deposit number. Warrant numbers start with the number 17 and are nine-digit numbers. Direct deposits are identified by seven-digit numbers.
- PAYMENT DATE H0H.CHKDATE
- Displays the date the funds will be made available to the employee.
- ORGANIZATION CODE HNP.ORGCODE
- Displays the organization code as defined by the employee's primary position.
Note: The organization code will be the most recent organization code for the position being paid and not necessarily the organization code valid for the pay period. For an employee paid in multiple jobs, the primary position and organization code will be indicated based on the payroll transaction dates.
- PAYROLL DOC NO H0H.ALPHACONS1
- Displays the USAS document number assigned to the payroll.
- LOC/EXT LOC HNP.PLANTLOC/HNP.EXLOCCD
- Displays the agency defined code used to identify the agency's physical location and extended location, if applicable.
- EMPLOYEE'S NAME HID.FIRSTNAME, HID.MIDDLENAME, HID.LASTNAME
- Displays the employee's name. (Only the initial of the middle name is intended.)
- EMPLOYEE'S SOCIAL SECURITY NUMBER H0B.EMPLOYEENO
- Displays the last four digits of the employee's SSN.
- EMPLOYEE'S ADDRESS HIDU1
- Displays the employee's address.
- SINGLE/MARRIED/HEAD OF HOUSEHOLD H0B.MSTATUS
- Displays the employee's filing status for federal income tax (FIT) purposes.
- NO. EXEMPTIONS H0B.FITNOEXEMP
- Displays the employee's number of personal exemptions for FIT calculation purposes.
- ADDITIONAL AMOUNT H0B.FITEXTAMT
- Displays additional FIT deducted from the employee's pay, if applicable. This field does not display if extra FIT is not requested.
- STATE SVC H0B.ADJEMPLDAT (PROJECTED)
- Displays the employee's total state service in years, months and days as of the end of the pay period. This is the current employment plus prior state service minus leave without pay.
Note: For employees in agency 241, this field will not display.
- HAZDTY SVC H0B.SCAN, DATE01 (PROJECTED)
- Displays the employee's total hazardous duty service in years, months and days as of the end of the pay period. Hazardous duty service will only display when the hazardous duty indicator at the end of the pay period is a Y or 8. When displayed, this is the current hazardous duty date plus prior hazardous duty service minus leave without pay.
- ORG TITLE HNO.ORGNAME
- Displays the organization title as defined by the organization code.
Note: The organization title will be the most recent organization title and not necessarily the organization title valid for the period.
- PAY TBL HNH.SALTBLTYP
- Displays the employee's pay table.
1A Classified Table A 1B Classified Table B 1C Classified Table C 02 Unclassified 03 Exempt - PAY GROUP HNH.POSPAYGRP
- Displays the employee's pay group.
- STEP HNH.ACTUALSTEP
- Displays the employee's pay step, if applicable.
- POS NO H0H.POSITION
- Displays the employee's primary position number.
- CLASS NO HNH.JOBCLASS
- Displays the employee's job classification code.
- SALARY CHANGE DERIVED FROM HNH.HRISREASCD AND H1TZZ (TABLE 874)
- Displays employee's last salary action, if it occurred during the current pay period.
- TITLE H70.JCTITLE
- Displays the title for the employee's primary position assignment.
- EFFECTIVE DATE HNH.HLSTINCRDT
- Displays the date of the employee's last salary change. This field does not display if HNH.HLSTINCRDT is blank.
- EARNINGS/CURRENT/YR-TO-DT/DEDUCT/CURRENT/YR-TO-DT DERIVED FROM H0H, H0B, H0Z, H10
- Display both the employee's current and year-to-date totals for all taxes, taxables, deductions, special pays, regular wages, gross pay and net pay for the current calendar year.
Note: MISC Deduct is the total of an employee's deductions after the first 23, not including taxes. This field only exists when the H0XCR Break option to print sub-deduction and savings bond detail is not required. Wages transferred in from another state agency are included in the year-to-date totals.
- HRS H0H.REGULARHRS, H0H.OT1HRS, H0M.SPECHRS
- Displays the hours the employee was paid in the current pay period.
- EARNINGS DISBURSEMENT: WARRANT, CHECKING, SAVINGS DERIVED
- Displays the employee earnings disbursement to warrant, checking and/or savings accounts. Year-to-date amounts only display for savings disbursements.
Note: If an employee receives multiple statements of earnings during a single pay cycle, the year-to-date totals will be carried forward to all statements of earnings.
Sample Report
AGENCY XXX AGENCY NAME REPORT: 24 *** STATEMENT OF EARNINGS *** PAYROLL PERIOD 08/01/20XX TO 08/31/20XX PAYMENT NUMBER: 0000XXXXXXX PAYMENT DATE: 09/01/20XX XXX XXX XXX XX PAYROLL DOC NO: 89084XXX 00001 XXXXXXXX XXXXXXXXXXXX XXX-XX-XXXX ADDRESS LINE 101 SINGLE NO. EXEMPTIONS: 1 AUSTIN TX XXXXX STATE SVC: 1 YR 7 MO 0 DY HZDTY SVC: 0 YR 2 MO 0 DY ORG TITLE: ORG NAME PAY TBL: 1B PAY GROUP: 06 STEP: POS NO: 01234567 CLASS NO: 7464 TITLE: ACCOUNTANT I EARNINGS HRS CURRENT YR-TO-DT DEDUCT CURRENT YR-TO-DT REGULAR PAY 168:00 2567.16 27886.45 FED W/H TAX 357.42 3387.48 1XMERIT 0.00 400.00 OASDI TAX 222.38 1912.15 LEGBONUS 0.00 1600.00 MEDICARE TAX 52.01 447.20 BRP 1026.86 1026.86 DENTFLEX 7.22 72.20 SALARY GROSS 3594.02 30913.31 ERS RET 215.64 1281.77 - PREM CONV 7.22 72.20 LECOS 17.97 17.97 SOC SEC GROSS 3586.80 30841.11 401K 0.00 25.16 MEDICARE GROSS 3586.80 30841.11 - RETIREMENT 233.61 1299.74 - 401K AMT 0.00 25.16 TOT DEDUCTS 872.64 7143.93 FED W/H GROSS 3353.19 29516.21 EARNINGS DISBURSEMENT: TOTAL GROSS 3594.02 30913.31 CHECKING 2721.38 TOTAL DEDUCTS- 872.64 7143.93 TOTAL NET PAY 2721.38 23769.38