|
|
 |
|
|
TABLE 9D: PATIENT RELATED REVENUE (Scope of Project Only)
State Summary for Connecticut for 2007
10 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 |
33,557,066 |
35.6% |
18.9% |
22,570,928 |
32.3% |
21.1% |
67.3% |
0 |
403,411 |
|
0 |
403,411 |
1.2% |
8,564,833 |
25.5% |
| 2a. Medicaid Managed Care (capitated)
|
15,159,991 |
16.1% |
8.5% |
12,735,574 |
18.2% |
11.9% |
84.0% |
5,794,426 |
1,243,725 |
36,330 |
0 |
7,074,481 |
46.7% |
1,763,612 |
11.6% |
| 2b. Medicaid Managed Care (fee-for-service)
|
45,639,180 |
48.4% |
25.7% |
34,547,417 |
49.5% |
32.3% |
75.7% |
12,496,508 |
2,783,597 |
0 |
0 |
15,280,105 |
33.5% |
14,618,866 |
32.0% |
| 3. Total Medicaid (Lines 1 +
2a + 2b) |
94,356,237 |
100.0% |
53.1% |
69,853,919 |
100.0% |
65.2% |
74.0% |
18,290,934 |
4,430,733 |
36,330 |
0 |
22,757,997 |
24.1% |
24,947,311 |
26.4% |
| 4. Medicare Non-Managed Care |
11,378,510 |
100.0% |
6.4% |
7,278,249 |
100.0% |
6.8% |
64.0% |
110,687 |
9,100 |
|
4,900 |
114,887 |
1.0% |
2,327,009 |
20.5% |
| 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)
|
0 |
0.0% |
0.0% |
0 |
0.0% |
0.0% |
--- |
0 |
0 |
0 |
0 |
0 |
--- |
0 |
--- |
| 6. Total Medicare (Lines 4 +
5a + 5b) |
11,378,510 |
100.0% |
6.4% |
7,278,249 |
100.0% |
6.8% |
64.0% |
110,687 |
9,100 |
0 |
4,900 |
114,887 |
1.0% |
2,327,009 |
20.5% |
| 7. Other Public including Non-Medicaid
CHIP (Non Managed Care) |
9,590,855 |
36.2% |
5.4% |
7,091,996 |
45.0% |
6.6% |
73.9% |
|
|
|
0 |
0 |
0.0% |
2,185,867 |
22.8% |
| 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) |
16,886,773 |
63.8% |
9.5% |
8,685,028 |
55.0% |
8.1% |
51.4% |
|
|
0 |
0 |
0 |
0.0% |
7,071,652 |
41.9% |
| 9. Total Other Public (Lines
7 + 8a + 8b) |
26,477,628 |
100.0% |
14.9% |
15,777,024 |
100.0% |
14.7% |
59.6% |
|
|
0 |
0 |
0 |
0.0% |
9,257,519 |
35.0% |
| 10. Private Non-Managed Care |
15,005,714 |
93.3% |
8.4% |
7,665,113 |
91.7% |
7.2% |
51.1% |
|
|
|
0 |
0 |
|
5,274,470 |
35.1% |
| 11a. Private Managed Care (capitated)
|
0 |
0.0% |
0.0% |
0 |
0.0% |
0.0% |
--- |
|
|
0 |
0 |
0 |
--- |
0 |
--- |
| 11b. Private Managed Care (fee-for-service)
|
1,071,176 |
6.7% |
0.6% |
689,991 |
8.3% |
0.6% |
64.4% |
|
|
0 |
0 |
0 |
0.0% |
373,272 |
34.8% |
| 12. Total Private (Lines 10
+ 11a + 11b) |
16,076,890 |
100.0% |
9.1% |
8,355,104 |
100.0% |
7.8% |
52.0% |
|
|
0 |
0 |
0 |
0.0% |
5,647,742 |
35.1% |
| 13. Self-Pay |
29,340,300 |
100.0% |
16.5% |
5,804,330 |
100.0% |
5.4% |
19.8% |
|
|
|
|
|
|
|
|
| 14. Total (Lines 3 + 6 + 9 +
12 + 13) |
177,629,565 |
|
100.0% |
107,068,626 |
|
100.0% |
60.3% |
18,401,621 |
4,439,833 |
36,330 |
4,900 |
22,872,884 |
12.9% |
42,179,581 |
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) |
20,958,570 |
71.4% |
2,832,737 |
9.7% |
data as of: 7/22/2008 11:21:07
|
