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:PR1 USPS Payment PR3 Deceased 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