Federal Poverty Line Table

P

Phil

I work in the healthcare industry and in order to qualify a patient for a
discounted fee I need to be able to calculate where they fall in the Federal
poverty line (FPL). I have to tables: 1 for patient data. and 2. federal
poverty line values

Two fields from the patient table are needed to determine the federal
poverty level: 1. # dependants 2. annual family income

There are four levels of FPL: 0-50%, 51-100%, 101-150% and 151-200%

The FPL table is as follows:

50% Federal Poverty Line 100% Federal Poverty Line 150% Federal Poverty
Line 200% Federal Poverty Line
# Dep Income Levels Income Levels Income Levels Income Levels
0 5,200 10,400 15,600 20,800
1 5,200 10,400 15,600 20,800
2 7,000 14,000 21,000 28,000
3 8,800 17,600 26,400 35,200
4 10,600 21,200 31,800 42,400
5 12,400 24,800 37,200 49,600
6 14,200 28,400 42,600 56,800
7 16,000 32,000 48,000 64,000
8 17,800 35,600 53,400 71,200
If Blank Income Unreported Income Unreported Income Unreported Income
Unreported

I need a query or something that can be put into a report classifying the
patient into the various FPL levels.

Please help me...
 
K

KARL DEWEY

You need to reformat your FPL table to look like this --
# Dep Low High % FPL
0 0 5,200 50% Federal Poverty Line
1 5,200 10,400 50% Federal Poverty Line
2 7,000 14,000 50% Federal Poverty Line
3 8,800 17,600 50% Federal Poverty Line
4 10,600 21,200 50% Federal Poverty Line
5 12,400 24,800 50% Federal Poverty Line
6 14,200 28,400 50% Federal Poverty Line
7 16,000 32,000 50% Federal Poverty Line
8 17,800 35,600 50% Federal Poverty Line
0 10,400 15,600 100% Federal Poverty Line
1 10,400 15,600 100% Federal Poverty Line
2 14,000 21,000 100% Federal Poverty Line
3 17,600 26,400 100% Federal Poverty Line
4 21,200 31,800 100% Federal Poverty Line
5 24,800 37,200 100% Federal Poverty Line
6 28,400 42,600 100% Federal Poverty Line
7 32,000 48,000 100% Federal Poverty Line
8 35,600 53,400 100% Federal Poverty Line
0 15,600 20,800 150% Federal Poverty
1 15,600 20,800 150% Federal Poverty
2 21,000 28,000 150% Federal Poverty
3 26,400 35,200 150% Federal Poverty
4 31,800 42,400 150% Federal Poverty
5 37,200 49,600 150% Federal Poverty
6 42,600 56,800 150% Federal Poverty
7 48,000 64,000 150% Federal Poverty
8 53,400 71,200 150% Federal Poverty

Then in query criteria on # dependants = # dependants AND annual family
income BETWEEN Low And High.
 
Top