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:
BFM Pending file deletion ### 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. - 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