|
|
 |
|
|
TABLE 9D: PATIENT RELATED REVENUE (Scope of Project Only)
State Summary for Arizona for 2007
14 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 |
1,930,901 |
2.0% |
0.9% |
1,336,818 |
1.6% |
1.0% |
69.2% |
170,874 |
74,928 |
|
0 |
245,802 |
12.7% |
459,223 |
23.8% |
| 2a. Medicaid Managed Care (capitated)
|
22,811,057 |
23.7% |
10.5% |
18,161,128 |
22.0% |
13.3% |
79.6% |
4,564,997 |
2,336,296 |
0 |
127,989 |
6,773,304 |
29.7% |
4,492,793 |
19.7% |
| 2b. Medicaid Managed Care (fee-for-service)
|
71,653,676 |
74.3% |
33.0% |
63,215,331 |
76.4% |
46.4% |
88.2% |
17,077,259 |
5,023,284 |
12,484 |
164,599 |
21,948,428 |
30.6% |
12,372,910 |
17.3% |
| 3. Total Medicaid (Lines 1 +
2a + 2b) |
96,395,634 |
100.0% |
44.4% |
82,713,277 |
100.0% |
60.7% |
85.8% |
21,813,130 |
7,434,508 |
12,484 |
292,588 |
28,967,534 |
30.1% |
17,324,926 |
18.0% |
| 4. Medicare Non-Managed Care |
15,254,023 |
85.5% |
7.0% |
10,268,777 |
82.9% |
7.5% |
67.3% |
84,882 |
230,503 |
|
0 |
315,385 |
2.1% |
4,729,034 |
31.0% |
| 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)
|
2,583,510 |
14.5% |
1.2% |
2,124,875 |
17.1% |
1.6% |
82.2% |
0 |
107,108 |
0 |
0 |
107,108 |
4.1% |
148,330 |
5.7% |
| 6. Total Medicare (Lines 4 +
5a + 5b) |
17,837,533 |
100.0% |
8.2% |
12,393,652 |
100.0% |
9.1% |
69.5% |
84,882 |
337,611 |
0 |
0 |
422,493 |
2.4% |
4,877,364 |
27.3% |
| 7. Other Public including Non-Medicaid
CHIP (Non Managed Care) |
296,201 |
5.5% |
0.1% |
71,673 |
2.4% |
0.1% |
24.2% |
|
|
|
0 |
0 |
0.0% |
239,093 |
80.7% |
| 8a. Other Public including Non-Medicaid
CHIP (Managed Care Capitated) |
4,839,359 |
90.0% |
2.2% |
2,804,317 |
92.3% |
2.1% |
57.9% |
|
|
0 |
0 |
0 |
0.0% |
2,035,042 |
42.1% |
| 8b. Other Public including Non-Medicaid
CHIP (Managed Care fee-for-service) |
241,829 |
4.5% |
0.1% |
163,430 |
5.4% |
0.1% |
67.6% |
|
|
0 |
0 |
0 |
0.0% |
43,249 |
17.9% |
| 9. Total Other Public (Lines
7 + 8a + 8b) |
5,377,389 |
100.0% |
2.5% |
3,039,420 |
100.0% |
2.2% |
56.5% |
|
|
0 |
0 |
0 |
0.0% |
2,317,384 |
43.1% |
| 10. Private Non-Managed Care |
31,297,820 |
84.1% |
14.4% |
17,717,920 |
84.8% |
13.0% |
56.6% |
|
|
|
0 |
0 |
|
13,289,520 |
42.5% |
| 11a. Private Managed Care (capitated)
|
923,637 |
2.5% |
0.4% |
541,151 |
2.6% |
0.4% |
58.6% |
|
|
0 |
0 |
0 |
0.0% |
382,486 |
41.4% |
| 11b. Private Managed Care (fee-for-service)
|
4,992,606 |
13.4% |
2.3% |
2,622,457 |
12.6% |
1.9% |
52.5% |
|
|
0 |
0 |
0 |
0.0% |
2,474,251 |
49.6% |
| 12. Total Private (Lines 10
+ 11a + 11b) |
37,214,063 |
100.0% |
17.1% |
20,881,528 |
100.0% |
15.3% |
56.1% |
|
|
0 |
0 |
0 |
0.0% |
16,146,257 |
43.4% |
| 13. Self-Pay |
60,420,297 |
100.0% |
27.8% |
17,246,579 |
100.0% |
12.7% |
28.5% |
|
|
|
|
|
|
|
|
| 14. Total (Lines 3 + 6 + 9 +
12 + 13) |
217,244,916 |
|
100.0% |
136,274,456 |
|
100.0% |
62.7% |
21,898,012 |
7,772,119 |
12,484 |
292,588 |
29,390,027 |
13.5% |
40,665,931 |
18.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) |
36,902,204 |
61.1% |
4,738,439 |
7.8% |
data as of: 7/22/2008 11:07:28
|
