Most efficient way to store this example data in sql server or some other object
Posted on 2012-03-30
I have Earnings_Code that is dependent on the Employment_Type, and Job_Code.
The earnings code are not all treated the same. There is a group of codes, that have will are determined on weekly hours and number of weeks. There is a group of code that are determined on different criteria. I have attached a file of what one record for a person might look like.
In our office we discussed how we might represent this data so that it would be easy to modify ie not tons of conditional if statements.
There were two model: represent the data as an object with properties of the different scenario or use a set up table and provide a function to grab the data.
Any input would be greatly appreciated.