[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

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
0
Lucia
Asked:
Lucia
  • 2
1 Solution
 
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
 
LuciaAuthor 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
 
LuciaAuthor 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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now