This report displays payment data for each employee for the current payroll. Adjustments within a document are sorted to the bottom of each fund. Totals are calculated by each organization code, labor code, and comp object code. Agency and document totals are also listed at the end of the report. History records are updated after each final payroll run. Builds the extract file used to build USAS records.
Report Criteria
Category |
Payroll Administration |
Distribution |
Agency |
Frequency |
Runs with payroll. |
Form |
113 |
Sort Sequence |
Options |
H0XCR Sort |
Document Number, Fund Number, Adjustments, Organization Code,
Position Number, Employee Number |
882 |
|
Page Break |
Options |
H0XCR Break |
None |
0000 |
Organization Code |
9999 |
First Level - Organization Code |
1000 |
First and Second - Level Organization Code |
1200 |
First, Second, and Third Level - Organization Code |
1230 |
|
Parameters |
|
Databases Used |
H0M, H0H, HID, H70, H0C, H0B, H0W, H0Z, H0N, HO0, HNO, HNH, H1T, HMP, HPS |
Selection Criteria |
All employees on the current payroll. |
Produce Output? |
Yes |
Request Screen |
HPRPT – Set up to run automatically with each payroll. |
Posting Report? |
No |
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 only when a final payroll is rejected. Use the latest RUN TIME/DATE, which is found in the top right corner of the report. |
Report Headings
- ORGANIZATION CODE H0H.ORGCODE
- Displays the employee's organization code if the organization code sort is being used.
- PAYROLL FOR WARRANT DATE OF H0H.CHKDATE
- Displays the warrant date of the current payroll.
- BATCH H0H.ALPHACONS5
- Displays the batch number assigned by the USAS interface.
- DOCUMENT NUMBER H0H.ALPHACONS1
- Displays the USAS document number assigned to the payroll.
- RUN TYPE H0H.ALPHAC0NS2
- Displays the type of payroll being processed:
ER | Edit Regular |
ES | Edit Supplemental |
EC | Edit Consitutional Per Deim |
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 |
- FUND/AY H0H.ALPHACONS2/H0H.ALPHACONS3
- Displays the USAS fund number and the appropriation year from which the payment is being posted.
- CHG HNH.HRISREASCD
- Displays an asterisk (*) and an HRIS reason code for employees who had personnel changes in the current pay period.
- EMPLOYEE SSN H0B.EMPLOYEENO/DERIVED
- Displays the employee's SSN.
- PRD END DT H0H.PERIODEND
- Displays the last day of the employee's pay period.
- PCA/I H0H.LABORCD
- Displays the labor code to which the payment was charged.
- OBJC H0H.LABORCDEXT
- Displays the USAS expenditure code assigned to each type of pay the employee receives.
- GROSS AMOUNTS H0H.REG, H0H.DT1, H0H.DT2, H0M.SPECAMT
- Displays the employee's gross pay broken down by object code.
- NET H0H.NET + H0M.DEDAMT(69)
- Displays the employee's take home pay after all deductions have been taken. Any direct deposit deduction is considered net pay.
- W/H H0H.FITTAX
- Displays the federal income tax deducted from the employee's pay.
- INS H0M.DEDAMT
- Displays the sum of all short-term and long-term disability and dependent life insurance that was deducted.
- DEF COMP H0M.DEDAMT(54)
- Displays the 457 compensation that was deducted.
- MISC H0M.DEDAMT, H1TZZ (TABLE 885)
- Displays the deduction’s three-character abbreviation and the amount deducted. Deduction names are in Appendix A: “Deduction Numbers” of the USPS Process Guide.
- ORG CODE H0H.ORGCODE
- Displays the employee's organization code.
- NAME HID.RPTNAME
- Displays the employee's name.
- ST PHC H0M.DEDAMT(23)
- Displays the Payroll Health Insurance Contribution
- OASDI H0H.OASDITAX
- Displays the OASDI tax that was deducted.
- RETIR H0M.DEDAMT(5-10)
- Displays the retirement contribution that was deducted.
- TXSVER H0M.DEDAMT(53)
- Displays the 401(k) contribution that was deducted.
- PAYMENT NO H0H.CHECKNO
- Displays the warrant or direct deposit advise number.
- JCLS H0H.JOBCLASS
- Displays the employee's job class code.
- TB/GR/ST HNH.AGYCOMMENT/HNH.POSPAYGRP/HNH.ACTUALSTEP
- Displays the pay table and group associated with the employee's job class code. Displays the employee's pay step, if applicable.
- JS H0H.WKCMPCODE
- Displays the employee's job schedule.
- LV H0B.FLAGA
- Displays whether or not the employee is leveling benefit replacement pay.
Y | Level |
N | Do Not Level |
W | Not Eligible for BRP |
- POSITION H0H.POSITION
- Displays the employee's position number for this payment.
- NONCASH DERIVED H0M.SPECPAY
- Displays the non-cash compensation that was added to the employee's taxable wages. For example, IMPUT will display when imputed income is calculated for the employee.
- MED H0H.HITAX
- Displays the HI/Medicare taxes that was deducted.
- ST RET H0M.DEDAMT(25)
- Displays the state-paid retirement for the employee.
- ST INS H0M.DEDAMT(26,43)
- Displays the state-paid health insurance and state-paid health savings account for the employee.
- ST PRC H0M.DEDAMT (22)
- Displays the agency paid retirement contribution.
- PCA/I TOTALS DERIVED
- Displays the total gross pay, including BRP and longevity for each PCA or index.
- ORG TOT DERIVED
- Displays the totals of gross pay, net, taxes, and all other deductions associated with the organization code.
- TOTAL ORG CODE EXPENDITURES BY OBJECT CODE DERIVED
- Displays the total of all object codes associated with the organization code.
- FUND TOTALS DERIVED
- Displays the totals of gross pay, net, taxes, and all other deductions associated with the fund number.
- DOCUMENT TOTALS DERIVED
- Displays the totals of gross pay, net, taxes, and all other deductions associated with this document.
- TOTAL DOCUMENT EXPENDITURES BY OBJECT CODE DERIVED
- Displays the total of all expenditure codes associated with this document.
- TOTAL AGENCY EXPENDITURES BY OBJECT CODE DERIVED
- Displays the total of all object codes on the payroll.
- TOTAL EMPLOYEES WITH PAYROLL ACTIVITY BY ORG DERIVED
- Displays the number of employees paid by organization code.
- NUMBER OF EMPLOYEES PAID DERIVED
- Displays the number of employees paid on this document.
Sample Report
REPORT: 189 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
PAYROLL FOR WARRANT DATE OF 11/04/20XX RUN TIME: 10:38:35
BATCH 810 DOCUMENT NUMBER XXXXXXXX RUN TYPE FS
D E D U C T I O N S
------------------------------------------------------------------------------------------------------------------------------------
FUND/AY CHG EMPLOYEE SSN PRD END DT PCA/I OBJC GROSS NET W/H INS DEFCOMP MISC
ORG CODE NAME L AMOUNTS ST PHC OASDI RETIR TXSVER MISC
PAYMENT NO JCLS TB/GR/ST JS V POSITION NONCASH MED ST RET ST INS MISC
ST PRC MISC
------------------------------------------------------------------------------------------------------------------------------------
0001/12 *010 XXX-XX-XXXX 10/31/20XX P00001 7002 2,638.88 2,056.06 262.19 0.00 0.00 STF 3.00
00002000100 XXXXX, XXXXXXXX 0.00 0.00 110.83 171.53 0.00
XXXXXXXXXXX 0156 00/15/ W 30653I 38.27 183.40 0.00
0.00
152.00 HOURS AT 17.36105/HR NEW HIRE
P00001 PCA/I TOTALS 2,638.88
00002000100 STAFF ORG TOT 2,638.88 2,056.06 262.19 0.00 0.00 3.00
0.00 110.83 171.53 0.00
0.00 38.27 183.40 0.00
TOTAL ORG CODE EXPENDITURES BY OBJECT CODE
7002 2,638.88 7032 186.40 7043 201.88
0001 FUND TOTALS 2,638.88 2,056.06 262.19 0.00 0.00 3.00
0.00 110.83 171.53 0.00
0.00 38.27 183.40 0.00
XXXXXXXX DOCUMENT TOTALS 2,638.88 2,056.06 262.19 0.00 0.00 3.00
0.00 110.83 171.53 0.00
0.00 38.27 183.40 0.00
TOTAL DOCUMENT EXPENDITURES BY OBJECT CODE
7002 2,638.88 7032 186.40 7043 201.88
AGENCY TOTAL 2,638.88 2,056.06 262.19 0.00 0.00 3.00
0.00 110.83 171.53 0.00
0.00 38.27 183.40 0.00
TOTAL AGENCY EXPENDITURES BY OBJECT CODE
7002 2,638.88 7032 186.40 7043 201.88