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: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. 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