USPS Reports Guide –
USPS Reports by Number –
Report 195 Deductions Not Taken
This report displays all deductions for employees, including terminated employees whose pay was insufficient to cover their scheduled deductions. All deductions not taken are listed together by either the deduction number or the deduction group.
A deduction group is a set of common deductions that have been grouped together for easier reporting.
- Insurance (30-34, 44, 46)
- Medical Care Reimbursements (36, 38)
- Dependent Care Reimbursements (37, 39)
- Payables (48)
- Savings Bonds (62-66)
- Taxes
Report Criteria
Category | Payroll Administration |
---|---|
Distribution | Agency |
Frequency | Runs with payroll. |
Form | 195 |
Sort Sequence | Deduction Number (Group), Document Number, Employee Name Note: For agencies with Payables: Deduction Number (Group), Document Number, Sub-Deduction Number for Deduction 48, Employee Name. |
Page Break | Deduction Number (Group) |
Parameters | |
Databases Used | H04, H09, H0B, H0H, H0M, H0V, H0Z, HNP, HID, HN6, HNY, HN6, HNZ, HSC, H0B |
Selection Criteria | All employees on the payroll where H0H.DEDNTKNSW equals 1. |
Produce Output? | Yes |
Request Screen | HPRPT – Set up to run automatically with each payroll. |
Posting Report? | No |
Additional Notes | Employees on Leave Without Pay for the entire pay period will not be included. |
Report Headings
- DOCUMENT NUMBER H0H.ALPHACONS2
- Displays the USAS document number assigned to the payroll.
- PAYMENT DATE H0H.CHKDATE
- Displays the date of the check where the deduction was not taken.
- EMPLOYEE NAME HID.RPTNAME
- Displays the employee's name.
- SSN H0H.EMPLOYEENO
- Displays the employee's SSN.
- ORG CODE HNP.ORGCODE
- Displays the organization code as defined by the employee's position.
- EMP STA H0B.EMPSTATUS
- Displays the employee's employment status.
1 Active 2 On-Leave 3 Terminated - DED NO H0Z.DEDNO OR H0Z.PODNO
- Displays the number of the deduction listed.
- SUB NO HNZ.SEQNO
- Displays the number of the sub-deduction, if applicable.
- DEDUCTION NAME H0V.DEDNAME OR HNZ.VENDORNAME
- Displays the name of the deduction that corresponds to the deduction or sub-deduction number listed.
- SCHEDULED DEDUCTION DERIVED (CURRENT DEDUCTION + DEDUCTIONS NOT TAKEN) OR H0Z.DEDAMT
- Displays the amount that was scheduled to be deducted from the employee's pay. If the deduction is a percentage deduction, the maximum legal deductions allowed is calculated and shown.
- CURRENT DEDUCTION H0M.CURRENTDED OR HNZ.CURRDEDAMT
- Displays the amount that was deducted from the employee's pay.
- DEDUCTION NOT TAKEN H0M.DEDNOTTAKN OR HNZ.DEDNTAKEN
- Displays the amount not taken from the employee's pay due to insufficient wages.
- TOTAL DEDUCTIONS NOT TAKEN DERIVED
- Displays the total of SCHEDULED DEDUCTION, CURRENT DEDUCTION, and DEDUCTIONS NOT TAKEN.
Sample Report
REPORT: 195 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1 AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX DEDUCTIONS NOT TAKEN FOR 52 - 401KLOAN RUN TIME: 21:14:08 DOCUMENT NUMBER 84094FR1, PAYMENT DATE 10/01/20XX EMPLOYEE NAME SSN ORG CODE EMP DED SUB DEDUCTION NAME SCHEDULED CURRENT DEDUCTION STA NO. NO. DEDUCTION DEDUCTION NOT TAKEN XXXXXXX, XXXXXX X XXX-XX-XXXX 01010101010 1 401KLOAN 333.33 0.00 333.33 52 401KLOAN 333.33 0.00 333.33