|
|
 |
|
|
TABLE 9D: PATIENT RELATED REVENUE (Scope of Project Only)
State Summary for North Carolina for 2007
27 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 |
39,022,261 |
100.0% |
25.7% |
30,866,472 |
100.0% |
38.7% |
79.1% |
0 |
1,603,451 |
|
0 |
1,603,451 |
4.1% |
7,109,322 |
18.2% |
| 2a. Medicaid Managed Care (capitated)
|
0 |
0.0% |
0.0% |
0 |
0.0% |
0.0% |
--- |
0 |
0 |
0 |
0 |
0 |
--- |
0 |
--- |
| 2b. Medicaid Managed Care (fee-for-service)
|
0 |
0.0% |
0.0% |
0 |
0.0% |
0.0% |
--- |
0 |
0 |
0 |
0 |
0 |
--- |
0 |
--- |
| 3. Total Medicaid (Lines 1 +
2a + 2b) |
39,022,261 |
100.0% |
25.7% |
30,866,472 |
100.0% |
38.7% |
79.1% |
0 |
1,603,451 |
0 |
0 |
1,603,451 |
4.1% |
7,109,322 |
18.2% |
| 4. Medicare Non-Managed Care |
22,454,870 |
99.5% |
14.8% |
15,734,632 |
99.5% |
19.7% |
70.1% |
26,795 |
552,194 |
|
113,117 |
465,872 |
2.1% |
4,244,001 |
18.9% |
| 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)
|
122,401 |
0.5% |
0.1% |
86,686 |
0.5% |
0.1% |
70.8% |
0 |
0 |
0 |
0 |
0 |
0.0% |
25,115 |
20.5% |
| 6. Total Medicare (Lines 4 +
5a + 5b) |
22,577,271 |
100.0% |
14.9% |
15,821,318 |
100.0% |
19.9% |
70.1% |
26,795 |
552,194 |
0 |
113,117 |
465,872 |
2.1% |
4,269,116 |
18.9% |
| 7. Other Public including Non-Medicaid
CHIP (Non Managed Care) |
1,452,820 |
100.0% |
1.0% |
885,750 |
100.0% |
1.1% |
61.0% |
|
|
|
0 |
0 |
0.0% |
488,273 |
33.6% |
| 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) |
1,452,820 |
100.0% |
1.0% |
885,750 |
100.0% |
1.1% |
61.0% |
|
|
0 |
0 |
0 |
0.0% |
488,273 |
33.6% |
| 10. Private Non-Managed Care |
21,463,323 |
96.8% |
14.1% |
12,090,795 |
97.0% |
15.2% |
56.3% |
|
|
|
0 |
0 |
|
6,590,271 |
30.7% |
| 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)
|
707,972 |
3.2% |
0.5% |
377,219 |
3.0% |
0.5% |
53.3% |
|
|
0 |
0 |
0 |
0.0% |
330,563 |
46.7% |
| 12. Total Private (Lines 10
+ 11a + 11b) |
22,171,295 |
100.0% |
14.6% |
12,468,014 |
100.0% |
15.6% |
56.2% |
|
|
0 |
0 |
0 |
0.0% |
6,920,834 |
31.2% |
| 13. Self-Pay |
66,544,897 |
100.0% |
43.8% |
19,651,799 |
100.0% |
24.7% |
29.5% |
|
|
|
|
|
|
|
|
| 14. Total (Lines 3 + 6 + 9 +
12 + 13) |
151,768,544 |
|
100.0% |
79,693,353 |
|
100.0% |
52.5% |
26,795 |
2,155,645 |
0 |
113,117 |
2,069,323 |
1.4% |
18,787,545 |
12.4% |
|
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) |
42,486,642 |
63.8% |
4,579,090 |
6.9% |
data as of: 7/22/2008 3:38:37
|
