USPS Reports Guide –
USPS Reports by Number –
Report 970 Treasury Cancellations
This report displays all cancellations processed during the nightly batch cycles.
Report Criteria
| Category | Payroll Administration |
|---|---|
| Distribution | Agency |
| Frequency | Nightly |
| Form | |
| Sort Sequence | Payment Number |
| Page Break | |
| Parameters | |
| Databases Used | H0C, HID, HPC |
| Selection Criteria | All requests entered on HPCAN. |
| Produce Output? | Yes |
| Request Screen | Not requestable by the agencies. Automatically runs each night. |
| Posting Report? | Yes – Builds cancellation transactions and deletes the HPC transactions. |
| Additional Notes | Requires a final payroll in order to write to history; if a final payroll is not processed, this transaction is stored on the pending file (H1KLS). |
Report Headings
- STATUS
- Displays the current status of the cancellation.
Blank Warrant cancellation not yet sent to Treasury, unprocessed direct deposit or callback cancellation, and unprocessed reissues of warrants or direct deposit. S Request for warrant cancellation approval sent to Treasury. O Request for warrant cancellation will bypass treasury approval process. D Request for warrant cancellation approval has been denied by Treasury. Agency must delete transaction or contact Fiscal Management to override if cancellation is valid. X The cancellation requested on HPCAN will not be sent to Treasury and has been deleted from HPCAN because the payment was not canceled prior to the direct deposit deadline. - PAYMENT NBR HPC.PAYMENTNO
- Displays the warrant or direct deposit number being canceled.
- EMPLOYEE NUMBER HPC.EMPLOYEENO
- Displays the employee's SSN.
- EMPLOYEE NAME – LAST, FIRST, MI HID.LASTNAME, HID.FIRSTNAME, HID.MIDDLENAME
- Displays the employee's name.
- PAYMENT DATE HPC.PAYDATE
- Displays the date the warrant or direct deposit was payable.
- PERIOD END DATE HPC.PENDDATE
- Displays the pay period ending date of the payment being canceled.
- YQ HPC.YTDQTDFLAG
- Displays the employee's accumulators to be adjusted by the cancellation.
Y Year-to-date only Q Quarter-to-date and Year-to-date only C Year-to-date and Prior Quarter-to-date only P Prior Quarter-to-date only - MC HPC.METHCODE
- Displays the method code 0 which indicates reverse only.
- RS CD HPC.REASCODE
- Displays the reason code for the reversal.
- TYPE
- Displays the type of reversal.
Reverse Only Reverse the payment Reverse/Reissue Reverse and issue a new payment Reissue Reissue a previously reversed payment - EXCPT DESC DERIVED
- Displays the exception description DENIED which means the cancellation request was not approved.
Note: A warning message will appear on this report for any employee who has an active HODAJ entry and is having a payment canceled.
Sample Report
REPORT: 970 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXX XXXXXXXXXX XX XXXXXX XXXXXX RUN DATE: XX/XX/20XX
CANCELLATIONS AND REISSUE REPORT RUN TIME: 19:23:43
PAYMENT EMPLOYEE PAYMENT PERIOD Y M RS EXCPT
STATUS NUMBER NUMBER NAME DATE END DATE Q C CD TYPE DESC
WARNING MESSAGE
S 555555555 XXX-XX-XXXX XXXXXXXX, XXXXXXX 02/01/20XX 01/31/20XX 0 310 REVERSE ONLY
S 666666666 XXX-XX-XXXX XXXXXX, XXXXXXXXX 02/01/20XX 01/31/20XX 0 310 REVERSE ONLY
S 888888888 XXX-XX-XXXX XXXXXXXX, XXXXXXX XXXX 02/01/20XX 12/31/20XX 0 306 REVERSE/REISSUE