468,301 Members | 1,537 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,301 developers. It's quick & easy.

What is the most efficient way to do this?

Hi all,
I was hoping I could get some direction for you folks on how to tackle this problem.
A person applying for health coverage gets assigned certain number of points which range from 1 - around 200. Based on the points and their age group, we decide what level of coverage (5 levels) they get. Each level has a maximum point allowed. The number of points per plan and level is very random. The only sequence is that Level 1 is the lowest number of points, level 5 the highest. If you exceed the amount for one level, you get the next level.
A 4 year old with 11 points, may get level 3 in Plan A, but level 2 in Plan B.
A 40 year old with 11 points will get level 2 in Plan A and level 1 in Plan B.
There are 4 different age groups, 5 different health plans, and 5 different levels of coverage.
What is needed:
If a user enters a person's age and how many points was assigned to them, I need to provide the user with all plan names and levels that the person would qualify for.
What is the most efficient way of doing this?

Thank you for your time
Oct 6 '06 #1
2 1166
1,418 Expert 1GB
Maybe you have also tables with information what level how much point be...

It's very further... Do you have any idea about the structure of your tables? Where store what..

Maybe you have to think first for this...

and then how to offer the information to your users!!!

Oct 8 '06 #2
Thank you PEB.
I will work on creating the tables to have this data and then write a query to pull the right data from it.
Oct 9 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Narendra C. Tulpule | last post: by
12 posts views Thread by Michael Culley | last post: by
21 posts views Thread by Helge Jensen | last post: by
13 posts views Thread by Jason Huang | last post: by
6 posts views Thread by Karlo Lozovina | last post: by
20 posts views Thread by athar.mirchi | last post: by
10 posts views Thread by timor.super | last post: by
25 posts views Thread by Abubakar | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.