|
|
 |
|
|
TABLE 9D: PATIENT RELATED REVENUE (Scope of Project Only)
State Summary for Texas for 2007
58 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 |
73,117,959 |
69.5% |
17.9% |
74,579,925 |
79.2% |
41.6% |
102.0% |
2,026,432 |
532,312 |
|
0 |
2,558,744 |
3.5% |
-4,713,987 |
- 6.4% |
| 2a. Medicaid Managed Care (capitated)
|
573,202 |
0.5% |
0.1% |
258,238 |
0.3% |
0.1% |
45.1% |
8,860 |
5,174 |
0 |
0 |
14,034 |
2.4% |
158,676 |
27.7% |
| 2b. Medicaid Managed Care (fee-for-service)
|
31,515,841 |
30.0% |
7.7% |
19,387,001 |
20.6% |
10.8% |
61.5% |
6,880,795 |
2,143,689 |
32,053 |
27,901 |
9,028,636 |
28.6% |
8,087,567 |
25.7% |
| 3. Total Medicaid (Lines 1 +
2a + 2b) |
105,207,002 |
100.0% |
25.8% |
94,225,164 |
100.0% |
52.6% |
89.6% |
8,916,087 |
2,681,175 |
32,053 |
27,901 |
11,601,414 |
11.0% |
3,532,256 |
3.4% |
| 4. Medicare Non-Managed Care |
28,183,980 |
98.8% |
6.9% |
20,549,844 |
98.9% |
11.5% |
72.9% |
76,165 |
406,799 |
|
28,470 |
454,494 |
1.6% |
5,633,400 |
20.0% |
| 5a. Medicare Managed Care (capitated)
|
297,856 |
1.0% |
0.1% |
221,125 |
1.1% |
0.1% |
74.2% |
0 |
0 |
0 |
0 |
0 |
0.0% |
78,071 |
26.2% |
| 5b. Medicare Managed Care (fee-for-service)
|
56,830 |
0.2% |
0.0% |
4,605 |
0.0% |
0.0% |
8.1% |
0 |
0 |
0 |
0 |
0 |
0.0% |
9,816 |
17.3% |
| 6. Total Medicare (Lines 4 +
5a + 5b) |
28,538,666 |
100.0% |
7.0% |
20,775,574 |
100.0% |
11.6% |
72.8% |
76,165 |
406,799 |
0 |
28,470 |
454,494 |
1.6% |
5,721,287 |
20.0% |
| 7. Other Public including Non-Medicaid
CHIP (Non Managed Care) |
22,767,484 |
82.4% |
5.6% |
6,261,279 |
80.5% |
3.5% |
27.5% |
|
|
|
0 |
0 |
0.0% |
12,562,321 |
55.2% |
| 8a. Other Public including Non-Medicaid
CHIP (Managed Care Capitated) |
3,372 |
0.0% |
0.0% |
300 |
0.0% |
0.0% |
8.9% |
|
|
0 |
0 |
0 |
0.0% |
0 |
0.0% |
| 8b. Other Public including Non-Medicaid
CHIP (Managed Care fee-for-service) |
4,851,183 |
17.6% |
1.2% |
1,516,280 |
19.5% |
0.8% |
31.3% |
|
|
0 |
0 |
0 |
0.0% |
2,630,729 |
54.2% |
| 9. Total Other Public (Lines
7 + 8a + 8b) |
27,622,039 |
100.0% |
6.8% |
7,777,859 |
100.0% |
4.3% |
28.2% |
|
|
0 |
0 |
0 |
0.0% |
15,193,050 |
55.0% |
| 10. Private Non-Managed Care |
24,053,645 |
93.4% |
5.9% |
9,943,247 |
93.4% |
5.5% |
41.3% |
|
|
|
0 |
0 |
|
11,184,376 |
46.5% |
| 11a. Private Managed Care (capitated)
|
9,316 |
0.0% |
0.0% |
3,092 |
0.0% |
0.0% |
33.2% |
|
|
0 |
0 |
0 |
0.0% |
4,819 |
51.7% |
| 11b. Private Managed Care (fee-for-service)
|
1,699,911 |
6.6% |
0.4% |
701,584 |
6.6% |
0.4% |
41.3% |
|
|
0 |
0 |
0 |
0.0% |
701,736 |
41.3% |
| 12. Total Private (Lines 10
+ 11a + 11b) |
25,762,872 |
100.0% |
6.3% |
10,647,923 |
100.0% |
5.9% |
41.3% |
|
|
0 |
0 |
0 |
0.0% |
11,890,931 |
46.2% |
| 13. Self-Pay |
220,286,061 |
100.0% |
54.1% |
45,831,761 |
100.0% |
25.6% |
20.8% |
|
|
|
|
|
|
|
|
| 14. Total (Lines 3 + 6 + 9 +
12 + 13) |
407,416,640 |
|
100.0% |
179,258,281 |
|
100.0% |
44.0% |
8,992,252 |
3,087,974 |
32,053 |
56,371 |
12,055,908 |
3.0% |
36,337,524 |
8.9% |
|
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) |
147,898,495 |
67.1% |
24,426,534 |
11.1% |
data as of: 7/22/2008 4:15:25
|
