USPS Reports Guide –
USPS Reports by Number –
Report 192 State Matching Money
This report displays the state matching contributions deposited to different funds by labor code. It is used to document billings to outside entities for costs associated with state employee services, such as state matching taxes, state paid insurance, and state matching retirement.
Beginning with the September 2011 pay period, this report includes the Payroll Health Insurance Contribution (PHC) fee. PHC is paid from the agencies’ budget and defaults to the Program Cost Account or Index used to fund the employee’s base salary. PHC will adjust the state paid portion for health insurance or the Opt Out option up to but not more than the total state match for each benefits eligible employee.
Report Criteria
| Category | Payroll Administration | ||||||
|---|---|---|---|---|---|---|---|
| Distribution | Agency | ||||||
| Frequency | Upon request. | ||||||
| Form | 111 | ||||||
| Sort Sequence |
|
||||||
| Page Break | Fund Number | ||||||
| Parameters |
|
||||||
| Databases Used | H0H, HOM, HID, H0C, HNK, H0B, HNO, HNP | ||||||
| Selection Criteria | Payments with warrant dates within the HSRPQ range or all payments within the current payroll. | ||||||
| Produce Output? | Yes | ||||||
| Request Screen | HSRPQ; HPRPT – Set up to run automatically with each payroll or with Month-End Reports. | ||||||
| Posting Report? | No | ||||||
| Additional Notes |
Report Headings
- FROM/TO HNK.RPTSDT/HNK.RPTEDT
- Displays the beginning and ending dates of the reporting period.
- EMPLOYEE NAME HID.RPTNAME
- Displays the employee's name.
- EMPLOYEE SSN H0H.EMPLOYEENO
- Displays the employee's SSN.
- DOC NO H0H.ALPHACONS1
- Displays the USAS document number assigned to the payroll.
- RET PLAN H0B.FLAGB
- Displays the retirement plan to which contributions are being made.
- OASDI TXBL H0H.OASDITXBL
- Displays the amount of payroll wages that were taxable for OASDI tax.
- MED TXBL H0H.HICOTXBL
- Displays the amount of payroll wages that were taxable for HI/Medicare tax.
- GROSS H0H.SUIGROSS
- Displays the employee’s gross salary.
- ST PRC H0M.DEDAMT (22)
- Displays the agency paid retirement contribution that is funded from a PCA/Index not associated with appropriated funds.
- ST PD RETIRE H0M.DEDAMT(25)
- Displays the retirement paid by the state for the employee.
- ST PD FEE H0M.DEDAMT(24)
- Displays the retirement fee paid by the state for the employee.
- ST PD OASDI H0H.OASDICOTAX
- Displays the OASDI tax paid by the state for the employee.
- ST PD MED H0H.HICOTAX
- Displays the HI/Medicare tax paid by the state for the employee.
- ST PD HEALTH H0M.DEDAMT(26, 43)
- Displays the health insurance portion paid by the state out of appropriated funds and health savings account.
- ST PD LECOS H0M.DEDAMT(29)
- Displays the LECOS employer paid contribution for the employee.
- ST PHC H0M.DEDAMT(23)
- Displays the payroll health insurance contribution fee paid by the agency and funded from a PCA/Index not associated with appropriated funds.
- OPT/OUT H0H.DEDAMT(28)
- Displays the credit paid by the state for the employee.
- FUND H0H.ALPHACONS2
- Displays the USAS fund number from which the payment is being paid.
- PCA/INDEX TOTAL H0H.LABORCODE
- Displays the labor code from which the payment is being posted.
- ORG CODE H0H.ORGCODE
- Displays the organization code as defined by the employee's position.
- ORG CODE NAME HNO.ORGNAME
- Displays the name of the organization code.
- PCA/INDEX TOTAL DERIVED
- Displays the total for a given PCA.
- ORG CODE TOTAL DERIVED
- Displays the total for a given organization code.
- FUND TOTAL DERIVED
- Displays the total for a given fund.
- AGENCY TOTAL DERIVED
- Displays the agency totals.
- WARRANTS DATED FROM DERIVED
- Displays the date of the earliest and latest payments used in this report. These dates will be equal to or within the range of payment dates on HSRPQ.
Sample Report
REPORT: 192 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX BOARD OF DENTAL EXAMINERS RUN DATE: XX/XX/20XX
STATE MATCHING MONEY RUN TIME: 10:10:59
FROM 07/01/20XX TO 07/31/20XX
DOC NO OASDI TXBL GROSS ST PD RETIRE ST PD OASDI ST PD HEALTH ST PHC
EMPLOYEE NAME EMPLOYEE SSN RET PLAN MED TXBL ST PRC ST PD FEE ST PD MED ST PD LECOS OPT/OUT
------------------------------------------------------------------------------------------------------------------------------------
FUND:0001 PCA/INDEX: P00001
ORG CODE: 00002000100 ORG CODE NAME: STAFF
XXXXX, XXXXXXX XXX-XX-XXXX XXXXXXXX 3,004.38 3,666.66 254.83 186.27 832.63 36.67
ERS 3,004.38 0.00 3.00 43.56 0.00 0.00
============== ============== ============= ============= ============= ============
PCA/INDEX P00001 TOTAL: 3,004.38 3,666.66 254.83 186.27 832.63 36.67
3,004.38 3.00 43.56 0.00 0.00
============== ============== ============= ============= ============= ============
ORG CODE 00002000100 TOTAL: 3,004.38 3,666.66 254.83 186.27 832.63 36.67
3,004.38 3.00 43.56 0.00 0.00
============== ============== ============= ============= ============= ============
FUND 0001 TOTAL: 3,004.38 3,666.66 254.83 186.27 832.63 36.67
3,004.38 3.00 43.56 0.00 0.00
============== ============== ============= ============= ============= ============
AGENCY XXX TOTAL: 3,004.38 3,666.66 254.83 186.27 832.63 36.67
3,004.38 3.00 43.56 0.00 0.00
WARRANTS DATED FROM 11/04/20XX TO 11/04/20XX