Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table of Contents
maxLevel2

 


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.

Pros and

...

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.

Calculate the adjusted hours for the period

Assess the following values:

  1. HOURS WORKED = hours on the timesheet for the employee.
  2. BUSINESS HOURS = standard work day hours * the number of business days in the time period.
  3. PERCENTAGE OF PERIOD = HOURS WORKED/BUSINESS HOURS.
  4. 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://wwwhelp.unanet.com/unadocs/current/unanet_menu/people/people_dilution.htm).  Following Following this process will ensure the employee’s adjusted cost rate is accurate.
 
Image Added


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.

   July
   
S M TWTFSSMTWTFSS
ProjectTitlePay Code1st2nd3rd4th 5th6th7th 8th9th10th11th12th13th14th15th
1110100USDART    



88  

88888  

 

 



StepFormulaExampleResults
AHOURS WORKED8 hours * 7 days56 hours
BBUSINESS HOURS8 hours * 10 days80 hours
CPERCENTAGE OF PERIOD56 hours worked/80 hours in period.7
DADJUSTED PERIOD HOURS86.667 dilution period default *.7 percent of time period worked60.6667

 


 

 

Image Removed

 

 

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.

 

 

 

July

 

 

 

M

T

W

T

F

S

S

M

T

W

T

F

S

S

Project

Title

Pay Code

2nd

3rd

4th

5th

6th

7th

8th

9th

10th

11th

12th

13th

14th

15th

1110100

USDA

RT

 

 

 

 

 

 

 

 









8

8

8

8



 

 

Step

Formula

Example

Results

A

HOURS WORKED

8 hours * 4 days

32 hours

B

BUSINESS HOURS

8 hours * 10 days

80 hours

C

PERCENTAGE OF PERIOD

32 hours worked/80 hours in period

.4

D

ADJUSTED PERIOD HOURS

80 dilution period default *.4 percent of time period worked

32

 


Considerations for a Stored Procedure

One concern with this process is that the Unanet Administrator or client Payroll Manager is unaware of the situation and that the user timesheet is completed and time is diluted prior to this setting being in effect. Recalculation is always a possibility, but a stored procedure may help to reduce the possibility of missing the scenario.

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.

 


Additional Resources

Person Profile

Dilution

 

 

 

 

KC - FAQ - Dilution and Partial Periods - Handling New and Terminating Salaried Employees

KC - FAQ - What are Business Rules Enforcement and Validation Stored Procedures?

Help Docs - Validation Stored Procedures for Time Users

Help Docs - Validation Stored Procedures for Expense Users

Help Docs - Validation Stored Procedures for Manager Time Approvers (Preview Approval Screen)