Vacation Database Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a vacation database and I need to calculate their vacation
based on their anniversary. So, if they were hired on 12/1/93, they will be
able to have 160 hrs available to use. Each person would be different based
upon their anniversary date.
 
Hi,
You also have some business logic questions to answer.
When do you calculate the vacation time?
First of year?
Then what do you do about someon hired in march of last year?
Is it prorated?
On anaversery date?
Have to make sure that it is calculated at that time.
And/or Do you accumulate vacation time prior to the aniversery date?
After the first 6 months you get 20 hours to use for the rest of the
(what time period)
etc...

I would use a table that defined the basics
tblVacationHours
Years HoursAvail
1 40
5 80
10 120
99 160

Then depending on your buiness logic you need to calculate the
difference (ie =DateDiff("yyyy",#12/1/1993#,Now()) - this rounds up to the
next year - 13 years) and compare it to the table.


--
Craig Hornish

Visit weekly Access conferences
Tuesday, 11:00am-12:30pm (Eastern US)
Thursday, 3:30pm- 5:00pm (Eastern US)

http://community.compuserve.com/n/pfx/forum.aspx?webtag=ws-msdevapps

"Think outside the box, because anything is possible."
"How long it will take or whether it requires divine intervention is another
issue"
 
What I need to figure out now is how to get a query to look at their
anniversary date and add in what amount they get awarded. When a new employee
is eligible for vacation is on their anniversary date and then they can start
taking it. So, if someone starts in march they have to wait until the
following march to use their vacation.
 
Hi Roger,
I downloaded your "VacationUsed" db but I'm a little unclear as to what the
Factor table is for. What exactly is this calculating and why the need for
this type of calculation? I'm trying to set up a database to track vacation
for my employees and would like to use yours as a benchmark but I'm unsure
about this factor part.
Thanks
SS
 
The sample is based on the scenerio where the worker accrues vacation on a
monthly basis. At the 3rd year, he gets .6 days for every month worked. At
the 5th year, he gets .8 days for every month and at the 8th year, .9 days.
If your model gives a set number of days each year, instead of a
multiplication factor, you could just put the actual number of days the
employee gets at each interval.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Hi Roger,
Thanks for the clarification on the factor. Here is how our vacation is
calculated. Can you show me how I would set up the table with these factors:

6 months thru 1 full calendar year* 4/hrs accrued per month
2nd full year through 4 years 6.66/hrs accrued per month
5 thru 9 years 8/hrs accrued per month
10 thru 14 years 10/hrs accrued per month
15 thru 19 years 10.66/hrs accrued per month
20 thru 24 years 11.33/hrs accrued per month
25 thru 29 years 12hrs/hrs accrued per month
30 thru 34 years 12.66/hrs accrued per month
35 thru 39 years 13.33/hrs accrued per month

No accrual in November or December of the first full year.

I'm not sure I fully understand how to set this up and use the formulas in
your vacation used db.

Thanks
SS
 
I was using Factor as a fraction of a day. If you deal with hours, you
would just store the hours. AFAIK, the rest should work the same except the
vacation accrued and used will be in terms of hours rather than days.
 
Back
Top