[AccessD] Payroll

[Bob Heygood]

Thanks Stuart,
Again, sorry if I did not state objective clearly.
Pay periods are in stone. I know, we have all heard this before.
NO time of day is involved.
Just a matter of recording hours worked ( straight, time and a half and
double time) for a given job and pay period; for a given employee. 

I am pretty sure I will stick with my original schema unless I run into an
issue.
Only non "normalized" aspect is multiple date fields in the time card table.

Thanks again all

Bob


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Stuart McLachlan
Sent: Tuesday, May 1, 2018 2:18 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Payroll

Assuming an 8 hour work day, that's just 6 hrs on day 1 and 6.5 hours on day
2.
 
How/where you track the reasons for absences is an entrely different topic
to how you recordhours worked.

Let's not complicate the issue unnecessarily, Bob said ealier:

"I should have been a bit more clear.
I am only tracking the hours worked per day per payperiod."



On 1 May 2018 at 21:52, James Button via AccessD wrote:

> Or, as happened to me -
> Had to take a 2 hour break from a shift to report to the police that 
> my car had been broken into and accompany them to the car, (in the 
> works car park during working time - the heated rear window smashed!) 
> Then, the following day another 90 minutes to have the replacement 
> window put into the car.
> 
> OK - I could have taken the rest of the day off, but that would have 
> seriously annoyed my employer as it would have meant at least 8 hours 
> delay to the already late project I was working on!
> 
> Yes - that was optional as the employer could have said I could not 
> take time off from a shift. That would mean I missed an entire shift.
> - But court attendance - not optional! Not as a juror, or as a witness
> 
> JimB
> 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com