Timesheets and Holidays

Here's my table structure:

tblTask:

TaskID (pk)
TaskName
LabourPrice

tblTransaction:

TaskID (fk)
TransactionID (pk)
Authorised (where authorised is the amount paid)
EmployeeID (fk, related to Employees table with usual info)
TransactionDate
TransactionTypeID (fk, related to table with different types, Daywork, Price
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14026-timesheets-and-holidays.html
Work etc)

Every task has a price. Employees book against a task. So if "Paint House"
is £100, and the employee completed 50% of the work, he will get paid £50.
Sometimes, if an employee is working on daywork, the amount paid will go over
the labour price.

However, all this is irrelevant, in as much as the amount the employee is to
be paid is stored in [Authorised]. All the transactions relating to how much
an employee is to be paid is stored in tblTransaction and always relates back
to a specific task. Now for the question.

How could I handle holidays?

I'm able to generate a timesheet showing what the employee is due to be
paid, based on the entries in tblTrnascation, but am not sure how to show
that a days holiday was taken. It would be easy if any weekday not worked
counted as a holiday, but this is not the case.

Would a seperate table for booking holidays be the way to go? How would I
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14026
then link this table (with the HolidayDate field), to the TransactionDate
field?

Any ideas for other ways to handle it would be appreciated.

Thanks,

Dave

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

check http://www.mvps.org/access/datetime/index.html
for how to handle holidays

Pieter


"David M C" wrote in message
news:81FCFB3A-00DD-48FF-A118-94F2AEE4CCD4@microsoft.com...
> Here's my table structure:
>
> tblTask:
>
> TaskID (pk)
> TaskName
> LabourPrice
>
> tblTransaction:
>
> TaskID (fk)
> TransactionID (pk)
> Authorised (where authorised is the amount paid)
> EmployeeID (fk, related to Employees table with usual info)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14026
> TransactionDate
> TransactionTypeID (fk, related to table with different types, Daywork,
> Price
> Work etc)
>
> Every task has a price. Employees book against a task. So if "Paint House"
> is £100, and the employee completed 50% of the work, he will get paid £50.
> Sometimes, if an employee is working on daywork, the amount paid will go
> over
> the labour price.
>
> However, all this is irrelevant, in as much as the amount the employee is
> to
> be paid is stored in [Authorised]. All the transactions relating to how
> much
> an employee is to be paid is stored in tblTransaction and always relates
> back
> to a specific task. Now for the question.
>
> How could I handle holidays?
>
> I'm able to generate a timesheet showing what the employee is due to be
> paid, based on the entries in tblTrnascation, but am not sure how to show
> that a days holiday was taken. It would be easy if any weekday not worked
> counted as a holiday, but this is not the case.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14026
>
> Would a seperate table for booking holidays be the way to go? How would I
> then link this table (with the HolidayDate field), to the TransactionDate
> field?
>
> Any ideas for other ways to handle it would be appreciated.
>
> Thanks,
>
> Dave

check http://www.mvps.org/access/datetime/index.html
for how to handle holidays

Pieter


"David M C" wrote in message
news:81FCFB3A-00DD-48FF-A118-94F2AEE4CCD4@microsoft.com...
> Here's my table structure:
>
> tblTask:
>
> TaskID (pk)
> TaskName
> LabourPrice
>
> tblTransaction:
>
> TaskID (fk)
> TransactionID (pk)
> Authorised (where authorised is the amount paid)
> EmployeeID (fk, related to Employees table with usual info)
> TransactionDate
> TransactionTypeID (fk, related to table with different types, Daywork,
> Price
> Work etc)
>
> Every task has a price. Employees book against a task. So if "Paint House"
> is £100, and the employee completed 50% of the work, he will get paid £50.
> Sometimes, if an employee is working on daywork, the amount paid will go
> over
> the labour price.
>
> However, all this is irrelevant, in as much as the amount the employee is
> to
> be paid is stored in [Authorised]. All the transactions relating to how
> much
> an employee is to be paid is stored in tblTransaction and always relates
> back
> to a specific task. Now for the question.
>
> How could I handle holidays?
>
> I'm able to generate a timesheet showing what the employee is due to be
> paid, based on the entries in tblTrnascation, but am not sure how to show
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14026
> that a days holiday was taken. It would be easy if any weekday not worked
> counted as a holiday, but this is not the case.
>
> Would a seperate table for booking holidays be the way to go? How would I
> then link this table (with the HolidayDate field), to the TransactionDate
> field?
>
> Any ideas for other ways to handle it would be appreciated.
>
> Thanks,
>
> Dave



--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4367 spam emails to date.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14026
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len

You do know your answers are showing up twice, don't you?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14026

You do know your answers are showing up twice, don't you?

(g)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14026

Don't you?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14026

Ironic this!
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14026

>>>I am using the free version of SPAMfighter for private users.
>>>It has removed 4367 spam emails to date.
>>>Paying users do not have this message in their emails.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14026

Looks like your spamfighter is spewing spam all over these newsgroups.

--
Slainte

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited

"Pieter Wijnen"

wrote in message news:ukqoRfVsGHA.2376@TK2MSFTNGP04.phx.gbl...
> check http://www.mvps.org/access/datetime/index.html

yepp, I think I need to remove SpamFighter & get my act together
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14026

Pieter

"Craig Alexander Morrison" wrote in
message news:ubGVbJWsGHA.3480@TK2MSFTNGP04.phx.gbl...
> You do know your answers are showing up twice, don't you?
>



--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4367 spam emails to date.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14026
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len