Skip to content

USPS Reports Guide
USPS Reports by Number

Report 669 USPS Daily Warrant Held Register

This report displays warrant information for warrants that were on hold in TINS when issued out of USPS. It is produced daily for the Fiscal Management Division of the Comptroller's office only. If no warrants are produced with holds No Hold Warrants Generated During This Payroll Process will display.

Report 536 is the historical version of this report, which can be run for a requested time frame.

Report Criteria

Category Payroll Administration
Distribution Comptroller of Public Accounts – Fiscal Management Division
Frequency Nightly
Form  
Sort Sequence Agency, Warrant Number
Page Break  
Parameters HNKU1 – QTD START DATE, QTD END DATE
Databases Used HID, HNK, H0H
Selection Criteria All warrants paid during the processing night with a warrant hold (8th position of H0H.APLHACONS4 blank).
Produce Output? Yes
Request Screen Not requestable by agencies. Automatically run each night.
Posting Report? No
Additional Notes  

Report Headings

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. Field will not display if no holds are found.
WARRANT AMOUNT DERIVED
Displays the total dollar amount of the held warrants. Field will not display if no holds are found.

Sample Report

    REPORT:   669                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                           PAGE:     1    
    AGENCY:                                                                                                    RUN DATE: XX/XX/20XX
                                                   USPS DAILY WARRANT HELD REGISTER                            RUN TIME: 23:05:10 
                                                                                                                                    
  AGENCY           WARRANT             WARRANT            ISSUE                                      EMPLOYEE                       
  NUMBER           NUMBER              AMOUNT             DATE                   PIN/MC              NAME                           
                                                                                                                                    
  XXX             471884124           $4,039.86           10/01/20XX             2XXXXXXXXX3 PR1     XXXX X. XXXXXXX                
  XXX             671835365           $1,459.18           10/01/20XX             2XXXXXXXXX8 PR1     XXXXXXX X. XXXXXXXXX           
    WARRANT COUNT         2     WARRANT AMOUNT $           5,499.04