|
|
 |
|
|
TABLE 9D: PATIENT RELATED REVENUE (Scope of Project Only)
State Summary for Illinois for 2007
36 Grantees
| Payor Category |
Full
Charges This Period (a) |
Charges
as Percent of Payor |
Charges
as Percent of Total |
Amount
Collected This Period (b) |
Collections
as Percent of Payor |
Collections
as Percent of Total |
Collections
as Percent of Charges |
Collection
of recon./wrap around Current Year (c1) |
Collection
of recon./wrap around Previous Years
(c2) |
Collection
of other retroactive payments (c3) |
Penalty/Payback
(c4) |
Net
Retros |
Net
Retros as Percent of Charges |
Allowances
(d) |
Allowances
as Percent of Charges |
| 1. Medicaid Non-Managed Care |
293,292,263 |
94.1% |
58.1% |
176,269,975 |
87.1% |
65.1% |
60.1% |
835,222 |
616,122 |
|
0 |
1,451,344 |
0.5% |
105,164,396 |
35.9% |
| 2a. Medicaid Managed Care (capitated)
|
17,377,789 |
5.6% |
3.4% |
25,945,772 |
12.8% |
9.6% |
149.3% |
6,378,410 |
266,421 |
1,948,330 |
0 |
8,593,161 |
49.4% |
-8,622,758 |
- 49.6% |
| 2b. Medicaid Managed Care (fee-for-service)
|
902,411 |
0.3% |
0.2% |
254,501 |
0.1% |
0.1% |
28.2% |
65,406 |
0 |
0 |
0 |
65,406 |
7.2% |
390,686 |
43.3% |
| 3. Total Medicaid (Lines 1 +
2a + 2b) |
311,572,463 |
100.0% |
61.8% |
202,470,248 |
100.0% |
74.7% |
65.0% |
7,279,038 |
882,543 |
1,948,330 |
0 |
10,109,911 |
3.2% |
96,932,324 |
31.1% |
| 4. Medicare Non-Managed Care |
25,442,629 |
98.5% |
5.0% |
16,346,892 |
87.7% |
6.0% |
64.3% |
154,614 |
232,827 |
|
38,335 |
349,106 |
1.4% |
8,066,781 |
31.7% |
| 5a. Medicare Managed Care (capitated)
|
273,812 |
1.1% |
0.1% |
2,230,909 |
12.0% |
0.8% |
814.8% |
0 |
0 |
39,335 |
0 |
39,335 |
14.4% |
-1,957,097 |
- 714.8% |
| 5b. Medicare Managed Care (fee-for-service)
|
117,048 |
0.5% |
0.0% |
59,602 |
0.3% |
0.0% |
50.9% |
0 |
0 |
0 |
0 |
0 |
0.0% |
46,486 |
39.7% |
| 6. Total Medicare (Lines 4 +
5a + 5b) |
25,833,489 |
100.0% |
5.1% |
18,637,403 |
100.0% |
6.9% |
72.1% |
154,614 |
232,827 |
39,335 |
38,335 |
388,441 |
1.5% |
6,156,170 |
23.8% |
| 7. Other Public including Non-Medicaid
CHIP (Non Managed Care) |
2,138,973 |
100.0% |
0.4% |
1,564,131 |
100.0% |
0.6% |
73.1% |
|
|
|
0 |
0 |
0.0% |
393,351 |
18.4% |
| 8a. Other Public including Non-Medicaid
CHIP (Managed Care Capitated) |
0 |
0.0% |
0.0% |
0 |
0.0% |
0.0% |
--- |
|
|
0 |
0 |
0 |
--- |
0 |
--- |
| 8b. Other Public including Non-Medicaid
CHIP (Managed Care fee-for-service) |
0 |
0.0% |
0.0% |
0 |
0.0% |
0.0% |
--- |
|
|
0 |
0 |
0 |
--- |
0 |
--- |
| 9. Total Other Public (Lines
7 + 8a + 8b) |
2,138,973 |
100.0% |
0.4% |
1,564,131 |
100.0% |
0.6% |
73.1% |
|
|
0 |
0 |
0 |
0.0% |
393,351 |
18.4% |
| 10. Private Non-Managed Care |
39,796,086 |
79.7% |
7.9% |
18,740,289 |
62.0% |
6.9% |
47.1% |
|
|
|
0 |
0 |
|
17,726,434 |
44.5% |
| 11a. Private Managed Care (capitated)
|
8,040,505 |
16.1% |
1.6% |
10,565,654 |
35.0% |
3.9% |
131.4% |
|
|
2,220,206 |
0 |
2,220,206 |
27.6% |
-2,525,149 |
- 31.4% |
| 11b. Private Managed Care (fee-for-service)
|
2,112,042 |
4.2% |
0.4% |
898,166 |
3.0% |
0.3% |
42.5% |
|
|
75,431 |
0 |
75,431 |
3.6% |
900,765 |
42.6% |
| 12. Total Private (Lines 10
+ 11a + 11b) |
49,948,633 |
100.0% |
9.9% |
30,204,109 |
100.0% |
11.1% |
60.5% |
|
|
2,295,637 |
0 |
2,295,637 |
4.6% |
16,102,050 |
32.2% |
| 13. Self-Pay |
115,073,743 |
100.0% |
22.8% |
18,082,518 |
100.0% |
6.7% |
15.7% |
|
|
|
|
|
|
|
|
| 14. Total (Lines 3 + 6 + 9 +
12 + 13) |
504,567,301 |
|
100.0% |
270,958,409 |
|
100.0% |
53.7% |
7,433,652 |
1,115,370 |
4,283,302 |
38,335 |
12,793,989 |
2.5% |
119,583,895 |
23.7% |
|
Sliding
Discounts (e) |
Sliding
Discounts as a Percent of Self-Pay Charges |
Bad
Debt Write Off(f) |
Bad
Debt as Percent of Self-Pay Charges |
| 13. Self-Pay (line 14 is same) |
91,969,506 |
79.9% |
9,951,944 |
8.6% |
data as of: 7/22/2008 2:02:48
|
