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

  • Thread starter Thread starter NYCPaul
  • Start date Start date
N

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
 
-----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
Click to expand...
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
 
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
 
Back
Top