USPS Reports Guide –
USPS Reports by Number –
Report 997 Payroll Voucher
This report displays information relating to the current payroll. This includes fund numbers, appropriation years, labor codes, object codes, and the corresponding dollar amounts for each. Totals are also provided for each.
This report MUST be set up on HPDES for payroll processing.
Report Criteria
| Category | Payroll Administration |
|---|---|
| Distribution | Agency, Comptroller of Public Accounts* (final payrolls only) |
| Frequency | Runs with each payroll. |
| Form | |
| Sort Sequence | Document Number, Fund Number, Appropriation Year, Labor Code, Object Code |
| Page Break | Document Number |
| Parameters | |
| Databases Used | H0H, H7O, HID, HNH, HN6, HO6, HSC |
| Selection Criteria | All records on the payroll. |
| Produce Output? | Yes |
| Request Screen | Not requestable by the agencies. Automatically runs with payrolls. |
| Posting Report? | Yes – Updates USAS (final payrolls only). |
| Additional Notes | ** EDIT/REPORT RUN ** will display in the top left corner of the report if the report was produced from a trial/edit payroll. This report will generate twice during final payroll. Use the latest RUN TIME/DATE, which is found in the top right corner of the report. * The Comptroller's office will not receive this report for agencies that do not require electronic approval. (Electronic APP RQD field on H0CCF displays 0.) |
Report Headings
- PAY PERIOD/TO, PAYMENT DATE HSC.CTLBEGDT/HSC.CTLENDDT, HSC.CTLCHKDT
- Displays the pay period dates and the warrant date of the current payroll.
- RUN TYPE HN6.RUNTYPE
- Displays the two-character code for the type of payroll being generated.
- DOCUMENT NUMBER HN6.DOCNO
- Displays the USAS document number assigned to the payroll.
- DOCUMENT TYPE DERIVED
- Displays the value derived from the Run Type.
ER Edit Regular ES Edit Supplemental EC Edit Constitutional Per Diem EA Edit Automatic Supplemental EN Edit New Hire Supplemental TR Trial Regular TS Trial Supplemental TC Trial Constitutional Per Diem TA Trial Automatic Supplemental TN Trial New Hire Supplemental FR Final Regular FS Final Supplemental FC Final Constitutional Per Diem FA Final Automatic Supplemental FN Final New Hire Supplemental - USAS EFFECTIVE DATE HN6.EFFDT
- Displays the USAS effective date for the payroll.
- FUND NUMBER DERIVED FROM USAS
- Displays the USAS fund number from which the payment is being posted.
- APPROP YEAR DERIVED FROM USAS
- Displays the USAS appropriation year from which the payment is being posted.
- USAS PCA/INDEX DERIVED
- Displays the total USAS labor code from which the payment is being posted.
- APPROPRIATION NUMBER DERIVED FROM USAS
- Displays the total USAS appropriation number from which the payment is being posted.
- AGENCY PCA/INDEX DERIVED
- Displays the labor code from which the payment is being posted.
- COMPTROLLER OBJECT CODE DERIVED
- Displays the USAS expenditure code assigned to each type of pay the employee receives.
- AGENCY OBJECT CODE DERIVED FROM USAS
- Displays the USAS expenditure code established by the agency that is assigned to each type of pay the employee receives. This is used only by agencies with agency object codes.
- AMOUNT DERIVED
- Displays the total gross amount for each fund labor code, object code, and document.
Sample Report
REPORT: 997 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
PAYROLL VOUCHER RUN TIME: 21:13:54
PAY PERIOD 09/01/20XX TO 09/30/20XX, PAYMENT DATE 10/01/20XX
RUN TYPE: FR DOCUMENT NUMBER: 84094FR1 DOCUMENT TYPE: FINAL REGULAR USAS EFFECTIVE DATE: 09/20/20XX
FUND APPROP USAS APPROPRIATION AGENCY COMPTROLLER AGENCY
NUMBER YEAR PCA/INDEX NUMBER PCA/INDEX OBJECT CODE OBJECT CODE AMOUNT
0001 04 P99327 99327 7041 415.02
PCA/INDEX TOTAL: 415.02
0001 FUND TOTAL: 415.02
0001 05 P00010 13001 7002 976,092.93
7003 7,482.60
7022 13,260.00
7050 3,509.80
PCA/INDEX TOTAL: 1,000,345.33
P18610 91142 7043 73,180.13
PCA/INDEX TOTAL: 73,180.13
P90327 90327 7032 55,168.91
PCA/INDEX TOTAL: 55,168.91
P99327 99327 7041 77,321.87
PCA/INDEX TOTAL: 77,321.87
0001 FUND TOTAL: 1,206,016.24
OBJECT TOTALS 7002 976,092.93
7003 7,482.60
7022 13,260.00
7032 55,168.91
7041 77,736.89
7043 73,180.13
7050 3,509.80
04 APPROPRIATION TOTALS: 99327 415.02
05 13001 1,000,345.33
90327 55,168.91
91142 73,180.13
99327 77,321.87
DOCUMENT TOTAL: 1,206,431.26
** ELECTRONIC APPROVAL **