Skip to content

USPS Reports Guide
USPS Reports by Number

Report 1002 Deleted Pending Transactions

This report displays transactions that have been deleted from the pending file using HPKDL. A list of current pending transactions can be seen on H1KLS for all transactions, H1KU1 for each employee, or Report 1017.

Avoid deleting transactions that start with 4, 5, or 6 because these transactions have already updated the employee's accumulators (H0A, H0B, H0Z, H10). If these transactions are deleted, earnings history (H0H, H0M, HNY, HNZ) will not get updated, nor will the accumulators be returned to the prior value. Thus, the employee's record will be out of balance. If a delete is needed, you must send a Letter of Authorization (LOA) to your USPS representative at the Comptroller's office to return the accumulators back to the previous value, or in some cases, a reverse action can be entered by the agency and then it can be deleted from the pending file the next night. This action must not be completed on a night with a final payroll.

Report Criteria

Category Payroll Administration
Distribution Agency
Frequency Nightly
Form  
Sort Sequence Input Order
Page Break  
Parameters  
Databases Used H0C, H0I, H1K, HSB, HSC
Selection Criteria All transactions on HPKDL.
Produce Output? Yes
Request Screen Not requestable by the agencies. Automatically runs each night.
Posting Report? No
Additional Notes Processes in PAY010.

Report Headings

ACTION DERIVED
Displays the action taken.
ENTRY DATE H1K.ENTRYDT
Displays the date the transaction was put on the pending file.
SEQ NUMBER H1K.SEQNO
Displays the sequence number assigned the transaction when it was originally entered. This number will aid in tracking a transaction if there is an error.
COMPANY NUMBER H1K.CMPNUM
Displays the agency's number.
EMPLOYEE NUMBER H1K.EMPLOYEENO
Displays the employee's SSN.
TRAN CODE H1K.TRANCODE
Displays the code defining the type of transaction. Common codes:
BFMPending file deletion
###Payroll transaction:
225Generated deduction changes
280Generated special pay changes
4##–6##Manual payset/adjustment
700Payment request on HUA
8##Deduction transaction on HUD. ## indicates the deduction number.
9##Special payment request on HUE. ## indicates the special pay number.
COLUMN FIELDS 20–80 H1K.TRANREST
Displays the transaction data fields as they were entered.
COMPANY NUMBER H1K.CMPNUM
Displays the agency's number.
DELETED TRANSACTIONS DERIVED
Displays the total number of transactions that have been deleted.

Sample Report

    REPORT:  1002                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1    
    AGENCY:   XXX                                  XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX                              RUN DATE: XX/XX/20XX
                                                     DELETED PENDING TRANSACTIONS                                RUN TIME: 20:17:14 
                                                                                                                                    
           ENTRY    SEQ    COMPANY     EMPLOYEE   TRAN    2         3         4         5         6         7         8             
 ACTION     DATE   NUMBER  NUMBER       NUMBER    CODE    0123456789012345678901234567890123456789012345678901234567890             
                                                                                                                                    
                                                                                                                                    
 INPUT    09/01/20XX    123    XXX                BFM     09012004    138    141                                                    
          09/01/20XX    123    XXX    XXXXXXXXX   824                 0901200409302004         300     00000000000000               
          

      COMPANY                              RELEASED                                                                                 
       NUMBER                            TRANSACTIONS                                                                               
          XXX                                      01