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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
So I will save the data in a similar manner.
Nigluc
ASKER
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