Skip to content

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