[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 630
  • Last Modified:

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.
0
Jim P.
Asked:
Jim P.
3 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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
 
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now