Calculating Datehired w/ Vacation, Sick, and Med. Leave Time

[NYCPaul]

Need to design three calculated fields to show available
time.

1.) Available Vacation Time
Vacation begins accruing 6 months after 'datehired' at
various rates. Initially at 6.66 days per month (2
weeks/yr). Management and those with 5 years, it is 10.00
days per month (3 wks/yr.). Other employees may get 4
weeks (13.34 days/mo.) or 5 weeks (16.67 days/mo).

2.) Available Sick Time
Sick Time begins accruing 3 months after 'datehired' at a
rate of 3.33 hours/mo. totaling 5 days per year. Sick
time resets each year based on 'datehired' (not calendar
year).

3.) Medical Leave
Medical Leave is 8 days per year.

Thanks for any help you can give!

NYCPaul

 

[david white]

-----Original Message-----
Need to design three calculated fields to show available
time.

1.) Available Vacation Time
Vacation begins accruing 6 months after 'datehired' at
various rates. Initially at 6.66 days per month (2
weeks/yr). Management and those with 5 years, it is 10.00
days per month (3 wks/yr.). Other employees may get 4
weeks (13.34 days/mo.) or 5 weeks (16.67 days/mo).

2.) Available Sick Time
Sick Time begins accruing 3 months after 'datehired' at a
rate of 3.33 hours/mo. totaling 5 days per year. Sick
time resets each year based on 'datehired' (not calendar
year).

3.) Medical Leave
Medical Leave is 8 days per year.

Thanks for any help you can give!

NYCPaul


.
There is not enough info provided to give you an absolute

answer. How many pay periods per year? Can you reduce the
forumla to hours. Is everyone assumed to work a 40 hour
week? if someone works less than a full week/month do they
still get credit.
I find it easier to use hours and accrue it each pay
period.
for example - 40 hours week/2080 hours per year.

A) if (YTD_hours > 1040 or
period_ending_date < start_date)
cp_vacTime = .0385 x 40
.0577 x 40
.077 x 40
.0962 x 40
B) YTD__base_hours = YTD__base_hours + 40
if YTD__base_hours < 365 then base_hours = 40
else
base_hours = YTD_base_hours - 365
YTD_base_hours = base_hours

if (YTD_hours > 520 or
period_ending_date - start_date) > 365
cp_sickTime = .0194 x 40

C) cp_medical_leave = .0308 x 40


cp = current period; YTD = year-to-date

 

[NYCPaul]

Mr. White:

Thanks for your help with this. I think your fields will
work. How do you recommend I create these fields? I was
hoping to cut&paste your formula into the expression
building, but the syntax is not exact. Any advice?

PAUL