|
|
 |
|
|
TABLE 9D: PATIENT RELATED REVENUE (Scope of Project Only)
State Summary for Tennessee for 2007
24 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 |
8,468,250 |
20.4% |
7.1% |
7,670,881 |
16.9% |
10.2% |
90.6% |
1,835,460 |
1,282,718 |
|
0 |
3,118,178 |
36.8% |
1,075,115 |
12.7% |
| 2a. Medicaid Managed Care (capitated)
|
6,289,628 |
15.2% |
5.3% |
14,003,071 |
30.8% |
18.6% |
222.6% |
738,152 |
244,133 |
0 |
0 |
982,285 |
15.6% |
-7,713,443 |
- 122.6% |
| 2b. Medicaid Managed Care (fee-for-service)
|
26,675,021 |
64.4% |
22.5% |
23,840,784 |
52.4% |
31.6% |
89.4% |
8,619,863 |
3,006,597 |
77,252 |
1,699 |
11,702,013 |
43.9% |
5,933,758 |
22.2% |
| 3. Total Medicaid (Lines 1 +
2a + 2b) |
41,432,899 |
100.0% |
35.0% |
45,514,736 |
100.0% |
60.3% |
109.9% |
11,193,475 |
4,533,448 |
77,252 |
1,699 |
15,802,476 |
38.1% |
-704,570 |
- 1.7% |
| 4. Medicare Non-Managed Care |
13,246,482 |
95.2% |
11.2% |
9,856,697 |
98.3% |
13.1% |
74.4% |
26,000 |
472,228 |
|
0 |
498,228 |
3.8% |
2,686,711 |
20.3% |
| 5a. Medicare Managed Care (capitated)
|
0 |
0.0% |
0.0% |
0 |
0.0% |
0.0% |
--- |
0 |
0 |
0 |
0 |
0 |
--- |
0 |
--- |
| 5b. Medicare Managed Care (fee-for-service)
|
669,615 |
4.8% |
0.6% |
173,973 |
1.7% |
0.2% |
26.0% |
0 |
0 |
0 |
0 |
0 |
0.0% |
279,618 |
41.8% |
| 6. Total Medicare (Lines 4 +
5a + 5b) |
13,916,097 |
100.0% |
11.7% |
10,030,670 |
100.0% |
13.3% |
72.1% |
26,000 |
472,228 |
0 |
0 |
498,228 |
3.6% |
2,966,329 |
21.3% |
| 7. Other Public including Non-Medicaid
CHIP (Non Managed Care) |
299,474 |
70.1% |
0.3% |
141,918 |
44.4% |
0.2% |
47.4% |
|
|
|
0 |
0 |
0.0% |
145,847 |
48.7% |
| 8a. Other Public including Non-Medicaid
CHIP (Managed Care Capitated) |
127,636 |
29.9% |
0.1% |
177,792 |
55.6% |
0.2% |
139.3% |
|
|
0 |
0 |
0 |
0.0% |
-50,156 |
- 39.3% |
| 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) |
427,110 |
100.0% |
0.4% |
319,710 |
100.0% |
0.4% |
74.9% |
|
|
0 |
0 |
0 |
0.0% |
95,691 |
22.4% |
| 10. Private Non-Managed Care |
14,880,762 |
88.1% |
12.6% |
7,886,764 |
79.5% |
10.4% |
53.0% |
|
|
|
0 |
0 |
|
5,995,003 |
40.3% |
| 11a. Private Managed Care (capitated)
|
1,984,923 |
11.8% |
1.7% |
2,028,942 |
20.4% |
2.7% |
102.2% |
|
|
0 |
0 |
0 |
0.0% |
-46,248 |
- 2.3% |
| 11b. Private Managed Care (fee-for-service)
|
16,562 |
0.1% |
0.0% |
6,238 |
0.1% |
0.0% |
37.7% |
|
|
0 |
0 |
0 |
0.0% |
13,024 |
78.6% |
| 12. Total Private (Lines 10
+ 11a + 11b) |
16,882,247 |
100.0% |
14.2% |
9,921,944 |
100.0% |
13.1% |
58.8% |
|
|
0 |
0 |
0 |
0.0% |
5,961,779 |
35.3% |
| 13. Self-Pay |
45,842,309 |
100.0% |
38.7% |
9,693,720 |
100.0% |
12.8% |
21.1% |
|
|
|
|
|
|
|
|
| 14. Total (Lines 3 + 6 + 9 +
12 + 13) |
118,500,662 |
|
100.0% |
75,480,780 |
|
100.0% |
63.7% |
11,219,475 |
5,005,676 |
77,252 |
1,699 |
16,300,704 |
13.8% |
8,319,229 |
7.0% |
|
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) |
32,728,565 |
71.4% |
2,282,133 |
5.0% |
data as of: 7/22/2008 4:14:17
|
