Skip to content

USPS Reports Guide
USPS Reports by Number

Report 536 USPS Warrant Held Register – Standalone

This report displays warrant information for warrants that were on hold in TINS when issued out of USPS. Only the Fiscal Management Division of the Comptroller's office can request this report.

Report 669 is the daily version of this report.

Report Criteria

Category Payroll Administration
Distribution Comptroller of Public Accounts – Fiscal Management Division
Frequency Required when a warrant is being held.
Form  
Sort Sequence Agency, Warrant Number
Page Break  
Parameters HNKPA – QTD START DATE, QTD END DATE
Databases Used HID, HNK, H0H
Selection Criteria All warrants paid between the QTD START DATE and QTD END DATE with a warrant hold (Eighth position of H0H.APLHACONS4 <> blank).
Produce Output? Yes
Request Screen HNKPA; Not requestable by the agencies.
Posting Report?  
Additional Notes  

Report Headings

FROM/TO HNK.QTDSTDT/QTDEDT
Displays the warrant date range for the reporting period.
AGENCY NUMBER H0H.CMPNUM
Displays the number of the agency with the warrant hold.
WARRANT NUMBER H0H.CHECKNO
Displays the payment number of the held warrant. A blank indicates that the entry is a reversal of a held warrant.
WARRANT AMOUNT H0H.NET
Displays the amount of the held warrant. Negative numbers are not indicated with the negative symbol, however the Warrant Amount field takes the negative into account.
ISSUE DATE H0H.CHKDATE
Displays the date of the held warrant.
PIN DERIVED FROM H0H.EMPLOYEENO
Displays the employee's vendor identification number. It is made up of a proceeding 2, the employee's SSN, and a check digit.
MC H0H.ALPHACONS3(POSITIONS 6TH-8TH)
Displays the 3-digit code used to provide additional information regarding the payment.

For Example:
PR1USPS Payment
PR3Deceased Payment
EMPLOYEE NAME HID.RPTNAME
Displays the name of the employee with the held warrant.
WARRANT COUNT DERIVED
Displays the total number of held warrants.
WARRANT AMOUNT DERIVED
Displays the total dollar amount of the held warrants.

Sample Report

 REPORT:   536                         UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                           PAGE:    1             
 AGENCY:   XXX                                XXXX XXXXX XXXXXXXXXXX XXXXX                               RUN DATE: XX/XX/20XX        
                                          USPS WARRANT HELD REGISTER - STANDALONE                        RUN TIME: 2:00:00         
                                               FROM 09/01/20XX TO 08/31/20XX                                                       
                                                                                                                                   
AGENCY                     WARRANT                   WARRANT                 ISSUE                                      EMPLOYEE   
NUMBER                     NUMBER                    AMOUNT                  DATE              PIN/MC                     NAME     
                                                                                                                                   
998                        XXXXXXXXX                 $5,384.71             09/01/20XX       XXXXXXXXXXX  PR1           XXXXXXX,XXX 
                                                                                                                                   
                    WARRANT COUNT         1       WARRANT AMOUNT $          5,384.71