Need advs/comments on this Design

Vinodonly posted on Wednesday, October 07, 2009

I'm designing a HR module in which one of the req is to generate salary for employees..

There are multiple values added and deducted and finally we get the "Net Salary Figure"..

Additions can be :- Basic Salary, Allowance, Overtime etc..

Deductions can be :- Income Tax, Absent Amount etc..

To cover up this design currently I have done following

A table called SalRelInfo in DB which is having following columns

InfoType i.e. Allowance, Income Tax etc..
InfoDate
InfoValue - This is holding the actual value..

BO is also designed in same way..

The other approach might be to create seperate columns for each and every value but then all the updations, editions etc. in bo needs extra effort.

Secondly, if a new val type is added then we have to revise everything i.e. bo, UI etc..

My questions is Is this the right way ? If you are given the same problem, how you will approach it with advantages and disadvantages of current approach v/s my approach..

I'm posting it here bcos here lot of experts are posting and they are aware of both csla and db design..

so your advs/comments are needed...

Vinodonly replied on Thursday, October 08, 2009

any advs/comments/help on this..