468,301 Members | 1,537 Online

# What is the most efficient way to do this?

3
Hi all,
I was hoping I could get some direction for you folks on how to tackle this problem.
Background:
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?

Oct 6 '06 #1
2 1166
PEB
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
JJ48
3
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