Paid Time Off tracking DB

Does anyone have an Access DB that can track time off -- whether sick, vacation, etc.

It would also allow for Approve/Disapprove for pending requests and such?

It should also have to be able to calculate accumulated hours.

I can probably build one myself, but if one exists, or even a framework it would save me time.
LVL 38
Jim P.Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Hi Jim ...

Looks like there is an Excel version:

http://www.actitime.com/features.html

Of course, a Google search brings up a load of hits.

I don't have one per se.

mx
0
GRayLCommented:
Hi Jim:  What you want was my former life.  Let me tell you, the verities for what you are asking are extreme.  Do you want it daily, weekly, monthly, all the above?  My experience was a weekly granularity.  200 employees, many sales orders, many tasks and many subtasks within a sales order.  The  Tasks, and Subtasks were integrated into a JobNo.  If a person charged to an overhead number, the sales order changed to the dept number and Sick, Vac, Hol, Pto, Upo, Trg (Sick, Vacation, Holiday, Paid Time Off, Unpaid Time Off, Training) etc. was entered into the Job no.

I guess what I'm trying to say is each case has its own characteristics, and the likelihood of your finding something coming up here that will fit your specific requirements - very remote!  If you are going daily, it looks like you need a time sheet.  That's a whole new can of worms.  
0
Jim P.Author Commented:
We are mostly salary. Its a situation where we accumulate every 2 weeks, but they don't show our accumulated time from our pay stubs. And when we use our time it doesn't show either.

So we are trying to come up with something for our department to track PTO and de-conflict PTO requests.

I guess I have to build. :-(
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Richard DanekeTrainerCommented:
This sounds like the QuickBooks payroll without the pay checks.   This could work for your group if you ran the payroll, policy allows for individual accumulation rates for sick and vacation.  Only when sick or vacation pay are used in a Payroll run does it subtract.   A form for approval and using Employee notes for misc. tracking would do the trick.  Maybe a customized report or two.
0
Jim P.Author Commented:
I'm looking for a cheap solution.. I'll take a look.
0
GRayLCommented:
Jim:  I have a few ideas I can give you but now must leave for Easter dinner.  Later
0
Jim P.Author Commented:
Thanks Ray.
0
GRayLCommented:
In the Employees table you need to add fields AccumSick, AccumVacn - double - representing the hours an employee may spend for each over some given period (most probably fiscal)

I imagine you have a ChgCodes table representing the source to which an employee may charge time.  Also a Contracts table and an Overhead table with multiple entries if you have several departments.  On a form, you need combos for the Employee, and a second combo for either Overhead or a direct charge to one of several Contracts.  When that selection is made a third combo populates with all the ChgCodes eligible for a charge to that Overhead department or Contract.  If a charge is made to Vacn or Sick, code steps in and verifies through lookups that the intended amount does not exceed what was allotted at the start of the reporting period reduced by the sum of what has been expended to date.  In fact, once an employee has been selected, the form could be calculating those two values while the user is busy selecting the Contract/Overhead source and selecting a JobNo.  Then hours are entered, and on to the next charge line for the employee or the selection of a new employee.

At a minimum the WorkedHours table would look like:

WorkedHours
==========
WkHrsID - pk - autonumber
EmpID - fk from Employees
WkEnd - datetime
ChgCode - fk from ChgCodes
Hrs - dbl

Does that look like something you can work with?

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim P.Author Commented:
That is pretty much what I was thinking. Now to code all this. :-(

Thanks.
0
Jim P.Author Commented:
Thanks all.
0
GRayLCommented:
Thanks, glad to help.  Get hold me outside of EE and I'm sure I'll be able to help you.
0
Jim P.Author Commented:
If I have any design challenges, I'll do a related Q.

Thanks all.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.