Register calculated field in table from Form

[Mark_]

I am trying to understand the 'End Date' concept. Wouldn't the 'New' [Effective Date] be the ending for the last Rate? For Example

EMPID_____________RATE______________EFFECTIVE DATE
J.DAWN___________$6200__________________9/1/17
J.DAWN___________$7200__________________4/1/18

In the table above 3/31/18 would be the 'End Date' that the Rate of $6200 is used, right?

This is how I've setup my Employee Rates Table.

The proper answer is "Maybe".

Employee 1 has a rate of $6200 as of 9/1/17.
Employee 1 stops working as of 11/30/17.
Employee 1 start working as of 2/1/18.

Having an end date lets you know there is NO PAY RATE for the period 12/1/17 to 1/31/18 without needing a "zero value" entry. In most cases this would not be needed but allows for special situations.

 

[Mark_]

I have a Payroll entry Form

[cboemp] references the Employee Name
[Periodend] is the end of the pay period

For ease of use, I would have the query that drives the combobox (cboemp) return the rate for the current period. I would also include the effective date. As you are allowing "Period End" there should also be a "PeriodBegin". How do you currently handle a pay change during the period?

Please note, this is one of the reasons I HATE dealing with payroll. Too many exceptions and strange things can come up...

 

[raziel3]

How do you currently handle a pay change during the period?

Pay Rate changes will only occur at the beginning of each month for Monthly paid employees.

Hourly (Weekly, Fortnightly) employees period ends on a Friday so their new pay rates can change the following Saturday. Additionally their Pay Period runs from Saturday to Friday.

 

[Mark_]

From a design standpoint, I would work out how to handle changes during a pay period now. Much better to be able to support it and not need it than to find out someone was promised something that your system won't be able to handle. People get rather upset when their pay isn't right.

 

[raziel3]

Much thanks. I didn't even consider a pay rate change during a period. I will definitely need to put something place (just to be safe).