USPS Reports Guide –
USPS Reports by Number –
Report 1004 Transaction Balance Report
This report displays transactions that were processed through the overnight payroll process. These can include transactions entered on payroll batches, transactions from the pending file, and HSCU1 transactions.
Multiple Report 1004s can generate on any given night. A report will generate for each agency generated batch and for each system generated batch.
Report Criteria
| Category | Payroll Administration |
|---|---|
| Distribution | Agency |
| Frequency | Runs with payroll. |
| Form | |
| Sort Sequence | Batch Number, Employee Number, Sequence Number |
| Page Break | |
| Parameters | |
| Databases Used | H0C, H0I, HSC, HUA, HUD, HUE, HUX, HUZ, T10 |
| Selection Criteria | All transactions that were processed on the payroll through a batch. |
| Produce Output? | Yes |
| Request Screen | Not requestable by the agencies. Automatically runs each night. |
| Posting Report? | No |
| Additional Notes | Processes in PAY020. |
Report Headings
- BATCH NO
- Displays the batch number assigned by the agency or the system during the processing. Batch 0 is system generated and usually made up of pending transactions, cancellations, and manual paysets.
- TRANSACTION BALANCE REPORT AS OF H0I.CURPROCDT
- Displays the current processing date.
- SEQ NO
- Displays the sequence number assigned the transaction.
- EMPLOYEE NUMBER
- Displays the employee's SSN.
- TRAN CODE
- Displays the code defining the type of transaction. Common codes:
CTL Payroll request on HSCU1 IBC Batch control information (see HRSUB) ### Payroll transaction: 225 Generated deduction changes 280 Generated special pay changes 4##–6## Manual payset/adjustment 700 Payment request on HUA 8## Deduction transaction on HUD. ## indicates the deduction number. 9## Special payment request on HUE. ## indicates the special pay number. - REG HRS/SPC–HRS
- Displays the number of regular or special pay hours the employee is being paid or docked.
- REG R/A/SPC R/A
- Displays the regular or special pay hourly rate or the actual amount being paid or docked.
- OT HRS
- Displays the number of overtime hours the employee is being paid or docked.
- OT R/A
- Displays the overtime-hourly rate or the actual amount being paid or docked. A rate will print with five decimal positions, and an amount will have two decimal positions.
- WORK
- Not used.
- O–T
- Displays the indicator to determine if the entry is for regular, overtime, or compensatory time.
- T/P
- Displays the indicator to determine how to tax the entry. Applicable for special pays only.
- ADJ IND
- Displays the indicator to determine how this transaction should affect other transactions for this employee. For example, should the transaction be added or subtracted from the employee's other pay transactions?
- SHF
- Displays the shift code associated with the payment.
- CHK
- Displays the indicator to determine how this transaction should affect other transactions for this employee. For example, should this transaction be paid on the same check or a separate one from the employee's other pay?
- AMT A/P
- Displays the overtime-hourly rate or the actual amount being paid or docked. A rate will print with five decimal positions, and an amount will have two decimal positions.
- DED IND
- Displays the indicator to determine which deductions should be taken from this transaction.
- ST CDE
- Displays the state code used for this transaction.
- LOC CDE
- Displays the local code used for this transaction.
- DEP NO
- Displays the department number used for this transaction.
- SEC NO
- Displays the section number used for this transaction.
- FROM DATE
- Displays the transaction's begin date.
- TO DATE
- Displays the transaction's end date.
- LABOR DISTRIBUTION
- Displays the labor code (first 6 positions) and position number (last 8 positions) used for this transaction.
- TRANSACTION BATCH STATISTICS
- This batch is out of balance will display if the batch was not balanced on HRSUB or USPS modified the batch internally during initial processing. An out of balance condition does not cause a problem in processing. Balancing is a way that a batch can be verified for data entry errors.
Displays the total number of employees not paid, the number of transactions in the batch and the totals for regular and overtime hours and pay rate/pay amounts for the batch.
IBC Control Totals are taken from HRSUB, while Transaction Totals and Difference are calculated by the system.
Sample Report
REPORT: 1004 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 2
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
BATCH NO: 6 TRANSACTION BALANCE REPORT AS OF 09/23/20XX RUN TIME: 20:22:14
SEQ. EMPLOYEE TRAN REG HRS REG R/A OT HRS OT R/A O-T ADJ SHF AMT DED ST LOC DEP SEC FROM TO LABOR
NO. NUMBER CODE SPC-HRS SPC R/A WORK T/P IND CHK A/P IND CDE CDE NO NO DATE DATE DISTRIBUTION
7574 IBC 6 696.00 .00 113.45000 .00000 90 90
7580 XXXXXXXX X 700 176.00 10.29545 .00 0 0 XX/XX/20XX XX/XX/20XX P240031361153
7577 XXXXXXXX X 700 176.00 25.50755 .00 0 0 XX/XX/20XX XX/XX/20XX P016305421184
7578 XXXXXXXX X 700 113.45 .00 0 1 7 08/16/20XX 08/31/20XX P016305421184
7576 XXXXXXXX X 700 176.00 19.59846 .00 0 0 XX/XX/20XX XX/XX/20XX P016285232181
7579 XXXXXXXX X 700 56.00 12.84659 .00 0 0 09/22/20XX 09/30/20XX P211087323100
7575 XXXXXXXX X 700 112.00 17.23482 .00 0 0 XX/XX/20XX XX/XX/20XX P016285212105
TRANSACTION BATCH STATISTICS
THIS BATCH IS OUT OF BALANCE.
NO. OF EMPLOYEES NOT TO BE PAID 0
NO. OF TRANSACTIONS IN THIS BATCH 7
REGULAR OVERTIME REGULAR OVERTIME
HOURS HOURS RATE/PAY RATE/PAY
IBC CONTROL TOTALS 696.00 0.00 113.45000 0.00000
TRANSACTION TOTALS 696.00 0.00 198.93287 0.00000
DIFFERENCE 0.00 0.00 85.48287- 0.00000