Get documents about "Total Claims Pending
Document Sample
Department of Mental Health
Local Assistance Claims Pending Receipt of FFP for FFY 2005
and Total Amounts for All FFY
as of May 30, 2008
Page 1 of 16
FFY Claim # Total Alameda Alpine Amador Butte Calaveras Colusa Contra Costa Del Norte El Dorado Fresno Glenn Humboldt Imperial Inyo Kern Kings
2005 2706074 LA 8,190,999.99
2005 2706169 LA 81,905.02
2005 2706358 LA 1,206,536.32
2005 2706414 LA 97,902.60
9,577,343.93 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 Crosscheck
Total Alameda Alpine Amador Butte Calaveras Colusa Contra Costa Del Norte El Dorado Fresno Glenn Humboldt Imperial Inyo Kern Kings
Total All FFY 190,122,368.48 12,552,373.09 2,035.81 4,793.21 102,223.19 371.46 17,261.41 3,375,288.50 20,008.07 138,588.11 1,127,199.88 30,749.79 103,708.21 427,570.23 1,274.94 2,504,936.85 427,693.09
0.00 Crosscheck
Spreadsheet identifies claim schedules pending submission to the State Controller's Office for the 2005 Funding Fiscal Year (FFY) and in total for all open FFY.
Detail includes Funding Fiscal year, claim schedule, and amount by county.
Department of Mental Health
Local Assistance Claims Pending Receipt of FFP for FFY 2005
and Total Amounts for All FFY
as of May 30, 2008
Page 2 of 16
FFY Claim # Total Lake Lassen Los Angeles Madera Marin Mariposa Mendocino Merced Modoc Mono Monterey Napa Nevada Orange Placer Plumas
2005 2706074 LA 8,190,999.99 8,190,999.99
2005 2706169 LA 81,905.02 81,905.02
2005 2706358 LA 1,206,536.32 1,206,536.32
2005 2706414 LA 97,902.60 97,902.60
9,577,343.93 0.00 0.00 9,577,343.93 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00
Total Lake Lassen Los Angeles Madera Marin Mariposa Mendocino Merced Modoc Mono Monterey Napa Nevada Orange Placer Plumas
Total All FFY 190,122,368.48 26,645.96 5,879.92 153,420,355.76 1,325.61 183,448.30 0.00 1,190,066.39 29,335.49 18,598.92 1,488.89 79,797.77 120,167.19 87,431.14 1,755,637.76 3,229.75 3,920.84
0.00
Department of Mental Health
Local Assistance Claims Pending Receipt of FFP for FFY 2005
and Total Amounts for All FFY
as of May 30, 2008
Page 3 of 16
FFY Claim # Total Riverside Sacramento San Benito San Bernardino San Diego San Francisco San Joaquin San Luis Obispo San Mateo Santa Barbara Santa Clara Santa Cruz Shasta
2005 2706074 LA 8,190,999.99
2005 2706169 LA 81,905.02
2005 2706358 LA 1,206,536.32
2005 2706414 LA 97,902.60
9,577,343.93 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00
Total Riverside Sacramento San Benito San Bernardino San Diego San Francisco San Joaquin San Luis Obispo San Mateo Santa Barbara Santa Clara Santa Cruz Shasta
Total All FFY 190,122,368.48 607,083.90 119,039.80 31,479.73 1,288,549.68 1,247,318.90 587,503.24 486,966.12 624,087.67 473,705.57 1,709,759.17 1,905,412.81 126,070.08 49,710.74
0.00
Department of Mental Health
Local Assistance Claims Pending Receipt of FFP for FFY 2005
and Total Amounts for All FFY
as of May 30, 2008
Page 4 of 16
FFY Claim # Total Sierra Siskiyou Solano Sonoma Stanislaus Sutter/Yuba Tehama Trinity Tulare Tuolumne Ventura Yolo Yuba
2005 2706074 LA 8,190,999.99
2005 2706169 LA 81,905.02
2005 2706358 LA 1,206,536.32
2005 2706414 LA 97,902.60
9,577,343.93 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00
Total Sierra Siskiyou Solano Sonoma Stanislaus Sutter/Yuba Tehama Trinity Tulare Tuolumne Ventura Yolo Yuba
Total All FFY 190,122,368.48 0.00 871,673.39 687,657.21 39,378.83 120,616.50 313,194.70 77,166.33 3,256.40 588,710.52 546.79 94,440.94 305,633.93 0.00
0.00
Department of Mental Health
Local Assistance Claims Invoiced to Department of Health Care Services
Claims Pending Receipt of FFP for FFY 2006
as of May 30, 2008
Page 5 of 16
FFY Program Claim # Total Alameda Alpine Amador Butte Calaveras Colusa Contra Costa Del Norte El Dorado Fresno Glenn Humboldt Imperial Inyo Kern Kings
2006 2706002 60,112,891.50
2006 2706031 5,777,566.49
2006 2706061 5,419,365.38
2006 2706063 1,154,609.03
2006 2706081 617,687.51
2006 2706092 711,870.46
2006 2706108 441,564.09
2006 2706119 976,867.03
2006 2706144 14,117,908.44
2006 2706159 1,966,491.47
2006 2706166 100,015.65
2006 2706173 167,881.08
2006 2706189 273,940.25
2006 2706199 158,774.20
2006 Title 21 - MCHIP 2706242 4,305.93 860.84 440.42
2006 Healthy Fam 2706265 2,308.43
2006 Title 21 - MCHIP 2706267 2,864.43 254.48
2006 Title 21 - MCHIP 2706290 437.29 260.00 177.29
2006 Ben Services 2706306 275,928.47 497.87 626.41 520.66 70.80 12,354.00 15,766.15 53,524.23
2006 Healthy Fam 2706310 29,905.95 2,576.05
2006 Title 21 - MCHIP 2706312 246.19 85.31
2006 Healthy Fam 2706332 7,949.30 228.41 2,102.78
2006 Title 21 - MCHIP 2706336 816.82
2006 Healthy Fam 2706353 4,158.61
2006 Title 21 - MCHIP 2706365 1,318.00 500.76
2006 Healthy Fam 2706373 4,249.08 79.76
2006 MAA 2706380 9,532,231.13 7,560,477.85 493,170.74
2006 Ben Services 2706396 139,276.80 8,399.61 2,696.23
2006 Healthy Fam 2706398 139.91 139.91
Total 2006 Claims Pending FFP 102,003,568.92 7,570,104.50 626.41 0.00 1,641.50 70.80 0.00 0.00 15,190.14 0.00 508,936.89 0.00 56,185.59 0.00 79.76 2,797.68 177.29
0.00 crosscheck
Check to be returned to DMH Spreadsheet identifies claim schedules pending receipt of Federal Financial Participation (FFP) from the Department of Health Care Services.
for offset of Accts Receivable Detail includes Funding Fiscal Year (FFY), DMH claim schedule number, and amount by county.
The column identifying the related Federal program is a recent addition to the detail maintained within this spreadsheet. Federal programs have not been identified for each claim.
Green shaded amounts identify amounts which will be returned to DMH to collect various amount due from counties (e.g. cost settlements or audits).
Department of Mental Health
Local Assistance Claims Invoiced to Department of Health Care Services
Claims Pending Receipt of FFP for FFY 2006
as of May 30, 2008
Page 6 of 16
FFY Program Claim # Total Lake Lassen Los Angeles Madera Marin Mariposa Mendocino Merced Modoc Mono Monterey Napa Nevada Orange Placer Plumas
2006 2706002 60,112,891.50 60,112,891.50
2006 2706031 5,777,566.49 5,777,566.49
2006 2706061 5,419,365.38 5,419,365.38
2006 2706063 1,154,609.03 1,154,609.03
2006 2706081 617,687.51 617,687.51
2006 2706092 711,870.46 711,870.46
2006 2706108 441,564.09 441,564.09
2006 2706119 976,867.03 976,867.03
2006 2706144 14,117,908.44 14,117,908.44
2006 2706159 1,966,491.47 1,966,491.47
2006 2706166 100,015.65 100,015.65
2006 2706173 167,881.08 167,881.08
2006 2706189 273,940.25 273,940.25
2006 2706199 158,774.20 158,774.20
2006 Title 21 - MCHIP 2706242 4,305.93
2006 Healthy Fam 2706265 2,308.43
2006 Title 21 - MCHIP 2706267 2,864.43
2006 Title 21 - MCHIP 2706290 437.29
2006 Ben Services 2706306 275,928.47 16,007.87 12,446.75 4,055.36 374.15
2006 Healthy Fam 2706310 29,905.95
2006 Title 21 - MCHIP 2706312 246.19
2006 Healthy Fam 2706332 7,949.30 4,717.99
2006 Title 21 - MCHIP 2706336 816.82 376.63
2006 Healthy Fam 2706353 4,158.61
2006 Title 21 - MCHIP 2706365 1,318.00 817.24
2006 Healthy Fam 2706373 4,249.08 4,169.32
2006 MAA 2706380 9,532,231.13 62,597.92 569,602.08
2006 Ben Services 2706396 139,276.80 663.73
2006 Healthy Fam 2706398 139.91
Total 2006 Claims Pending FFP 102,003,568.92 0.00 0.00 91,997,432.58 0.00 0.00 0.00 4,986.56 16,007.87 0.00 0.00 17,541.37 62,597.92 0.00 574,321.17 0.00 374.15
0.00
Check to be returned to DMH
for offset of Accts Receivable
Department of Mental Health
Local Assistance Claims Invoiced to Department of Health Care Services
Claims Pending Receipt of FFP for FFY 2006
as of May 30, 2008
Page 7 of 16
FFY Program Claim # Total Riverside Sacramento San Benito San Bernardino San Diego San Francisco San Joaquin San Luis Obispo San Mateo Santa Barbara Santa Clara Santa Cruz Shasta Sierra
2006 2706002 60,112,891.50
2006 2706031 5,777,566.49
2006 2706061 5,419,365.38
2006 2706063 1,154,609.03
2006 2706081 617,687.51
2006 2706092 711,870.46
2006 2706108 441,564.09
2006 2706119 976,867.03
2006 2706144 14,117,908.44
2006 2706159 1,966,491.47
2006 2706166 100,015.65
2006 2706173 167,881.08
2006 2706189 273,940.25
2006 2706199 158,774.20
2006 Title 21 - MCHIP 2706242 4,305.93 85.02 48.75 411.75 676.61 1,106.73 330.82
2006 Healthy Fam 2706265 2,308.43 2,308.43
2006 Title 21 - MCHIP 2706267 2,864.43 149.50
2006 Title 21 - MCHIP 2706290 437.29
2006 Ben Services 2706306 275,928.47 5,042.12 23,693.45 20,532.82 17,590.97 21,002.66
2006 Healthy Fam 2706310 29,905.95 6,804.98
2006 Title 21 - MCHIP 2706312 246.19 160.88
2006 Healthy Fam 2706332 7,949.30 900.12
2006 Title 21 - MCHIP 2706336 816.82 299.20
2006 Healthy Fam 2706353 4,158.61 3,317.59 319.41
2006 Title 21 - MCHIP 2706365 1,318.00
2006 Healthy Fam 2706373 4,249.08
2006 MAA 2706380 9,532,231.13 382,291.03 242,018.44 222,073.07
2006 Ben Services 2706396 139,276.80 832.69 76.07 440.83 124,933.91
2006 Healthy Fam 2706398 139.91
Total 2006 Claims Pending FFP 102,003,568.92 85.02 5,090.87 832.69 2,796.25 1,348.82 386,726.06 0.00 1,106.73 272,836.28 20,693.70 364,928.77 21,002.66 0.00 0.00
0.00
Check to be returned to DMH
for offset of Accts Receivable
Department of Mental Health
Local Assistance Claims Invoiced to Department of Health Care Services
Claims Pending Receipt of FFP for FFY 2006
as of May 30, 2008
Page 8 of 16
FFY Program Claim # Total Siskiyou Solano Sonoma Stanislaus Sutter/Yuba Tehama Trinity Tulare Tuolumne Ventura Yolo Yuba
2006 2706002 60,112,891.50
2006 2706031 5,777,566.49
2006 2706061 5,419,365.38
2006 2706063 1,154,609.03
2006 2706081 617,687.51
2006 2706092 711,870.46
2006 2706108 441,564.09
2006 2706119 976,867.03
2006 2706144 14,117,908.44
2006 2706159 1,966,491.47
2006 2706166 100,015.65
2006 2706173 167,881.08
2006 2706189 273,940.25
2006 2706199 158,774.20
2006 Title 21 - MCHIP 2706242 4,305.93 344.99
2006 Healthy Fam 2706265 2,308.43
2006 Title 21 - MCHIP 2706267 2,864.43 62.40 2,398.05
2006 Title 21 - MCHIP 2706290 437.29
2006 Ben Services 2706306 275,928.47 3,733.12 84.35 53,216.87 166.40 379.52 14,241.94
2006 Healthy Fam 2706310 29,905.95 20,079.18 445.74
2006 Title 21 - MCHIP 2706312 246.19
2006 Healthy Fam 2706332 7,949.30
2006 Title 21 - MCHIP 2706336 816.82 140.99
2006 Healthy Fam 2706353 4,158.61 521.61
2006 Title 21 - MCHIP 2706365 1,318.00
2006 Healthy Fam 2706373 4,249.08
2006 MAA 2706380 9,532,231.13
2006 Ben Services 2706396 139,276.80 1,233.73
2006 Healthy Fam 2706398 139.91
Total 2006 Claims Pending FFP 102,003,568.92 3,733.12 84.35 407.39 73,296.05 688.01 1,613.25 0.00 14,687.68 0.00 2,539.04 0.00 0.00
0.00
Check to be returned to DMH
for offset of Accts Receivable
Department of Mental Health
Local Assistance Claims Invoiced to Department of Health Care Services
Claims Pending Receipt of FFP for FFY 2007
as of May 30, 2008
Page 9 of 16
FFY Program Claim # Total Alameda Alpine Amador Butte Calaveras Colusa Contra Costa Del Norte El Dorado Fresno Glenn Humboldt Imperial Inyo Kern Kings
2007 2706160 15,047,032.85
2007 2706167 5,653,474.78
2007 2706174 7,408,085.22
2007 2706183 4,579,974.56
2007 2706190 16,026,804.13
2007 2706200 3,130,207.71
2007 Title 21-MCHIP 2706244 433,159.99 941.56 18,944.22 300.66 1,401.00 21,710.84 14,823.27 8,323.69 12,625.17 10,168.24 2,464.18 1,014.90 20,745.33
2007 Title 21 - MCHIP 2706268 205,342.62 5,970.58 327.14 7,110.88 85.80
2007 Title 21 - MCHIP 2706291 77,842.04 20,165.99 837.91 821.14 3,652.69 16,872.89
2007 Healthy Fam 2706311 530,666.94 11,339.27 7,368.41 8,233.91 13,991.85 110.45 23,937.16 185.17
2007 Title 21 MCHIP 2706313 197,095.81 22,146.15 2,279.34 1,841.62 7,590.61 788.51 3,289.13 203.58
2007 Healthy Fam 2706333 210,203.96 4,409.68 15,223.63 1,747.38 6,542.20 154.48 635.62 19,265.44
2007 Title 21 - MCHIP 2706337 171,561.03 2,284.89 16,328.05 1,540.96 883.91 7,142.99 254.48 1,825.02
2007 MHP UR 2706344 4,968,092.00 308,719.56 99,365.93 409,616.50
2007 Healthy Fam 2706354 137,022.20 1,524.38 4,447.80 24.70 11,792.98
2007 Title 21 - MCHIP 2706357 71,709.47 50.51 347.79 5,583.01 8,292.47 1,173.07
2007 Title 21 - MCHIP 2706366 99,242.08 237.52 506.15 10,293.52 7,508.55 94.48 1,106.12
2007 Healthy Fam 2706374 207,094.62 130.63 20,396.43 3,350.71 3,324.89 107,419.24
2007 MHP Admin 2706384 5,303,354.60 933,455.77 127,481.00 35,478.60
2007 Beneficiary Serv 2706397 12,788,576.11 4,873,722.12 1,409.40 3,266.34 48,164.65 2,081,923.68 1,435.35 9,698.13 366,374.10 2,342,786.44 329,560.49
2007 Healthy Fam 2706399 85,005.77 23,107.96 398.68 3,708.63 27,971.46 356.27 18,619.65
2007 Title 21 - MCHIP 2706400 104,010.78 30,212.21 291.20 11,004.54 3,534.20 12,184.95 871.00
2007 Refugee 2706401 1,072.00
2007 MHP UR 2706409 396,098.00
2007 MHP UR 2706410 708,726.36 28,160.00 8,929.55
Total 2007 Claims Pending FFP 78,541,455.63 4,982,268.59 1,409.40 4,793.21 100,581.69 300.66 17,261.41 3,375,288.50 4,817.93 138,588.11 618,262.99 30,749.79 47,522.62 427,570.23 1,195.18 2,502,139.17 427,515.80
0.00 crosscheck
Check to be returned to DMH Spreadsheet identifies claim schedules pending receipt of Federal Financial Participation (FFP) from the Department of Health Care Services.
for offset of Accts Receivable Detail includes Funding Fiscal Year (FFY), DMH claim schedule number, and amount by county.
The column identifying the related Federal program is a recent addition to the detail maintained within this spreadsheet. Federal programs have not been identified for each claim.
Green shaded amounts identify amounts which will be returned to DMH to collect various amount due from counties (e.g. cost settlements or audits).
Department of Mental Health
Local Assistance Claims Invoiced to Department of Health Care Services
Claims Pending Receipt of FFP for FFY 2007
as of May 30, 2008
Page 10 of 16
FFY Program Claim # Total Lake Lassen Los Angeles Madera Marin Mariposa Mendocino Merced Modoc Mono Monterey Napa Nevada Orange Placer Plumas
2007 2706160 15,047,032.85 15,047,032.85
2007 2706167 5,653,474.78 5,653,474.78
2007 2706174 7,408,085.22 7,408,085.22
2007 2706183 4,579,974.56 4,579,974.56
2007 2706190 16,026,804.13 16,026,804.13
2007 2706200 3,130,207.71 3,130,207.71
2007 Title 21-MCHIP 2706244 433,159.99 3,956.16 3,487.54 715.00 473.98 4,251.51 790.07 38,731.72 47.32 870.99
2007 Title 21 - MCHIP 2706268 205,342.62 85.80 803.92 1,228.11 6,584.34 1,753.73 7,877.43
2007 Title 21 - MCHIP 2706291 77,842.04 2,755.62 8,685.60
2007 Healthy Fam 2706311 530,666.94 206.31 439.13 159.12
2007 Title 21 MCHIP 2706313 197,095.81 763.62 745.03 14,816.69 1,943.12
2007 Healthy Fam 2706333 210,203.96 17,760.01 45,787.97 9,220.79 2,682.57 1.18
2007 Title 21 - MCHIP 2706337 171,561.03 5,680.25 4,706.07 2,330.02 6,041.79 1,079.01 2,675.70
2007 MHP UR 2706344 4,968,092.00 76,536.62 56,635.06 73,336.53 581,371.17
2007 Healthy Fam 2706354 137,022.20 10,376.42 8,736.24 1,497.08
2007 Title 21 - MCHIP 2706357 71,709.47 911.30 16,046.41 3,363.27 3,063.89
2007 Title 21 - MCHIP 2706366 99,242.08 2,596.18 305.76 476.19 2,887.17 269.88 931.81 5,562.69
2007 Healthy Fam 2706374 207,094.62 6,667.78 387.62
2007 MHP Admin 2706384 5,303,354.60 19,182.32 76,424.34 2.40 245,505.91
2007 Beneficiary Serv 2706397 12,788,576.11 1,123,821.13 18,598.92 261,092.29
2007 Healthy Fam 2706399 85,005.77 4,274.13 720.20
2007 Title 21 - MCHIP 2706400 104,010.78 20,291.79 2,489.01
2007 Refugee 2706401 1,072.00 1,072.00
2007 MHP UR 2706409 396,098.00
2007 MHP UR 2706410 708,726.36 5,574.16
Total 2007 Claims Pending FFP 78,541,455.63 26,645.96 5,879.92 51,845,579.25 1,325.61 183,448.30 0.00 1,185,079.83 13,327.62 18,598.92 1,488.89 62,256.40 57,569.27 87,431.14 1,181,316.59 3,229.75 3,546.69
0.00
Check to be returned to DMH
for offset of Accts Receivable
Green shaded amounts identify amounts which will be returned to DMH to collect various amount due from counties (e.g. cost settlements or audits).
Department of Mental Health
Local Assistance Claims Invoiced to Department of Health Care Services
Claims Pending Receipt of FFP for FFY 2007
as of May 30, 2008
Page 11 of 16
FFY Program Claim # Total Riverside Sacramento San Benito San Bernardino San Diego San Francisco San Joaquin San Luis Obispo San Mateo Santa Barbara Santa Clara Santa Cruz Shasta Sierra
2007 2706160 15,047,032.85
2007 2706167 5,653,474.78
2007 2706174 7,408,085.22
2007 2706183 4,579,974.56
2007 2706190 16,026,804.13
2007 2706200 3,130,207.71
2007 Title 21-MCHIP 2706244 433,159.99 161.85 30,674.28 845.26 25,619.62 64,184.52 12,425.68 8,875.24 13,546.12 13,836.35 4,602.23 18,085.04 3,714.38
2007 Title 21 - MCHIP 2706268 205,342.62 22,565.07 22,996.69 59,850.02 96.72 21,320.97 5,526.97
2007 Title 21 - MCHIP 2706291 77,842.04 4,988.05 10,524.42 3,335.41 2,771.49
2007 Healthy Fam 2706311 530,666.94 6,444.27 130,094.67 650.13 52,232.02 12,785.14 71,354.91 22,295.39
2007 Title 21 MCHIP 2706313 197,095.81 31,019.31 17,629.16 2,656.16 9,570.16 2,640.45 15,627.47 17,572.12
2007 Healthy Fam 2706333 210,203.96 196.35 16,417.23 21,681.34 3,447.31 290.16 157.46
2007 Title 21 - MCHIP 2706337 171,561.03 905.48 27,292.57 63,276.85 9,151.58 470.48
2007 MHP UR 2706344 4,968,092.00 390,737.50 1,167,934.27 543,373.75 624,786.83
2007 Healthy Fam 2706354 137,022.20 33,660.11 916.75 165.49 849.90 45,265.22 4,891.43
2007 Title 21 - MCHIP 2706357 71,709.47 13,390.35 882.98 7,062.47 7,859.90
2007 Title 21 - MCHIP 2706366 99,242.08 45,348.98 294.77 17,243.81 1,742.01 504.17
2007 Healthy Fam 2706374 207,094.62 462.09 929.92 412.85 40,443.65 16,287.02 2,695.73
2007 MHP Admin 2706384 5,303,354.60 485,613.17 461,866.14 617,992.89 1,244,250.21 493,686.59
2007 Beneficiary Serv 2706397 12,788,576.11 25,554.50 7,069.03 7,140.53 40,530.95 319.56 164.94 361,579.42
2007 Healthy Fam 2706399 85,005.77 1,218.95
2007 Title 21 - MCHIP 2706400 104,010.78 121.03
2007 Refugee 2706401 1,072.00
2007 MHP UR 2706409 396,098.00
2007 MHP UR 2706410 708,726.36 146,484.00 16,626.73 4,981.42 409,493.00
Total 2007 Claims Pending FFP 78,541,455.63 606,998.88 113,948.93 30,647.04 1,285,753.43 1,245,970.08 200,777.18 486,966.12 622,980.94 200,869.29 1,689,065.47 1,540,484.04 105,067.42 49,710.74 0.00
0.00
Check to be returned to DMH
for offset of Accts Receivable
Green shaded amounts identify amounts which will be returned to DMH to collect various amount due from counties (e.g. cost settlements or audits).
Department of Mental Health
Local Assistance Claims Invoiced to Department of Health Care Services
Claims Pending Receipt of FFP for FFY 2007
as of May 30, 2008
Page 12 of 16
FFY Program Claim # Total Siskiyou Solano Sonoma Stanislaus Sutter/Yuba Tehama Trinity Tulare Tuolumne Ventura Yolo Yuba
2007 2706160 15,047,032.85
2007 2706167 5,653,474.78
2007 2706174 7,408,085.22
2007 2706183 4,579,974.56
2007 2706190 16,026,804.13
2007 2706200 3,130,207.71
2007 Title 21-MCHIP 2706244 433,159.99 16,748.79 5,265.07 6,124.92 6,564.13 5,884.40 685.99 440.48 17,385.90 546.79 7,743.70 2,411.90
2007 Title 21 - MCHIP 2706268 205,342.62 7,277.30 2,025.79 1,036.18 20,593.50 10,225.68
2007 Title 21 - MCHIP 2706291 77,842.04 459.89 1,970.94
2007 Healthy Fam 2706311 530,666.94 3,292.38 32,101.01 4,804.47 125,488.62 3,153.15
2007 Title 21 MCHIP 2706313 197,095.81 14,993.11 6,949.06 773.41 1,763.75 18,070.38 1,423.87
2007 Healthy Fam 2706333 210,203.96 11,467.66 29,360.66 948.09 2,806.75
2007 Title 21 - MCHIP 2706337 171,561.03 8,603.07 1,460.07 375.96 773.06 6,478.77
2007 MHP UR 2706344 4,968,092.00 148,289.03 120,706.25 366,683.00
2007 Healthy Fam 2706354 137,022.20 12,873.70
2007 Title 21 - MCHIP 2706357 71,709.47 2,128.11 279.11 1,274.83
2007 Title 21 - MCHIP 2706366 99,242.08 854.99 477.33
2007 Healthy Fam 2706374 207,094.62 4,186.06
2007 MHP Admin 2706384 5,303,354.60 144,372.07 138,155.51 298.27 279,589.41
2007 Beneficiary Serv 2706397 12,788,576.11 514,891.74 74,389.76 295,082.64
2007 Healthy Fam 2706399 85,005.77 4,629.84
2007 Title 21 - MCHIP 2706400 104,010.78 20,723.31 2,287.54
2007 Refugee 2706401 1,072.00
2007 MHP UR 2706409 396,098.00 396,098.00
2007 MHP UR 2706410 708,726.36 23,830.50 64,647.00
Total 2007 Claims Pending FFP 78,541,455.63 867,940.27 687,572.86 38,971.44 47,320.45 312,506.69 75,553.08 3,256.40 574,022.84 546.79 91,901.90 305,633.93 0.00
0.00
Check to be returned to DMH
for offset of Accts Receivable
Green shaded amounts identify amounts which will be returned to DMH to collect various amount due from counties (e.g. cost settlements or audits).
Department of Mental Health
Claims Sent to and Paid by State Controller
May 2008
as of May 30, 2008
Page 13 of 16
FFY Program Claim # SCO Date Paid Date Total Alameda Alpine Amador Butte Calaveras Colusa Contra Costa Del Norte El Dorado Fresno Glenn Humboldt Imperial Inyo Kern Kings Lake
2007 Healthy Fam 2706241 5/13/2008 5/16/2008 765,240.43 25,025.82 9,676.72 1,447.60 16,098.77 15,371.01 2,084.79 28,102.56 300.30 59,179.35
2007 Healthy Fam 2706266 5/13/2008 5/16/2008 392,517.16 34.84 2,181.39 1,043.35 2,512.96 412.46 558.58
2007 Healthy Fam 2706289 5/13/2008 5/16/2008 258,553.67 36,692.24 2,210.47 268.91 13,768.23 811.72 85,081.39
2006 Healthy Fam 2706239 5/13/2008 5/16/2008 22,725.21 42.41 7,740.31 121.16
2006 Healthy Fam 2706265 5/13/2008 5/16/2008 15,269.84 404.11 2,129.15 155.48 122.85 3,375.78
2006 Healthy Fam 2706288 5/13/2008 5/16/2008 8,711.05 4,746.66 1,592.40
2007 various 2706181 5/20/2008 5/22/2008 40,970.77
2006 Refugee 2706340 5/21/2008 5/27/2008 490.38
2006 MHP Admin 2706343 5/21/2008 5/27/2008 2,554.36
2006 Ben Services 2706349 5/21/2008 330,633.49 2,657.07 39,298.81 45.48
2007 2706327 5/21/2008 5/28/2008 18,263,949.60
Beneficiary Svcs 33,471.93 246,933.82 2,910,590.59 105,669.22 217,022.18 10,874.52 786,039.19 23,893.82 355,388.40 95,431.05
2007 Refugee 2706341 5/21/2008 2,053.85
2007 MHP - UR 2706346 5/21/2008 2,307,177.11 283,793.00 270,410.18 16,075.71
2007 2706350 5/21/2008
Beneficiary Svcs 8,839,076.78 150,127.10 65,920.39 269,867.49 1,111.10 8,633.26 811,287.93 1,175.05 217,255.96 117,199.51
2007 Refugee 2706367 5/21/2008 5/27/2008 57.00 57.00
2007 2706378 5/21/2008
Beneficiary Svcs 9,171,246.66 27,290.40 55,670.76 8,770.85 90,649.72 7,554.92 1,133,028.24 126,453.16 8,740.38 79,787.65 175,856.48 123,607.36
2007 2706309 5/21/2008
Beneficiary Svcs 27,811,693.41 3,902,899.27 338,149.54 2,665.20 201,486.06 1,428.93 1,189,328.08 128,604.78 378,356.71 122,549.01
2006 2706326 5/21/2008
Beneficiary Svcs 4,621,197.26 106,949.84 278,674.44 2,365.04 12,519.00 88,669.69 1,541,303.20 370,306.59 1,958.00 92,981.83 8,210.89
2006 2706377 5/21/2008
Beneficiary Svcs 257,894.88 40,278.79 4,268.93 182.66 66.00 14,993.76
2007 various 2706178 5/30/2008 10,486,621.31 137,010.61 3,624.50
2007 various 2706178 5/30/2008 4,029,421.28
2007 various 2706207 5/30/2008 1,134,213.25 630,418.50 66,676.23
2005 various 2706413 5/30/2008 600,041.28 81,241.43 1,225.08 19,385.59 11,807.24 20,354.40 511.75 13,912.21 7,087.23
Total Claims to SCO 89,362,310.03 4,489,152.57 0.00 94,435.87 1,240,756.39 12,547.15 106,132.89 2,986,842.66 404,503.71 255,733.21 4,817,922.36 140,336.68 1,748,890.00 777,577.58 82,111.95 857,795.54 605,610.59 403,035.31
0.00 crossfoot
.
Spreadsheet identifies DMH claim schedules sent to the State Controller's Office for payment during the month of May 2008.
Detail includes the date each claim was sent from the DMH to the SCO, the date SCO warrants were issued to counties, and the payment amount each county received
Shaded amounts identify amounts which will be returned to the DMH to collect various amounts due from counties (ed.g. cost settlement or audit).
Department of Mental Health
Claims Sent to and Paid by State Controller
May 2008
as of May 30, 2008
Page 14 of 16
FFY Program Claim # SCO Date Paid Date Total Lassen Los Angeles Madera Marin Mariposa Mendocino Merced Modoc Mono Monterey Napa Nevada Orange Placer Plumas Riverside
2007 Healthy Fam 2706241 5/13/2008 5/16/2008 765,240.43 13,416.35 27,044.91 4,413.74 91,290.43 376.18
2007 Healthy Fam 2706266 5/13/2008 5/16/2008 392,517.16 1,052.28 11,207.28 4,671.21 27,164.01 7,739.33 24,787.65 72,362.61
2007 Healthy Fam 2706289 5/13/2008 5/16/2008 258,553.67 19,931.18 7,766.77
2006 Healthy Fam 2706239 5/13/2008 5/16/2008 22,725.21 1,822.51
2006 Healthy Fam 2706265 5/13/2008 5/16/2008 15,269.84 1,859.23
2006 Healthy Fam 2706288 5/13/2008 5/16/2008 8,711.05 296.89
2007 various 2706181 5/20/2008 5/22/2008 40,970.77
2006 Refugee 2706340 5/21/2008 5/27/2008 490.38 490.38
2006 MHP Admin 2706343 5/21/2008 5/27/2008 2,554.36 2,554.36
2006 Ben Services 2706349 5/21/2008 330,633.49 112,195.55 11,304.61 69.80 561.78 22,988.82
2007 2706327 5/21/2008 5/28/2008 18,263,949.60
Beneficiary Svcs 477,483.43 15,534.24 1,327,944.68 169,046.31 413,649.94 256,714.01 66,949.18
2007 Refugee 2706341 5/21/2008 2,053.85
2007 MHP - UR 2706346 5/21/2008 2,307,177.11 215,707.23 66,777.67 254,687.50
2007 2706350 5/21/2008
Beneficiary Svcs 8,839,076.78 25,449.17 1,463,503.36 462,624.96 699.60 56,320.08 407,361.76 7,643.66 1,969,510.44
2007 Refugee 2706367 5/21/2008 5/27/2008 57.00
2007 2706378 5/21/2008
Beneficiary Svcs 9,171,246.66 85,608.71 199,461.23 432,285.72 6,696.30 83,547.44 438,642.06
2007 2706309 5/21/2008
Beneficiary Svcs 27,811,693.41 217,909.57 6,523.72 14,828.50 7,614.06 1,089,179.73 506,064.58 1,976.86
2006 2706326 5/21/2008
Beneficiary Svcs 4,621,197.26 1,765.31 312,694.31 89,661.01 1,147.95 1,236.63 5,036.56
2006 2706377 5/21/2008
Beneficiary Svcs 257,894.88 157,296.07 290.93
2007 various 2706178 5/30/2008 10,486,621.31 19,019.48 601,709.55 81,874.12
2007 various 2706178 5/30/2008 4,029,421.28
2007 various 2706207 5/30/2008 1,134,213.25 7,221.47 296,611.42 3,122.74
2005 various 2706413 5/30/2008 600,041.28 4,439.53 168.45 20,326.27 50.26 9,656.31 17,991.86
Total Claims to SCO 89,362,310.03 302,368.22 0.00 424,592.27 508,311.90 25,449.17 2,781,600.53 467,296.17 15,534.24 27,370.35 1,523,155.76 217,949.80 182,397.59 3,098,102.86 776,020.59 68,926.04 2,427,558.30
0.00
.
Department of Mental Health
Claims Sent to and Paid by State Controller
May 2008
as of May 30, 2008
Page 15 of 16
FFY Program Claim # SCO Date Paid Date Total Sacramento San Benito San Bernardino San Diego San Francisco San Joaquin San Luis Obispo San Mateo Santa Barbara Santa Clara Santa Cruz Shasta Sierra Siskiyou
2007 Healthy Fam 2706241 5/13/2008 5/16/2008 765,240.43 1,874.30 13,659.89 17,506.64 88,289.78 13,064.02 70,307.97 264.10 25,897.10 52,909.71 13,923.38 2,064.27
2007 Healthy Fam 2706266 5/13/2008 5/16/2008 392,517.16 32,728.86 27,119.11 1,290.82 11,249.79 893.65
2007 Healthy Fam 2706289 5/13/2008 5/16/2008 258,553.67 25,674.02 50,379.42 15,101.67 25.64
2006 Healthy Fam 2706239 5/13/2008 5/16/2008 22,725.21 4,289.94 3,818.15 1,163.45 499.44 886.40 1,964.84
2006 Healthy Fam 2706265 5/13/2008 5/16/2008 15,269.84 5,262.85
2006 Healthy Fam 2706288 5/13/2008 5/16/2008 8,711.05 2,075.10
2007 various 2706181 5/20/2008 5/22/2008 40,970.77
2006 Refugee 2706340 5/21/2008 5/27/2008 490.38
2006 MHP Admin 2706343 5/21/2008 5/27/2008 2,554.36
2006 Ben Services 2706349 5/21/2008 330,633.49 942.09 1,340.96 120,332.57 10,375.42 597.24
2007 2706327 5/21/2008 5/28/2008 18,263,949.60
Beneficiary Svcs 51,753.65 2,153,083.43 3,091,840.37 2,054,456.30 393,037.41 12,287.67
2007 Refugee 2706341 5/21/2008 2,053.85 1,258.97 794.88
2007 MHP - UR 2706346 5/21/2008 2,307,177.11 727,913.44 273,997.19 5,713.69
2007 2706350 5/21/2008
Beneficiary Svcs 8,839,076.78 86,566.96 4,702.57 28,839.61 23,630.89 925,057.71 1,299,354.47
2007 Refugee 2706367 5/21/2008 5/27/2008 57.00
2007 2706378 5/21/2008
Beneficiary Svcs 9,171,246.66 3,883,292.52 53,018.06 1,926.88 20,632.59 982,290.92 876,224.31 5,818.78 2,233.68
2007 2706309 5/21/2008
Beneficiary Svcs 27,811,693.41 3,075,710.15 7,537,437.11 822,237.38 962,226.09 448,594.19 1,515,597.05 2,145,967.49 399,160.02
2006 2706326 5/21/2008
Beneficiary Svcs 4,621,197.26 59,664.85 18,524.80 67,241.75 405,602.63 1,044,601.47 1,021.06
2006 2706377 5/21/2008
Beneficiary Svcs 257,894.88 658.68 262.41 26,485.56 368.10 868.99 11,776.12
2007 various 2706178 5/30/2008 10,486,621.31 4,683,382.70 19,963.40 1,653,958.89 2,180,972.47 608,663.37 496,442.22
2007 various 2706178 5/30/2008 4,029,421.28 3,932,785.27 5,632.08
2007 various 2706207 5/30/2008 1,134,213.25 331.37 129,831.52
2005 various 2706413 5/30/2008 600,041.28 11,119.47 54,314.61 56,588.24 64,616.77 262.80 19,226.07 103,522.76 252.95
Total Claims to SCO 89,362,310.03 11,656,037.82 251,334.89 2,304,398.88 5,669,400.74 10,011,437.31 3,680,968.79 1,217,617.42 3,027,332.68 1,554.92 8,165,501.52 1,587,320.16 2,165,988.24 0.00 404,479.03
0.00
.
Department of Mental Health
Claims Sent to and Paid by State Controller
May 2008
as of May 30, 2008
Page 16 of 16
FFY Program Claim # SCO Date Paid Date Total Solano Sonoma Stanislaus Sutter/Yuba Tehama Trinity Tulare Tuolumne Ventura Yolo Yuba
2007 Healthy Fam 2706241 5/13/2008 5/16/2008 765,240.43 5,059.86 9,800.87 24,334.47 31,717.54 306.61 98,314.69 145.08 1,971.62
2007 Healthy Fam 2706266 5/13/2008 5/16/2008 392,517.16 18,035.15 14,044.16 592.02 10,895.01 118,785.17 1,155.47
2007 Healthy Fam 2706289 5/13/2008 5/16/2008 258,553.67 476.19 365.82
2006 Healthy Fam 2706239 5/13/2008 5/16/2008 22,725.21 78.78 74.78 28.89 194.15
2006 Healthy Fam 2706265 5/13/2008 5/16/2008 15,269.84 93.99 1,866.40
2006 Healthy Fam 2706288 5/13/2008 5/16/2008 8,711.05
2007 various 2706181 5/20/2008 5/22/2008 40,970.77 40,970.77
2006 Refugee 2706340 5/21/2008 5/27/2008 490.38
2006 MHP Admin 2706343 5/21/2008 5/27/2008 2,554.36
2006 Ben Services 2706349 5/21/2008 330,633.49 7,923.29
2007 2706327 5/21/2008 5/28/2008 18,263,949.60
Beneficiary Svcs 751,888.38 734,707.92 2,240.91 3,322.40 18,544.73 1,484,149.92
2007 Refugee 2706341 5/21/2008 2,053.85
2007 MHP - UR 2706346 5/21/2008 2,307,177.11 83,993.75 108,107.75
2007 2706350 5/21/2008
Beneficiary Svcs 8,839,076.78 342,071.81 47,292.20 17,281.51 28,588.23
2007 Refugee 2706367 5/21/2008 5/27/2008 57.00
2007 2706378 5/21/2008
Beneficiary Svcs 9,171,246.66 21,518.21 82,102.38 158,536.95
2007 2706309 5/21/2008
Beneficiary Svcs 27,811,693.41 20,358.54 21,226.86 886,590.26 227,637.73 63,827.43 70,635.00 1,254,154.58 93.30 250,675.63
2006 2706326 5/21/2008
Beneficiary Svcs 4,621,197.26 7,939.14 1,866.61 205.56 33,614.09 65,435.01
2006 2706377 5/21/2008
Beneficiary Svcs 257,894.88 97.88
2007 various 2706178 5/30/2008 10,486,621.31
2007 various 2706178 5/30/2008 4,029,421.28 22,576.92 6,273.12 18,281.59 16,661.43 27,210.87
2007 various 2706207 5/30/2008 1,134,213.25
2005 various 2706413 5/30/2008 600,041.28 5,187.27 1,534.15 19,679.53 4,416.26 394.40 50,768.39
Total Claims to SCO 89,362,310.03 852,834.12 789,453.69 952,475.31 739,284.25 222,364.38 136,778.54 1,576,720.59 41,652.62 1,756,120.40 281,235.48 0.00
0.00
.
