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?
Thank you for your time
2  1334  PEB 1,418
Recognized Expert Top Contributor
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!!!
:)
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.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Narendra C. Tulpule |
last post by:
Hi,
if you know the Python internals, here is a newbie question for you.
If I have a list with 100 elements, each element being a long string,
is it more efficient to maintain it as a dictionary (with a key = a
string from the list and value = None) for the purpose of insertion
and removal?
Basically, if Python really implements lists as linked lists but
dictionaries as hash tables, it may well be that hashing a key takes
negligible time...
|
by: Chris Pels |
last post by:
What would be the most efficient way to serialize a group of the same
objects? For example, if I have 10 Organization objects I want to return
from a WebMethod in a "container", what type of container would be most
efficient (ArrayList, Collection, etc.)? It is a requirement that the
container be dynamic in size and be able to add each object dynamically.
Also, if an ArrayList or something similar is used, is there a way to have
the root...
|
by: Michael Culley |
last post by:
I found this code in a project:
StringBuilder sb = new StringBuilder();
sb.Append("SELECT * FROM SomeTable")
.Append("WHERE SomeField = SomeValue")
.Append("ORDER BY etc etc etc")
at first I thought it was using a using statement but it's not. It works
because sb.Append returns an instance of itself. I'd be interested to hear
what everyone thinks of it.
|
by: Helge Jensen |
last post by:
I've got some data that has Set structure, that is membership, insert
and delete is fast (O(1), hashing). I can't find a System.Collections
interface that matches the operations naturally offered by Sets.
- ICollection cannot decide containment
- IList promises indexability by the natural numbers, which is not
achievable (since i hash elements, not sort them).
- IDictionary is definatly not setlike.
Although I can, of course, define...
|
by: Jason Huang |
last post by:
Hi,
Would someone explain the following coding more detail for me? What's the
( ) for?
CurrentText = (TextBox)e.Item.Cells.Controls;
Thanks.
Jason
| | |
by: Anders |
last post by:
Hi, I was wondering what is most efficient of the two.
Is it more efficient to add server controls within the Itemtemplate and use
OnItemDataBound to manipulate and databind the servercontrols.
Or is better to send the DataItems via. a method/function from within the
Itemtemplate (<%# call function %>)
Id love to hear your thoughts.
Anders
|
by: Karlo Lozovina |
last post by:
Let's say I have a class with few string properties and few integers, and
a lot of methods defined for that class.
Now if I have hundreds of thousands (or even more) of instances of that
class - is it more efficient to remove those methods and make them
separate functions, or it doesn't matter?
Thanks...
--
|
by: athar.mirchi |
last post by:
..plz define it.
|
by: timor.super |
last post by:
Hi all,
Imagine I've an array of int :
int anArray = new int;
I want to extract all the integer that are superior to 500
I can do :
|
by: Abubakar |
last post by:
Hi,
recently some C programmer told me that using fwrite/fopen functions
are not efficient because the output that they do to the file is
actually buffered and gets late in writing. Is that true?
regards,
...ab
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
