Attendance, is a troublesome problem!

Attendance, is a problem that is troublesome.
My first job after graduation is to engage in attendance, time is the work (VB+SQL development MRP) Six months after the start,
I was the only one who did the job, and it was up to 4 weeks to complete the staff attendance pay. Oh, my God, that time.
I'm sorry. At that time intermittent (but also to participate in other module development) for six months, haha, ashamed ing ...
============================================================================
If it is a one-shift system (same as everyday work time) it is better to do
1: Specify the timing of each clocking (for example: 8:00, noon 12:00,
14:00, 18:00);

2: Specify the time range of clocking out (for example: 7:30--8:30, 12:00-12:30,
13:30--14:30 and 18:00--18:30 can also be defined as 30 minutes before and after the positive time;

3: You can redefine the time to punch loose (for example: 2 minutes late is not late), which is more suitable for late leave early
According to the "second" calculation of the situation;

4: I punch the status into: "Normal", "late", "Leave early," "Supplementary card", "not clocked";

5: Specify the holidays, shifts (even if only one), the purpose is to specify a certain time of day, which employees
Clock-out

6: If there is overtime, can be before or after a certain period of time for overtime, of course, also to stipulate what
Staff in the scope of the overtime;

7: Do not punch out in the clocking time range. The approach to this situation is as follows:
A: Supplementary card: The attendance device is broken, power failure, forget to clock, accidents and so on, by the operator
Supplementary card processing. My practice is to insert a clocking record directly into the attendance table.
B: Absenteeism: No clock-in and no supplementary card. There are some things to do here, such as clocking in at work, but getting off
No clocking in, or vice versa, or no clocking in;
C: Leave, leave, temporary transfer classes: the original need not clock, unless overtime;

8: Multiple clocks: I am using the loose way, that is, as long as a normal even a few times to be late as normal (for example:
Played three times: 7:50, 8:10, 8:12); If you are late for a few times, whichever is the least late;

It should be noted that "clocking" is a time concept, work, absenteeism,
Leave and leave are the concepts of time period, such as staff leave, time is 9:00 to 15:00, or cross-day leave, leave
Also includes holidays ...
=============================================================================
If it's a multi-shift system (it may not work the same every day)
In addition to the above points, you also need to set a certain time of day on that shift. For example, set the shift schedule for the next month,
To be transferred in case of special situation.
=============================================================================
The time table to do the trigger, each clocking in the calculation, real-time display out of the clock status, both reminder clock and can remind
Manager: The time of day or the previous day of clocking out from work or at some point, so that you can deal with clocks that are not clocked,
Leave, absenteeism, vacation and so on, and finally save the results. It's best not to wait until the end of the month.
The calculation function will be better.

Attendance and wages are combined, the attendance can be directly integrated into the wages of the calculation formula is the best, this I do not
Let me elaborate.
=============================================================================

Above is only my personal humble opinion, I hope to help the landlord ^-^