Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2012-03-30
3
Medium Priority
?
327 Views
Last Modified: 2012-03-31
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
0
Comment
Question by:Lucia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
OCDan earned 2000 total points
ID: 37789386
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
 

Author Comment

by:Lucia
ID: 37789995
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
 

Author Closing Comment

by:Lucia
ID: 37790782
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

Featured Post

Build and deliver software with DevOps

A digital transformation requires faster time to market, shorter software development lifecycles, and the ability to adapt rapidly to changing customer demands. DevOps provides the solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Make the most of your online learning experience.
If you are a mobile app developer and especially develop hybrid mobile apps then these 4 mistakes you must avoid for hybrid app development to be the more genuine app developer.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question