Table structure for salary

[Harrold]

Hi

Can you please see the attached and provide comment about my table structure?

Thanks in advance

 

[Mr Smin]

tblEmployees likely does not need the resigneddate checkbox - if the date field is null then they haven't resigned.

Gross salary might want it's own table since it could change per person over time. Table would be something like
ID (PK)
EmployeeID(FK)
Salary
DateFrom
DateTo


You are using FirstName as a FK in several places but it may be better to use tblEmployees.Autonumber since this will be unique but two people may share a firstname.

 

[Harrold]

Gross salary might want it's own table since it could change per person over time. Table would be something like
ID (PK)
EmployeeID(FK)
Salary
DateFrom
DateTo

Can DateFrom & DateTo be replaced by PaymentDate under tblRef_Payment_Period?

 

[Mr Smin]

Is tblRef_Payment_Period the place to store base salary data? or does it store actual payments made (taking account of deductions or bonus payments)?

If the first, you could replace it with the table I described.

e2a: I personally prefer 2 date fields to define a period, but there are circumstances where just one makes sense.

 

[Harrold]

tblRef_Payment_Period is for the date when salary is released to employees.