The following steps outline the process for calculating the expected dilution period for a salaried new hire, termination mid-period or employee with uncompensated leave. This process should be followed after the timesheet has been approved and is in a COMPLETED or LOCKED state status but before the timesheet is extractedEXTRACTED.
Cons of this Method
- Pros of the Adjusting the Period Hours method: you You don't need to create a separate non-work/LWOP project or paycode pay code or have people charge against that non-work/LWOP project.
- Consideration Cons of the Adjusting the Period Hours method: you You must as an Admin edit the Person Profile Dilution Hours in Period > Dilution > HOURS IN PERIOD field with a value calculated outside the system. It may be easy to forget to do this, so you may choose to employ a validation stored procedure (described below) to assist.
- HOURS WORKED = hours on the timesheet for the employee.
- BUSINESS HOURS = standard work day hours * the number of business days in the time period.
- PERCENTAGE OF PERIOD = HOURS WORKED/BUSINESS HOURS.
- ADJUSTED PERIOD HOURS = Dilution Period Default hours * PERCENTAGE OF PERIOD.
Setting the adjusted hours in the Person Dilution
HOURS IN PERIOD
The ADJUSTED PERIOD HOURS are entered into “Hours in Period” the HOURS IN PERIOD field of the employee’s dilution Dilution screen in the person profile. (http://help.unanet.com/current/unanet_menu/people/people_dilution.htm). Following this process will ensure the employee’s adjusted cost rate is accurate.
Example 1 - Semi-monthly
In a semi-monthly time period, the standard dilution hours are set to 86.667. Within a given period, a new-hire works 7 of 10 working days. Let’s assume the standard work day is 8 hours.
|A||HOURS WORKED||8 hours * 7 days||56 hours|
|B||BUSINESS HOURS||8 hours * 10 days||80 hours|
|C||PERCENTAGE OF PERIOD||56 hours worked / 80 hours in period||.7|
|D||ADJUSTED PERIOD HOURS||86.667 dilution period default *.7 percent of time period worked||60.6667|
Example 2 - Biweekly
In a biweekly time period, the standard dilution hours are set to 80. Within a given period, a new-hire is employee for 4 of 10 working days in the period. The employee is expected to work 8 hours a day.
A stored procedure is a customized script that runs on the Unanet database and validates entries to the timesheet or expense report. In this case, the validation would be a Save validation warning and submit Submit validation warning on the timesheet.
For a new hire, the stored procedure would be setup set up to trigger if the user Hire Date field was populated with a date within the time period and the hours worked are less than the business hours in the period. Special exceptions would need to be accounted for if the Hire Date was on the first weekday of the time period and therefore all normal business hours were included in the dilution period. The Save and Submit message would be a warning to indicate to the user that he should contact the System Administrator to review the dilution settings.
Unanet does not track Termination Dates as a standard field, but if validation on termination is necessary, it would be possible to setup set up a Person user-defined field (UDF) to enter a Termination Date. The validation routine would be very similar for the termination, with special exception if the termination date Termination Date is on the last weekday of the time period. The client will need to determine if the Termination date Date can be identified and entered into Unanet in a timely fashion in order to make the stored procedure routine viable in their environment.
If a Stored Procedure stored procedure is desired, the client should contact their Customer Account Manager or implementation consultant.