On Mar 29, 2007, at 6:16 PM, Jim Lucas wrote:
you stated in a different email that there are 6 possible values/ settings for the sequence col.what are they, and what do they mean?One person asked about missed punches. What happens if someone forgets to clock out? Is an entry made for the person for the appropriate day/minutes/sequence ???I can see a way to do what you are asking, but I need these questions answered first.
Okay, here's what I have figured out about how the original programmer did it. Employees are given the option of using a "clock in/clock out" link on the web page or entering the hours manually. Most of the employees just sign in/out at the end of the day.
The sequence number is used to keep it in order so that it can do the math based on the right day. sequence 0 is the first sign in, sequence 1 is the first sign out, sequence 2 is the second sign in, sequence 3 is the second sign out etc. etc.. Basically if an employee works from 8:00 AM until 4:30 PM with a half hour lunch the database would look something like this:
Sequence 0 480 (8 AM) IN Sequence 1 720 (12 noon) OUT Sequence 2 750 (12:30) IN Sequence 3 990 (4:30) OUTOr if they work until 7 PM with a break for lunch and supper it would look like:
Sequence 0 480 (8 AM) IN Sequence 1 720 (12 noon) OUT Sequence 2 750 (12:30) IN Sequence 3 990 (4:30) OUT Sequence 4 1020 (5PM) IN Sequence 5 1140 (7PM) OUTThe idea being if you sort by employee, day, and then sequence you can do the math by subtracting sequence 0 from sequence 1, sequence 2 from sequence 3 etc. etc.
When I started looking at this originally, I was just looking at adding a feature to it, but now I'm thinking that since I've learned a fair amount about working with databases, I may try and write my own as a side project to learn even more :)
I will try the suggestions that were given and any new ones that come in and see what works best, and when I do that I'll post the results back here for posterity.
Thanks everyone for your help! It's because of people like you that I have been able to come as far as I have in this world.
-- Jason Pruim japruim@xxxxxxxxxx Production & Technology Manager MQC Specialist (2005 certified) 3251 132nd Ave Holland MI 49424 616.399.2355 www.raoset.com “Give me your tired, your poor, Your huddled masses yearning to breathe free, The wretched refuse of your teeming shore. Send these, the homeless tempest-tost to me, I lift my lamp beside the golden door!” From “The New Colossus,” by Emma Lazarus
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
