USPS Reports Guide –
USPS Reports by Number –
Report 971 Cancellation Activity Report
This report displays cancellation activity on a monthly and quarterly basis. Cancellations are separated between direct deposits and warrants with agency totals for each.
Report Criteria
Category | Payroll Administration |
---|---|
Distribution | Agency, Comptroller of Public Accounts – Fiscal Management Division |
Frequency | Monthly – Approximately the third working day of the month. |
Form | |
Sort Sequence | Payment Number |
Page Break | |
Parameters | |
Databases Used | H0C, H0H, H0I, H0O, H10, H1T, HID, HNK |
Selection Criteria | All cancellations where the approval date (USAS effective date) is within the current month. |
Produce Output? | Yes |
Request Screen | Not requestable by the agencies. Requested by USPS Personnel each month. |
Posting Report? | No |
Additional Notes |
Report Headings
- FROM/TO HNK.QTDSTDT/HNK.QTDEDT
- Displays the pay period date range for the month.
- PAYMENT NUMBER H0H.CHECKNO
- Displays the canceled warrant or direct deposit advise number. Direct deposits will display all zeros.
- PAYMENT AMOUNT DERIVED FROM H0H
- Displays the amount of the canceled warrant or direct deposit. Direct deposits that were sent entirely to a savings account (deduction 69) will display .00.
- CAN DOC NUMBER H0H.ALPHACONS
- Displays the Cancellation Document Number as appears on the report.
- ORIG DOC NUMBER H0H.ALPHACONS1
- Displays the USAS document number assigned to the payroll where the warrant or direct deposit was issued originally.
- TREASURY CANCELLED DATE H0H.COMPFIELD1
- Displays the date when Treasury approved the cancellation.
- REASON CODE H0H.REASREVISS
- Displays the reason code for the cancellation.
- PAYEE NAME HID.FIRSTNAME, HID.LASTNAME
- Displays the name of the person who was assigned the warrant or direct deposit that was canceled.
- EMPLOYEE SSN DERIVED FROM H0H.EMPLOYEENO
- Displays the employee's Social Security number.
- AGY TOTAL DERIVED
- Displays the cancellation payment totals, for both direct deposits and the warrants.
Warrants canceled and direct deposits canceled will only appear if those type cancellations occurred during the report period. (If there are no cancellations during the report period, the report is not created.)
Sample Report
REPORT: 971 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1 AGENCY: XXX XXXXX XXXXXXXX XXXXXXXXXX RUN DATE: XX/XX/20XX CANCELLATION ACTIVITY REPORT RUN TIME: 01:13:04 03/01/20XX - 03/31/20XX PAYMENT PAYMENT CAN DOC ORIG DOC TREASURY REASON NUMBER AMOUNT NUMBER NUMBER CANCEL DATE CODE PAYEE NAME EMPLOYEE SSN WARRANTS CANCELLED 172999351 1,424.32 86026FS5 86014FR1 03/09/20XX 39 XXXXXXXXX XXXXXXX XXX-XX-XXXX 172998055 786.25 86026FS3 86024FR1 03/02/20XX 310 XXXX XXXXX XXX-XX-XXXX 172998072 2,466.67 86026FS5 86024FR1 03/09/20XX 309 XXXXXXXXX XXXXXXXX XXX-XX-XXXX 172998122 1,188.75 86026FS3 86024FR1 03/02/20XX 310 XXXXXXX XXXXXXXXXXXX XXX-XX-XXXX AGY TOTAL 5,865.99 DIRECT DEPOSITS CANCELLED 006880666 1,590.93 86034FS1 86034FR1 03/28/20XX 302 XXXXXX XXXXX XXX-XX-XXXX 006880638 610.25 86026FS6 86034FR1 03/27/20XX 309 XXXXX XXXXXXXXXXXXXXX XXX-XX-XXXX 006880942 704.17 86034FS1 86034FR1 03/28/20XX 302 XXXXXXXX XXXXXXXXXXXX XXX-XX-XXXX AGY TOTAL 2,905.35