Most efficient way to store this example data in sql server or some other object

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.

Nigluc
BrockAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

OCDanCommented:
No file attached mate?

How many rules are there for how earning codes are treated?
Is there some logic to the earning codes that mean by looking at the code you can work out (without just remembering) how it should be treated.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BrockAuthor Commented:
PossibleRecordRepresentation.xlsxHi,

sorry end of day and I thought I attached it .

---Yes there is logic to the codes .  I have an example attached. The logic is different depending for the different earning codes.  

Thank you,
Nigluc
0
BrockAuthor Commented:
Thanks for answering.  We are writing a custom bolton to an application.  I looked at the existing earnings code table and the earnings code are determined based on payment type.
So I will save the data in a similar manner.

Nigluc
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.