This page (revision-18) was last changed on 26-Nov-2021 10:22 by kparrott

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
18 26-Nov-2021 10:22 7 KB kparrott to previous
17 26-Nov-2021 10:22 7 KB rforbes to previous | to last
16 26-Nov-2021 10:22 7 KB rforbes to previous | to last
15 26-Nov-2021 10:22 7 KB JMyers to previous | to last
14 26-Nov-2021 10:22 8 KB JMyers to previous | to last
13 26-Nov-2021 10:22 8 KB JMyers to previous | to last
12 26-Nov-2021 10:22 7 KB JMyers to previous | to last
11 26-Nov-2021 10:22 7 KB JMyers to previous | to last
10 26-Nov-2021 10:22 7 KB JMyers to previous | to last
9 26-Nov-2021 10:22 7 KB JMyers to previous | to last
8 26-Nov-2021 10:22 7 KB JMyers to previous | to last
7 26-Nov-2021 10:22 7 KB JMyers to previous | to last
6 26-Nov-2021 10:22 7 KB JMyers to previous | to last
5 26-Nov-2021 10:22 7 KB JMyers to previous | to last
4 26-Nov-2021 10:22 7 KB JMyers to previous | to last
3 26-Nov-2021 10:22 7 KB JMyers to previous | to last
2 26-Nov-2021 10:22 7 KB JMyers to previous | to last
1 26-Nov-2021 10:22 7 KB JMyers to last

Page References

Incoming links Outgoing links
DISPOSABLE INCOME PRORATION
DISPOSABLE INCOME PRORATION

Version management

Difference between version and

At line 4 changed 2 lines
!!Overview
This feature provides for the ability to ensure that an employee receives a guaranteed percentage of their ‘Disposable Income’. Certain deductions that are for payment to other parties for wage garnishment and/or Child support and/or designated others, can be reduced to allow the employee to receive this guaranteed percentage of their ‘Disposable Income.
This document describes the set up requirements and specific logic for GES Quote Number 1144. The GES terminology for this feature is ‘Wage Assignment’, however the term ‘Assignment’ is already an important element within P2K, and therefore this new feature will be known as ‘Disposable Income Proration‘.
At line 7 changed one line
This feature is an extension to the ‘Vendor Payment’ logic and those deductions that can be reduced can only be those that originated as ‘Sundry deductions’.
This feature provides for the ability to ensure that an employee receives a guaranteed percentage of their ‘Disposable Income’. Certain deductions that are for payment to other parties for wage garnishment and/or Child support and/or designated others, can be reduced to allow the employee to receive this guaranteed percentage of their ‘Disposable Income.
This feature is an extension to the ‘Vendor Payment’ logic within P2k, and those deductions that can be reduced can only be those that originated as ‘Sundry deductions’.
At line 9 changed 2 lines
!!Implementation Approach
This feature is a natural extension to the Accounts Payable ‘Vendor’ support logic already existing. Multiple deductions per employee that are direct deductions from the employee net pay, can be entered as Sundry items that are subsequently paid to Vendors during the [UPVEND] process.
Implementation Approach
This feature is a natural extension to the Accounts Payable ‘Vendor’ support logic already existing within various parts of P2K. Multiple deductions per employee that are direct deductions from the employee net pay, can be entered as Sundry items that are subsequently paid to Vendors during the UPVEND process.
At line 12 changed one line
The Disposable Income Guarantee module will be executed as part of [UPCALC] at a point designated by the Pay Point Set. It will be a new ‘Pay Point Task’, which can be positioned at the appropriate point in the pay calculation. This point would be as soon as all Pay Components that make up ‘Disposable Income’ are available.
The Disposable Income Guarantee, module will be executed as part of UPCALC at a point designated by the Pay Point Set. It will be a new ‘Pay Point Task’, which can be positioned at the appropriate point in the pay calculation. This point would be as soon as all Pay Components that make up ‘Disposable Income’ are available.
At line 17 removed one line
At line 22 changed one line
!!Sundry Items Subject to Net Reduction
Sundry Items Subject to Net Reduction
At line 25 changed 3 lines
[Disposible_Income_Proration_01.jpg]
!!Guaranteed Percentage
Guaranteed Percentage
At line 28 added one line
At line 30 removed one line
[Disposible_Income_Proration_02.jpg]
At line 32 changed 2 lines
!!Pay Point Task – Disposable Income Proration
This task invokes the logic that checks the Sundry lines. It can be placed at any point in the ‘Pay Point Set’.
Pay Point Task – Disposable Income Proration
This task invokes the logic that checks the Sundry lines. It can be placed at ant point in the ‘Pay Point Set’.
At line 35 changed one line
[Disposible_Income_Proration_03.jpg]
At line 37 changed one line
!!Pay Point Set - Sample
Pay Point Set - Sample
At line 39 removed 2 lines
[Disposible_Income_Proration_03_1.jpg]
At line 42 removed 3 lines
!!PC Usage - ‘Disposable Income Guaranteed Earnings’
[Disposible_Income_Proration_04.jpg]
At line 46 changed one line
!!Element - ‘Disposable Income Proration’ (SAMPLE)
PC Usage - ‘Disposable Income Guaranteed Earnings’
Element - ‘Disposable Income Proration’ (SAMPLE)
At line 49 removed one line
[Disposible_Income_Proration_05.jpg]
At line 51 changed 2 lines
!!Pay Component - Disposable Income (SAMPLE)
%%information Proration will ONLY be performed on Pay Component Details with a ‘PC Detail Type’ of ‘Computed Value’. Details with ‘Entered Value’, ‘Additional Computed Value’, etc. will NOT be prorated. This is needed to ensure that the declining balances, original amounts and fees attached to Child Support Orders, etc. are not altered.%%
Pay Component - Disposable Income (SAMPLE)
%%informationProration will ONLY be performed on Pay Component Details with a ‘PC Detail Type’ of ‘Computed Value’. Details with ‘Entered Value’, ‘Additional Computed Value’, etc. will NOT be prorated. This is needed to ensure that the declining balances, original amounts and fees attached to Child Support Orders, etc. are not altered.%%
At line 54 changed 2 lines
[Disposible_Income_Proration_06.jpg]
At line 57 changed 6 lines
||PC||Sundry Deduction||Amount
|1000|Earnings|$400.00
|2000|Federal Tax|$100.00
|2001|State Tax|$50.00
|500|Child Support Payment| $150.00
|501|IRS Charge| $50.00
PC Sundry Deduction Amount
1000 Earnings $400.00
2000 Federal Tax $100.00
2001 State Tax $50.00
500 Child Support Payment $150.00
501 IRS Charge $50.00
At line 65 changed 4 lines
|Element| +/- |PC |
|DISPOSABLE| + |1000| Earnings
| | - |2000| Federal Tax
| | - |2001| State Tax
Element +/- PC
DISPOSABLE + 1000 Earnings
- 2000 Federal Tax
- 2001 State Tax
At line 70 changed 3 lines
__Calculate Disposable Income__\\
$400.00 less $100.00 (FT) Less $50.00 (PT) = $250.00
%%information NOTE: If Disposable income is negative then the sundries will NOT be prorated.%%
Calculate Disposable Income
$400.00 less $100.00 (FT) Less $50.00 (PT) = $250.00
NOTE: If Disposable income is negative then the sundries will NOT be prorated!
At line 74 changed one line
__Calculated Disposable Income Guarantee__\\
Calculated Disposable Income Guarantee
At line 77 changed one line
__Calculate Total Deductions Subject to Guarantee__\\
Calculate Total Deductions Subject to Guarantee
At line 80 changed one line
__Calculated the required reduction amount__\\
Calculated the required reduction amount
At line 85 changed 4 lines
__Compute Revised Deduction Amounts__\\
|Child Care|$150 - (($75.00 / $200) * $150)= $93.75
|IRS Charge|$50 -(($75.00 / $200) * $50)= $31.25
%%information The Deductions and Pay Amounts are revised accordingly%%
Compute Revised Deduction Amounts
Child Care $150 - (($75.00 / $200) * $150) = $93.75
IRS Charge $50 -(($75.00 / $200) * $50) = $31.25
*** The Deductions and Pay Amounts are revised accordingly ***
At line 90 changed 6 lines
__Net Pay Calculation (Done later in the Pay)__
|+|$400.00|Earnings
|-|$100.00|Federal Tax
|-|$50.00|State Tax
|-|$93.75|Child Care
|-|$31.25|IRS Charge
Net Pay Calculation (Done later in the Pay)
+ $400.00 Earnings
- $100.00 Federal Tax
- $50.00 State Tax
- $93.75 Child Care
- $31.25 IRS Charge
At line 97 changed one line
Net Pay = $125.00
Net Pay  $125.00!!!!!!!!
At line 99 removed 2 lines
!!Typical Exception Messages
These messages are not representative of the example on the previous section, but provide a sample of the exceptions that would be issued in a situation where Sundry deductions had to be reduced to provide the employee with a ‘Guaranteed Disposable Income’.
At line 102 removed one line
[Disposible_Income_Proration_07.jpg]
At line 104 changed 2 lines
!!Tax Levies
Sometimes there is a Sundry item that requires an employee to pay additional tax on each pay to make up for previous tax shortages. These deductions are not subject to any kind of proration, and therefore are not handled by this particular feature.
Typical exception messages
These messages are not representative of the example on the previous page, but provide a sample of the exceptions that would be issued in a situation where Sundry deductions had to be reduced to provide the employee with a ‘Guaranteed Disposable Income’.
At line 107 changed 6 lines
These levies can further reduce the 50% left after ‘Disposable Income Pro ration’. This can be accomplished by having ‘Tax Levy’ Pay Component processed on a Pay Point after ‘Disposable Income Proration’.
When the net income and the tax levy are both available in the pay, invoke a UserCalc to manipulate the Tax Levy amount any way needed. The ‘Net Pay’ available (even after Net Income Pro ration), can be retrieved along with the amount of the tax levy.
In this example, the employee has $400.00 car loan, an $800.00 Child Support payment, and a $400.00 tax levy. After the car loan and child care payments, the employee is guaranteed 50% of their disposable income. The employee does NOT have enough income in the pay to handle the two deductions completely, so ‘Disposable Income Proration’ kicks in and reduces each of the Car Loan and the Child Support payment proportionally.
Tax Levies
Sometimes there is a Sundry Item that requires an employee to pay Additional Tax on each pay to make up for previous tax shortages. These deductions are not subject to any kind of pro ration, and therefore are not handled by this particular P2K feature.
These levies can further reduce the 50% left after ‘Disposable Income Pro ration’. This can be accomplished by having ‘Tax Levy’ Pay Component processed on a Pay Point after ‘Disposable Income Pro ration’.
When the net income, and the Tax Levy are both available in the pay, invoke a UserCalc to manipulate the Tax Levy amount any way needed. The ‘Net Pay’ available (even after Net Income Pro ration), can be retrieved along with the amount of the tax levy.
In this example, the employee has $400.00 Car Loan, an $800.00 Child Support Payment, and a $400.00 Tax levy. After the Car Loan and Child Care, the employee is guaranteed 50% of disposable Income. The Employee does NOT have enough income in the pay to handle the two deductions completely, so ‘Disposable Income Proration’ kicks in and reduces each of the Car Loan and the Child Support Payment proportionally.
At line 114 changed 3 lines
[Disposible_Income_Proration_08.jpg]
At line 118 removed 4 lines
[Disposible_Income_Proration_09.jpg]\\ \\
User Calc to ensure the employee gets $100.00 Minimum Net Pay after the Tax Levy.\\ \\
[Disposible_Income_Proration_11.jpg] \\ \\
At line 123 changed 2 lines
The results of the pay will be as displayed, and note that all three deductions have been reduced, two by ‘Disposable Income Proration’, and the tax levy by the UserCalc.\\ \\
[Disposible_Income_Proration_12.jpg]
At line 126 changed one line
!!Software Needed for this Release
After being audited, the Pay will look like this …
User Calc to ensure the employee gets $100.00 Minimum Net Pay after the Tax Levy.
At line 128 changed 9 lines
||File Name||Type||Components
|GES_Q1144_Disposable_Income_Proration.doc|Word|This document
|SEED_Q1144_20030207.sql|Seed|Payroll Messages\\X_PAY_POINT_TASK
|P2K_SPPG_GUAR_INCOME.sql|PLSQL|Server Code
|P2K_SPPGMAIN.sql|PLSQL|Server Code
|SEED_USAGE7_20030207.sql|Script|PC Usage
|HR_IEEI.rdf and rep|Form|Employment Form
|PR_IPSN.rdf and rep|Form|Sundry Form
|ddl_030211.tab DDL|DB|Update
The results of the pay will be as displayed, and note that all three deductions have been reduced, two by ‘Disposable Income Proration’, and the tax levy by the UserCalc.
At line 124 added 20 lines
Software needed for this release
File Name Type Components
GES_Q1144_Disposable_Income_Proration.doc Word This document
SEED_Q1144_20030207.sql Seed Payroll Messages
X_PAY_POINT_TASK
P2K_SPPG_GUAR_INCOME.sql PLSQL Server Code
P2K_SPPGMAIN.sql PLSQL Server Code
SEED_USAGE7_20030207.sql Script PC Usage
HR_IEEI.rdf and rep Form Employment Form
PR_IPSN.rdf and rep Form Sundry Form
ddl_030211.tab DDL DB Update
[{If var='loginstatus' contains 'authenticated'
At line 139 changed 2 lines
![Notes|Edit:Internal.DISPOSABLE INCOME PRORATION]
[{InsertPage page='Internal.DISPOSABLE INCOME PRORATION' default='Click to create a new notes page'}]
![Discussion|Edit:Internal.DISPOSABLE INCOME PRORATION]
[{InsertPage page='Internal.DISPOSABLE INCOME PRORATION' default='Click to create a new discussion page'}]
At line 148 added one line
}]
This page (revision-18) was last changed on 26-Nov-2021 10:22 by kparrottTop