Re: Hourly rate changes in payroll system

Thanks. I think a paid history table is what I'm looking for as long the field would populate itself with the currect rate rather than having to edit each record seperately. Would it be possible to have an employee table with the name and the current rate and have the history table populate itself with this rate automatically? I'm not sure how to do this automatically with just a click of a process button.

Thanks




On Mon, 08 May 2006 14:02:01 -0400, Klatuu <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Barry's solution is correct; however, a more simplistic approach would be a
little denormalization. In you pay History table, just a field [PAID_RATE].
When you process payroll update that field with the rate at which the
employee was paid.

I am sure there will be some purists who will flame me for this suggestion,
but I think purists sometimes don't read the entire book. The skip the part
about when and why you should denormalize. I would argue this is a good case
for denormalization.

"Sierras" wrote:


Hi

Just trying to get ideas as to how to get around the problem of hourly
rate changes in a payroll type database. If I place the hourly rate of
the employee in the employee table, then it would be easy to get the total
amount to pay the person based on the hours worked. But that would mess
up my history totals when running a query.

I guess I need to capture the rate being used for the employee for the
week worked and store it in a table so that any rate changes in the furure
won't affect historical data.

Any ideas or examples of how to get around this?
Thanks




--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
.

Loading