Data Appendices 3 1 12
Data Appendices 3 1 12
Completed by:
10
Table 1a: Penetration Rates for Mental Health & SUD Services 2009
Mental Health or Medicaid ADP DMH
SUD Prevalence Utilization Utilization Utilization
Characteristics N %1 N %2 N %3 N %4
Total 7,895,082 22% 564,480 7% 162,811 2% 635,942 8%
SMI
Total 1,178,513 4% 255,603 22% -- -- 407,672 35%
Age
18-20 31,870 2% 14,139 44% -- -- 29,780 93%
21-24 94,321 4% 11,708 12% -- -- 34,146 36%
25-34 305,097 6% 37,727 12% -- -- 83,937 28%
35-44 324,956 6% 47,630 15% -- -- 88,649 27%
45-54 246,083 5% 67,516 27% -- -- 97,807 40%
55-64 108,748 3% 52,510 48% -- -- 54,402 50%
65+ 67,438 2% 24,364 36% -- -- 18,951 28%
Gender
Male 494,204 4% 102,454 21% -- -- 192,193 39%
Female 684,308 5% 153,149 22% -- -- 214,544 31%
5
Race / Ethnicity
White-NH 526,102 4% 91,889 -- -- -- 134,079 --
African American-NH 98,255 6% 30,075 -- -- -- 37,966 --
Asian-NH 62,347 2% 3,959 -- -- -- 22,025 --
Pacific Islander-NH 2,167 2% 9,578 -- -- -- 1,443 --
Native-NH 10,578 7% 1,403 -- -- -- 3,966 --
Other6 26,440 6% 77,931 -- -- -- 58,853 --
Hispanic 452,625 5% 38,430 -- -- -- 63,322 --
Unknown/Not Reported -- -- 2,324 -- -- -- -- --
Mental Health Illness – Broad Definition Adults
Total 3,183,061 12% 62,679 2% -- -- N/A
Age
18-20 254,935 16% 10,852 4%
21-24 392,745 18% 4,673 1%
25-34 892,437 17% 9,821 1%
35-44 720,964 14% 9,214 1%
45-54 511,573 10% 10,252 2%
55-64 240,519 6% 8,124 3%
65+ 169,888 4% 9,736 6%
1
These percentages reflect the number of individuals of the total population with the given Characteristic that is diagnosed with a mental health
illness or substance use disorder. The total populations of each characteristic are included in the MH/SUD Prevalence source data. For example, for
all Californians within the age cohort “18-20,” 2% are diagnosed with a mental illness or substance use disorder.
2
These percentages represent the number of individuals with the given Characteristic category that utilize Medicaid services. For example, of the
31,870 individuals between the ages of 18-20 diagnosed with SMI, 44% (or 14,139 individuals) utilize Medicaid services.
3
These percentages represent the number of individuals within the given Characteristic category that utilize ADP services. For example, of the
270,604 12-17 year old Californians with an Alcohol or Drug Diagnosis, 3% (or 7,785 individuals) utilize ADP services.
4
These percentages represent the number of individuals with the given Characteristic category that utilize DMH services. For example, of the
494,204 individuals diagnosed with SMI that are male, 39% (or 192,193 individuals) utilize DMH services.
5
Percentages were not calculated for the Race/Ethnicity categories in Medicaid Utilization because the Race/Ethnicity categories across data sets
did not match-up
6
Multi-ethnic groups are not represented as a Race/Ethnic group on this table but are included in the MH/SUD Prevalence source data. Thus, they
have been included in the “Other” category in the Prevalence column of this table.
CA BHNA Appendix A: DHCS Data 11
Mental Health or Medicaid ADP DMH
SUD Prevalence Utilization Utilization Utilization
Characteristics N %1 N %2 N %3 N %4
Gender
Male 1,453,244 11% 26,638 2% -- -- N/A
Female 1,729,818 12% 36,041 2% -- -- N/A
Race / Ethnicity
White-NH 1,252,828 10% 18,298 -- -- -- N/A
African American-NH 216,811 13% 7,147 -- -- -- N/A
Asian-NH 311,918 9% 1,533 -- -- -- N/A
Pacific Islander-NH 9,850 11% 2,396 -- -- -- N/A
Native-NH 19,833 13% 298 -- -- -- N/A
Other 60,142 14% 19,505 -- -- -- N/A
Hispanic 1,311,678 15% 12,936 -- -- -- N/A
Unknown/Not Reported 550 --
SED
Total 714,430 8% 99,660 14% -- -- 228,109 32%
Age
0-5 248,544 8% 7,067 3% -- -- 28,793 12%
6-11 230,033 7% 42,424 18% -- -- 73,000 32%
12-17 235,853 8% 50,079 21% -- -- 126,316 54%
Gender
Male 367,079 8% 67,209 18% -- -- 138,126 38%
Female 347,351 8% 32,451 9% -- -- 89,692 26%
Race / Ethnicity
White-NH 191,164 7% 25,276 -- -- -- 43,795 --
African American-NH 44,357 8% 10,151 -- -- -- 24,840 --
Asian-NH 69,175 7% 782 -- -- -- 5,213 --
Pacific Islander-NH 2,440 8% 466 -- -- -- 971 --
Native-NH 3,436 8% 442 -- -- -- 2,209 --
Other 23,787 7% 34,575 -- -- -- 30,255 --
Hispanic 380,071 8% 27,051 -- -- -- 69,078 --
Unknown/Not Reported -- -- 911 -- -- -- -- --
Alcohol or Drug Diagnosis
Total 2,819,078 9% 99,408 4% 162,811 6% N/A
Age
0-5 -- -- 611 -- --
6-11 -- -- 282 -- 29 --
12-17 284,963 8% 15,999 6% 7,785 3%
18-20 258,129 14% 16,892 7% 7,045 3%
21-24 389,624 18% 7,203 2% 12,717 3%
25-34 719,344 14% 4,745 1% 34,646 5%
35-44 518,227 9% 14,793 3% 29,688 6%
45-54 381,205 7% 15,296 4% 26,906 7%
55-64 189,905 5% 21,495 11% 8,573 5%
65+ 77,681 2% 14,526 19% 1,195 2%
Gender
Male 1,910,536 12% 52,439 3% 102,922 5% N/A
7
These percentages reflect the percent of the total population of the given county has been diagnosed with SMI. The total populations of each
county are included in the MH/SUD Prevalence source data.
8
These percentages reflect the number of individuals within each county diagnosed with SMI (i.e. SMI prevalence) who utilize
Medicaid services.
9
These percentages reflect the number of individuals within each county diagnosed with SMI (i.e. SMI prevalence) who utilize ADP
services.
10
These percentages reflect the number of individuals within each county diagnosed with SMI (i.e. SMI prevalence) who utilize DMH
services.
CA BHNA Appendix A: DHCS Data 14
Medicaid ADP DMH
SMI Prevalence Utilization Utilization Utilization
Characteristics N %7 N %8 N %9 N %10
Napa 7,058 5% 652 9% NR 436 6%
Nevada 4,484 5% 686 15% NR 603 13%
Shasta 10,526 6% 1,965 19% NR 2,167 21%
Sutter 5,317 6% 75 1% NR 4,527 85%
Yolo 10,199 5% 1,092 11% NR 4,380 43%
Yuba 4,716 6% 1,585 34% NR -- --
MBA (Under 90,000)
Alpine 60 6% 6 10% NR 16 27%
Amador 2,326 6% 244 10% NR 111 5%
Calaveras 2,291 5% 293 13% NR 71 3%
Colusa 1,284 6% 170 13% NR 123 10%
Del Norte 2,206 8% 336 15% NR 370 17%
Glenn 1,729 6% 207 12% NR 161 9%
Inyo 930 5% 147 16% NR 127 14%
Lake 4,008 6% 659 16% NR 344 9%
Lassen 2,996 9% 305 10% NR 137 5%
Mariposa 940 5% 174 19% NR 271 29%
Modoc 547 6% 120 22% NR 213 39%
Mono 647 5% 27 4% NR 133 21%
Plumas 959 5% 211 22% NR 449 47%
San Benito 2,732 5% 277 10% NR 714 26%
Sierra 156 5% 5 3% NR 77 49%
Siskiyou 2,470 5% 720 29% NR 979 40%
Tehama 3,720 6% 709 19% NR 1,956 53%
Trinity 776 5% 141 18% NR 322 41%
Tuolumne 3,230 6% 503 16% NR 735 23%
Unlabelled 2,055 --
Out of State 219 --
11
These percentages reflect the percent of the total population of the given county that has been diagnosed with a broad definition mental health
illness. The total populations of each county included in the MH/SUD Prevalence source data.
12
These percentages reflect the number of individuals within each county diagnosed with a Broad Definition Mental Illness (i.e.
Broad Definition Mental Health prevalence) who utilize Medicaid services.
13
These percentages reflect the number of individuals within each county diagnosed with a Broad Definition Mental Illness (i.e.
Broad Definition Mental Health prevalence) who utilize ADP services.
14
These percentages reflect the number of individuals within each county diagnosed with a Broad Definition Mental Illness (i.e.
Broad Definition Mental Health prevalence) who utilize DMH services.
CA BHNA Appendix A: DHCS Data 16
Broad Definition
Mental Health Medicaid ADP DMH
Prevalence Utilization Utilization Utilization
Characteristics N %11 N %12 N %13 N %14
Merced 36,326 15% 3,281 9% NR NR
Napa 18,397 13% 860 5% NR NR
Nevada 11,946 12% 858 7% NR NR
Shasta 26,022 14% 2,820 11% NR NR
Sutter 13,340 14% 339 3% NR NR
Yolo 28,266 14% 1,179 4% NR NR
Yuba 11,398 16% 2,084 18% NR NR
MBA (Under 90,000)
Alpine 149 14% 4 3% NR NR
Amador 6,024 16% 329 5% NR NR
Calaveras 5,938 13% 308 5% NR NR
Colusa 3,204 15% 215 7% NR NR
Del Norte 5,525 19% 431 8% NR NR
Glenn 4,264 15% 316 7% NR NR
Inyo 2,372 14% 202 9% NR NR
Lake 9,708 15% 980 10% NR NR
Lassen 7,841 23% 425 5% NR NR
Mariposa 2,431 14% 202 8% NR NR
Modoc 1,327 15% 192 14% NR NR
Mono 1,808 14% 37 2% NR NR
Plumas 2,476 12% 230 9% NR NR
San Benito 7,285 13% 392 5% NR NR
Sierra 414 13% 12 3% NR NR
Siskiyou 6,036 14% 759 13% NR NR
Tehama 9,127 15% 859 9% NR NR
Trinity 1,892 13% 162 9% NR NR
Tuolumne 8,458 15% 506 6% NR NR
15
These percentages reflect the percent of the total population of the given county that have been diagnosed with SED. The total populations of
each county included in the MH/SUD Prevalence source data.
16
These percentages reflect the number of individuals within each county with a SED diagnosis (i.e. SED prevalence) who utilize
Medicaid services.
17
These percentages reflect the number of individuals within each county with a SED diagnosis (i.e. SED prevalence) who utilize ADP
services.
18
These percentages reflect the number of individuals within each county with a SED diagnosis (i.e. SED prevalence) who utilize
DMH services.
19
These percentages reflect the percent of the total population of the given county that suffer from SUD. The total populations of each county
included in the MH/SUD Prevalence source data.
20
These percentages reflect the number of individuals within each county who have an alcohol or drug diagnoses with (i.e. Alcohol
or Drug Prevalence) who utilize Medicaid services.
21
These percentages reflect the number of individuals within each county who have an alcohol or drug diagnoses with (i.e. Alcohol
or Drug Prevalence) who utilize ADP services.
22
These percentages reflect the number of individuals within each county who have an alcohol or drug diagnoses with (i.e. Alcohol
or Drug Prevalence) who utilize DMH services.
CA BHNA Appendix A: DHCS Data 20
Alcohol or Drug
Diagnosis Medicaid ADP DMH
Prevalence Utilization Utilization Utilization
Characteristics N %19 N %20 N %21 N %22
Merced 19,988 9% 839 4% 1,064 5% N/A
Napa 10,975 9% 255 2% 861 8% N/A
Nevada 7,637 8% 312 4% 680 9% N/A
Shasta 15,218 9% 1,403 9% 1,498 10% N/A
Sutter 6,839 9% 75 1% -- -- N/A
Yolo 16,240 9% 273 2% 707 4% N/A
Yuba 6,307 10% 682 11% -- -- N/A
MBA (Under 90,000)
Alpine 126 10% 2 2% 5 4% N/A
Amador 3,864 11% 70 2% 52 1% N/A
Calaveras 3,430 8% 82 2% 202 6% N/A
Colusa 1,800 9% 28 2% 123 7% N/A
Del Norte 3,448 13% 176 5% 174 5% N/A
Glenn 2,352 9% 75 3% 227 10% N/A
Inyo 1,545 9% 59 4% 128 8% N/A
Lake 5,015 9% 714 14% 708 14% N/A
Lassen 5,240 16% 169 3% 275 5% N/A
Mariposa 1,546 9% 128 8% 248 16% N/A
Modoc 905 10% 64 7% 83 9% N/A
Mono 1,244 10% 8 1% 38 3% N/A
Plumas 1,630 8% 84 5% 16 1% N/A
San Benito 4,530 9% 76 2% 276 6% N/A
Sierra 305 9% 9 3% 20 7% N/A
Siskiyou 3,619 9% 237 7% 119 3% N/A
Tehama 5,284 10% 217 4% 464 9% N/A
Trinity 1,235 9% 52 4% 107 9% N/A
Tuolumne 5,227 10% 196 4% 333 6% N/A
Unlabelled 349 --
Out of State 119 --
23
This column represents the percentage of individuals who are in a given characteristic category of the total Medicaid Beneficiaries
in 2009. For example, of the 564,480 beneficiaries, 21% (or 121,286 individuals) were aged 0-13.
24
Individuals may appear in more than one service category
CA BHNA Appendix A: DHCS Data 24
Any Use
Median Average
Total Expenditure Expenditure
Characteristics N %23 Expenditure Per User Per User
SED 99,661 18% $801,650,998 $2,859 $8,044
Substance Use Only 61,613 11% $292,283,905 $950 $4,744
Other BH Adult 62,679 11% $220,060,092 $458 $3,511
Other BH Youth 84,925 15% $334,268,116 $1,672 $3,936
Special Populations
Co-Occurring Mental Health/SUD 99,408 18% $976,876,124 $1,924 $9,827
Service Utilization
No outpatient MH/SUD service received 28,840 5% $216,420,541 $2,302 $7,504
25
This column represents the percentage of individuals who are in a given characteristic category of the total Medicaid Beneficiaries
who received DMC/SMHS Services in 2009. For example, of the 478,946 DMC/SMHS beneficiaries, 23% (or 111,335 individuals) were
aged 0-13.
CA BHNA Appendix A: DHCS Data 26
Table 2.1c: Medicaid Behavioral Health Care Expenditures Among Current Medicaid Beneficiaries 2009 –
FFS
Any Use Median Average
Total Expenditure Expenditure
Characteristics N %26 Expenditure Per User Per User
Total 162,105 100% $1,623,611,594 $248 $10,016
Demographics
Age
0-13 16,563 10% $56,541,725 $102 $3,414
14-17 13,817 9% $92,312,851 $444 $6,681
18-21 7,510 5% $59,751,298 $384 $7,956
22-26 8,003 5% $82,937,429 $298 $10,363
27-64 95,315 59% $1,091,959,007 $306 $11,456
65+ 20,855 13% $240,016,712 $142 $11,509
Gender
Male 79,268 49% $849,528,992 $274 $10,717
Female 82,837 51% $774,082,602 $221 $9,345
Race / Ethnicity
White-NH 75,227 46% $761,265,489 $246 $10,120
African American-NH 21,677 13% $276,818,796 $374 $12,770
Asian-NH 3,124 2% $37,175,723 $145 $11,900
Pacific Islander-NH 4,927 3% $59,568,419 $168 $12,090
Native-NH 1,486 1% $10,410,365 $328 $7,006
Other 15,686 10% $161,752,205 $630 $10,312
Hispanic 37,766 23% $294,341,212 $145 $7,794
Unknown/Not Reported 2,036 1% $22,238,279 $228 $10,923
Medicaid Eligibility Categories
CalWorks (TANF) 2,693 2% $12,119,163 $107 $4,500
SSI/SSP <65 82,133 51% $958,078,156 $339 $11,665
SSI/SSP ≥ 65 5,415 3% $47,429,458 $108 $8,759
Other Eligibility Categories for ≥65 7,374 5% $110,625,257 $167 $15,002
Foster Care 9,722 6% $46,769,815 $162 $4,811
AFDC 26,051 16% $130,156,167 $176 $4,996
Other Disabled 16,620 10% $250,017,423 $312 $15,043
Other Child/Family 6,799 4% $32,210,035 $121 $4,737
Unknown 108 0.1% $186,097 $198 $1,723
All Remaining Other Eligibility Categories 5,190 3% $36,020,023 $225 $6,940
Cohort
SMI 87,729 54% $1,202,034,532 $683 $13,702
SED 20,695 13% $119,195,948 $227 $5,760
Substance Use Only 23,189 14% $158,501,098 $197 $6,835
Other BH Adult 23,292 14% $126,463,768 $68 $5,429
Other BH Youth 7,200 4% $17,416,248 $68 $2,419
Special Populations
Co-Occurring Mental Health/SUD 47,194 29% $542,539,894 $348 $11,496
Service Utilization
No outpatient MH/SUD service received 4,884 3% $60,434,560 $4,312 $12,374
26
This column represents the percentage of individuals who are in a given characteristic category of the total Medicaid Beneficiaries
who received FFS Services in 2009. For example, of the 162,105 individuals who received FFS services, 10% (or 16,563 individuals)
were aged 0-13.
CA BHNA Appendix A: DHCS Data 27
Table 2.2a: Medicaid Behavioral Health Care Expenditures Among Current Medicaid Beneficiaries 2008
Any Use Median Average
Total Expenditure Expenditure
Characteristics N %27 Expenditure Per User Per User
Total 540,804 100% $3,412,409,924 $1,393 $6,310
Demographics
Age
0-13 101,820 19% $509,802,266 $1,809 $5,007
14-17 66,244 12% $458,743,092 $2,328 $6,925
18-21 38,358 7% $254,434,858 $1,807 $6,633
22-26 24,483 5% $159,473,079 $958 $6,514
27-64 274,295 51% $1,776,215,286 $1,196 $6,476
65+ 35,524 7% $253,344,297 $655 $7,132
Gender
Male 261,524 48% $1,846,009,470 $1,654 $7,059
Female 279,280 52% $1,566,400,454 $1,192 $5,609
Race / Ethnicity
White-NH 147,186 27% $1,247,046,105 $1,323 $8,473
African American-NH 53,100 10% $465,717,332 $1,666 $8,771
Asian-NH 6,880 1% $43,258,556 $706 $6,288
Pacific Islander-NH 10,246 2% $85,043,417 $1,024 $8,300
Native-NH 2,695 0.5% $19,421,966 $1,086 $7,207
Other 219,047 41% $940,638,754 $1,493 $4,294
Hispanic 96,815 18% $575,733,040 $1,188 $5,947
Unknown/Not Reported 4,647 1% $35,458,040 $1,230 $7,630
28
Service Categories
Residential 436 0.1% $2,754,766 -- $6,318
Emergency 68,060 13% $57,002,598 -- $838
Hospital/Inpatient 67,407 12% $1,337,497,299 -- $19,842
Mental Health Treatment Outpatient 406,328 75% $1,384,244,304 -- $3,407
Mental Health Rehabilitation 204,380 38% $222,266,674 -- $1,088
Substance Use Services 86,246 16% $362,393,833 -- $4,202
Medicaid Eligibility Categories
CalWorks (TANF) 5,860 1% $22,592,844 $684 $3,855
SSI/SSP <65 226,747 42% $1,696,865,345 $1,504 $7,484
SSI/SSP ≥ 65 7,392 1% $29,315,198 $472 $3,966
Other Eligibility Categories for ≥65 9,605 2% $117,801,574 $244 $12,265
Foster Care 45,617 8% $379,518,842 $2,853 $8,320
AFDC 158,968 29% $585,574,644 $1,157 $3,684
Other Disabled 35,584 7% $333,479,646 $1,293 $9,372
Other Child/Family 30,732 6% $151,794,533 $1,327 $4,939
Unknown 178 0% $626,214 $725 $3,518
All Remaining Other Eligibility Categories 20,121 4% $94,841,084 $1,390 $4,714
Cohort
SMI 252,183 47% $1,943,244,257 $1,409 $7,706
SED 88,143 16% $677,137,648 $2,684 $7,682
27
This column represents the percentage of individuals who are in a given characteristic category of the total Medicaid Beneficiaries
in 2008. For example, of the 540,804 beneficiaries, 19% (or 101,280 individuals) were aged 0-13.
28
Individuals may appear in more than one service category
CA BHNA Appendix A: DHCS Data 28
Any Use Median Average
Total Expenditure Expenditure
Characteristics N %27 Expenditure Per User Per User
Substance Use Only 58,026 11% $275,868,155 $1,124 $4,754
Other BH Adult 68,470 13% $247,184,874 $540 $3,610
Other BH Youth 73,982 14% $268,974,990 $1,541 $3,636
Special Populations
Co-Occurring Mental Health/SUD 94,082 17% $869,905,566 $2,118 $9,246
Service Utilization
No outpatient MH/SUD service received 33,605 6% $254,869,667 $2,477 $7,584
29
This column represents the percentage of individuals who are in a given characteristic category of the total Medicaid Beneficiaries
who received DMC/SMHS Services in 2008. For example, of the 460,047 DMC/SMHS recipients, 20% (or 92,307 individuals) were
aged 0-13.
CA BHNA Appendix A: DHCS Data 30
Table 2.2c: Medicaid Behavioral Health Care Expenditures Among Current Medicaid Beneficiaries 2008 –
FFS
Any Use Median Average
Total Expenditure Expenditure
Characteristics N %30 Expenditure Per User Per User
Total 149,939 100% $1,332,718,389 $212 $8,888
Demographics
Age
0-13 14,448 10% $41,931,380 $90 $2,902
14-17 11,549 8% $71,811,103 $356 $6,218
18-21 8,496 6% $56,931,470 $346 $6,701
22-26 7,686 5% $72,223,866 $270 $9,397
27-64 87,114 58% $891,350,889 $262 $10,232
65+ 20,583 14% $198,253,795 $116 $9,632
Gender
Male 73,573 49% $699,433,890 $234 $9,507
Female 76,366 51% $633,284,499 $192 $8,293
Race / Ethnicity
White-NH 70,109 47% $646,488,653 $211 $9,221
African American-NH 19,070 13% $215,694,354 $318 $11,311
Asian-NH 2,970 2% $21,985,866 $136 $7,403
Pacific Islander-NH 4,290 3% $47,143,568 $130 $10,989
Native-NH 1,431 1% $9,386,770 $256 $6,560
Other 15,169 10% $144,209,854 $709 $9,507
Hispanic 34,837 23% $230,488,944 $124 $6,616
Unknown/Not Reported 1,881 1% $17,244,867 $142 $9,168
Medicaid Eligibility Categories
CalWorks (TANF) 2,570 2% $10,624,696 $98 $4,134
SSI/SSP <65 74,869 50% $758,085,395 $292 $10,125
SSI/SSP ≥ 65 4,729 3% $19,902,142 $97 $4,209
Other Eligibility Categories for ≥65 7,649 5% $112,414,587 $118 $14,697
Foster Care 9,525 6% $42,879,541 $164 $4,502
AFDC 24,217 16% $111,866,896 $153 $4,619
Other Disabled 14,381 10% $216,552,353 $276 $15,058
Other Child/Family 6,584 4% $28,803,945 $105 $4,375
Unknown 111 0.1 % $106,168 $428 $956
All Remaining Other Eligibility Categories 5,304 4% $31,482,666 $167 $5,936
Cohort
SMI 79,541 53% $962,631,261 $526 $12,102
SED 17,335 12% $91,284,461 $191 $5,266
Substance Use Only 22,259 15% $146,290,163 $204 $6,572
Other BH Adult 24,041 16% $120,273,419 $68 $5,003
Other BH Youth 6,763 5% $12,239,085 $57 $1,810
Special Populations
Co-Occurring Mental Health/SUD 43,716 29% $455,734,514 $333 $10,425
Service Utilization
No outpatient MH/SUD service received 4,369 3% $56,372,174 $5,700 $12,903
30
This column represents the percentage of individuals who are in a given characteristic category of the total Medicaid Beneficiaries
who received FFS Services in 2008. For example, of the 149,939 individuals who received FFS services, 10% (or 14,448 individuals)
were aged 0-13.
CA BHNA Appendix A: DHCS Data 31
Table 2.3a: Medicaid Behavioral Health Care Expenditures Among Current Medicaid Beneficiaries 2007
31
This column represents the percentage of individuals who are in a given characteristic category of the total Medicaid Beneficiaries
in 2007. For example, of the 523,072 beneficiaries, 16% (or 83,781 individuals) were aged 0-13.
32
Individuals may appear in more than one service category
CA BHNA Appendix A: DHCS Data 32
Any Use Median Average
Total Expenditure Expenditure
Characteristics N %31 Expenditure Per User Per User
SED 75,903 15% $541,937,699 $2,441 $7,140
Substance Use Only 56,330 11% $238,846,277 $1,053 $4,240
Other BH Adult 77,523 15% $287,046,307 $538 $3,703
Other BH Youth 63,487 12% $206,580,029 $1,345 $3,254
Special Populations
Co-Occurring Mental Health/SUD 91,331 17% $802,538,619 $2,034 $8,787
Service Utilization
No outpatient MH/SUD service received 32,096 6% $232,436,187 $2,397 $7,242
33
This column represents the percentage of individuals who are in a given characteristic category of the total Medicaid Beneficiaries
who received DMC/SMHS services in 2007. For example, of the 437,620 DMC/SMHS recipients, 17% (or 74,711 individuals) were
aged 0-13.
CA BHNA Appendix A: DHCS Data 34
Table 2.3c: Medicaid Behavioral Health Care Expenditures Among Current Medicaid Beneficiaries 2007 –
FFS
Any Use Median Average
Total Expenditure Expenditure
Characteristics N %34 Expenditure Per User Per User
Total 150,329 100% $1,342,645,365 $158 $8,931
Demographics
Age
0-13 12,949 9% $42,707,675 $74 $3,298
14-17 9,844 7% $61,860,593 $184 $6,284
18-21 10,116 7% $69,496,422 $300 $6,870
22-26 8,208 5% $82,508,388 $204 $10,052
27-64 86,161 57% $901,047,008 $210 $10,458
65+ 22,991 15% $184,771,612 $87 $8,037
Gender
Male 72,476 48% $690,109,278 $186 $9,522
Female 77,853 52% $652,536,087 $136 $8,382
Race / Ethnicity
White-NH 33,903 23% $308,189,664 $154 $9,090
African American-NH 10,882 7% $113,331,322 $231 $10,415
Asian-NH 473 0.3% $3,083,001 $140 $6,518
Pacific Islander-NH 1,724 1% $13,967,170 $100 $8,102
Native-NH 475 0.3% $3,453,751 $256 $7,271
Other 0 -- -- -- --
Hispanic 16,608 25% $92,337,343 $79 $5,560
Unknown/Not Reported 1,872 3% $14,788,554 $113 $7,900
Medicaid Eligibility Categories
CalWorks (TANF) 3,121 2% $12,556,853 $62 $4,023
SSI/SSP <65 73,263 49% $776,291,020 $234 $10,596
SSI/SSP ≥ 65 4,895 3% $17,824,586 $76 $3,641
Other Eligibility Categories for ≥65 8,188 5% $97,864,946 $83 $11,952
Foster Care 9,842 7% $49,541,072 $139 $5,034
AFDC 23,898 16% $121,904,410 $129 $5,101
Other Disabled 14,024 9% $201,819,748 $220 $14,391
Other Child/Family 7,357 5% $34,699,261 $68 $4,716
Unknown 6 0% $5,694 $84 $949
All Remaining Other Eligibility Categories 5,735 4% $30,137,775 $109 $5,255
Cohort
SMI 78,520 52% $978,430,539 $428 $12,461
SED 14,729 10% $79,847,022 $145 $5,421
Substance Use Only 21,707 14% $128,955,292 $191 $5,941
Other BH Adult 28,567 19% $142,764,366 $54 $4,998
Other BH Youth 6,806 5% $12,648,146 $41 $1,858
Special Populations
Co-Occurring Mental Health/SUD 42,576 28% $446,804,537 $318 $10,494
Service Utilization
No outpatient MH/SUD service received 3,692 2% $48,978,242 $5,600 $13,266
34
This column represents the percentage of individuals who are in a given characteristic category of the total Medicaid Beneficiaries
who received FFS services in 2007. For example, of the 150,329 individuals who received FFS services, 9% (or 12,949 individuals)
were aged 0-13.
CA BHNA Appendix A: DHCS Data 35
Table 2.4a: Medicaid Behavioral Health Care Expenditures Among Current Foster Care Medicaid Beneficiaries
2009
Median Average
Any Use
Total Expenditure Expenditure
Characteristics N %35 Expenditure Per User Per User
Total 52,837 100% $493,333,696 $3,282 $9,337
Demographics
Age
0-13 28,794 54% $228,641,632 $2,849 $7,941
14-17 19,384 37% $221,344,100 $4,146 $11,419
18-21 4,583 9% $43,018,124 $3,053 $9,386
22-26 67 0.1% $324,583 $795 $4,845
Gender
Male 29,467 56% $271,676,142 $3,265 $9,220
Female 23,370 44% $221,657,554 $3,305 $9,485
Race / Ethnicity
White-NH 21,031 40% $219,794,975 $3,754 $10,451
African American-NH 9,378 18% $95,231,510 $3,502 $10,155
Asian-NH 345 1% $4,019,854 $3,088 $11,652
Pacific Islander-NH 256 0.5% $3,286,718 $3,435 $12,839
Native-NH 420 1% $3,936,263 $2,658 $9,372
Other 7,724 15% $50,139,492 $2,733 $6,491
Hispanic 13,247 25% $110,094,790 $2,869 $8,311
Unknown/Not Reported 436 1% $6,830,094 $4,313 $15,665
Service Categories36
Residential 0 -- -- -- --
Emergency 4,835 9% $6,363,439 -- $1,316
Hospital/Inpatient 3,622 7% $68,283,254 -- $18,852
Mental Health Treatment Outpatient 47,586 90% $347,026,964 -- $7,293
Mental Health Rehabilitation 24,488 46% $42,386,175 -- $1,731
Substance Use Services 5,751 11% $14,668,620 -- $2,551
Cohort
SMI 1,996 4% $29,073,790 $5,824 $14,566
SED 27,209 51% $336,379,230 $4,603 $12,363
Substance Use Only 2,090 4% $10,516,208 $1,504 $5,032
Other BH Adult 2,110 4% $12,743,024 $2,198 $6,039
Other BH Youth 19,432 37% $104,621,444 $2,334 $5,384
35
This column represents the percentage of individuals who are in a given characteristic category of the total Foster Care Medicaid
Beneficiaries in 2009. For example, of the 52,837 foster care Medicaid beneficiaries, 54% (or 28,794 individuals) were aged 0-13.
36
Individuals may appear in more than one service category
CA BHNA Appendix A: DHCS Data 36
Table 2.4b: Medicaid Behavioral Health Care Expenditures Among Current Foster Care Medicaid Beneficiaries
2009 – DMC/SMHS Services
Any Use Median Average
Total Expenditure Expenditure
Characteristics N %37 Expenditure Per User Per User
Total 47,958 100% $420,962,480 $3,670 $8,778
Demographics
Age
0-13 25,853 54% $202,212,774 $3,322 $7,822
14-17 17,879 37% $183,789,590 $4,455 $10,280
18-21 4,180 9% $34,781,785 $3,278 $8,321
22-26 43 0.1% $176,378 $1,278 $4,102
Gender
Male 26,351 55% $238,631,189 $3,725 $9,056
Female 21,607 45% $182,331,291 $3,600 $8,439
Race / Ethnicity
White-NH 18,570 39% $183,734,139 $4,337 $9,894
African American-NH 8,494 18% $80,745,361 $3,956 $9,506
Asian-NH 300 1% $3,030,607 $4,296 $10,102
Pacific Islander-NH 232 0.5% $2,399,753 $3,790 $10,344
Native-NH 331 1% $3,060,346 $3,381 $9,246
Other 7,635 16% $47,636,061 $2,725 $6,239
Hispanic 11,995 25% $95,148,936 $3,219 $7,932
Unknown/Not Reported 401 1% $5,207,277 $4,588 $12,986
Cohort
SMI 1,893 4% $21,601,381 $5,387 $11,411
SED 24,112 50% $280,806,065 $5,314 $11,646
Substance Use Only 1,661 3% $6,385,665 $1,855 $3,844
Other BH Adult 1,869 4% $12,019,682 $2,463 $6,431
Other BH Youth 18,423 38% $100,149,687 $2,506 $5,436
37
This column represents the percentage of individuals who are in a given characteristic category of the total Foster Care Medicaid
Beneficiaries who received DMC/SMHS services. For example, of the 47,958 foster care DMH/SMHS recipients, 54% (or 25,853 individuals)
were aged 0-13.
CA BHNA Appendix A: DHCS Data 37
Table 2.4c: Medicaid Behavioral Health Care Expenditures Among Current Foster Care Medicaid Beneficiaries
2009 – FFS
Any Use Median Average
Total Expenditure Expenditure
Characteristics N %38 Expenditure Per User Per User
Total 11,156 100% $61,923,129 $196 $5,551
Demographics
Age
0-13 4,691 42% $21,821,567 $124 $4,652
14-17 5,232 47% $32,946,474 $339 $6,297
18-21 1,209 11% $7,047,030 $329 $5,829
22-26 21 0.2% $107,366 $418 $5,113
Gender
Male 6,935 62% $27,026,837 $162 $3,897
Female 4,221 38% $34,896,292 $284 $8,267
Race / Ethnicity
White-NH 5,304 48% $30,846,123 $239 $5,816
African American-NH 2,124 19% $12,314,147 $152 $5,798
Asian-NH 78 1% $906,183 $119 $11,618
Pacific Islander-NH 63 1% $823,140 $213 $13,066
Native-NH 96 1% $652,964 $227 $6,802
Other 338 3% $2,002,608 $473 $5,925
Hispanic 3,030 27% $12,842,743 $165 $4,239
Unknown/Not Reported 123 1% $1,535,221 $752 $12,481
Cohort
SMI 692 6% $6,763,454 $798 $9,774
SED 7,703 69% $47,559,043 $216 $6,174
Substance Use Only 863 8% $4,096,431 $243 $4,747
Other BH Adult 361 3% $207,409 $81 $575
Other BH Youth 1,537 14% $3,296,792 $88 $2,145
38
This column represents the percentage of individuals who are in a given characteristic category of the total Foster Care Medicaid
Beneficiaries who received FFS services in 2009. For example, of the 11,156 individuals who received FFS services, 42% (or 4,691
individuals) were aged 0-13.
39
This column represents the percentage of individuals who are in a given characteristic category of the total Foster Care Medicaid
Beneficiaries in 2008. For example, of the 51,209 beneficiaries in 2008, 48% (or 24,453 individuals) were aged 0-13.
40
Individuals may appear in more than one service category
CA BHNA Appendix A: DHCS Data 39
Table 2.5b: Medicaid Behavioral Health Care Expenditures Among Current Foster Care Medicaid Beneficiaries
2008 – DMC/SMHS Services
Any Use Median Average
Total Expenditure Expenditure
Characteristics N %41 Expenditure Per User Per User
Total 48,208 100% $398,353,286 $3,421 $8,263
Demographics
Age
0-13 22,757 47% $159,767,037 $2,925 $7,021
14-17 16,586 34% $160,898,588 $4,124 $9,701
18-21 8,761 18% $77,049,363 $3,752 $8,795
22-26 98 0.2% $471,672 $1,288 $4,813
Gender
Male 26,500 55% $226,239,327 $3,504 $8,537
Female 21,708 45% $172,113,959 $3,322 $7,929
Race / Ethnicity
White-NH 16,408 34% $160,343,874 $4,308 $9,772
African American-NH 8,095 17% $70,106,411 $3,669 $8,660
Asian-NH 235 0.5% $2,253,857 $2,765 $9,591
Pacific Islander-NH 161 0.3% $1,412,876 $2,778 $8,776
Native-NH 291 1% $2,557,487 $3,283 $8,789
Other 12,516 26% $77,005,052 $2,643 $6,153
Hispanic 10,172 21% $80,292,457 $3,245 $7,893
Unknown/Not Reported 330 1% $4,381,272 $4,924 $13,277
Cohort
SMI 3,906 8% $47,854,285 $5,999 $12,251
SED 21,809 45% $237,787,041 $4,848 $10,903
Substance Use Only 1,995 4% $7,519,918 $2,304 $3,769
Other BH Adult 3,881 8% $25,700,294 $2,701 $6,622
Other BH Youth 16,617 34% $79,491,748 $2,195 $4,784
41
This column represents the percentage of individuals who are in a given characteristic category of the total Foster Care Medicaid
Beneficiaries who received DMC/SMHS services in 2008. For example, of the 48,208 Foster Care DMC/SMHS recipients in 2008, 47% (or
22,757 individuals) were aged 0-13.
CA BHNA Appendix A: DHCS Data 40
Table 2.5c: Medicaid Behavioral Health Care Expenditures Among Current Foster Care Medicaid Beneficiaries
2008 – FFS
Any Use Median Average
Total Expenditure Expenditure
Characteristics N %42 Expenditure Per User Per User
Total 10,815 100% $52,928,462 $192 $4,894
Demographics
Age
0-13 3,891 36% $11,644,185 $113 $2,993
14-17 4,313 40% $26,584,567 $314 $6,164
18-21 2,560 24% $14,416,640 $375 $5,631
22-26 44 0.4% $230,517 $172 $5,239
Gender
Male 6,752 62% $25,380,400 $174 $3,759
Female 4,063 38% $27,548,062 $229 $6,780
Race / Ethnicity
White-NH 5,146 48% $26,816,701 $201 $5,211
African American-NH 2,111 20% $8,548,595 $165 $4,050
Asian-NH 70 1% $662,945 $102 $9,471
Pacific Islander-NH 56 1% $180,527 $122 $3,224
Native-NH 99 1% $553,195 $135 $5,588
Other 416 4% $2,882,433 $657 $6,929
Hispanic 2,823 26% $12,417,450 $162 $4,399
Unknown/Not Reported 94 1% $866,616 $508 $9,219
Cohort
SMI 1,466 14% $13,141,861 $730 $8,964
SED 6,454 60% $34,641,112 $171 $5,367
Substance Use Only 959 9% $1,503,491 $284 $1,568
Other BH Adult 710 7% $1,241,273 $109 $1,748
Other BH Youth 1,226 11% $2,400,725 $91 $1,958
42
This column represents the percentage of individuals who are in a given characteristic category of the total Foster Care Medicaid
Beneficiaries received FFS services in 2008. For example, of the 10,815 individuals who received FFS services in 2008, 36% (or 3,891
individuals) were aged 0-13.
43
This column represents the percentage of individuals who are in a given characteristic category of the total Foster Care Medicaid
Beneficiaries in 2007. For example, of the 50,232 beneficiaries in 2007, 41% (or 20,619 individuals) were aged 0-13.
44
Individuals may appear in more than one service category
CA BHNA Appendix A: DHCS Data 42
Table 2.6b: Medicaid Behavioral Health Care Expenditures Among Current Foster Care Medicaid Beneficiaries
2007 – DMC/SMHS Services
Any Use Median Average
Total Expenditure Expenditure
Characteristics N %45 Expenditure Per User Per User
Total 47,037 100% $369,718,389 $3,196 $7,860
Demographics
Age
0-13 19,098 41% $122,782,666 $2,735 $6,429
14-17 14,665 31% $135,134,158 $3,674 $9,215
18-21 12,654 27% $107,943,214 $3,448 $8,530
22-26 612 1% $3,801,111 $2,181 $6,211
Gender
Male 25,948 55% $208,863,290 $3,240 $8,049
Female 21,089 45% $160,855,099 $3,141 $7,627
Race / Ethnicity
White-NH 12,846 27% $111,666,047 $3,760 $8,693
African American-NH 7,120 15% $57,353,353 $3,254 $8,055
Asian-NH 107 0.2% $833,585 $2,992 $7,791
Pacific Islander-NH 115 0% $655,053 $2,800 $5,696
Native-NH 242 1% $1,751,776 $2,630 $7,239
Other 0 -- -- -- --
Hispanic 7,787 17% $58,762,789 $3,061 $7,546
Unknown/Not Reported 324 1% $3,364,644 $4,168 $10,385
Cohort
SMI 5,711 12% $66,124,779 $5,400 $11,578
SED 18,944 40% $191,502,952 $4,343 $10,109
Substance Use Only 2,064 4% $7,282,892 $1,906 $3,529
Other BH Adult 5,986 13% $40,261,721 $2,605 $6,726
Other BH Youth 14,332 30% $64,546,045 $2,050 $4,504
45
This column represents the percentage of individuals who are in a given characteristic category of the total Foster Care Medicaid
Beneficiaries who received DMC/SMHS services in 2007. For example, of the 47,037 Foster Care DMC/SMHS recipients in 2007, 41% (or
19,098 individuals) were aged 0-13.
CA BHNA Appendix A: DHCS Data 43
Table 2.6c: Medicaid Behavioral Health Care Expenditures Among Current Foster Care Medicaid Beneficiaries
2007 – FFS
Any Use Median Average
Total Expenditure Expenditure
Characteristics N %46 Expenditure Per User Per User
Total 11,068 100% $63,751,734 $156 $5,760
Demographics
Age
0-13 3,296 30% $13,486,939 $98 $4,092
14-17 3,670 33% $25,098,261 $182 $6,839
18-21 3,925 35% $24,085,422 $350 $6,136
22-26 168 2% $1,068,415 $139 $6,360
Gender
Male 6,879 62% $34,396,086 $149 $5,000
Female 4,189 38% $29,355,648 $180 $7,008
Race / Ethnicity
White-NH 3,461 31% $19,833,363 $131 $5,731
African American-NH 1,775 16% $9,550,916 $124 $5,381
Asian-NH 24 0% $104,509 $122 $4,355
Pacific Islander-NH 28 0% $199,874 $174 $7,138
Native-NH 66 1% $256,311 $167 $3,884
Other 0 -- -- -- --
Hispanic 1,868 17% $7,832,304 $135 $4,193
Unknown/Not Reported 88 1% $938,762 $471 $10,668
Cohort
SMI 2,179 20% $23,056,162 $891 $10,581
SED 5,534 50% $33,788,305 $132 $6,106
Substance Use Only 1,134 10% $2,786,961 $245 $2,458
Other BH Adult 1,125 10% $1,380,645 $96 $1,227
Other BH Youth 1,096 10% $2,739,661 $75 $2,500
46
This column represents the percentage of individuals who are in a given characteristic category of the total Medicaid Beneficiaries who
received FFS services in 2007. For example, of the 11,068 individuals who received FFS services, 30% (or 3,296 individuals) were aged 0-13.
47
This column represents the percentage of individuals who are in a given characteristic category of the total EPSDT Medicaid
Beneficiaries in 2009. For example, of the 28,903 beneficiaries, 70% (or 20,275 individuals) were aged 0-13.
48
Individuals may appear in more than one service category
CA BHNA Appendix A: DHCS Data 45
Table 2.7b: Medicaid Behavioral Health Care Expenditures Among Current Medicaid Beneficiaries 2009 –
EPSDT DMC/SMHS Services
Any Use
Median Average
Total Expenditure Expenditure
Characteristics N %49 Expenditure Per User Per User
Total 18,299 100% $82,052,758 $619 $4,484
Demographics
Age
0-13 12,821 70% $49,827,776 $510 $3,886
14-17 5,424 30% $31,623,011 $1,098 $5,830
18-21 55 0% $609,130 $3,156 $11,075
22-26 0 0% -- -- --
Gender
Male 12,082 66% $54,132,957 $697 $4,480
Female 6,217 34% $27,919,801 $514 $4,491
Race / Ethnicity
White-NH 5,067 28% $30,960,325 $1,319 $6,110
African American-NH 1,529 8% $10,128,866 $928 $6,625
Asian-NH 223 1% $567,980 $250 $2,547
Pacific Islander-NH 110 1% $695,395 $287 $6,322
Native-NH 170 1% $1,471,185 $2,313 $8,654
Other 2,920 16% $13,437,512 $1,223 $4,602
Hispanic 8,143 44% $23,957,288 $300 $2,942
Unknown/Not Reported 138 1% $841,366 $989 $6,097
Cohort
SMI 38 0% $459,449 $3,374 $12,091
SED 12,677 69% $72,249,611 $1,156 $5,699
Substance Use Only 257 1% $446,100 $294 $1,736
Other BH Adult 16 0% $149,278 $2,474 $9,330
Other BH Youth 5,312 29% $8,755,479 $217 $1,648
49
This column represents the percentage of individuals who are in a given characteristic category of the total EPSDT Medicaid
Beneficiaries who received DMC/SMHS services in 2009. For example, of the 18,299 DMC/SMHS recipients, 70% (or 12,821
individuals) were aged 0-13.
50
This column represents the percentage of individuals who are in a given characteristic category of the total EPSDT Medicaid Beneficiaries
who received FFS services in 2009. For example, of the 4,292 individuals who received FFS services, 59% (or 2,513 individuals) were aged 0-
13.
51
This column represents the percentage of individuals who are in a given characteristic category of the total EPSDT Medicaid
Beneficiaries in 2008. For example, of the 16,285 beneficiaries, 67% (or 10,949 individuals) were aged 0-13.
52
Individuals may appear in more than one service category
CA BHNA Appendix A: DHCS Data 48
Table 2.8b: Medicaid Behavioral Health Care Expenditures Among Current Medicaid Beneficiaries 2008 –
EPSDT DMC/SMHS Services
Any Use
Median Average
Total Expenditure Expenditure
Characteristics N %53 Expenditure Per User Per User
Total 14,535 100% $65,837,723 $699 $4,530
Demographics
Age
0-13 9,737 67% $37,288,902 $528 $3,830
14-17 4,715 32% $27,461,511 $1,124 $5,824
18-21 83 1% $1,087,310 $3,660 $13,100
22-26 0 0% -- -- --
Gender
Male 9,754 67% $45,189,554 $768 $4,633
Female 4,781 33% $20,648,169 $551 $4,319
Race / Ethnicity
White-NH 3,830 26% $23,921,655 $1,412 $6,246
African American-NH 1,293 9% $7,750,332 $859 $5,994
Asian-NH 369 3% $1,021,332 $249 $2,768
Pacific Islander-NH 79 1% $247,286 $268 $3,130
Native-NH 116 1% $679,576 $1,782 $5,858
Other 2,504 17% $14,205,499 $1,865 $5,673
Hispanic 6,240 43% $17,338,623 $284 $2,779
Unknown/Not Reported 104 1% $673,420 $515 $6,475
Cohort
SMI 57 0.4% $912,154 $5,927 $16,003
SED 10,133 70% $58,765,005 $1,279 $5,799
Substance Use Only 198 1% $397,879 $280 $2,009
Other BH Adult 25 0.2% $147,777 $1,574 $5,911
Other BH Youth 4,122 28% $5,614,908 $224 $1,362
53
This column represents the percentage of individuals who are in a given characteristic category of the total EPSDT Medicaid
Beneficiaries who received DMC/SMHS services in 2008. For example, of the 14,353 DMC/SMHS recipients, 67% (or 9,737
individuals) were aged 0-13.
54
This column represents the percentage of individuals who are in a given characteristic category of the total EPSDT Medicaid Beneficiaries
who received FFS service in 2008. For example, of the 3,650 individuals who received FFS services, 58% (or 2,119 individuals) were aged 0-
13.
CA BHNA Appendix A: DHCS Data 50
Table 2.9a: Medicaid Behavioral Health Care Expenditures Among Current Medicaid Beneficiaries – EPSDT
2007
Any Use
Median Average
Total Expenditure Expenditure
Characteristics N %55 Expenditure Per User Per User
Total 13,932 100% $62,727,056 $550 $4,502
Demographics
Age
0-13 8,817 63% $29,371,242 $425 $3,331
14-17 4,873 35% $31,519,790 $1,000 $6,468
18-21 242 2% $1,836,024 $804 $7,587
22-26 0 0% -- -- --
Gender
Male 9,495 68% $42,856,958 $620 $4,514
Female 4,437 32% $19,870,098 $444 $4,478
Race / Ethnicity
White-NH 1,798 13% $13,836,358 $1,740 $7,695
African American-NH 596 4% $5,431,643 $1,378 $9,113
Asian-NH 29 0.2% $62,277 $471 $2,147
Pacific Islander-NH 27 0.2% $114,160 $262 $4,228
Native-NH 69 0.5% $346,432 $1,331 $5,021
Other 0 -- -- -- --
Hispanic 2,404 17% $8,155,611 $312 $3,393
Unknown/Not Reported 161 1% $582,399 $159 $3,617
56
Service Categories
Residential 1 0% $154 -- $154
Emergency 802 6% $830,443 -- $1,035
Hospital/Inpatient 653 5% $12,208,759 -- $18,696
Mental Health Treatment Outpatient 7,392 53% $40,304,762 -- $5,452
Mental Health Rehabilitation 10,077 72% $6,827,997 -- $678
Substance Use Services 674 5% $1,931,304 -- $2,865
Cohort
SMI 93 1% $1,439,914 $3,261 $15,483
SED 9,560 69% $54,183,790 $992 $5,668
Substance Use Only 333 2% $1,687,444 $326 $5,067
Other BH Adult 135 1% $382,980 $150 $2,837
Other BH Youth 3,811 27% $5,032,928 $197 $1,321
55
This column represents the percentage of individuals who are in a given characteristic category of the total EPSDT Medicaid
Beneficiaries in 2007. For example, of the 13,932 beneficiaries, 63% (or 8,817 individuals) were aged 0-13.
56
Individuals may appear in more than one service category
CA BHNA Appendix A: DHCS Data 51
Table 2.9b: Medicaid Behavioral Health Care Expenditures Among Current Medicaid Beneficiaries 2007 –
EPSDT DMC/SMHS Services
Any Use
Median Average
Total Expenditure Expenditure
Characteristics N %57 Expenditure Per User Per User
Total 12,290 100% $49,516,079 $685 $4,029
Demographics
Age
0-13 7,704 63% $24,676,937 $498 $3,203
14-17 4,441 36% $23,660,054 $1,165 $5,328
18-21 145 1% $1,179,088 $2,384 $8,132
22-26 0 -- -- -- --
Gender
Male 8,374 68% $35,100,146 $768 $4,192
Female 3,916 32% $14,415,933 $535 $3,681
Race / Ethnicity
White-NH 1,533 12% $10,733,213 $2,352 $7,001
African American-NH 491 4% $3,771,088 $2,231 $7,680
Asian-NH 27 0.2% $61,290 $583 $2,270
Pacific Islander-NH 19 0.2% $90,862 $711 $4,782
Native-NH 54 0.4% $229,184 $1,655 $4,244
Other 0 0% -- -- --
Hispanic 2,077 17% $6,579,453 $413 $3,168
Unknown/Not Reported 83 1% $468,186 $536 $5,641
Cohort
SMI 73 1% $811,239 $4,820 $11,113
SED 8,505 69% $43,617,936 $1,230 $5,129
Substance Use Only 150 1% $230,238 $240 $1,535
Other BH Adult 69 1% $362,012 $1,642 $5,247
Other BH Youth 3,493 28% $4,494,654 $212 $1,287
57
This column represents the percentage of individuals who are in a given characteristic category of the total EPSDT Medicaid
Beneficiaries who received DMC/SMHS services in 2007. For example, of the 12,290 DMC/SMHS recipients, 63% (or 7,704
individuals) were aged 0-13.
CA BHNA Appendix A: DHCS Data 52
Table 2.9c: Medicaid Behavioral Health Care Expenditures Among Current Medicaid Beneficiaries 2007 –
EPSDT FFS
Any Use Median Average
Total Expenditure Expenditure
Characteristics N %58 Expenditure Per User Per User
Total 3,302 100% $13,210,977 $140 $4,001
Demographics
Age
0-13 1,877 57% $4,694,305 $137 $2,501
14-17 1,239 38% $7,859,736 $159 $6,344
18-21 186 6% $656,936 $105 $3,532
22-26 0 0% -- -- --
Gender
Male 2,284 69% $7,756,812 $135 $3,396
Female 1,018 31% $5,454,165 $154 $5,358
Race / Ethnicity
White-NH 651 20% $3,103,145 $155 $4,767
African American-NH 265 8% $1,660,555 $108 $6,266
Asian-NH 7 0% $987 $118 $141
Pacific Islander-NH 11 0.3% $23,298 $116 $2,118
Native-NH 21 1% $117,248 $498 $5,583
Other 0 0% -- -- --
Hispanic 553 17% $1,576,158 $125 $2,850
Unknown/Not Reported 95 3% $114,213 $101 $1,202
Cohort
SMI 75 2% $628,675 $151 $8,382
SED 2,406 73% $10,565,854 $148 $4,391
Substance Use Only 235 7% $1,457,206 $335 $6,201
Other BH Adult 99 3% $20,968 $96 $212
Other BH Youth 487 15% $538,274 $100 $1,105
58
This column represents the percentage of individuals who are in a given characteristic category of the total EPSDT Medicaid
Beneficiaries who received FFS services in 2007. For example, of the 3,302 individuals who received FFS services, 57% (or 1,877
individuals) were aged 0-13.
38%
$1,414,862,390 Residential
Emergency
Hospital/Inpatient
44% Mental Health Treatment Outpatient
$1,660,470,323
Mental Health Rehabilitation
Substance Use Services
40%
$1,337,497,299 Residential
Emergency
Hospital/Inpatient
41% Mental Health Treatment Outpatient
$1,384,244,304
Mental Health Rehabilitation
Substance Use Services
42%
Residential
$1,321,482,746
Emergency
Hospital/Inpatient
39%
$1,236,590,551 Mental Health Treatment Outpatient
Mental Health Rehabilitation
Substance Use Services
Residential
48%
Emergency
$1,251,090,603
31% Hospital/Inpatient
$804,680,300 Mental Health Treatment Outpatient
Mental Health Rehabilitation
Substance Use Services
6% 14%
$150,371,556 $336,636,181
Residential
51% Emergency
$1,213,020,057
27% Hospital/Inpatient
$657,258,283 Mental Health Treatment Outpatient
Mental Health Rehabilitation
Substance Use Services
Residential
51% Emergency
$1,217,665,423
28% Hospital/Inpatient
$666,207,369
Mental Health Treatment Outpatient
Mental Health Rehabilitation
Substance Use Services
14%
$163,771,787
Residential
Emergency
Hospital/Inpatient
Mental Health Treatment Outpatient
74% Mental Health Rehabilitation
$855,790,023
Substance Use Services
13%
$124,477,242
Residential
Emergency
Hospital/Inpatient
Mental Health Treatment Outpatient
76% Mental Health Rehabilitation
$726,986,021
Substance Use Services
13%
$103,817,323
Residential
Emergency
Hospital/Inpatient
Mental Health Treatment Outpatient
75% Mental Health Rehabilitation
$570,383,182
Substance Use Services
59
These figures represent the percentage of the total high utilizer expenditure of a given cohort. For example, amongst the top 20%
of utilizers in 2009, high utilizers diagnosed with SMI expended 60% of the total top 20% high utilizer expenditure.
60
This total represents 82% of the total expenditures for 2009.
61
This total represents 69% of the total expenditures for 2009.
62
This total represents 55% of the total expenditures for 2009.
CA BHNA Appendix A: DHCS Data 59
Table 3b: Behavioral Health Expenditures by Top Utilizers 2008
% of Total 2008
Condition N Avg. per person Total Expenditure High Utilizer Expenditure 63
TOP 20%
SMI 54,242 $30,645 $1,662,262,493 60%
SED 26,505 $21,212 $562,215,799 20%
Substance Use Only 8,631 $22,909 $197,728,687 7%
Other BH – Adult 6,686 $28,097 $187,859,383 7%
Other BH – Youth 12,097 $13,823 $167,219,141 6%
Total 108,161 $116,687 $2,777,285,50364 100%
TOP 10%
SMI 31,446 $46,606 $1,465,561,791 63%
SED 13,503 $33,260 $449,107,480 19%
Substance Use Only 1,604 $90,843 $145,712,818 6%
Other BH – Adult 3,352 $47,508 $159,245,875 7%
Other BH – Youth 4,176 $23,854 $99,615,154 4%
Total 54,081 $242,071 $2,319,243,11865 100%
TOP 5%
SMI 17,182 $70,752 $1,215,662,652 66%
SED 6,036 $53,134 $320,718,372 17%
Substance Use Only 997 $135,976 $135,567,787 7%
Other BH – Adult 1,684 $77,458 $130,439,785 7%
Other BH – Youth 1,142 $42,181 $48,170,301 3%
Total 27,041 $379,501 $1,850,558,89766 100%
63
These figures represent the percentage of the total high utilizer expenditures of a given cohort. For example, amongst the top 20%
of utilizers in 2009, high utilizers diagnosed with SMI expended 60% of the total top 20% high utilizer expenditure.
64
This total represents 81% of the total expenditures for 2008.
65
This total represents 68% of the total expenditures for 2008.
66
This total represents 54% of the total expenditures for 2008.
CA BHNA Appendix A: DHCS Data 60
Table 3c: Behavioral Health Expenditures by Top Utilizers 2007
% of Total 2007
Condition N Avg. per person Total Expenditure High Utilizer Expenditure 67
TOP 20%
SMI 56,246 $28,999 $1,631,062,449 63%
SED 22,438 $20,045 $449,775,336 17%
Substance Use Only 7,615 $21,625 $164,670,981 6%
Other BH – Adult 8,564 $26,155 $223,990,171 9%
Other BH – Youth 9,752 $12,951 $126,295,210 5%
Total 104,615 $24,813 $2,595,794,14768 100%
TOP 10%
SMI 32,536 $44,217 $1,438,635,141 66%
SED 10,853 $32,783 $355,789,981 16%
Substance Use Only 1,590 $77,087 $122,568,043 6%
Other BH – Adult 4,259 $44,449 $189,309,329 9%
Other BH – Youth 3,070 $23,808 $73,090,584 3%
Total 52,308 $41,665 $2,179,393,07869 100%
TOP 5%
SMI 17,526 $67,617 $1,185,051,740 68%
SED 4,749 $53,604 $254,563,152 15%
Substance Use Only 935 $119,670 $111,891,359 6%
Other BH – Adult 2,105 $72,966 $153,592,705 9%
Other BH – Youth 839 $43,977 $36,896,358 2%
Total 26,154 $66,605 $1,741,995,31470 100%
67
These figures represent the percentage of the total high utilizer expenditures of a given cohort. For example, amongst the top 20%
of utilizers in 2009, high utilizers diagnosed with SMI expended 63% of the total top 20% high utilizer expenditure.
68
This total represents 82% of the total expenditures for 2007.
69
This total represents 69% of the total expenditures for 2007.
70
This total represents 55% of the total expenditures for 2007.
CA BHNA Appendix A: DHCS Data 61
Table 4: Characteristics of Current Participants in Behavioral Health Services 2009
No Outpatient
Top 20% MH/SUD Top 10% MH/SUD Top 5% MH/SUD MH/SUD
Total Service Utilizers Service Utilizers Service Utilizers Service Received
Characteristics N %71 N %72 N %73 N %74 N %75
Medicaid Beneficiaries 564,480 100% 112,896 20% 56,449 10% 28,225 5% 28,840 5%
Demographics
Age
0-13 121,286 21% 25,988 21% 10,302 8% 3,731 3% 4,681 4%
14-17 74,104 13% 19,593 26% 9,718 13% 4,111 6% 4,759 6%
18-21 30,035 5% 6,436 21% 3,321 11% 1,503 5% 2,404 8%
22-26 24,875 4% 4,293 17% 2,632 11% 1,371 6% 1,885 8%
27-64 280,653 50% 50,251 18% 26,305 9% 14,590 5% 14,206 5%
65+ 33,458 6% 6,329 19% 4,169 12% 2,918 9% 905 3%
Gender
Male 274,044 49% 61,189 22% 30,861 11% 15,284 6% 13,340 5%
Female 290,436 51% 51,707 18% 25,588 9% 12,941 4% 15,500 5%
Race / Ethnicity
White-NH 169,138 30% 39,482 23% 21,914 13% 12,108 7% 4,853 3%
African American-NH 61,543 11% 15,491 25% 8,810 14% 4,821 8% 3,501 6%
Asian-NH 7,500 1% 1,407 19% 797 11% 454 6% 110 1%
Pacific Islander-NH 13,460 2% 2,697 20% 1,624 12% 934 7% 186 1%
Native-NH 3,154 1% 707 22% 356 11% 188 6% 63 2%
Other 186,747 33% 28,459 15% 11,237 6% 4,081 2% 15,848 8%
Hispanic 117,863 21% 23,544 20% 11,065 9% 5,265 4% 4,041 3%
Unknown/Not Reported 4,898 1% 1,110 23% 646 13% 374 8% 238 5%
Medicaid Eligibility
CalWorks (TANF) 6,224 1% 858 14% 415 7% 176 3% 752 12%
SSI/SSP <65 229,264 41% 51,216 22% 27,983 12% 15,172 7% 11,722 5%
SSI/SSP ≥ 65 7,988 1% 1,321 17% 847 11% 552 7% 152 2%
Other Eligibility
9,317 2% 2,124 23% 1,746 19% 1,386 15% 146 2%
Categories for ≥65
Foster Care 44,875 8% 14,541 32% 7,467 17% 3,327 7% 1,624 4%
AFDC 171,002 30% 25,014 15% 9,041 5% 3,113 2% 8,847 5%
Other Disabled 40,107 7% 8,166 20% 4,710 12% 2,830 7% 2,160 5%
Other Child/Family 35,660 6% 6,238 17% 2,805 8% 1,059 3% 1,843 5%
Unknown 172 0% 28 16% 12 7% 4 2% 1 1%
All Remaining Other 19,872 4% 3,391 17% 1,423 7% 606 3% 1,593 8%
71
This column represents the percentage of individuals who are in a given characteristic category of the total Medicaid Beneficiaries in 2009.
For example, of the 564,480 beneficiaries, 21% (or 121,286 individuals) were aged 0-13.
72
This column represents the percentage of individuals in the top 20% of high MH/SUD Service Utilizers that are in a given characteristic
category of the total Medicaid Beneficiaries in 2009. For example, of the 564,480 beneficiaries in 2009, 21% (or 25,988 individuals) of the top
20% high utilizers were aged 0-13.
73
This column represents the percentage of individuals in the top 10% of high MH/SUD Service Utilizers that are in a given characteristic
category of the total Medicaid Beneficiaries in 2009. For example, of the 564,480 beneficiaries in 2009, 8% (or 10,302 individuals) of the top
10% high utilizers were aged 0-13.
74
This column represents the percentage of individuals in the top 5% of high MH/SUD Service Utilizers that are in a given characteristic
category of the total Medicaid Beneficiaries in 2009. For example, of the 564,480 beneficiaries in 2009, 3% (or 3,731 individuals) of the top
5% high utilizers were aged 0-13.
75
This column represents the percentage of individuals who received no outpatient MH/SUD services that are in a given characteristic
category of the total Medicaid Beneficiaries in 2009. For example, of the 564,480 beneficiaries in 2009, 4% (or 4,681 individuals) were aged 0-
13.
CA BHNA Appendix A: DHCS Data 62
No Outpatient
Top 20% MH/SUD Top 10% MH/SUD Top 5% MH/SUD MH/SUD
Total Service Utilizers Service Utilizers Service Utilizers Service Received
Characteristics N %71 N %72 N %73 N %74 N %75
Eligibility Categories
Cohort
SMI 255,603 45% 55,373 22% 32,513 13% 18,081 7% 14,680 6%
SED 99,661 18% 30,222 30% 14,916 15% 6,441 6% 4,464 4%
Substance Use Only 61,613 11% 7,735 13% 1,480 2% 959 2% 418 1%
Other BH Adult 62,679 11% 5,034 8% 2,620 4% 1,419 2% 4,335 7%
Other BH Youth 84,925 15% 14,533 17% 4,920 6% 1,325 2% 4,943 6%
Special Populations
Co-Occurring Mental
99,408 18% 24,601 25% 11,572 12% 6,771 7% 1,190 1%
Health/SUD
76
Represents the percentage of individuals enrolled in Medicaid by eligibility category. For example, of the 523,072 Medicaid
beneficiaries in 2007, 1% (or 6,067 individuals) were eligible through CalWorks (TANF).
77
Defined as presenting for service in calendar year and not in calendar year prior. Percents are of the total N in the current year.
CA BHNA Appendix A: DHCS Data 64
Table 6a: Number of ED Admissions by Cohort 2009
Number of BH Admissions
0 1-2 3-4 5-6 7+ Total
78
Cohort N % N % N % N % N % N %
SMI 204,238 80% 34,643 14% 8,964 4% 3,468 1% 4,290 2% 255,603 100%
SED 89,966 90% 6,736 7% 1,627 2% 569 1% 763 1% 99,661 100%
Substance Use Only 51,821 84% 8,719 14% 713 1% 182 0% 178 0% 61,613 100%
Other BH – Adult 52,249 83% 9,325 15% 812 1% 165 0% 128 0% 62,679 100%
Other BH – Youth 78,878 93% 5,094 6% 686 1% 157 0% 110 0% 84,925 100%
Total 477,152 85% 64,517 11% 12,802 2% 4,541 1% 5,469 1% 564,481 100%
78
Represents the percentage of individuals with zero (0) behavioral health related emergency department admissions in 2009. For example,
of the 255,603 individuals with SMI in 2009, 80% (or 204,238 individuals) had zero admissions.
79
Represents the percentage of individuals with zero (0) behavioral health related emergency department admissions in 2008. For example,
of the 252,183 individuals with SMI in 2008, 80% (or 201,140 individuals) had zero admissions.
80
Represents the percentage of individuals with zero (0) behavioral health related emergency department admissions in 2007. For example,
of the 249,829 individuals with SMI in 2007, 80% (or 199,498 individuals) had zero admissions.
CA BHNA Appendix A: DHCS Data 65
Table 7a: Number of Encounters –2009
DMC/SMHS FFS
Number of Encounters Number of Encounters
0 1-3 4-10 11+ Total 0 1-3 4-10 11+ Total
81 82
Cohort N % N % N % N % N % N % N % N % N % N %
Residential
SMI 220,410 99.9% 2 0% 9 0% 55 0.02% 220,476 100% 44,936 100% 0 0% 0 0% 0 0% 44,936 100%
SED 91,640 100% 0 0% 1 0% 0 0.00% 91,641 100% 17,831 100% 0 0% 0 0% 0 0% 17,831 100%
Substance Use 44,608 99% 26 0% 31 0% 259 0.12% 44,924 100% 27,709 100% 0 0% 0 0% 0 0% 27,709 100%
Other BH – 0
42,261 100% 0% 2 0% 2 0.00% 42,265 100% 25,156 100% 0 0% 0 0% 0 0% 25,156 100%
Adult
Other BH – 0
80,371 100% 0% 0 0% 1 0.00% 80,372 100% 10,271 100% 0 0% 0 0% 0 0% 10,271 100%
Youth
Emergency
SMI 174,907 79% 38,438 17% 6,215 3% 916 0% 220,476 100% 39,140 87% 5,595 12% 193 0% 8 0% 44,936 100%
SED 82,169 90% 8,295 9% 1,028 1% 149 0% 91,641 100% 17,608 99% 222 1% 1 0% 0 0% 17,831 100%
Substance Use 42,638 95% 2,152 5% 111 0% 23 0% 44,924 100% 20,203 73% 7,316 26% 173 1% 17 0% 27,709 100%
Other BH –
37,190 88% 4,854 11% 201 0% 20 0% 42,265 100% 19,801 79% 5,343 21% 12 0% 0 0% 25,156 100%
Adult
Other BH –
75,399 94% 4,805 6% 162 0% 6 0% 80,372 100% 9,197 90% 1,074 10% 0 0% 0 0% 10,271 100%
Youth
Hospital/Inpatient
SMI 180,513 82% 23,269 11% 9,161 4% 7,533 3% 220,476 100% 35,203 78% 6,209 14% 1,360 3% 2,164 5% 44,936 100%
SED 83,342 91% 5,091 6% 1,895 2% 1,313 1% 91,641 100% 17,702 99% 120 1% 7 0% 2 0% 17,831 100%
Substance Use 43,283 96% 1,096 2% 210 0% 335 1% 44,924 100% 26,591 96% 980 4% 121 0% 17 0% 27,709 100%
Other BH –
38,971 92% 2,569 6% 484 1% 241 1% 42,265 100% 22,066 88% 1,780 7% 420 2% 890 4% 25,156 100%
Adult
Other BH –
76,314 95% 2,448 3% 783 1% 827 1% 80,372 100% 10,001 97% 236 2% 23 0% 11 0% 10,271 100%
Youth
Mental Health Treatment Outpatient
SMI 21,888 10% 50,222 23% 67,846 31% 80,520 37% 220,476 100% 11,265 25% 25,041 56% 4,707 10% 3,923 9% 44,936 100%
SED 4,334 5% 14,437 16% 19,021 21% 53,849 59% 91,641 100% 404 2% 14,798 83% 2,073 12% 556 3% 17,831 100%
Substance Use 37,845 84% 5,175 12% 1,146 3% 758 2% 44,924 100% 22,148 80% 5,293 19% 211 1% 57 0% 27,709 100%
Other BH –
7,149 17% 13,201 31% 11,614 27% 10,301 24% 42,265 100% 8,448 34% 15,141 60% 1,084 4% 483 2% 25,156 100%
Adult
Other BH –
6,019 7% 19,464 24% 19,282 24% 35,607 44% 80,372 100% 1,416 14% 8,476 83% 277 3% 102 1% 10,271 100%
Youth
81
Represents the percentage of individuals with who received DMC/SMHS services in 2009 who had zero (0) encounters in 2009 by service and cohort. For example, of the 220,476
individuals diagnosed with SMI receiving DMC/SMHS services, 99.9% (or 220,410 individuals) had zero encounters with Residential services.
82
Represents the percentage of individuals with received FFS services in 2009 who had zero (0) encounters in 2009 by service and cohort. For example, of the 44,936 individuals
diagnosed with SMI receiving FFS services, 100% (or 44,936 individuals) had zero encounters with Residential services.
CA BHNA Appendix A: DHCS Data 66
DMC/SMHS FFS
Number of Encounters Number of Encounters
0 1-3 4-10 11+ Total 0 1-3 4-10 11+ Total
81 82
Cohort N % N % N % N % N % N % N % N % N % N %
Mental Health Rehabilitation
SMI 108,203 49% 57,597 26% 31,230 14% 23,446 11% 220,476 100% 44,923 100% 9 0% 3 0% 1 0% 44,936 100%
SED 44,009 48% 23,632 26% 13,223 14% 10,777 12% 91,641 100% 17,683 99% 130 1% 18 0% 0 0% 17,831 100%
Substance Use 41,585 93% 2,873 6% 328 1% 138 0% 44,924 100% 27,702 100% 2 0% 2 0% 3 0% 27,709 100%
Other BH –
24,842 59% 11,494 27% 3,698 9% 2,231 5% 42,265 100% 25,132 100% 20 0% 3 0% 1 0% 25,156 100%
Adult
Other BH –
45,962 57% 21,111 26% 8,505 11% 4,794 6% 80,372 100% 10,251 100% 20 0% 0 0% 0 0% 10,271 100%
Youth
Substance Use Services
SMI 191,049 87% 15,340 7% 2,724 1% 11,363 5% 220,476 100% 40,369 90% 4,067 9% 378 1% 122 0% 44,936 100%
SED 86,633 95% 2,655 3% 559 1% 1,794 2% 91,641 100% 17,620 99% 200 1% 6 0% 5 0% 17,831 100%
Substance Use 2,871 6% 5,890 13% 5,880 13% 30,283 67% 44,924 100% 5,095 18% 21,008 76% 1,181 4% 425 2% 27,709 100%
Other BH –
40,363 95% 1,438 3% 224 1% 240 1% 42,265 100% 23,857 95% 1,264 5% 33 0% 2 0% 25,156 100%
Adult
Other BH –
78,505 98% 1,212 2% 248 0% 407 1% 80,372 100% 9,961 97% 305 3% 5 0% 0 0% 10,271 100%
Youth
83
Represents the percentage of individuals with who received DMC/SMHS services in 2008 who had zero (0) encounters in 2008 by service and cohort. For example, of the 220,945
individuals diagnosed with SMI receiving DMC/SMHS services, 99.9% (or 220,847 individuals) had zero encounters with Residential services.
84
Represents the percentage of individuals with who received FFS services in 2008 who had zero (0) encounters in 2008 by service and cohort. For example, of the 42,594 individuals
diagnosed with SMI receiving FFS services, 100% (or 42,594 individuals) had zero encounters with Residential services.
CA BHNA Appendix A: DHCS Data 68
DMC/SMHS FFS
Number of Encounters Number of Encounters
0 1-3 4-10 11+ Total 0 1-3 4-10 11+ Total
83 84
Cohort N % N % N % N % N % N % N % N % N % N %
Other BH – Adult 28,195 59% 11,739 25% 4,639 10% 3,107 7% 47,680 100% 25,312 100% 25 0% 4 0% 1 0% 25,342 100%
Other BH –
40,065 58% 18,164 26% 6,934 10% 3,900 6% 69,063 100% 9,553 100% 15 0% 1 0% 3 0% 9,572 100%
Youth
Substance Use Services
SMI 191,440 87% 15,567 7% 2,758 1% 11,180 5% 220,945 100% 38,290 90% 3,893 9% 322 1% 89 0% 42,594 100%
SED 77,275 95% 1,925 2% 373 0% 1,345 2% 80,918 100% 15,983 99% 163 1% 10 0% 1 0% 16,157 100%
Substance Use 2,754 7% 5,247 12% 5,162 12% 28,942 69% 42,105 100% 5,295 19% 20,577 75% 1,154 4% 432 2% 27,458 100%
Other BH – Adult 45,188 95% 1,792 4% 336 1% 364 1% 47,680 100% 24,124 95% 1,203 5% 14 0% 1 0% 25,342 100%
Other BH –
67,804 98% 855 1% 163 0% 241 0% 69,063 100% 9,381 98% 190 2% 0 0% 1 0% 9,572 100%
Youth
85
Represents the percentage of individuals with who received DMC/SMHS services in 2007 who had zero (0) encounters in 2007 by service and cohort. For example, of the 218,243
individuals diagnosed with SMI receiving DMC/SMHS services, 99.9% (or 218,077 individuals) had zero encounters with Residential services.
86
Represents the percentage of individuals with who received FFS services in 2007 who had zero (0) encounters in 2007 by service and cohort. For example, of the 42,339 individuals
diagnosed with SMI receiving FFS services, 100% (or 42,339 individuals) had zero encounters with Residential services.
CA BHNA Appendix A: DHCS Data 70
DMC/SMHS FFS
Number of Encounters Number of Encounters
0 1-3 4-10 11+ Total 0 1-3 4-10 11+ Total
85 86
Cohort N % N % N % N % N % N % N % N % N % N %
SMI 189,696 87% 14,461 7% 2,859 1% 11,227 5% 218,243 100% 38,110 90% 3,806 9% 342 1% 81 0% 42,339 100%
SED 67,210 97% 1,074 2% 228 0% 791 1% 69,303 100% 14,601 99% 99 1% 6 0% 0 0% 14,706 100%
Substance Use 2,790 7% 4,962 12% 4,994 12% 27,329 68% 40,075 100% 4,715 18% 20,014 76% 1,202 5% 397 2% 26,328 100%
Other BH – Adult 49,681 95% 1,725 3% 391 1% 482 1% 52,279 100% 25,777 95% 1,233 5% 23 0% 3 0% 27,036 100%
Other BH – Youth 57,315 99% 458 1% 104 0% 152 0% 58,029 100% 8,874 98% 195 2% 3 0% 0 0% 9,072 100%
87
Represents the percentage of individuals within a characteristic category with an elapsed time of 0-7 days between hospital discharge and receipt of Medicaid Behavioral
Health Outpatient services in 2009. For example, of the 7,210 individuals aged 0-13 in 2009 with a hospital discharge, 71% (or 5,120 individuals) had an elapsed time of 0-7 days
before receiving Medicaid BH Outpatient services.
CA BHNA Appendix A: DHCS Data 72
0-7 Days 8-14 Days 15-30 Days 30+ Days No Contact
Characteristics Total Discharge N N %87 N % N % N % N %
Other Child/Family 3,643 2,120 58% 206 6% 168 5% 201 6% 948 26%
Unknown 1 0 0% 0 0% 0 0% 0 0% 1 100%
All Remaining Other Eligibility Categories 2,965 1,229 41% 95 3% 94 3% 147 5% 1,400 47%
Cohort
SMI 137,868 99,433 72% 6,592 5% 5,762 4% 6,507 5% 19,574 14%
SED 13,828 10,208 74% 872 6% 606 4% 593 4% 1,549 11%
Substance Use Only 1,280 396 31% 18 1% 17 1% 49 4% 800 63%
Other BH Adult 788 393 50% 25 3% 24 3% 27 3% 319 40%
Other BH Youth 3,302 1,536 47% 161 5% 124 4% 158 5% 1,323 40%
Special Populations
Co-Occurring Mental Health/SUD 44,961 33,425 74% 2,246 5% 1,973 4% 2,385 5% 4,932 11%
88
Represents the percentage of individuals within a characteristic category with an elapsed time of 0-7 days between hospital discharge and receipt of Medicaid Behavioral
Health Outpatient services in 2008. For example, of the 4,830 individuals aged 0-13 in 2008 with a hospital discharge, 68% (or 3,270 individuals) had an elapsed time of 0-7 days
before receiving Medicaid BH Outpatient services.
CA BHNA Appendix A: DHCS Data 74
0-7 Days 8-14 Days 15-30 Days 30+ Days No Contact
Characteristics Total Discharge N N %88 N % N % N % N %
Other Child/Family 3,352 1,996 60% 202 6% 137 4% 181 5% 836 25%
Unknown 1 0 % 0 % 1 100% 0 % 0 %
All Remaining Other Eligibility Categories 2,846 1,119 39% 111 4% 99 3% 150 5% 1,367 48%
Cohort
SMI 135,139 95,987 71% 6,684 5% 5,730 4% 6,691 5% 20,047 15%
SED 10,007 7,177 72% 626 6% 480 5% 508 5% 1,216 12%
Substance Use Only 1,185 400 34% 20 2% 15 1% 35 3% 715 60%
Other BH Adult 517 185 36% 31 6% 15 3% 30 6% 256 50%
Other BH Youth 2,372 1,028 43% 133 6% 94 4% 99 4% 1,018 43%
Special Populations
Co-Occurring Mental Health/SUD 44,552 33,321 75% 2,193 5% 1,896 4% 2,402 5% 4,740 11%
89
Represents the percentage of individuals within a characteristic category with an elapsed time of 0-7 days between hospital discharge and receipt of Medicaid Behavioral
Health Outpatient services in 2007. For example, of the 4,161 individuals aged 0-13 in 2007 with a hospital discharge, 66% (or 2,705 individuals) had an elapsed time of 0-7 days
before receiving Medicaid BH Outpatient services.
CA BHNA Appendix A: DHCS Data 76
0-7 Days 8-14 Days 15-30 Days 30+ Days No Contact
Characteristics Total Discharge N N %89 N % N % N % N %
Other Child/Family 3,226 1,636 51% 237 7% 175 5% 190 6% 988 31%
Unknown 0 -- -- -- -- -- -- -- -- -- --
All Remaining Other Eligibility Categories 2,401 712 30% 102 4% 90 4% 135 6% 1,362 57%
Cohort
SMI 101,993 61,376 60% 7,241 7% 6,013 6% 6,711 7% 20,652 20%
SED 7,815 5,443 70% 543 7% 430 6% 442 6% 957 12%
Substance Use Only 1,473 306 21% 38 3% 28 2% 38 3% 1,063 72%
Other BH Adult 578 181 31% 40 7% 18 3% 27 5% 312 54%
Other BH Youth 1,780 674 38% 98 6% 59 3% 82 5% 867 49%
Special Populations
Co-Occurring Mental Health/SUD 31,155 19,414 62% 2,415 8% 1,935 6% 2,315 7% 5,076 16%
90 st
Admissions are based on the number of valid admissions (admissions with no discharge before Dec 1 and admissions less than 1 day
from prior discharge have been eliminated).
91
This represents the percent of individuals who had a valid admission followed by an inpatient readmission within 30 days of their
previous discharge. For example, of the 4,072 individuals aged 0-13 with a valid admission, 13% (or 511 individuals) had a hospital inpatient
readmission within 30 days of discharge for behavioral health reasons.
92
This represents the percent of individuals who had a valid admission followed by an emergency department readmission within 30 days
of their previous discharge. For example, of the 4,072 individuals aged 0-13 with a valid admission, 6% (or 234 individuals) had an
emergency department readmission within 30 days of discharge for behavioral health reasons.
CA BHNA Appendix A: DHCS Data 78
Table 9b: Special Analyses: Hospital and Emergency Department Readmissions within 30 Days of Inpatient
Discharge for a Behavioral Health Condition 2008
Unique Individuals with Mental Health
Valid Inpatient Admission Inpatient Emergency Department
93 94 95
Characteristics N N % N %
Total 88,486 17,624 20% 4,428 5%
Demographics
Age
0-13 3,477 273 8% 110 3%
14-17 6,142 874 14% 404 7%
18-21 4,962 867 17% 283 6%
22-26 6,901 1,611 23% 446 6%
27-64 60,187 13,473 22% 3,128 5%
65+ 6,798 525 8% 57 1%
Gender
Male 46,112 10,218 22% 2,302 5%
Female 42,374 7,406 17% 2,126 5%
Race / Ethnicity
White-NH 31,143 5,429 17% 1,482 5%
African American-NH 14,217 3,517 25% 474 3%
Asian-NH 890 106 12% 23 3%
Pacific Islander-NH 2,028 389 19% 74 4%
Native-NH 395 50 13% 17 4%
Other 25,855 5,781 22% 1,864 7%
Hispanic 12,870 2,150 17% 453 4%
Unknown/Not Reported 1,088 202 19% 41 4%
Medicaid Eligibility
CalWorks (TANF) 634 78 12% 21 3%
SSI/SSP <65 54,220 13,004 24% 3,100 6%
SSI/SSP ≥ 65 909 51 6% 8 1%
Other Eligibility Categories for ≥65 3,338 236 7% 6 0%
Foster Care 3,373 532 16% 228 7%
AFDC 10,823 1,151 11% 479 4%
Other Disabled 10,148 1,835 18% 388 4%
Other Child/Family 2,471 360 15% 132 5%
Unknown 1 0 0% 0 0%
All Remaining Other Eligibility Categories 2,569 377 15% 66 3%
Cohort
SMI 73,204 16,143 22% 3,829 5%
SED 7,324 1,056 14% 462 6%
Substance Use Only 838 45 5% 16 2%
Other BH Adult 4,846 289 6% 69 1%
Other BH Youth 2,274 91 4% 52 2%
Special Populations
Co-Occurring Mental Health/SUD 24,578 8,028 33% 1,434 6%
Service Utilization
High MH/SUD Medicaid service utilizer 46,573 14,279 31% 3,035 7%
93 st
Admissions are based on the number of valid admissions (admissions with no discharge before Dec 1 and admissions less than 1 day
from prior discharge have been eliminated).
94
This represents the percent of individuals who had a valid admission followed by an inpatient readmission within 30 days of their
previous discharge. For example, of the 3,477 individuals aged 0-13 with a valid admission, 8% (or 273 individuals) had a hospital inpatient
readmission within 30 days of discharge for behavioral health reasons.
95
This represents the percent of individuals who had a valid admission followed by an emergency department readmission within 30 days
of their previous discharge. For example, of the 3,477 individuals aged 0-13 with a valid admission, 3% (or 110 individuals) had an
emergency department readmission within 30 days of discharge for behavioral health reasons.
CA BHNA Appendix A: DHCS Data 79
Table 9c: Special Analyses: Hospital and Emergency Department Readmissions within 30 Days of Inpatient
Discharge for a Behavioral Health Condition 2007
Unique Individuals with Mental Health
Valid Inpatient Admission Inpatient Emergency Department
96 97 98
Characteristics N N % N %
Total 76,790 17,714 23% 4,171 5%
Demographics
Age
0-13 2,480 260 10% 100 4%
14-17 4,266 632 15% 269 6%
18-21 4,576 727 16% 250 5%
22-26 6,420 1,572 24% 402 6%
27-64 54,127 13,974 26% 3,072 6%
65+ 4,898 549 11% 78 2%
Gender
Male 39,776 10,250 26% 2,103 5%
Female 37,014 7,464 20% 2,068 6%
Race / Ethnicity
White-NH 14,103 2,851 20% 816 6%
African American-NH 7,518 2,053 27% 241 3%
Asian-NH 145 15 10% 8 6%
Pacific Islander-NH 637 123 19% 21 3%
Native-NH 157 33 21% 12 8%
Other 0 -- -- --
Hispanic 5,215 968 19% 210 4%
Unknown/Not Reported 903 199 22% 34 4%
Medicaid Eligibility
CalWorks (TANF) 633 69 11% 11 2%
SSI/SSP <65 48,558 13,309 27% 2,996 6%
SSI/SSP ≥ 65 734 49 7% 11 1%
Other Eligibility Categories for ≥65 1,816 218 12% 8 0%
Foster Care 2,981 533 18% 254 9%
AFDC 9,925 1,091 11% 363 4%
Other Disabled 7,802 1,778 23% 363 5%
Other Child/Family 2,278 329 14% 122 5%
Unknown 0 -- -- --
All Remaining Other Eligibility Categories 2,063 338 16% 43 2%
Cohort
SMI 64,970 16,539 25% 3,734 6%
SED 5,289 824 16% 323 6%
Substance Use Only 713 36 5% 3 0%
Other BH Adult 4,368 249 6% 65 1%
Other BH Youth 1,450 66 5% 46 3%
Special Populations
Co-Occurring Mental Health/SUD 22,303 7,929 36% 1,441 6%
Service Utilization
High MH/SUD Medicaid service utilizer 39,439 14,421 37% 2,814 7%
96 st
Admissions are based on the number of valid admissions (admissions with no discharge before Dec 1 and admissions less than 1 day
from prior discharge have been eliminated).
97
This represents the percent of individuals who had a valid admission followed by an inpatient readmission within 30 days of their
previous discharge. For example, of the 2,480 individuals aged 0-13 with a valid admission, 10% (or 260 individuals) had a hospital inpatient
readmission within 30 days of discharge for behavioral health reasons.
98
This represents the percent of individuals who had a valid admission followed by an emergency department readmission within 30 days
of their previous discharge. For example, of the 2,480 individuals aged 0-13 with a valid admission, 4% (or 100 individuals) had an
emergency department readmission within 30 days of discharge for behavioral health reasons.
CA BHNA Appendix A: DHCS Data 80
Table 10a: System at a Glance – Adults
99
Average number of new adults entering the system each month.
100
Average number of adult consumers continuously serviced by the system.
101
This number represents the average percent that exit the system (those who do not receive a service for the three months following the
last month of service) in a given month. The denominator varies by month and includes those currently receiving services (continuously
served plus new arrivals receiving services in the three month window of the month).
102
Average number of new youth entering the system each month.
103
Average number of youth consumers continuously serviced by the system.
104
This number represents the average percent that exit the system (those who do not receive a service for the three months following the
last month of service) in a given month. The denominator varies by month and includes those currently receiving services (continuously
served plus new arrivals receiving services in the three month window of the month).
CA BHNA Appendix A: DHCS Data 81
Table 11a: Number of Months with Service Received – 2009 Adults
105
Represents the percentage of adults out of all adults receiving services who received services for a given
number of months in 2009. For example, in 2009, 282,901 adults received services; of those, 29% (or 82,987
adults) received services for one month.
106
Represents the percentage of adults out of all adults receiving services who received services for a given
number of months in 2008. For example, in 2008, 272,904 adults received services; of those, 29% (or 79,315
adults) received services for one month.
107
Represents the percentage of adults out of all adults receiving services who received services for a given
number of months in 2007. For example, in 2007, 262,964 adults received services; of those, 29% (or 74,867
adults) received services for one month.
108
Represents the percentage of youth out of all youth receiving services who received services for a given number
of months in 2009. For example, in 2009, 193,189 youth received services; of those, 25% (or 49,051 youth)
received services for one month.
109
Represents the percentage of youth out of all youth receiving services who received services for a given number
of months in 2008. For example, in 2008, 182,664 youth received services; of those, 25% (or 45,500 youth)
received services for one month.
110
Represents the percentage of youth out of all youth receiving services who received services for a given number
of months in 2007. For example, in 2007, 174,260 youth received services; of those, 25% (or 43,648 youth)
received services for one month.
111
Represents the percentage of individuals within the population of a given county that participated in behavioral
health services in 2009. For example, in Alameda county in 2009, 2% of the population (or 26,507 individuals)
participated in behavioral health services.
112
Represents the percentage of individuals within the population of a given county that participate in behavioral
health services in 2008. For example, in Alameda county in 2008, 2% of the population (or 24,695 individuals)
participated in behavioral health services.
113
Represents the percentage of individuals within the population of a given county that participate in behavioral
health services in 2007. For example, in Alameda county in 2007, 2% of the population (or 24,040 individuals)
participated in behavioral health services.
114 st
Admission Rate is based on the number of valid admissions (admissions with no discharge before Dec 1 and admissions less than
1 day from prior discharge have been eliminated).
115
This represents the percent of individuals with a valid inpatient admission who experienced a mental health inpatient
readmission within 30 days of discharge in a given county. For example, in Alameda county, of the 951 individuals with a valid
inpatient admission, 24% (or 224 individuals) experienced a mental health inpatient readmission within 30 days of discharge.
CA BHNA Appendix A: DHCS Data 92
Mental Health Inpatient
30 Day Readmission
Avg. Length of Stay Rate
County Admission Rate114 (days) N %115
Shasta 1 2 0 0%
Sutter -- -- -- --
Yolo 294 9 19 6%
Yuba 4 4 0 0%
MBA (Under 90,000)
Alpine -- -- -- --
Amador -- -- -- --
Calaveras -- -- -- --
Colusa -- -- -- --
Del Norte 0 6 -- --
Glenn -- -- -- --
Inyo -- -- -- --
Lake 0 3 -- --
Lassen -- -- -- --
Mariposa -- -- -- --
Modoc -- -- -- --
Mono -- -- -- --
Plumas 1 3 0 0%
San Benito -- -- -- --
Sierra -- -- -- --
Siskiyou -- -- -- --
Tehama -- -- -- --
Trinity -- -- -- --
Tuolumne -- -- -- --
116 st
Admission Rate is based on the number of valid admissions (admissions with no discharge before Dec 1 and admissions less than
1 day from prior discharge have been eliminated).
117
This represents the percent of individuals with a valid inpatient admission who experienced a mental health inpatient
readmission within 30 days of discharge in a given county. For example, in Alameda county, of the 839 individuals with a valid
inpatient admission, 23% (or 197 individuals) experienced a mental health inpatient readmission within 30 days of discharge.
CA BHNA Appendix A: DHCS Data 94
Mental Health Inpatient
30 Day Readmission
Avg. Length of Stay Rate
County Admission Rate116 (days) N %117
Shasta 7 12 0 0%
Sutter -- -- -- --
Yolo 288 9 25 9%
Yuba 3 4 0 0%
MBA (Under 90,000)
Alpine -- -- -- --
Amador 1 2 0 0%
Calaveras 1 2 0 0%
Colusa 0 1 . .
Del Norte -- -- -- --
Glenn -- -- -- --
Inyo -- -- -- --
Lake -- -- -- --
Lassen -- -- -- --
Mariposa -- -- -- --
Modoc -- -- -- --
Mono -- -- -- --
Plumas 1 1 0 0%
San Benito -- -- -- --
Sierra -- -- -- --
Siskiyou -- -- -- --
Tehama -- -- -- --
Trinity -- -- -- --
Tuolumne 245 7 34 14%
118 st
Admission Rate is based on the number of valid admissions (admissions with no discharge before Dec 1 and admissions less than
1 day from prior discharge have been eliminated).
119
This represents the percent of individuals with a valid inpatient admission who experienced a mental health inpatient
readmission within 30 days of discharge in a given county. For example, in Alameda county, of the 1,230 individuals with a valid
inpatient admission, 21% (or 260 individuals) experienced a mental health inpatient readmission within 30 days of discharge.
CA BHNA Appendix A: DHCS Data 96
Mental Health Inpatient
30 Day Readmission
Avg. Length of Stay Rate
County Admission Rate118 (days) N %119
Shasta 38 3 1 3%
Sutter -- -- -- --
Yolo 233 9 32 14%
Yuba 10 3 1 10%
MBA (Under 90,000)
Alpine -- -- -- --
Amador 1 2 0 --
Calaveras 1 42 1 100%
Colusa 1 3 0 --
Del Norte -- -- -- --
Glenn 1 3 0 --
Inyo 1 4 0 --
Lake 3 4 0 --
Lassen 1 2 0 --
Mariposa -- -- -- --
Modoc -- -- -- --
Mono 1 3 0 --
Plumas -- -- -- --
San Benito 1 3 0 --
Sierra -- -- -- --
Siskiyou 2 2 0 --
Tehama 1 2 0 --
Trinity -- -- -- --
Tuolumne 262 8 31 12%
98
This section describes the methodology used to analyze Medi-Cal Claims data provided by the
Department of Health Care Services (DHCS) for the years 2007-2009. In order to ascertain the current
state of behavioral health service utilization in California, it was determined that access to Medi-Cal
claims level data was critical. This data would help the TAC/HSRI team to determine current need for
behavioral health services and evaluate the extent to which estimated need was met through
penetration rates. Through additional statistical analysis, this data would help to provide a deeper
understanding of how services are currently being delivered and how this pattern of service utilization
may impact the expansion population to serve the complex needs of Medi-Cal clients with behavioral
health issues.
The TAC/HSRI team requested from DHCS claims data for behavioral health clients enrolled in the Medi-
Cal program between 2007 and 2010. Because of data lag issues it was determined that 2010 would not
be used. Thus, the analysis included in this report and was restricted to 2007 – 2009. The extraction
algorithm used to download the claims files of all DHCS behavioral health clients across the 3 years is
shown in Table 14 below.
99
with or without developmental delay
Pregnancy/Childbirth 648.40-648.44 Mental conditions associated with pregnancy or childbirth
Conditions
SAMHSA Diagnosis Codes to Identify Substance Abuse Population
Alcohol Abuse 291, 303, Alcoholic psychoses
305.0
Drug Abuse 292, 304, Drug psychoses and moon conditions, drug dependence
305.2-305.9
Tobacco Use Disorder 305.1 Tobacco use disorder
Pregnancy/Childbirth 760.71, 648.3- Substance abuse related pregnancy or childbirth
Conditions 648.34, 779.5
The requested Medi-Cal dataset was populated by clients with specific diagnosis codes (ICD9 Codes )
with a primary diagnosis identifying a behavioral health disorder such as schizophrenia, depressive
conditions, disorders of conduct, and substance use from SAMHSA’s diagnostic categories for substance
use. Additionally, pregnancy and childbirth mental conditions were also included (see Table 14).
DHCS also provided the TAC/HSRI team with a list of variables available from the data element list. The
team requested the following variables listed in Table 15 along with a brief indication as to which main
task in the work plan the variable would enable us to perform.
100
Table 15: Claims Level Data Requested
Data Element List
(Based on the ‘35’ Paid Claims File)
DATA ELEMENT Level of Data DESCRIPTION FROM MIS/DSS METADATA Data Requested for
Required TAC Work Plan
MAIN TASK (may then
be used for additional
task)
Header Elements
1. Unique Medicaid identifier X Medicaid ID that can be linked to eligibility file and possibly other files 2
4. DHCS Claim Type X Identifies the general type of service that was provided. 2
6. Beneficiary ID: County X Identifies the county of the patient. 2
7. Beneficiary ID: Aid Code X Aid Category identifies which aid code the claim was paid under. 2
10. Beneficiary ID: Person Number X Person Number identifies the individual person in the case. The 2
counties assign the codes.
12. Sex X Identifies the sex of the patient. 2, 4, 5
Identifies ethnicity of the patient. This coding scheme is used on 2, 4, 5
13. Race X
MEDS.
15. Provider Zip Code1 X Servicing address for billing provider. 4, 5
16. Provider Number1, 2 X Billing provider number. It identifies the provider of services. 4, 5
17. Hospital Reimbursement Rates X Hospital Reimbursement Rate identifies the percentage rate in which 3,4, 5
allowed charges will be adjusted to reflect the variance between
charges and actual cost for out-of-state and non-contract hospitals.
This variable may be available if dollar amounts are removed.
18. Patient Liability Amount X Patient Liability identifies the amount owed by the recipient for the 3, 5
services being billed for by the provider on this claim.
19. Provider County1 X County code of the billing provider. 4, 5
20. Physician Specialty X Identifies the primary specialty for Physicians. 4, 5
21. Vendor Code X Identifies the general type of provider. 4, 5
22. Discharge/Status Code X DHCS Discharge/Patient Status Code indicates status of patient on the 3, 5, 7
last day of service on inpatient claims.
25. Medicare Indicator X Medicare Indicator indicates that this was a Medicare Crossover Claim 2, 5
26. Admission Date Complete date Admission Date identifies the date the patient was admitted to the 2, 7
is allowed. hospital (Inpatient claims only).
27. Discharge Date Complete date Discharge Date identifies the date the patient was discharged to the 2, 7
is allowed. hospital (Inpatient claims only).
101
Data Element List
(Based on the ‘35’ Paid Claims File)
DATA ELEMENT Level of Data DESCRIPTION FROM MIS/DSS METADATA Data Requested for
Required TAC Work Plan
MAIN TASK (may then
be used for additional
task)
Header Elements
29. Primary Diagnosis Code (ICD) X Primary Diagnosis Code identifies the diagnosis code for the principal 2, 5, 7
condition requiring medical attention.
30. Co-Insurance Amount X Co-Insurance Amount identifies the co-insurance amount billed to 2, 5, 7
Medi-Cal for Medicare services.
31. Total Medi-Cal Billed Amount X Total Medi-Cal Billed Amount indicates the amount Medi-Cal was billed 2, 5, 7
by the provider.
32. Total Medi-Cal Paid Amount1 X Total Medi-Cal Paid Amount indentifies the amount Medi-Cal paid to 3, 7, 8
the provider.
34. Federal Financial Participation X Indicates what FFP rate was used for payment. 3, 7
35. Adjustment Indicator X Adjustment Indicator identifies the record as an adjustment. 3, 7
36. Days Stay X Days Stay indicates the number of days that the patient stayed in the 3, 7
hospital (Inpatient claims only).
39. From Date of Service Complete date This is the earliest date of service for the period of service being 3,7
is allowed. reported by the provider in this claim.
40. To Date of Service Complete date This is the latest date of service for the period of service being reported 3,7
is allowed. by the provider in this claim.
41. Other Coverage Indicator X Other Coverage Indicator indicates that there was a non-Medicare 3,7
other health insurance for the claim.
43. Birth Date Complete date Birth Date identifies the Medi-Cal recipient’s date of birth. 3
is allowed for (for linking with DMH
all individuals. and / or ADP data)
44. Provider Type Code X Provider Type Code identifies the classification of the provider 4, 5
rendering health and medical services using the newer 3-digit coding.
45. Category of Service X Category of Service identifies the category of service the service 3, 5
(procedure) code falls into and that the provider is qualified to render
(using the newer 3-digit coding).
46. CCS/GHPP Indicator X CCS/GHPP Indicator indicates service authorized by the California 3, 5
Children’s Services (CCS) or Genetically Handicapped Persons Program
(GHPP).
102
Data Element List
(Based on the ‘35’ Paid Claims File)
DATA ELEMENT Level of Data DESCRIPTION FROM MIS/DSS METADATA Data Requested for
Required TAC Work Plan
MAIN TASK (may then
be used for additional
task)
Header Elements
47. Provider Name1 X Identifies the name of the billing provider. 4, 5
Minor Consent Service Code identifies the recipient as a minor consent 2, 5
48. Minor Consent Service Code X
eligible and to identify the minor consent services needed.
50. FI Claim Type X Identifies the type of claim used for this billing and the type of edits 3, 5
that were applicable.
51. Prepaid Health Plan Code X Recipient Managed Care Plan Code (a.k.a. Prepaid Health Plan Code) 3, 5
identifies the prepaid health plan that the recipient is enrolled in.
52. Secondary Diagnosis Code X Secondary Diagnosis Code identifies patient’s secondary diagnosis, 2,5
which requires supplementary medical treatment.
53. Claim Emergency Indicator X Claim Emergency Indicator indicates whether the service was 2,5
performed in an emergency situation.
55. Admission Necessity Code X Inpatient Admission Necessity/Type Code indicates the necessity for 2,5
admission to an inpatient hospital.
56. Patient Status Code X DHCS Discharge/Patient Status Code indicates status of patient on the 2, 5, 7
last day of service on inpatient claims.
Admit Source identifies the reason a patient was admitted to a 2, 5, 7
62. Admit Source X
hospital.
103
Data Element List
(Based on the ‘35’ Paid Claims File)
DATA ELEMENT Level of Data DESCRIPTION FROM MIS/DSS METADATA Data Requested for
Required TAC Work Plan
MAIN TASK (may then
be used for additional
task)
Header Elements
Detail Line Elements
64. Medi-Cal Billed Amount X Detailed Medi-Cal Allowed Amount (Previously named “Detail Medi-Cal 3, 5, 7
Amount Paid”) identifies the maximum amount payable for this service
by Medi-Cal.
65. Medi-Cal Paid Amount1 X Detail Medi-Cal Billed Amount identifies the amount billed for this 3, 7
service.
66. Medicare Billed Amount X Medicare Billed Amount identifies the amount billed to Medicare. 3,7
67. Medicare Paid Amount X Medicare Paid Amount identifies the amount paid by Medicare. 3, 7
68. Medicare Deduction Code X Medicare Deduction Code identifies the type of deductible amount 3, 7
reported in the data element MEDICARE DEDUCTIBLE AMOUNT for
Medicare claims.
69. Medicare Deductible Amount X Medicare Deductible Amount indicates the Medicare deductible 3, 7
amount billed to Medi-Cal for this service.
70. From Date of Service Complete date Detail From Date of Service identifies the start date of the service on 3, 7
is allowed. this detail.
71. To Date of Service Complete date Detail To Date of Service identifies the end date of the service on this 3, 7
is allowed. detail.
72. PCCM Indicator X Primary Care Case Management Indicator identifies if this is a Primary 3, 5
Care Case Management record.
73. Other Health Care Coverage X Other Coverage Indicator indicates that there was a non-Medicare 2, 7
other health insurance for the claim. It identifies the Other Health Care
Circumstances for each service rendered.
74. EPSDT Service Indicator X EPSDT Service Indicator identifies the kind of service for Early Periodic 2, 7
Screening, Diagnosis and Treatment (EPSDT) claims.
76. Place of Service X DHCS Place of Service identifies where service was rendered. 2, 7
77. Type of Service X Type of Service based on the procedure code/revenue code on 2, 7
claims/encounters.
78. Procedure Code X The procedure code being billed on the claim line. This procedure code 3, 7
field can contain CPT-4, HCPCS, Revenue Codes or State Codes.
104
Data Element List
(Based on the ‘35’ Paid Claims File)
DATA ELEMENT Level of Data DESCRIPTION FROM MIS/DSS METADATA Data Requested for
Required TAC Work Plan
MAIN TASK (may then
be used for additional
task)
Header Elements
79. Procedure Indicator X Identifies the type of procedure code or drug code present in the 3, 7
procedure code field.
82. Units of Service X Units indicates number of units of service provided. 3, 7
84. CoPay Amount X The co-payment amount is to be collected by or obligated to the 3, 4, 5
provider at the time the service is rendered.
86. Prescribing Provider Number2 X Referring Prescribing Provider Number. 3, 4, 5
87. EPSDT Referral Code X EPSDT (Early Periodic Screening, Diagnosis and Treatment) Referral 3, 4, 5
Code identifies if this claim is a CHDP screen-related service; e.g., if a
CHDP (Child Health and Disability Prevention) referral preceded this
claim.
88. CoPay Indicator X CoPay Indicator determines the kind of copay. 3, 4, 5
89. Drug Manufacturer X Indicates code of drug manufacturer. 3, 4, 5
90. FI Type of Service X FI Type of Service characterizes the type of service with which a 3, 4, 7
procedure code is associated.
91. Medi-Cal Reimbursement X Medi-Cal Reimbursed Amount identifies the actual amount reimbursed 3, 4, 7
Amount 1 for this detail line procedure.
92. Other Coverage Amount X Detail Other Coverage Amount identifies the amount of money paid by 3, 7
an insurance carrier or third party for this service. Does not include
Medicare payment.
93. Original Place of Service X Original Place of Service identifies where the service was rendered. 3, 4, 7
95. Drug Days Supply X Drug Days Supply identifies the number of days that the prescription 3, 4, 7
covered.
96. Medical Supply Indicator X Medical Supply Indicator indicates whether this drug code is for a 3, 7
medical supply.
97. Compound Drug Indicator X Indicates whether a drug claim is for a compound drug. 3, 7
99. Billed Code Indicator X Provides information about the original contents of the Procedure 3, 5, 7
Code field before any cross-referencing takes place.
105
Data Element List
(Based on the ‘35’ Paid Claims File)
DATA ELEMENT Level of Data DESCRIPTION FROM MIS/DSS METADATA Data Requested for
Required TAC Work Plan
MAIN TASK (may then
be used for additional
task)
Header Elements
100. FFP Indicator X Detailed FFP (Federal Financial Participation) Indicator currently used 3, 7
only on FPACT claims from EDS to indicate the level of Medicaid
Federal Financial Participation, if any, that the state may claim.
RECORD_ID X Record ID 2, 4,5
ADJ_IND X Adjusted claim 2, 4,5
REVENUE_CD X Revenue code 2, 4,5
106
It was determined that both claims level and eligibility level variables were necessary for a
comprehensive analysis. However, the eligibility files had a number of missing data elements useful for
the analysis, most notably race. Attempts were made to use it for select demographic variables in
instances that were missing in the claims files. The claims level variables identify the population’s need
for services, the Medi-Cal expenditures on this population, and other information on service utilization.
Claims level variables include items such as provider information (type, specialty, county of practice,
etc.), primary and secondary diagnosis codes, category of services, and Medi-Cal paid amount (see table
15). Information on Short-Doyle and Drug Medi-Cal providers were also included in the claims files.
To facilitate data transfer, a secure FTP server was assigned to upload data in text format. Data was
encrypted and restricted to the appointed team of analysts, with all files being password protected and
stored in a locked secured server environment. All staff who worked with the data received standard
training on confidentiality awareness that conformed to standards set by the Federal Department of
Health and Human Services. A data security administrator (DSA) was designated to ensure that all
information for shared network resources were done at the server level based upon the user’s
authentication credentials. Application-level access passwords were only allowed when explicitly
authorized by management. Security administrators ensured that server access was restricted such that
information transfer could not be affected via access to shared system resources such as disk space or
memory. The security administrator also ensured that firewalls at the system boundaries were
monitored and controlled from communication with the outside world. Such firewalls logged all access
attempts, both successful and unsuccessful. The data security administrator ensured that any publicly
accessible server was located on a separate subnet to prevent unauthorized access. The DSA created
standards for the creation and use of cryptographic keys and the standards for use of cryptography. All
moderate-risk information that leaves a site’s internal network (even if it is headed for another site’s
internal network) was encrypted using a 128-bit key and the AES method of cryptography. The data was
stored in a secured server in climate control environment.
All physical access points (including designated entry/exit points) to facilities containing information
systems (except for those areas within the facilities officially designated as publicly accessible) were
controlled and individual access authorizations were verified before granting access to the facilities.
Access to areas officially designated as publicly accessible, as appropriate, in accordance with the
organization’s assessment of risk were also controlled. A copy of the signed confidentiality contract
required for the use of Medicaid Data is on file.
All data files were uploaded in panel or disaggregated (claims) format, with multiple claims per client on
successive rows. There were a total of 3 files that corresponded to the years under the analysis. After
the data files were successfully downloaded, they were stored in SQL format by calendar year, with
select variables migrated and converted to SPSS format for specific analyses. Most utilization and
performance indicator analyses were performed using SPSS. All provider analyses and analyses
exploring arrivals and monthly service penetration were conducted using SQL program.
To prepare for data analysis, the team created several variables that are introduced across multiple
analysis result tables. These included individual level data found in demographic variables such as age
categories, race/ethnicity and gender. Eligibility categories were also developed from the Medi-Cal Aid
codes provided (details discussed below). Clinical variables such as cohort by behavioral health
diagnostic conditions and special populations such as DMC/SMHS, EPSDT (Early & Periodic Screening,
Diagnosis & Treatment) and Children’s Medi-Cal Foster Care Program were also constructed. The final
category of individual level variables constructed was the Top utilizers. Aggregate variables on
behavioral service categories were also constructed using CPT and HCPCS procedure codes. Indicator
(dummy) variables were created for all cohort or special population of interest that were used in the
analyses. Details on how these variables were constructed for analyses are described below.
Demographic variables were created primarily from data furnished in the claims files. Gender was
uploaded as a string variable that was converted to numeric sequence with 0 for male and 1 for male.
Age categories were constructed from the client’s birthday and it was determined by age as of January
1st of the given year. Once age on January 1 was calculated, they were subdivided into 10 categories to
match the prevalence estimates for data presented in the penetration tables (0-5, 6-11, 12-17, 18-20,
21-24, 25-34, 35-44, 45-54, 55-64, 65+) and into 6 categories for all other tables (0-13, 14-17, 18-21, 22-
26, 27-64, 65+). Race and ethnicity were collapsed into 8 categories from those reported in the Claims
Data. Asian demographics include individuals from north (China, Japan, Korea) as well as southeast Asia
(India, Thailand, Vietnam, Hmong, Cambodia and Phillippines). Pacific Islanders include those from
pacific isles located several hundred miles from the coast of any mainland Asian continent. Where
possible, missing information was provided by identical respondents on the limited eligibility files.
Eligibility Categories
Medi -Cal, California’s Medicaid program, was started in 1965 in response to the passage of Title XIX of
the Social Security Act120. The original intent of Medi-Cal was to provide healthcare to uninsured
individuals and address the complex healthcare coverage issues of the disabled and elderly. Additional
eligibility categories have been added in the 47 years since Medi-Cal’s creation. These new categories
were developed in response to the changing healthcare needs of California’s population.
120
Overview History of Centers for Medicare and Medicaid Services. https://www.cms.gov/History/
Individuals who are aged, blind or disabled according to Social Security Rules
Families with children where deprivation exists (linked to Cal-Works, California’s TANF program)
Children or pregnant women without regard to deprivation or property
Individuals with specific health needs, such as Tuberculosis sufferers, dialysis users, users of
intravenous nutrition services, breast and cervical cancer sufferers, certain services for minors
and nursing home care.
In determining one’s eligibility for Medi-Cal, county eligibility workers assign each applicant an Aid Code.
This code is not seen by the applicant, but is used to track the criteria by which the beneficiary qualified
for Medi-Cal. For example, a person receiving coverage through the Medically Needy Program would
have a different aid code based on whether he or she is aged, disabled, blind, etc121. Aid codes are also
used by health care workers to discern which services will be covered by Medi-Cal based on the
applicant’s eligibility. There are over 170 aid codes used in California today.
For the purposes of this analysis, it was not necessary to calculate the frequency of behavioral health
service utilization for individuals qualifying for Medi-Cal through each of the approximately 170 aid
codes. Our team highlighted 10 prominent categories of aid code that was most useful to our analysis
and our ability to determine who qualified eligible enrollees are likely to be among the expansion
population. These categories included the following:
In Table 16 below we outline how the aid codes were distributed into these 9 categories. A definition of
each of the aid codes can be found at the end of this document.
121
Kulkarni, M. (2006) A guide to MediCal programs: Third edition. Retrieved from
http://www.chcf.org/~/media/MEDIA%20LIBRARY%20Files/PDF/G/PDF%20GuideMediCalPrograms2006.pdf
122
Covers those who would have been eligible for MediCal if AFDC were still in effect.
We developed for analysis several clinical cohort variables to further examine their current utilization
under Medi-Cal. The most prominent among these are our definition of SMI (individuals with severe and
persistent mental illness), SED (children with severe emotional disturbance) adults and youths with
other behavioral health complications also known as broad definition behavioral health individuals,
individuals with substance use, and those with substance use and mental health comorbidity. We
identified these clinical cohorts through the ICD-9 diagnostic codes. We began by identifying our broad
behavioral health individuals as those with a primary diagnosis between 295 and 314 and 648.4. These
correspond to diagnostic conditions listed below in Table 17. Some apply only to adults, others only to
children, and some to both. For those that apply to both, age up to 17 was used to isolate behavioral
youth population from behavioral adult population.
From these broad definition categories we constructed a mutually exclusive cohort of SMI, SED and
broad definition other behavioral health cohorts. Substance Use only population was constructed
according to a set of diagnostic categories specified below. The construction of the SMI and SED cohorts
are described below.
The target population served by the California Department of Public Health consists of individuals with
severe mental illness (SMI), children with serious emotional disturbances (SED) and individuals using
substances. To determine the current need for state Medicaid behavioral health services, it is important
to assess the service utilization rates of these specific cohorts. Cohort-based data facilitates the design
of specialized strategies that can effectively address the complex needs of individuals with behavioral
health issues.
In order to identify the individuals in these specific cohorts, we identified the diagnosis codes associated
with SMI, SED and Substance Use from California that used SAMHSA definitions. Table 18 below lists
some of the common diagnoses and Table 19 details additional codes used to determine SMI & SED. A
diagnosis of schizophrenia, schizoaffective disorder, bipolar disorder (manic-depressive illness), or major
depressive disorders were used to classify SMI and SED.
Table 18: ICD9 Diagnosis Codes that Correspond with SMI, Substance Use, and SED
SMI
ICD Code Diagnosis
SED
ICD Code Diagnosis
295.10 Hebephrenia
295.20 Catatonic (schizophrenia):
agitation
excitation
excited type
stupor
withdrawn type
Schizophrenic:
catalepsy
catatonia
flexibilitas cerea
295.30 Paraphrenic schizophrenia
Excludes:
involutional paranoid state (297.2)
paranoia (297.1)
paraphrenia (297.2)
295.60 Residual type
Chronic undifferentiated schizophrenia
Restzustand (schizophrenic)
Schizophrenic residual state
295.90 Unspecified schizophrenia
Schizophrenia:
NOS
mixed NOS
undifferentiated NOS
undifferentiated type
Schizophrenic reaction NOS
Schizophreniform psychosis NOS
313.81 Oppositional defiant disorder
299.00 Other specified pervasive developmental disorders
Asperger's disorder
Atypical childhood psychosis
Borderline psychosis of childhood
Excludes:
Excludes:
circular type, if previous attack was of manic type
(296.5)
depression NOS (311)
reactive depression (neurotic) (300.4)
psychotic (298.0)
296.3 Major depressive disorder, recurrent episode
Any condition classifiable to 296.2, stated to be
recurrent
Excludes:
circular type, if previous attack was of manic type
(296.5)
depression NOS (311)
reactive depression (neurotic) (300.4)
psychotic (298.0)
296.4 Bipolar I disorder, most recent episode (or current)
manic
Bipolar disorder, now manic
Manic-depressive psychosis, circular type but
In terms of the substance use cohort, we included diagnostic categories related to alcohol and drug use
and dependence, including complications to the mother of use during pregnancy or to the newborn. We
excluded the use of tobacco and caffeine from consideration. Table 19 below details the full list of
diagnostic categories that we considered for inclusion as SMI & SED, respectively.
Table 19: SMI and SED Qualifying Diagnoses Table (full details)
ICD-9 Code ICD-9 Description SMI SED
295.00 Simple Type Schizophrenia, Unspecified State X X
295.01 Simple Type Schizophrenia, Subchronic State X X
295.02 Simple Type Schizophrenia, Chronic State X X
Simple Type Schizophrenia, Subchronic State With Acute
295.03 X X
Exacerbation
Simple Type Schizophrenia, Chronic State With Acute
295.04 X X
Exacerbation
295.05 Simple Type Schizophrenia, in Remission X X
295.10 Disorganized Type Schizophrenia, Unspecified State X X
295.11 Disorganized Type Schizophrenia, Subchronic State X X
295.12 Disorganized Type Schizophrenia, Chronic State X X
Disorganized Type Schizophrenia, Subchronic State With Acute
295.13 X X
Exacerbation
Disorganized Type Schizophrenia, Chronic State With Acute
295.14 X X
Exacerbation
295.15 Disorganized Type Schizophrenia, in Remission X X
295.20 Catatonic Type Schizophrenia, Unspecified State X X
295.21 Catatonic State Schizophrenia, Subchronic State X X
295.22 Catatonic Type Schizophrenia, Chronic State X X
Catatonic Type Schizophrenia, Subchronic State With Acute
295.23 X X
Exacerbation
Catatonic Type Schizophrenia, Chronic State With Acute
295.24 X X
Exacerbation
This cohort was defined as anyone in the diagnostic range included above, but not meeting the
above definition of SMI or SED (e.g. other depressives disorders, PTSD).
This cohort was defined as anyone who did not meet SMI or SED criteria and a majority of claims were
substance use related.
Since diagnoses are associated with individual claims and persons could have more than one primary
diagnosis, our algorithm for selecting individuals into the mutually exclusive cohorts is based on the
modal occurrence of diagnoses across multiple claims occurring in the same calendar year. An individual
was classified as substance use and mental health co-occurring cohort is not a mutually exclusive
category in that it was based on individuals with both a mental health and substance use disorder
primary diagnosis occurring in the same year. Therefore, individuals who are SMI or SED as well as
those who are part of the broader definition of behavioral health cohort could be classified as co-
occurring users.
DMC/SMHS Services
Individuals were identified as receiving behavioral health services funded through DMC/SMHS through
procedure codes and vendor codes that specify Short-Doyle services. Table 20 below lists the procedure
codes provided by the Medi-Cal Data Element Dictionary used to identify DMC/SMHS recipient service.
California’s Early and Periodic Screening, Diagnosis & Treatment program is commonly referred to as the
Child Health and Disability Prevention (CHDP) program, which is indicated by Claim Type 6, a referral
code of 1 on the EPSDT Referral Code indicator, and procedure indicator. All three variables were used
to identify the EPSDT special population. In the case of the Other Procedure Indicator (2), additional
restrictions were placed such as only claims coded that belonged to individuals under age 18. Additional
analyses on Claim Type 6 and EPSDT Referral Code indicator revealed that a small number of adults over
age 20 were included. We excluded adults over age 20 in our pool of EPSDT subpopulation. Children
belonging to the medical foster care program were exclusively identified through Eligibility code for
Foster Care described above.
Top utilizers were estimated from paid claims and used to identify patterns of utilization. These groups
were identified in each year by ranking behavioral service users by paid amount and obtaining the Top 5,
10, and 20% of all behavioral health service users. Once these groups were selected from the ranking
distribution, additional analyses such as expenditure and utilization were performed and reported
elsewhere in this document along with comparisons made by their respective cohorts in the overall
population.
Behavioral health service categories were used to describe the overall pattern of behavioral health
service provided overall to individuals in each year, as well as for subgroups such as adults, youths,
EPSDT and Foster Care program participants. These categories were defined through the vast range of
CPT, HCPCS & Short-Doyle procedure codes. From our analyses of nearly 6,000 unique procedure codes,
we categorized all Behavioral Services into 40 unique service codes, and from these service codes
further categorized them into 6 major service categories. Indicator variables (dummy) were created for
each service domain to estimate the number of individuals who received services in the domain and the
amount paid by Medi-Cal for those services by domain in each year. Table 21 below outlines the 44
behavioral health services provided through Medi-Cal we catalogued and their respective domain
assignments.
We used snapshot, arrival and disappearance as a means of presenting another glimpse of behavioral
health utilization using methods our team has pioneered and used in the federal Block Grant and various
state and local health reform initiatives. This is based on examining the patterns of service use by
examining the number of individuals who are served using 3 consecutive months as a barometer for
gauging how many cease service use and perhaps returning in subsequent months in the same calendar
year or in a subsequent year. We therefore, assign individuals to snapshot who have 3 or more
consecutive months of service (as indicated by claims). Those who experience any interruption but
return subsequently are considered arrivals. Arrivals may also include individuals who are new to
services funded through Medi-Cal. Disappearances are defined by those who receive no services for
more than 3 months.
New enrollees reported in Table 5 is a category we assigned to individuals beginning in 2008 and into
2009. They refer to individuals who are known to the Medi-Cal claim system in 2008 but not in 2007
and those known in 2009 but not in 2008. As part of that section of analyses, we also examined the
number of individuals who experienced 1, 2 up to 12 months of unbroken service as defined by service
begin or end dates.
Encounter
We defined encounters reported in Table 7 primarily by counting individual claims for services. This was
the case for Emergency, Mental Health Outpatient Treatment and Rehabilitation and Substance Use
services. For inpatient and residential services we defined encounters by counting as unique episode or
encounter those claims separated by more than one day from the defined end of service date.
In Table 8 as a performance indicator we examined the length in days that elapsed from inpatient
discharge to the receipt of Medicaid outpatient behavioral services. These services are those that are
defined by service categories ranging from residential to mental health outpatient treatment,
rehabilitation and substance use services. Emergency services are excluded. We measured the days
from hospital discharge date to the begin date of service for the outpatient service that met our
inclusion criteria. The column “No Contact’ includes either individual who did not receive a behavioral
health service or those who were readmitted to the hospital for behavioral health reasons.
Characteristics Total FY FY FY FY
2006-07 2007-08 2008-09 2009-10
Total Admissions 841,610 224,396 220,711 214,212 182,291
Admissions (% of total across FYs 2007-2010) 100% 27% 26% 25% 22%
Demographics
Female 37% 36% 36% 36% 37%
< 18 11% 10% 11% 11% 12%
Hispanic (Any race) 34% 33% 34% 34% 33%
White (Non-Hispanic) 43% 44% 43% 42% 43%
Black (Non-Hispanic) 16% 15% 15% 16% 16%
Multi-race (Non-Hispanic) 2% 2% 2% 2% 2%
Other race123 (Non-Hispanic) 6% 6% 6% 6% 6%
Pregnant 2% 2% 2% 2% 2%
Homeless124 19% 18% 18% 19% 20%
< High School Diploma 42% 41% 42% 42% 42%
125
Criminal Justice Involvement 55% 57% 57% 55% 50%
Employed (past 30 days) 22% 26% 24% 19% 16%
U.S. Veteran 4% 4% 4% 4% 4%
126
Medi-Cal Beneficiary 30% 29% 29% 30% 33%
Referral Source
Individual (includes self-referral) 38% 36% 37% 38% 43%
Substance abuse program 8% 8% 8% 8% 7%
Other health care provider 3% 3% 3% 3% 3%
SACPA127/Prop 36/OTP 23% 27% 25% 23% 16%
Non-SACPA court/Criminal Justice 18% 18% 18% 18% 17%
Other community referral 5% 5% 5% 5% 7%
Child Protective Services 4% 3% 4% 5% 6%
Total 100% 100% 100% 100% 100%
Substance Use Conditions
123
Self-reported as “other race”, not all races combined.
124
Homeless data does not cover the large number of criminal justice referred client who report “dependent living” as opposed to
“homeless” because they are coming from a controlled environment
125
Includes all referrals from SACPA or Court System in addition to Variable LEG-1 Criminal Justice Status
126
MediCal beneficiary status varies by age group; clients under 18 and over 64 are more than twice as likely to be MediCal beneficiaries.
127
Substance Abuse and Crime Prevention Act (SACPA), also known as Proposition 36, is a treatment diversion program for first and second
time non-violent adult drug offenders. Offender Treatment Program (OTP) is an enhancement of the SACPA program. Funding for SACPA
ended in SFY 2009-10
CA BHNA Appendix B: ADP Data 143
Characteristics Total FY FY FY FY
2006-07 2007-08 2008-09 2009-10
Alcohol only128 11% 10% 11% 12% 13%
Marijuana only 6% 5% 5% 6% 7%
Methamphetamine only 12% 13% 12% 11% 10%
Heroin only 8% 8% 8% 8% 8%
Cocaine/Crack only 3% 4% 4% 4% 3%
OxyCodone/OxyContin/other opiates only 2% 1% 2% 2% 2%
Other single use 1% 1% 1% 1% 1%
Alcohol & Marijuana (poly-drug use) 10% 9% 10% 11% 11%
Other poly drug use 47% 49% 47% 46% 45%
Needle Use (past 30-days) 15% 15% 15% 15% 16%
Total 100% 100% 100% 100% 100%
Treatment Service Type
Outpatient 52% 53% 52% 52% 50%
Day treatment 5% 5% 6% 4% 4%
Detox 12% 12% 12% 13% 13%
Residential – 30 days or less 1% 2% 1% 1% 1%
Residential – 31 days or more 18% 17% 18% 18% 18%
Narcotic Treatment Maintenance 7% 7% 7% 7% 8%
Narcotic Treatment Detox 4% 4% 4% 4% 5%
Medication prescribed as part of treatment 13% 12% 12% 12% 14%
Admission Type
Single Admission 37% 39% 36% 35% 40%
129
Recurrent Admission 22% 9% 22% 27% 31%
130
CoC Admission 20% 17% 21% 22% 21%
Other Service Conditions
Past 30-days ER visit(s) 10% 9% 10% 10% 11%
Past 30-days overnight hospital stay(s) 4% 3% 4% 4% 4%
Past 30-days experiencing physical health problems 19% 18% 19% 19% 20%
131
Mental illness diagnosis 23% 22% 22% 24% 26%
128
The percentages noted with ONLY one drug condition are overestimates since previous data analysis shows that county variation in
reporting secondary drug use varies far more than actual poly-drug use patterns across counties.
129
Refers to any admission that is not the first admission for an individual and are admissions that are more than 30 days from the previous
discharge
130
Refers to any admission that is not the first admission for an individual and are concurrent admissions or admissions within 30 days of
previous discharge.
131
DADP and CalOMS TX do no collect adequate data from which to determine actual numbers of clients with co-occurring mental illness.
CA BHNA Appendix B: ADP Data 144
Characteristics Total FY FY FY FY
2006-07 2007-08 2008-09 2009-10
Past 30-days OP ER services for MH needs 3% 3% 3% 3% 4%
Past 30-days overnight stay(s) in psychiatric facility/hospital for MH 3% 2% 2% 3% 3%
needs
Medication prescribed for MH needs 17% 15% 16% 17% 19%
Past 30-days participation in social support recovery activities 36% 37% 37% 36% 34%
Social Conditions
Past 30-days lived with someone who uses substances 14% 14% 14% 14% 15%
Past 30-days serious conflict with family member(s) 12% 12% 12% 12% 13%
BEST PRACTICE INDICATORS
Days waited to enter treatment
0 days 72% 70% 71% 72% 74%
1-3 days 10% 10% 10% 10% 9%
4-7 days 7% 8% 7% 7% 6%
8-14 days 5% 5% 5% 5% 4%
15-30 days 4% 5% 4% 4% 4%
More than 30 days 2% 2% 2% 2% 3%
Total 100% 100% 100% 100% 100%
Length of Stay
0 days 4% 4% 4% 4% 4%
1-15 days 24% 23% 23% 24% 26%
16-30 days 12% 12% 12% 12% 12%
31-60 days 13% 14% 13% 13% 13%
61-90 days 11% 11% 11% 12% 11%
91-120 days 8% 8% 8% 8% 8%
121-150 days 6% 5% 6% 6% 6%
151-180 days 5% 5% 5% 5% 5%
More than 180 days 17% 18% 18% 16% 15%
Total 100% 100% 100% 100% 100%
Discharge Status
Completed Tx 39% 38% 39% 40% 39%
Non-complete Tx/Satisfactory Progress 18% 17% 17% 18% 19%
Non-complete/Unsatisfactory progress 41% 43% 42% 40% 39%
Incarceration 2% 2% 2% 2% 2%
Total 100% 100% 100% 100% 100%
Characteristics Total FY FY FY FY
2006- 2007- 2008- 2009-
07 08 09 10
Total First Admissions 489,962 165,010 127,074 109,512 88,366
First Admissions (% of total across FYs 2007-2010) 100% 34% 26% 22% 18%
Demographics at First Admission
Female 35% 35% 35% 35% 35%
< 18 15% 12% 15% 16% 20%
Hispanic (Any race) 36% 35% 36% 37% 37%
White (Non-Hispanic) 41% 43% 40% 39% 40%
Black (Non-Hispanic) 15% 15% 15% 16% 15%
Multi-race (Non-Hispanic) 2% 1% 2% 2% 2%
Other race (Non-Hispanic) 6% 6% 7% 7% 6%
Pregnant 2% 2% 2% 2% 1%
Homeless 15% 16% 15% 15% 14%
< High School Diploma 45% 43% 45% 46% 46%
Criminal Justice Involvement 55% 58% 56% 55% 50%
Employed (past 30 days) 25% 28% 26% 23% 19%
U.S. Veteran 4% 4% 4% 4% 3%
Medi-Cal Beneficiary 31% 30% 30% 32% 34%
Referral Source at First Admission
Individual (includes self-referral) 37% 36% 36% 36% 39%
Substance abuse program 6% 6% 7% 6% 5%
Other health care provider 4% 3% 4% 4% 4%
SACPA/Prop 36/OTP 23% 26% 24% 22% 16%
Non-SACPA court/Criminal Justice 20% 19% 20% 21% 20%
Other community referral 7% 5% 6% 7% 10%
Child Protective Services 4% 3% 4% 5% 5%
Total 100% 100% 100% 100% 100%
Substance Use Conditions at First Admission
Alcohol only 13% 10% 13% 14% 14%
Marijuana only 8% 6% 8% 9% 11%
Methamphetamine only 12% 14% 12% 11% 10%
Heroin only 6% 7% 6% 6% 6%
Cocaine/Crack only 3% 4% 4% 3% 3%
CA BHNA Appendix B: ADP Data 146
Characteristics Total FY FY FY FY
2006- 2007- 2008- 2009-
07 08 09 10
OxyCodone/OxyContin/other opiates only 2% 1% 2% 2% 2%
Other single use 1% 1% 1% 1% 1%
Alcohol & Marijuana (poly-drug use) 13% 10% 13% 14% 15%
Other poly drug use 43% 47% 43% 40% 38%
Needle Use (past 30-days) 12% 14% 12% 11% 11%
Total 100% 100% 100% 100% 100%
Treatment Service Type at First Admission
Outpatient 58% 57% 58% 60% 59%
Day treatment 5% 5% 6% 5% 5%
Detox 10% 11% 9% 9% 10%
Residential – 30 days or less 1% 1% 1% 1% 1%
Residential – 31 days or more 16% 16% 16% 16% 16%
Narcotic Treatment Maintenance 5% 6% 5% 5% 5%
Narcotic Treatment Detox 4% 4% 4% 4% 4%
Medication prescribed as part of treatment 10% 10% 10% 10% 10%
User Type at First Admission
Single132 64% 53% 62% 69% 83%
Any Recurrent133 25% 36% 27% 19% 7%
Any CoC 134 21% 27% 22% 19% 13%
Other Service Conditions at First Admission
Past 30-days ER visit(s) 9% 9% 9% 9% 10%
Past 30-days overnight hospital stay(s) 3% 3% 3% 4% 4%
Past 30-days experiencing physical health problems 18% 18% 18% 18% 19%
Mental illness diagnosis 20% 20% 20% 20% 22%
Past 30-days OP ER services for MH needs 3% 3% 3% 3% 3%
Past 30-days overnight stay(s) in psychiatric facility/hospital for 2% 2% 2% 2% 3%
MH needs
Medication prescribed for MH needs 15% 15% 15% 15% 17%
Past 30-days participation in social support recovery activities 30% 33% 30% 29% 27%
132
An individual who has only one admission
133
An individual who has had any recurrent admissions
134
An individual who has any CoC admission
CA BHNA Appendix B: ADP Data 147
Characteristics Total FY FY FY FY
2006- 2007- 2008- 2009-
07 08 09 10
Social Conditions
Past 30-days lived with someone who uses substances 15% 15% 14% 14% 15%
Past 30-days serious conflict with family member(s) 13% 13% 12% 13% 13%
BEST PRACTICE INDICATORS
Days waited to enter treatment at First Admission
0 days 72% 70% 71% 73% 75%
1-3 days 10% 10% 10% 9% 9%
4-7 days 7% 8% 7% 7% 6%
8-14 days 5% 5% 4% 5% 4%
15-30 days 4% 5% 4% 4% 4%
More than 30 days 2% 3% 2% 2% 3%
Total 100% 100% 100% 100% 100%
Length of Stay (Mean – All Admissions)
0 days 3% 2% 3% 3% 3%
1-15 days 16% 15% 15% 16% 19%
16-30 days 10% 10% 10% 10% 11%
31-60 days 15% 16% 15% 15% 15%
61-90 days 13% 14% 13% 14% 13%
91-120 days 10% 10% 10% 10% 10%
121-150 days 7% 7% 8% 7% 7%
151-180 days 6% 6% 6% 6% 6%
More than 180 days 19% 20% 20% 19% 16%
Total 100% 100% 100% 100% 100%
Discharge Status at First Admission
Completed Tx 37% 37% 37% 38% 38%
Non-complete/Satisfactory progress 18% 17% 18% 19% 20%
Non-complete/Unsatisfactory progress 42% 44% 43% 40% 40%
Incarceration 2% 2% 2% 2% 2%
Total 100% 100% 100% 100% 100%
135
Because individuals included in Needle Use (past-30 days) may be included in one other Substance Use Condition as well, the total
percentages for Substance Use Conditions may not sum to 100%.
CA BHNA Appendix B: ADP Data 151
Characteristics Total OP Day Tx Detox ≤ 30 > 30 Narcotic Narcotic
day day Tx Maint. Tx Detox
Res Res
Length of Stay
0 days 4% 5% 5% 5% 1% 1% 2% 3%
1-15 days 24% 9% 12% 89% 36% 21% 10% 36%
16-30 days 12% 10% 11% 5% 48% 14% 10% 36%
31-60 days 13% 15% 18% 1% 8% 19% 10% 8%
61-90 days 11% 12% 12% 0% 4% 21% 8% 5%
91-120 days 8% 11% 10% 0% 1% 8% 6% 3%
121-150 days 6% 8% 7% 0% 0% 4% 5% 3%
151-180 days 5% 7% 6% 0% 0% 4% 4% 4%
More than 180 days 17% 23% 20% 0% 1% 7% 45% 4%
Total 100% 100% 100% 100% 100% 100% 100% 100%
Discharge Status
Completed Tx 39% 32% 28% 71% 72% 49% 10% 23%
Non-complete/Satisfactory
18% 18% 21% 11% 6% 16% 31% 26%
progress
Non-complete/Unsatisfactory
41% 47% 48% 18% 21% 34% 54% 50%
progress
Incarceration 2% 3% 3% 0% 0% 1% 5% 1%
Total 100% 100% 100% 100% 100% 100% 100% 100%
Admission Type
Single Admission 37% 46% 41% 22% 32% 31% 26% 19%
Recurrent Admission 22% 19% 16% 31% 19% 21% 23% 29%
CoC Admission 20% 15% 22% 22% 25% 27% 33% 18%
136
Because individuals included in Needle Use (past-30 days) may be included in one other Substance Use Condition as well, the
total percentages for Substance Use Conditions may not sum to 100%.
CA BHNA Appendix B: ADP Data 154
Characteristics Total OP Day Tx Detox ≤ 30 > 30 Narcotic Narcotic
day day Tx Tx Detox
Res Res Maint.
0 days 4% 5% 4% 5% 2% 1% 2% 3%
1-15 days 19% 9% 10% 88% 42% 24% 9% 42%
16-30 days 10% 9% 10% 5% 44% 15% 7% 40%
31-60 days 13% 15% 16% 1% 6% 18% 9% 4%
61-90 days 10% 12% 12% 0% 5% 18% 7% 3%
91-120 days 8% 10% 10% 0% 1% 8% 6% 2%
121-150 days 6% 8% 7% 0% 0% 3% 5% 1%
151-180 days 5% 6% 6% 0% 0% 5% 4% 1%
More than 180 days 24% 27% 24% 0% 1% 8% 52% 3%
Total 100% 100% 100% 100% 100% 100% 100% 100%
Discharge Status
Completed Tx 31% 27% 25% 72% 69% 45% 8% 23%
Non-complete/Satisfactory
22% 23% 24% 10% 7% 18% 31% 27%
progress
Non-complete/Unsatisfactory
44% 47% 49% 18% 23% 36% 54% 49%
progress
Incarceration 2% 2% 2% 0% 1% 1% 7% 1%
Total 100% 100% 100% 100% 100% 100% 100% 100%
Admission Type
Single Admission 41% 49% 49% 18% 26% 27% 27% 17%
Recurrent Admission 21% 19% 13% 35% 19% 21% 24% 30%
CoC Admission 19% 14% 20% 26% 32% 31% 32% 13%
137
Because individuals included in Needle Use (past-30 days) may be included in one other Substance Use Condition as well, the
total percentages for Substance Use Conditions may not sum to 100%.
CA BHNA Appendix B: ADP Data 157
Characteristics Total OP Day Tx Detox ≤ 30 > 30 Narcotic Narcotic
day day Tx Maint. Tx Detox
Res Res
Length of Stay
0 days 4% 5% 5% 5% 1% 1% 2% 3%
1-15 days 26% 10% 14% 89% 34% 21% 10% 34%
16-30 days 12% 10% 13% 5% 49% 14% 12% 35%
31-60 days 14% 16% 19% 1% 8% 20% 11% 9%
61-90 days 12% 12% 12% 0% 4% 21% 9% 5%
91-120 days 8% 11% 10% 0% 1% 8% 7% 3%
121-150 days 5% 8% 6% 0% 0% 4% 5% 3%
151-180 days 5% 7% 5% 0% 0% 4% 5% 5%
More than 180 days 14% 21% 16% 0% 1% 6% 40% 4%
Total 100% 100% 100% 100% 100% 100% 100% 100%
Discharge Status
Completed Tx 42% 34% 31% 70% 73% 49% 12% 23%
Non-complete/Satisfactory progress 16% 15% 19% 11% 6% 16% 31% 26%
Non-complete/Unsatisfactory
40% 47% 46% 18% 21% 34% 53% 50%
progress
Incarceration 2% 3% 3% 0% 0% 1% 4% 1%
Total 100% 100% 100% 100% 100% 100% 100% 100%
Admission Type
Single Admission 36% 45% 31% 23% 33% 32% 26% 19%
Recurrent Admission 22% 19% 19% 31% 19% 21% 23% 29%
CoC Admission 21% 16% 24% 22% 24% 27% 34% 20%
Characteristics Total 0 1-15 16-30 31-60 61-90 91- 121- 151- > 180
days days days days days 120 150 180 days
days days days
Total Admissions 776,197 30,095 184,902 90,998 104,619 88,216 63,054 44,334 38,271 131,708
Admissions (% of total by length of stay) 100% 4% 24% 12% 13% 11% 8% 6% 5% 17%
Demographics
Female 36% 36% 33% 35% 38% 36% 36% 37% 38% 40%
< 18 10% 7% 3% 8% 11% 12% 16% 17% 15% 13%
Hispanic (Any race) 34% 35% 27% 33% 35% 35% 37% 39% 38% 36%
White (Non-Hispanic) 44% 43% 49% 45% 42% 42% 40% 39% 40% 42%
Black (Non-Hispanic) 15% 15% 17% 14% 15% 15% 14% 14% 14% 15%
Multi-race (Non-Hispanic) 2% 2% 1% 2% 2% 2% 2% 2% 2% 2%
Other race (Non-Hispanic) 6% 6% 5% 6% 6% 6% 7% 7% 7% 6%
Pregnant 2% 2% 2% 2% 2% 2% 2% 2% 3% 2%
Homeless 19% 20% 36% 18% 16% 18% 13% 11% 12% 9%
< High School Diploma 41% 42% 34% 41% 44% 43% 45% 46% 45% 44%
Criminal Justice Involvement 56% 57% 41% 54% 64% 66% 67% 66% 65% 55%
Employed (past 30 days) 22% 22% 17% 21% 21% 21% 26% 27% 26% 26%
U.S. Veteran 4% 4% 5% 4% 3% 3% 3% 3% 3% 4%
Medi-Cal Beneficiary 29% 28% 22% 26% 28% 26% 29% 32% 31% 40%
Characteristics Total Completed Not Complete Tx/ Not Complete Tx/ Incarceration
Tx Satisfactory Unsatisfactory
Progress Progress
Total Admissions 766,821 298,176 135,730 315,709 17,206
Admissions (% of total by discharge status) 100% 39% 18% 41% 2%
Demographics
Female 36% 35% 40% 37% 25%
< 18 10% 7% 15% 11% 16%
Hispanic (Any race) 34% 30% 34% 36% 39%
White (Non-Hispanic) 44% 47% 42% 41% 38%
Black (Non-Hispanic) 15% 15% 17% 15% 14%
Multi-race (Non-Hispanic) 2% 2% 2% 2% 2%
Other race (Non-Hispanic) 6% 6% 6% 6% 7%
Pregnant 2% 2% 3% 2% 1%
Homeless 20% 25% 18% 16% 9%
< High School Diploma 41% 36% 46% 44% 49%
Criminal Justice Involvement 57% 58% 47% 58% 82%
Employed (past 30 days) 22% 22% 20% 22% 24%
U.S. Veteran 4% 5% 4% 3% 3%
Medi-Cal Beneficiary 28% 23% 36% 31% 29%
Substance Use Conditions
Alcohol 41% 47% 40% 36% 33%
Marijuana 32% 30% 33% 34% 39%
Methamphetamine 40% 41% 33% 42% 44%
Heroin 17% 12% 21% 20% 23%
Cocaine/Crack 17% 18% 17% 16% 16%
CA BHNA Appendix B: ADP Data 165
Characteristics Total Completed Not Complete Tx/ Not Complete Tx/ Incarceration
Tx Satisfactory Unsatisfactory
Progress Progress
OxyCodone/OxyContin/other opiates 5% 5% 7% 5% 4%
Other Service Conditions
Past 30-days ER visit(s) 10% 12% 10% 9% 7%
Past 30-days overnight hospital stay(s) 4% 4% 4% 3% 2%
Past 30-days experiencing physical health problems 19% 20% 19% 18% 18%
Mental illness diagnosis 23% 23% 25% 23% 20%
Past 30-days OP ER services for MH needs 3% 3% 3% 3% 2%
Past 30-days overnight stay(s) in psychiatric facility/hospital for MH 3% 3% 3% 3% 1%
needs
Medication prescribed for MH needs 17% 16% 19% 16% 14%
Past 30-days participation in social support recovery activities 37% 42% 33% 33% 37%
Social Conditions
Past 30-days lived with someone who uses substances 14% 14% 14% 15% 13%
Past 30-days serious conflict with family member(s) 12% 12% 12% 13% 10%
Characteristics Total Alcohol Marijuana Other Drug Alcohol & Other Poly Needle Substance
Only Only Only Marij. Drug Use Use
Total Admissions 841,610 94,798 48,786 163,226 85,296 334,460 115,044 569,316
Admissions (% of total by substance use type) 100% 11% 6% 19% 10% 40% 14% 68%
Demographics
Female 37% 35% 29% 43% 27% 39% 32% 35%
< 18 11% 12% 51% 2% 42% 4% 0% 10%
Hispanic (Any race) 34% 29% 43% 34% 42% 32% 33% 33%
White (Non-Hispanic) 43% 50% 21% 40% 35% 44% 53% 44%
Black (Non-Hispanic) 16% 13% 28% 16% 15% 17% 9% 16%
Multi-race (Non-Hispanic) 2% 1% 2% 1% 2% 2% 1% 2%
Other race (Non-Hispanic) 6% 6% 6% 8% 6% 6% 4% 6%
Pregnant 2% 1% 2% 3% 1% 2% 1% 1%
Homeless 19% 24% 5% 16% 12% 22% 22% 21%
< High School Diploma 42% 33% 69% 37% 61% 39% 38% 41%
Criminal Justice Involvement 55% 34% 56% 53% 56% 62% 36% 47%
Employed (past 30 days) 22% 22% 24% 22% 25% 21% 20% 22%
U.S. Veteran 4% 6% 1% 4% 3% 4% 4% 4%
Medi-Cal Beneficiary 30% 34% 52% 26% 44% 26% 26% 30%
Referral Source
Individual (includes self-referral) 38% 51% 23% 32% 29% 30% 71% 47%
Substance abuse program 8% 9% 5% 8% 6% 8% 8% 8%
Other health care provider 3% 8% 4% 2% 4% 3% 2% 4%
SACPA/Prop 36/OTP 23% 5% 16% 34% 13% 31% 12% 20%
Non-SACPA Court/Criminal Justice 18% 16% 31% 16% 30% 19% 5% 13%
Other community referral 5% 8% 15% 4% 14% 4% 1% 5%
Characteristics Total Ind SA Other Health SACPA/ Non-SACPA Other Comm CPS
Prog Prog Prop 36/ Court/ Ref
OTP Criminal
Justice
Total Admissions 757,962 290,371 59,091 24,918 175,364 134,115 41,565 32,538
Admissions (% of total by referral source) 100% 38% 8% 3% 23% 18% 5% 4%
Demographics
Female 35% 38% 35% 39% 27% 28% 36% 75%
< 18 10% 6% 10% 14% 2% 18% 49% 4%
Hispanic (Any race) 33% 29% 28% 25% 36% 38% 49% 40%
White (Non-Hispanic) 44% 50% 39% 49% 42% 40% 28% 41%
Black (Non-Hispanic) 15% 15% 26% 18% 14% 13% 16% 11%
Multi-race (Non-Hispanic) 2% 1% 2% 2% 2% 2% 2% 2%
Other race (Non-Hispanic) 6% 5% 6% 6% 7% 7% 6% 6%
Pregnant 2% 2% 2% 3% 1% 2% 1% 6%
Homeless 19% 22% 36% 28% 12% 14% 9% 12%
< High School Diploma 41% 36% 38% 38% 39% 49% 66% 48%
Criminal Justice Involvement 57% 24% 34% 24% 100% 100% 47% 32%
Employed (past 30 days) 22% 20% 13% 12% 29% 25% 21% 18%
U.S. Veteran 4% 4% 6% 7% 4% 3% 2% 2%
Medi-Cal Beneficiary 28% 32% 34% 45% 15% 22% 47% 44%
County Total FY FY FY FY
2006-07 2007-08 2008-09 2009-10
Admissions (Statewide) 100.0% 25.4% 25.3% 25.7% 23.6%
Alameda 3.4% 2.6% 2.8% 3.9% 4.3%
Alpine 0.0% 0.0% 0.0% 0.0% 0.0%
Amador 0.0% 0.1% 0.0% 0.0% 0.0%
Butte 1.1% 1.3% 1.1% 1.0% 0.8%
Calaveras 0.1% 0.1% 0.1% 0.2% 0.1%
Colusa 0.1% 0.1% 0.1% 0.1% 0.1%
Contra Costa 1.3% 1.4% 1.3% 1.2% 1.3%
Del Norte 0.1% 0.1% 0.1% 0.1% 0.1%
El Dorado 0.7% 0.8% 0.7% 0.7% 0.5%
Fresno 6.2% 5.9% 7.0% 7.0% 5.1%
Glenn 0.1% 0.1% 0.1% 0.1% 0.1%
Humboldt 0.8% 0.8% 0.8% 0.8% 0.9%
Imperial 1.5% 1.9% 1.6% 1.2% 1.1%
Inyo 0.1% 0.1% 0.1% 0.1% 0.0%
Kern 1.4% 1.4% 1.4% 1.4% 1.4%
Kings 0.4% 0.5% 0.5% 0.3% 0.1%
Lake 0.6% 0.5% 0.5% 0.6% 0.7%
Lassen 0.3% 0.3% 0.3% 0.3% 0.2%
Los Angeles 33.6% 33.1% 33.3% 32.8% 35.6%
Madera 0.6% 0.8% 0.7% 0.6% 0.4%
Marin 0.9% 0.8% 1.0% 0.8% 0.9%
Mariposa 0.1% 0.2% 0.1% 0.1% 0.1%
Mendocino 0.7% 0.7% 0.8% 0.7% 0.5%
Merced 0.3% 0.4% 0.4% 0.3% 0.2%
Modoc 0.0% 0.1% 0.0% 0.0% 0.1%
Mono 0.0% 0.0% 0.0% 0.0% 0.0%
Monterey 0.6% 0.6% 0.6% 0.6% 0.7%
Napa 0.3% 0.2% 0.2% 0.3% 0.3%
Nevada 0.3% 0.3% 0.3% 0.3% 0.3%
Orange 1.9% 2.1% 2.0% 1.8% 1.8%
Placer 0.6% 0.5% 0.6% 0.7% 0.7%
Plumas 0.0% 0.1% 0.1% 0.0% 0.0%
CA BHNA Appendix B: ADP Data 176
County Total FY FY FY FY
2006-07 2007-08 2008-09 2009-10
Riverside 3.8% 3.3% 3.5% 3.6% 4.8%
Sacramento 4.9% 4.4% 4.4% 5.5% 5.2%
San Benito 0.2% 0.1% 0.1% 0.2% 0.2%
San Bernardino 3.4% 3.8% 3.4% 3.1% 3.3%
San Diego 3.2% 3.3% 3.3% 3.2% 3.1%
San Francisco 4.4% 3.8% 4.2% 4.5% 5.1%
San Joaquin 1.6% 1.6% 1.6% 1.5% 1.5%
San Luis Obispo 0.5% 0.6% 0.5% 0.5% 0.5%
San Mateo 1.0% 0.9% 1.0% 1.1% 1.1%
Santa Barbara 2.1% 2.8% 2.1% 1.7% 1.9%
Santa Clara 2.8% 3.0% 2.7% 3.0% 2.4%
Santa Cruz 1.4% 1.6% 1.6% 1.2% 1.1%
Shasta 1.4% 1.5% 1.3% 1.5% 1.2%
Sierra 0.0% 0.0% 0.0% 0.0% 0.0%
Siskiyou 0.1% 0.1% 0.1% 0.1% 0.1%
Solano 1.2% 1.2% 1.3% 1.2% 1.1%
Sonoma 2.2% 2.5% 2.2% 2.1% 2.1%
Stanislaus 1.8% 1.5% 1.8% 2.0% 1.7%
Tehama 0.5% 0.6% 0.5% 0.5% 0.3%
Trinity 0.1% 0.1% 0.1% 0.1% 0.1%
Tulare 2.4% 2.5% 2.6% 2.4% 2.2%
Tuolumne 0.2% 0.2% 0.2% 0.2% 0.2%
Ventura 1.4% 1.3% 1.4% 1.4% 1.4%
Yolo 0.4% 0.5% 0.4% 0.4% 0.4%
Yuba & Sutter 0.8% 1.0% 0.8% 0.8% 0.6%
138
These percentages represent the total population served by county mental health plans that belong to a given characteristic category.
For example, in 2006, of the 630,239 individuals served by county mental health plans, 21% (or 133,735 individuals) were aged 0-13.
139
Because the age is unknown or not reported we were unable to determine if they were a Youth or Adult and thus these individuals have
not been included in the following Adult & Youth tables
CA BHNA Appendix C: CSI Data 179
Table 1b: System at a glance – Adults
CY 2006 CY 2007 CY 2008 CY 2009 CY 2010
Characteristics N %140 N % N % N % N %
Total 411,236 100% 416,810 100% 430,436 100% 407,672 100% 355,279 100%
Demographics
Gender
Female 215,864 52% 216,986 52% 223,998 52% 214,544 53% 189,013 53%
Male 193,540 47% 198,026 48% 204,759 48% 192,193 47% 165,523 47%
Other 29 0% 33 0% 40 0% 42 0% 36 0%
Unknown 1,803 0.4% 1,765 0.4% 1,639 0.4% 893 0.2% 707 0.2%
Race/Ethnicity
White 111,889 27% 136,906 33% 143,842 33% 134,079 33% 117,298 33%
African American 30,744 7% 37,674 9% 39,512 9% 37,966 9% 31,129 9%
Asian 20,132 5% 22,753 5% 23,037 5% 22,025 5% 18,697 5%
Pacific Islander 1,080 0.3% 1,423 0.3% 2,864 1% 1,443 0.4% 1,197 0.3%
Native 3,108 1% 3,906 1% 4,180 1% 3,966 1% 3,199 1%
Other 37,489 9% 41,584 10% 40,737 9% 39,103 10% 33,851 10%
Hispanic 45,304 11% 59,478 14% 65,194 15% 63,322 16% 56,397 16%
Multi 15,519 4% 18,629 4% 21,063 5% 19,750 5% 17,843 5%
Homeless 8,206 2% 6,550 2% 7,985 2% 9,315 2% 6,981 2%
< High School Diploma 60,101 15% 38,913 9% 44,587 10% 43,091 11% 35,462 10%
Criminal Justice Involvement 2,400 1% 2,071 0.5% 2,943 1% 3,040 1% 3,486 1%
Employed (past 30 days) 14,105 3% 13,377 3% 14,319 3% 13,883 3% 10,114 3%
Has Experienced Trauma 41,853 10% 77,113 19% 88,395 21% 86,156 21% 73,345 21%
Substance Use Conditions
Has Substance Dependence
71,563 17% 114,548 27% 116,459 27% 102,131 25% 77,667 22%
Diagnosis
140
These percentages represent the total population of adults served by county mental health plans that belong to a given characteristic
category. For example, in 2006, of the 411,236 individual adults served by county mental health plans, 52% (or 215,864 adults) were
female.
CA BHNA Appendix C: CSI Data 180
Table 1c: System at a Glance – Youth
CY 2006 CY 2007 CY 2008 CY 2009 CY 2010
141
Characteristics N % N % N % N % N %
Total 218,690 100% 220,741 100% 229,590 100% 228,109 100% 205,418 100%
Demographics
Gender
Female 85,963 39% 86,465 39% 89,532 39% 89,692 39% 81,286 40%
Male 132,252 60% 133,760 61% 139,608 61% 138,126 61% 123,903 60%
Other 11 0% 7 0% 6 0% 9 0% 6 0%
Unknown 464 0.2% 509 0.2% 444 0.2% 282 0.1% 223 0.1%
Race/Ethnicity
White 40,746 19% 48,306 22% 47,623 21% 43,733 19% 36,804 18%
African American 21,882 10% 27,382 12% 26,838 12% 24,827 11% 19,391 9%
Asian 4,385 2% 5,684 3% 5,694 2% 5,200 2% 4,166 2%
Pacific Islander 596 0.3% 882 0.4% 932 0.4% 970 0.4% 721 0.4%
Native 1,801 1% 2,297 1% 2,330 1% 2,209 1% 1,754 1%
Other 18,509 8% 21,686 10% 19,868 9% 18,444 8% 15,934 8%
Hispanic 50,357 23% 69,906 32% 69,746 30% 69,078 30% 60,203 29%
Multi 10,140 5% 12,529 6% 12,476 5% 11,783 5% 10,114 5%
Homeless 487 0.2% 436 0.2% 503 0.2% 626 0.3% 472 0.2%
< High School Diploma 75,281 34% 61,704 28% 74,214 32% 75,893 33% 64,236 31%
Criminal Justice
9,403 4% 4,848 2% 6,655 3% 7,878 3% 5,428 3%
Involvement
Employed (past 30 days) 1,381 1% 1,476 1% 1342 1% 1,041 0.5% 835 0.4%
Has Experienced Trauma 27,969 13% 48,532 22% 53,199 23% 52,664 23% 44,670 22%
Substance Use Conditions
Has Substance Dependence
13,470 6% 19,685 9% 20,057 9% 18,654 8% 16,691 8%
Diagnosis
141
These percentages represent the total population of youth served by county mental health plans that belong to a given
characteristic category. For example, in 2006, of the 218,690 individual youth served by county mental health plans, 39% (or 85,963
youth) were female.
CA BHNA Appendix C: CSI Data 181
Table 2a: System at a Glance – Service Utilization (% Received)
CY 2006 CY 2007 CY 2008 CY 2009 CY 2010
Services N %142 N % N % N % N %
Total 630,213 100% 637,671 100% 660,134 100% 635,899 100% 560,784 100%
24 Hour Services
Hospital Inpatient 22,319 4% 18,478 3% 17,365 3% 18,870 3% 16,353 3%
Hospital Administrative Day 3,264 1% 4,099 1% 3,736 1% 3,641 1% 3,066 1%
Psychiatric Health Facility 7,462 1% 7,598 1% 8,693 1% 7,298 1% 5,242 1%
SNF Intensive 2,338 0.4% 2,273 0.4% 1,992 0.3% 1,694 0.3% 1,521 0.3%
IMD Basic (no Patch) 1,796 0.3% 1,626 0.3% 1,400 0.2% 1,015 0.2% 721 0.1%
IMD with Patch 1,920 0.3% 1,515 0.2% 1,719 0.3% 1,646 0.3% 250 0%
Adult Crisis Residential 5,239 1% 5,173 1% 5,881 1% 5,499 1% 4,189 1%
Jail Inpatient 331 0.1% -- -- -- -- -- -- -- --
Residential, Other 1,363 0.2% 1,312 0.2% 1,194 0.2% 1,243 0.2% 1,024 0.2%
Adult Residential 2,251 0.4% 2,489 0.4% 2,325 0.4% 2,148 0.3% 1,450 0.3%
Semi-Supervised Living 1,206 0.2% 1,025 0.2% 816 0.1% 632 0.1% 362 0.1%
Independent Living 112 0% 130 0% 124 0% 134 0% 70 0%
Mental Health Rehab Center 2,074 0.3% 2,145 0.3% 2,124 0.3% 2,020 0.3% 1,393 0.2%
Day Services
Crisis Stabilization – Emergency
40,175 6% 42,123 7% 44,950 7% 43,290 7% 32,946 6%
Room
Crisis Stabilization – Urgent
13,217 2% 13,618 2% 11,981 2% 16,065 3% 17,415 3%
Care
Vocational Services 700 0.1% 861 0.1% 934 0.1% 764 0.1% 582 0.1%
Socialization 1,571 0.2% 2,167 0.3% 1,968 0.3% 1,812 0.3% 1,307 0.2%
SNF Augmentation 171 0% 151 0% 120 0% 111 0% 98 0%
Day Treatment Intensive – Half
544 0.1% 523 0.1% 457 0.1% 309 0% 177 0%
Day
Day Treatment Intensive – Full
4,099 1% 3,777 1% 3,561 1% 3,343 1% 2,507 0.4%
Day
Day Rehabilitation – Half Day 873 0.1% 667 0.1% 348 0.1% 420 0.1% 364 0.1%
Day Rehabilitation – Full Day 6,414 1% 5,359 1% 4,956 1% 4,274 1% 2,879 1%
Outpatient Services
Targeted Case Management 291,162 46% 289,261 45% 304,768 46% 290,048 46% 253,374 45%
Collateral 161,504 26% 162,934 26% 171,809 26% 170,176 27% 149,884 27%
Professional Inpatient Visit –
112 0% 138 0% 57 0% 50 0% 14 0%
Collateral
Mental Health Services (MHS) 477,616 76% 489,861 77% 507,191 77% 481,319 76% 413,051 74%
Professional Inpatient Visit –
6,561 1% 7,638 1% 6,262 1% 2,012 0.3% 1,354 0.2%
MHS
Therapeutic Behavioral
3,351 1% 3,652 1% 3,695 1% 4,201 1% 4,327 1%
Services
Medication Support (MS) 323,521 51% 322,874 51% 330,337 50% 314,891 50% 277,105 49%
Professional Inpatient Visit –
3,565 1% 3,070 0.5% 2,377 0.4% 2,361 0.4% 3,110 1%
MS
Crisis Intervention (CI) 126,607 20% 124,525 20% 128,234 19% 117,189 18% 109,412 20%
Professional Inpatient Visit (CI) 9 0% 8 0% 2 0% -- -- -- --
142
These percentages represents the total population receiving county mental health plans services of a given service category. For
example, in 2006, of the 630,213 individuals receiving county mental health plans services, 4% (or 22,319 individuals) received Hospital
Inpatient 24 Hour Services.
CA BHNA Appendix C: CSI Data 182
Table 2b: System at a Glance – Service Utilization (% Received) – Adults
CY 2006 CY 2007 CY 2008 CY 2009 CY 2010
Services N %143 N % N % N % N %
Total 411,207 100% 416,777 100% 430,396 100% 407,630 100% 355,243 100%
24 Hour Services
Hospital Inpatient 19,185 5% 15,970 4% 15,059 3% 16,497 4% 14,418 4%
Hospital Administrative Day 3,094 1% 3,905 1% 3,590 1% 3,508 1% 2,977 1%
Psychiatric Health Facility 6,929 2% 6,935 2% 7,723 2% 6,363 2% 4,460 1%
SNF Intensive 2,297 1% 2,232 1% 1,966 0.5% 1,670 0.4% 1,494 0.4%
IMD Basic (no Patch) 1,669 0.4% 1,530 0.4% 1,343 0.3% 971 0.2% 695 0.2%
IMD with Patch 1,771 0.4% 1,390 0.3% 1,589 0.4% 1,526 0.4% 240 0.1%
Adult Crisis Residential 5,082 1% 5,041 1% 5,676 1% 5,356 1% 4,077 1%
Jail Inpatient 312 0.1% -- -- -- -- -- -- -- --
Residential, Other 1,185 0.3% 1,134 0.3% 1,040 0.2% 1,104 0.3% 909 0.3%
Adult Residential 2,153 1% 2,383 1% 2,253 1% 2,088 1% 1,413 0.4%
Semi-Supervised Living 1,161 0.3% 992 0.2% 789 0.2% 603 0.1% 340 0.1%
Independent Living 112 0% 130 0% 124 0% 134 0% 70 0%
Mental Health Rehab Center 1,955 0.5% 2,031 0.5% 2,055 0.5% 1,962 0.5% 1,356 0.4%
Day Services
Crisis Stabilization – Emergency
36,261 9% 37,884 9% 40,126 9% 38,605 9% 29,071 8%
Room
Crisis Stabilization – Urgent Care 10,670 3% 11,081 3% 9,971 2% 13,512 3% 14,703 4%
Vocational Services 615 0.1% 793 0.2% 883 0.2% 745 0.2% 567 0.2%
Socialization 1,505 0.4% 2,035 0.5% 1,844 0.4% 1,724 0.4% 1,249 0.4%
SNF Augmentation 167 0% 148 0% 115 0% 106 0% 94 0%
Day Treatment Intensive – Half
82 0% 10 0% 9 0% 2 0% 1 0%
Day
Day Treatment Intensive – Full
559 0.1% 460 0.1% 398 0.1% 329 0.1% 171 0%
Day
Day Rehabilitation – Half Day 578 0.1% 527 0.1% 240 0.1% 236 0.1% 234 0.1%
Day Rehabilitation – Full Day 2,552 1% 2,209 1% 2,023 0.5% 1,605 0.4% 1,254 0.4%
Outpatient Services
Targeted Case Management 189,676 46% 189,730 46% 202,416 47% 191,723 47% 169,477 48%
Collateral 52,067 13% 50,748 12% 53,018 12% 50,196 12% 40,462 11%
Professional Inpatient Visit –
66 0% 102 0% 56 0% 49 0% 14 0%
Collateral
Mental Health Services (MHS) 281,061 68% 289,913 70% 298,519 69% 273,649 67% 227,640 64%
Professional Inpatient Visit – MHS 5,151 1% 6,221 1% 4,715 1% 1,692 0.4% 1,214 0.3%
Therapeutic Behavioral Services 171 0% 188 0% 203 0% 214 0.1% 264 0.1%
Medication Support (MS) 247,305 60% 246,604 59% 253,319 59% 240,325 59% 211,248 59%
Professional Inpatient Visit – MS 2,743 1% 2,403 1% 1,806 0.4% 1,641 0.4% 2,350 1%
Crisis Intervention (CI) 97,489 24% 97,002 23% 100,385 23% 91,019 22% 83,049 23%
Professional Inpatient Visit (CI) 3 0% 4 0% 2 0% -- -- -- --
143
These percentages represents the total population of adults receiving county mental health plans services of a given service category.
For example, in 2006, of the 411,207 individual adults receiving county mental health plans services, 5% (or 19,185 individuals) received
Hospital Inpatient 24 Hour Services.
CA BHNA Appendix C: CSI Data 183
Table 2c: System at a Glance – Service Utilization (% Received) – Youth
CY 2006 CY 2007 CY 2008 CY 2009 CY 2010
Services N %144 N % N % N % N %
Total 218,679 100% 220,734 100% 229,584 100% 228,100 100% 205,412 100%
24 Hour Services
Hospital Inpatient 3,127 1% 2,506 1% 2,304 1% 2,366 1% 1,928 1%
Hospital Administrative Day 169 0.1% 194 0.1% 146 0.1% 131 0.1% 88 0%
Psychiatric Health Facility 528 0.2% 656 0.3% 969 0.4% 930 0.4% 779 0.4%
SNF Intensive 41 0% 41 0% 26 0% 24 0% 27 0%
IMD Basic (no Patch) 126 0.1% 96 0% 57 0% 43 0% 25 0%
IMD with Patch 148 0.1% 125 0.1% 130 0.1% 120 0.1% 10 0%
Adult Crisis Residential 153 0.1% 131 0.1% 203 0.1% 142 0.1% 112 0.1%
Jail Inpatient 19 0% -- -- -- -- -- -- -- --
Residential, Other 178 0.1% 178 0.1% 154 0.1% 139 0.1% 115 0.1%
Adult Residential 94 0% 105 0% 72 0% 60 0% 37 0%
Semi-Supervised Living 42 0% 33 0% 27 0% 29 0% 22 0%
Independent Living -- -- -- -- -- -- -- -- -- --
Mental Health Rehab Center 117 0.1% 114 0.1% 68 0% 57 0% 35 0%
Day Services
Crisis Stabilization – Emergency
3,900 2% 4,234 2% 4,820 2% 4,675 2% 3,870 2%
Room
Crisis Stabilization – Urgent Care 2,542 1% 2,537 1% 2,006 1% 2,543 1% 2,683 1%
Vocational Services 83 0% 67 0% 50 0% 19 0% 15 0%
Socialization 62 0% 127 0.1% 118 0.1% 81 0% 55 0%
SNF Augmentation 4 0% 3 0% 5 0% 5 0% 3 0%
Day Treatment Intensive – Half
461 0.2% 512 0.2% 448 0.2% 307 0.1% 176 0.1%
Day
Day Treatment Intensive – Full
3,539 2% 3,317 2% 3,163 1% 3,014 1% 2,336 1%
Day
Day Rehabilitation – Half Day 295 0.1% 140 0.1% 108 0% 184 0.1% 130 0.1%
Day Rehabilitation – Full Day 3,858 2% 3,148 1% 2,933 1% 2,669 1% 1,625 1%
Outpatient Services
Targeted Case Management 101,327 46% 99,460 45% 102,303 45% 98,281 43% 83,870 41%
Collateral 109,355 50% 112,152 51% 118,764 52% 119,954 53% 109,409 53%
Professional Inpatient Visit –
46 0% 36 0% 1 0% 1 0% -- --
Collateral
Mental Health Services (MHS) 196,301 90% 199,826 91% 208,581 91% 207,579 91% 185,350 90%
Professional Inpatient Visit – MHS 1,409 1% 1,417 1% 1,546 1% 320 0.1% 140 0.1%
Therapeutic Behavioral Services 3,178 1% 3,463 2% 3,492 2% 3,987 2% 4,063 2%
Medication Support (MS) 76,026 35% 76,178 35% 76,952 34% 74,498 33% 65,815 32%
Professional Inpatient Visit – MS 821 0.4% 667 0.3% 571 0.2% 720 0.3% 760 0.4%
Crisis Intervention (CI) 29,065 13% 27,499 12% 27,820 12% 26,108 11% 26,332 13%
Professional Inpatient Visit (CI) 6 0% 4 0% -- -- -- -- -- --
144
These percentages represents the total population of youth receiving county mental health plans services of a given service category.
For example, in 2006, of the 218,679 individual youth receiving county mental health plans services, 1% (or 3,127 individuals) received
Hospital Inpatient 24 Hour Services.
145
This percentage represents the total individuals who received a given Evidence Based Practices (EBP). For example, in 2007, of the 3,805
individuals that received an EBP, 9% (or 325 individuals) received Assertive Community Treatment.
146
This percentage represents the total adults who received a given Evidence Based Practices (EBP). For example, in 2007, of the 2,140
individual adults that received an EBP, 9% (or 198 adults) received Assertive Community Treatment.
147
This percentage represents the total adults who received a given Evidence Based Practices (EBP). For example, in 2007, of the 1,665
individual youth that received an EBP, 8% (or 127 youth) received Assertive Community Treatment.
CA BHNA Appendix C: CSI Data 186
Table 5a: Number of Individuals Receiving Service Strategies
CY 2007 CY 2008 CY 2009 CY 2010
Service Strategy N %148 N % N % N %
Peer and/or Family Delivered Services 4,848 12% 5,819 10% 6,281 8% 6,493 11%
Psychoeducation 9,728 25% 14,760 25% 17,810 22% 13,892 23%
Family Support 7,985 21% 8,728 15% 9,379 12% 9,189 16%
Supportive Education 3,112 8% 4,719 8% 6,909 9% 4,957 8%
Delivered in Partnership with Law Enforcement 956 2% 2,383 4% 4,256 5% 2,383 4%
Delivered in Partnership with Health Care 1,466 4% 2,041 3% 2,815 4% 1,579 3%
Delivered in Partnership with Social Services 2,206 6% 2,616 4% 3,668 5% 2,235 4%
Delivered in Partnership with Substance Abuse Services 839 2% 1,900 3% 3,199 4% 1,644 3%
Integrated Services for Mental Health and Aging 831 2% 815 1% 736 1% 496 1%
Integrated Services for Mental Health and Developmental
243 1% 209 0.3% 164 0.2% 118 0%
Disability
Ethnic-Specific Service Strategy 1,566 4% 6,658 11% 9,177 12% 5,874 10%
Age-Specific Service Strategy 5,044 13% 9,483 16% 15,216 19% 10,310 17%
Total 38,824 100% 60,131 100% 79,610 100% 59,170 100%
148
This percentage represents the total individuals who received a given Service Strategy. For example, in 2007, of 38,824 individuals that
received a Service Strategy, 12% (or 4,848 individuals) received Peer and/or Family Delivered Services.
149
This percentage represents the total individual adults who received a given Service Strategy. For example, in 2007, of 13,059 adults that
received a Service Strategy, 8% (or 1,035 adults) received Peer and/or Family Delivered Services.
CA BHNA Appendix C: CSI Data 187
Table 5c: Number of Youth Receiving Service Strategies
CY 2007 CY 2008 CY 2009 CY 2010
150
Service Strategy N % N % N % N %
Peer and/or Family Delivered Services 3,813 15% 4,460 13% 4,794 10% 4,870 13%
Psychoeducation 6,325 25% 6,575 19% 7,120 15% 6,843 18%
Family Support 6,276 24% 6,777 19% 7,104 15% 7,057 19%
Supportive Education 1,826 7% 3,267 9% 4,864 10% 3,370 9%
Delivered in Partnership with Law Enforcement 689 3% 2,049 6% 3,721 8% 1,957 5%
Delivered in Partnership with Health Care 524 2% 610 2% 828 2% 558 1%
Delivered in Partnership with Social Services 962 4% 1,445 4% 2,628 6% 1,566 4%
Delivered in Partnership with Substance Abuse 1,275 3%
300 1% 1,393 4% 2,741 6%
Services
Integrated Services for Mental Health and Aging 111 0.4% 151 0.4% 164 0.3% 75 0%
Integrated Services for Mental Health and 64 0%
119 0.5% 101 0.3% 69 0.1%
Developmental Disability
Ethnic-Specific Service Strategy 913 4% 1,029 3% 1,134 2% 1,329 4%
Age-Specific Service Strategy 3,907 15% 7,441 21% 11,959 25% 8,472 23%
Total 25,765 100% 35,298 100% 47,126 100% 37,436 100%
150
This percentage represents the total individual youth who received a given Service Strategy. For example, in 2007, of 25,765
youth that received a Service Strategy, 15% (or 3,813 youth) received Peer and/or Family Delivered Services.
151
This percentage represents the number of individuals receiving multiple EBPs in a given category. For example, in 2007, of the
1,073 individuals receiving more than one EBP, 79% (or 846 individuals) received two EBPs.
152
This percentage represents the number of individual adults receiving multiple EBPs in a given category. For example, in 2007, of
the 829 individual adults receiving more than one EBP, 79% (or 652 adults) received two EBPs.
CA BHNA Appendix C: CSI Data 188
Table 6c: Number of Youth Receiving Multiple Evidence-Based Practices
CY 2007 CY 2008 CY 2009 CY 2010
153
Number of EBPs N % N % N % N %
2 Evidence-Based Practices 194 80% 439 74% 777 80% 494 80%
3 Evidence-Based Practices 48 20% 122 21% 168 17% 96 16%
4 Evidence-Based Practices 2 0.8% 16 3% 15 2% 21 3%
5 Evidence-Based Practices -- -- 10 2% 4 0.4% 1 0%
6 Evidence-Based Practices -- -- 6 1% 1 0.1% 2 0%
7 Evidence-Based Practices -- -- 2 0.3% 1 0.1% 1 0%
Total 244 100% 595 100% 966 100% 615 100%
153
This percentage represents the number of individual youth receiving multiple EBPs in a given category. For example, in 2007, of
the 244 individual youth receiving more than one EBP, 80% (or 194 youth) received two EBPs.
154
Number of unduplicated EBPs
155
This percentage represents the percent of the total population served by county mental health plans that received an
unduplicated EBP.
156
Number of unduplicated EBPs
157
This percentage represents the percent of the total adult population served by county mental health plans that received an
unduplicated EBP.
158
Number of unduplicated EBPs
159
This percentage represents the percent of the total youth population served by county mental health plans that received an
unduplicated EBP.
160
This represents the percent of county mental health plans services users in each county. For example, in Alameda county, 2% of
the total county population (or 32,204 individuals) utilize county mental health plans services.
161
This percentage reflects the percent of users in each county who receive EBPs. For example, in Alameda county the number of
county mental health plans service users is 32,204 individuals (or 2% of the total county population). Of these 32,204 users, 0% (or 0
individuals) receive an EBP.
CA BHNA Appendix C: CSI Data 190
# of
Individuals
that
Number % of Received % of
County of Users Population160 EBPs Users161
Madera 2,647 2% 5 0.2%
Mendocino 2,232 3% 0 0%
Merced 2,306 0.9% 109 5%
Napa 765 0.6% 13 2%
Nevada 927 0.9% 28 3%
Shasta 3,046 2% 99 3%
Sutter 0 -- -- --
Yolo 5,608 3% 177 3%
Yuba 0 -- -- --
MBA (Under 90,000)
Alpine 28 2% 0 0%
Amador 160 0.4% 0 0%
Calaveras 92 0.2% 30 33%
Colusa 217 1% 94 43%
Del Norte 550 2% 0 0%
Glenn 240 0.9% 28 12%
Inyo 202 1% 0 0%
Lake 496 0.8% 7 1%
Lassen 168 0.5% 13 8%
Mariposa 402 2% 0 0%
Modoc 292 3% 22 8%
Mono 242 2% 19 8%
Plumas 646 3% 0 0%
San Benito 1,032 2% 18 2%
Sierra 101 3% 4 4%
Siskiyou 1,574 4% 3 0.2%
Tehama 2,624 4% 33 1%
Trinity 553 4% 0 0%
Tuolumne 990 2% 2 0.2%
162
Average number of new adults entering the system each month.
163
These represent the percent of adults who “arrive” in the county mental health plans system at the specified
functioning level. For example, of the 17,032 adults who “arrived” to the system in 2010, 6% (or 1,077 adults)
entered the system at Functional Level 1.
164
Average number of adult consumers continuously serviced by the system
165
These represent the percent of adults who are continuously serviced by system at the specified functioning
level. For example, of the 180,028 adults continuously serviced in 2010, 2% (or 4,372 adults) were serviced at
Functional Level 1.
166
Average number of new youth entering the system each month.
167
These represent the percent of youth who “arrive” in the county mental health plans system at the specified
functioning level. For example, of the 9,765 youth who “arrived” to the system in 2010, 2% (or 163 youth) entered
the system at Functional Level 1.
168
Average number of youth consumers continuously serviced by the system
169
These represent the percent of youth who are continuously serviced by system at the specified functioning
level. For example, of the 107,069 youth continuously serviced in 2010, 1% (or 841 youth) were serviced at
Functional Level 1.
170
These percentages reflect the total number of adults at each functional level that received the specified service in 2010. For example, of all adults at functional level 1, 16% received
Hospital Inpatient 24-Hour Services.
CA BHNA Appendix C: CSI Data 193
Table 10b: Service Utilization – Youth
171
Percent Receiving Amount Received
1 2 3 4 5 6 7 Missing Service 1 2 3 4 5 6 7 Missing
24-Hour Services (days unless otherwise noted)
8% 4% 0.2% 0% 0% 0% 0% 0.1% Hospital Inpatient 1 1 1 1 1 0 0 1
0.5% 0.1% 0% 0% 0% 0% 0% 0% Hospital Administrative Day 1 1 1 0 1 0 0 0
1% 1% 0.2% 0% 0% 0% 0% 0% Psychiatric Health Facility 2 2 1 1 1 0 0 1
0.1% 0% 0% 0% 0% 0% 0% 0% SNF Intensive 4 1 1 8 0 0 0 12
0% 0% 0% 0% 0% 0% 0% 0% IMD Basic (no Patch) 15 10 10 2 4 0 0 0
0% 0% 0% 0% 0% 0% 0% 0% IMD with Patch 0 0 2 1 0 0 0 3
0.1% 0.1% 0% 0% 0% 0% 0% 0% Adult Crisis Residential 2 3 2 2 3 2 0 2
0% 0% 0% 0% 0% 0% 0% 0% Jail Inpatient 0 0 0 0 0 0 0 0
0% 0% 0% 0% 0% 0% 0% 0% Residential, Other 1 12 14 4 8 0 0 13
0% 0.1% 0% 0% 0% 0% 0% 0% Adult Residential 9 14 8 0 25 0 0 0
0% 0% 0% 0% 0% 0% 0% 0% Semi-Supervised Living 0 1 6 5 5 0 0 0
0% 0% 0% 0% 0% 0% 0% 0% Independent Living 0 0 0 0 0 0 0 0
0% 0% 0% 0% 0% 0% 0% 0% Mental Health Rehab Center 43 11 9 9 10 0 0 0
Day Services (days unless otherwise noted)
10% 5% 1% 0.1% 0.2% 0.3% 0% 0.4% Crisis Stabilization – Emergency Room 2 1 1 1 1 1 0 1
2% 2% 1% 0.2% 0.1% 0.2% 0.2% 0.1% Crisis Stabilization – Urgent Care 2 1 1 1 1 1 1 1
0% 0% 0% 0% 0% 0% 0% 0% Vocational Services 0 0 1 1 1 0 0 0
0% 0% 0% 0% 0% 0% 0% 0% Socialization 6 7 5 6 6 0 8 3
0% 0% 0% 0% 0% 0% 0% 0% SNF Augmentation 0 4 0 5 4 0 0 4
0.1% 0.1% 0.1% 0% 0% 0% 0% 0% Day Treatment Intensive – Half Day 18 15 16 16 17 0 0 13
2% 6% 3% 1% 0.3% 0.2% 1% 1% Day Treatment Intensive – Full Day 15 18 16 15 15 15 19 15
0% 0% 0.1% 0.1% 0% 0% 0% 0.1% Day Rehabilitation – Half Day 0 18 15 17 16 0 0 16
2% 2% 1% 1% 0.3% 0.4% 0.1% 0.1% Day Rehabilitation – Full Day 17 18 17 15 14 6 15 16
Outpatient Services (hours unless otherwise noted)
51% 38% 25% 21% 20% 19% 14% 13% Targeted Case Management 3 3 3 2 2 2 2 2
27% 28% 37% 36% 32% 27% 25% 16% Collateral 3 3 2 2 2 2 2 2
0% 0% 0% 0% 0% 0% 0% 0% Professional Inpatient Visit – Collateral 0 0 0 0 0 0 0 0
54% 59% 74% 77% 74% 76% 71% 69% Mental Health Services (MHS) 8 8 6 5 4 4 4 3
0.1% 0% 0% 0% 0% 0% 0% 0.1% Professional Inpatient Visit – MHS 2 2 3 3 1 1 4 4
4% 5% 3% 1% 0.5% 0.1% 0% 1% Therapeutic Behavioral Services 32 30 29 27 28 18 0 23
33% 39% 32% 24% 19% 11% 13% 22% Medication Support (MS) 2 1 1 1 1 1 1 1
1% 1% 0.1% 0% 0% 0% 0.1% 1% Professional Inpatient Visit – MS 4 4 4 4 3 5 4 2
35% 12% 5% 3% 2% 2% 8% 2% Crisis Intervention (CI) 6 4 3 2 2 3 2 3
0% 0% 0% 0% 0% 0% 0% 0% Professional Inpatient Visit (CI) 0 0 0 0 0 0 0 0
171
These percentages reflect the total number of youth at each functional level that received the specified service in 2019. For example, of all youth at functional level 1, 8% received
Hospital Inpatient 24-Hour Services.
CA BHNA Appendix C: CSI Data 194
Table 11a: Transitions – Adults172 Table 11b: Transitions – Youth173
FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis. FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis.
Missing 68 0 0 1 1 1 0 0 29 Missing 69 0 0 0 2 2 0 0 27
FL1 0 51 4 6 8 2 0 0 29 FL1 0 56 4 10 11 2 0 0 17
FL2 0 1 72 4 4 1 0 0 18 FL2 0 2 75 4 6 1 0 0 12
FL3 0 0 1 81 3 1 0 0 14 FL3 0 0 0 85 4 1 0 0 10
FL4 0 0 1 1 82 1 0 0 15 FL4 0 0 0 1 85 2 0 0 12
FL5 0 0 0 1 3 78 0 0 18 FL5 0 0 0 1 3 78 0 0 18
FL6 0 0 0 1 2 2 70 0 25 FL6 0 0 0 1 2 2 58 0 37
FL7 0 0 2 3 4 2 0 56 33 FL7 0 0 0 1 4 3 0 53 39
FL Disappear Stay the Same Move Forward Move Backward Total FL Disappear Stay the Same Move Forward Move Backward Total
FL1 29 51 20 0 100 FL1 17 56 27 0 100
FL2 18 72 9 1 100 FL2 12 75 11 2 100
FL3 14 81 4 1 100 FL3 10 85 5 0 100
FL4 15 82 2 1 100 FL4 12 85 2 1 100
FL5 18 78 0 4 100 FL5 18 78 0 4 100
FL6 25 70 0 5 100 FL6 37 58 0 5 100
FL7 33 56 0 11 100 FL7 39 53 0 8 100
TOTAL 152 490 35 23 TOTAL 145 490 45 20
172
This table presents percentages of adults who transitioned from one functional level
173
to another over the 12 month period. The disappearance rate (Dis.) is also presented. This table presents percentages of youth who transitioned from one functional level
The percentages presented in bold type are the percentage of individuals at that to another over the 12 month period. The disappearance rate (Dis.) is also presented.
functional level that remained at the same level. For example, 51% of adults remained The percentages presented in bold type are the percentage of youth at that functional
at FL1, and 72% remained at FL2. level that remained at the same level. For example, 56% of youth remained at FL1, and
75% remained at FL2.
174
Average number of new adults entering the system each month.
175
These percentages represents the number of adults who “arrive” in the county mental health plans system at
the specified functioning level. For example, of the 22,155 adults who “arrived” to the system in 2009, 6% (or
1,252 adults) entered the system at Functional Level 1.
176
Average number of adult consumers continuously serviced by the system.
177
These percentages represents the number of adults who were continuously served by the system at the
specified functioning level. For example, of the 193,856 adults continuously serviced in 2009, 3% (or 4,987 adults)
entered the system at Functional Level 1.
178
Average number of new youth entering the system each month.
179
These percentages represents the number of youth who “arrive” in the county mental health plans system at
the specified functioning level. For example, of the 11,809 youth who “arrived” to the system in 2009, 2% (or 181
youth) entered the system at Functional Level 1.
180
Average number of youth consumers continuously serviced by the system.
181
These percentages represents the number of youth who were continuously served by the system at the
specified functioning level. For example, of the 112,095 youth continuously serviced in 2009, 1% (or 940 youth)
entered the system at Functional Level 1.
182
These percentages reflect the total number of adults at each functional level that received the specified service in 2009. For example, of all adults at functional level 1, 12% received
Hospital Inpatient 24-Hour Services
CA BHNA Appendix C: CSI Data 197
Table 13b: Service Utilization – Youth
183
Percent Receiving Amount Received
1 2 3 4 5 6 7 Missing Service 1 2 3 4 5 6 7 Missing
24-Hour Services (days unless otherwise noted)
8% 4% 0.2% 0% 0% 0% 0% 0.1% Hospital Inpatient 1 1 1 1 1 3 0 1
0.5% 0.1% 0% 0% 0% 0% 0% 0% Hospital Administrative Day 1 1 1 1 2 0 0 1
1% 1% 0.2% 0.1% 0% 0% 0% 0% Psychiatric Health Facility 2 2 1 1 1 0 0 1
0% 0% 0% 0% 0% 0% 0% 0% SNF Intensive 0 8 12 12 26 0 0 20
0% 0.1% 0% 0% 0% 0% 0% 0% IMD Basic (no Patch) 9 5 5 20 4 0 0 3
0.3% 0.1% 0% 0% 0% 0% 0% 0.1% IMD with Patch 4 3 3 3 3 2 0 3
0.2% 0.1% 0% 0% 0% 0% 0% 0% Adult Crisis Residential 2 2 2 2 2 0 0 2
0% 0% 0% 0% 0% 0% 0% 0% Jail Inpatient 0 0 0 0 0 0 0 0
0% 0% 0% 0% 0% 0% 0% 0% Residential, Other 11 7 14 17 9 0 0 13
0.1% 0.1% 0% 0% 0% 0% 0% 0% Adult Residential 10 8 14 12 25 0 0 4
0% 0% 0% 0% 0% 0% 0% 0% Semi-Supervised Living 16 5 6 11 9 0 0 0
0% 0% 0% 0% 0% 0% 0% 0% Independent Living 0 0 0 0 0 0 0 0
0% 0% 0% 0% 0% 0% 0% 0% Mental Health Rehab Center 11 10 10 4 12 4 0 4
Day Services (days unless otherwise noted)
11% 5% 1% 0.1% 0.2% 0.1% 0.4% 0.4% Crisis Stabilization – Emergency Room 2 1 1 1 1 1 1 1
2% 2% 0.4% 0.2% 0.1% 0.3% 0.2% 0.2% Crisis Stabilization – Urgent Care 1 1 1 1 1 0 0 1
0% 0% 0% 0% 0% 0% 0% 0% Vocational Services 0 0 2 2 2 0 0 0
0.1% 0.1% 0.1% 0% 0% 0% 0% 0% Socialization 4 6 5 7 4 0 1 4
0% 0% 0% 0% 0% 0% 0% 0% SNF Augmentation 0 4 3 4 4 0 0 0
0.3% 0.2% 0.3% 0.1% 0.1% 0.1% 0% 0% Day Treatment Intensive – Half Day 13 15 16 16 18 20 0 11
2% 5% 3% 1% 0.5% 0.4% 2% 1% Day Treatment Intensive – Full Day 16 19 16 15 15 16 17 14
0% 0% 0.1% 0.1% 0.1% 0% 0% 0.1% Day Rehabilitation – Half Day 10 15 16 15 14 0 0 13
1% 3% 1% 1% 1% 1% 0.1% 0.2% Day Rehabilitation – Full Day 16 19 17 15 13 7 12 13
Outpatient Services (hours unless otherwise noted)
44% 39% 27% 22% 21% 17% 11% 15% Targeted Case Management 4 3 3 2 2 1 2 2
30% 28% 37% 36% 32% 25% 26% 13% Collateral 3 3 2 2 2 2 2 2
0% 0% 0% 0% 0% 0% 0% 0% Professional Inpatient Visit – Collateral 0 0 0 0 0 0 0 0
58% 63% 77% 78% 74% 76% 76% 71% Mental Health Services (MHS) 8 7 7 5 4 3 4 3
0.2% 0.1% 0% 0% 0% 0% 0.1% 0.3% Professional Inpatient Visit – MHS 3 2 4 5 2 1 8 3
5% 4% 2% 1% 0.4% 0.3% 0.1% 0.5% Therapeutic Behavioral Services 32 30 31 28 28 20 17 24
376% 41% 33% 25% 20% 12% 15% 19% Medication Support (MS) 2 1 1 1 1 1 1 1
1% 1% 0.1% 0% 0% 0% 0% 0.2% Professional Inpatient Visit – MS 4 4 5 5 3 2 0 3
30% 12% 3% 2% 2% 2% 4% 2% Crisis Intervention (CI) 5 4 3 3 2 3 2 3
0% 0% 0% 0% 0% 0% 0% 0% Professional Inpatient Visit (CI) 0 0 0 0 0 0 0 0
183
These percentages reflect the total number of youth at each functional level that received the specified service in 2009. For example, of all youth at functional level 1, 8% received
Hospital Inpatient 24-Hour Services
CA BHNA Appendix C: CSI Data 198
Table 14a: Transitions – Adults184 Table 14b: Transitions – Youth185
FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis. FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis.
Missing 75 0 0 0 1 1 0 0 23 Missing 78 0 0 0 2 1 0 0 19
FL1 0 61 4 5 6 1 0 0 23 FL1 0 62 4 8 9 2 0 0 15
FL2 0 1 78 4 3 1 0 0 13 FL2 0 1 78 4 6 1 0 0 10
FL3 0 0 1 85 3 1 0 0 10 FL3 0 0 1 87 3 1 0 0 8
FL4 0 0 1 1 85 1 0 0 12 FL4 0 0 0 1 87 2 0 0 10
FL5 0 0 0 1 3 81 0 0 15 FL5 0 0 0 1 3 82 0 0 14
FL6 0 0 0 0 2 2 74 0 22 FL6 0 0 0 0 3 3 62 0 32
FL7 0 0 1 1 4 1 0 72 21 FL7 0 0 0 1 3 3 0 62 31
FL Disappear Stay the Same Move Forward Move Backward Total FL Disappear Stay the Same Move Forward Move Backward Total
FL1 23 61 16 0 100 FL1 15 62 23 0 100
FL2 13 78 8 1 100 FL2 10 78 11 1 100
FL3 10 85 4 1 100 FL3 8 87 4 1 100
FL4 12 85 1 2 100 FL4 10 87 2 1 100
FL5 15 81 0 4 100 FL5 14 82 0 4 100
FL6 22 74 0 4 100 FL6 32 62 0 6 100
FL7 21 72 0 7 100 FL7 31 62 0 7 100
TOTAL 116 536 29 19 TOTAL 120 520 40 20
184 185
This table presents percentages of adults who transitioned from one functional level This table presents percentages of youth who transitioned from one functional level
to another over the 12 month period. The disappearance rate (Dis.) is also presented. to another over the 12 month period. The disappearance rate (Dis.) is also presented.
The percentages presented in bold type are the percentage of adults at that functional The percentages presented in bold type are the percentage of youth at that functional
level that remained at the same level. For example, 61% of adults remained at FL1, and level that remained at the same level. For example, 62% remained at FL1, and 78%
78% remained at FL2. remained at FL2.
186
Average number of new adults entering the system each month.
187
These represent the percent of adults who “arrive” in the county mental health plans system at the specified
functioning level. For example, of the 24,186 adults who “arrived” to the system in 2008, 5% (or 1,309 adults)
entered the system at Functional Level 1.
188
Average number of adult consumers continuously serviced by the system.
189
These represent the percent of adults who are continuously serviced by the system at the specified functioning
level. For example, of the 201,984 adults continuously serviced in 2008, 2% (or 4,956 adults) were serviced at
Functional Level 1.
190
Average number of new youth entering the system each month.
191
These represent the percent of youth who “arrive” in the county mental health plans system at the specified
functioning level. For example, of the 12,666 youth who “arrived” to the system in 2008, 1% (or 189 youth)
entered the system at Functional Level 1.
192
Average number of youth consumers continuously serviced by the system.
193
These represent the percent of youth who are continuously serviced by the system at the specified functioning
level. For example, of the 108,869 youth continuously serviced in 2008, 1% (or 964 youth) were serviced at
Functional Level 1.
194
These percentages reflect the total number of adults at each functional level that received the specified service in 2008. For example, of all adults at functional level 1, 12% received
Hospital Inpatient 24-Hour Services
CA BHNA Appendix C: CSI Data 201
Table 16b: Service Utilization – Youth
195
Percent Receiving Amount Received
1 2 3 4 5 6 7 Missing Service 1 2 3 4 5 6 7 Missing
24-Hour Services (days unless otherwise noted)
9% 4% 0.1% 0% 0% 0% 0% 0% Hospital Inpatient 1 1 1 1 1 0 1 1
0.5% 0.2% 0% 0% 0% 0% 0% 0% Hospital Administrative Day 1 1 2 1 1 0 0 2
1% 0.9% 0.2% 0% 0% 0% 0% 0% Psychiatric Health Facility 2 2 1 1 1 0 0 1
0% 0% 0% 0% 0% 0% 0% 0% SNF Intensive 3 9 2 1 0 0 0 0
0.1% 0% 0% 0% 0% 0% 0% 0.1% IMD Basic (no Patch) 13 7 4 3 3 0 0 4
0.3% 0.3% 0% 0% 0% 0% 0% 0.1% IMD with Patch 2 3 3 3 3 0 0 3
0.3% 0.1% 0% 0% 0% 0% 0% 0% Adult Crisis Residential 2 2 2 2 2 1 0 1
0% 0% 0% 0% 0% 0% 0% 0% Jail Inpatient 0 0 0 0 0 0 0 0
0% 0% 0% 0% 0% 0% 0% 0% Residential, Other 19 10 16 10 18 27 30 24
0% 0% 0% 0% 0% 0% 0% 0% Adult Residential 11 8 10 8 17 0 0 0
0% 0% 0% 0% 0% 0% 0% 0% Semi-Supervised Living 1 2 7 4 7 0 0 0
0% 0% 0% 0% 0% 0% 0% 0% Independent Living 0 0 0 0 0 0 0 0
0.2% 0.1% 0% 0% 0% 0.1% 0% 0.1% Mental Health Rehab Center 4 5 5 7 3 3 0 4
Day Services (days unless otherwise noted)
11% 4% 1% 0.2% 0.2% 0.2% 0.2% 0.4% Crisis Stabilization – Emergency Room 2 2 1 1 1 1 1 1
3% 1% 0.3% 0.1% 0.1% 0.1% 0% 0% Crisis Stabilization – Urgent Care 2 1 1 1 1 1 0 1
0% 0% 0% 0% 0% 0% 0% 0% Vocational Services 1 1 4 2 3 0 0 3
0.1% 0.1% 0.1% 0% 0% 0% 0% 0.1% Socialization 5 4 5 5 5 4 2 3
0% 0% 0% 0% 0% 0% 0% 0% SNF Augmentation 0 4 4 4 4 0 0 0
0.3% 0.3% 0.4% 0.2% 0.1% 0.1% 0% 0.1% Day Treatment Intensive – Half Day 12 13 16 16 14 0 0 16
3% 6% 3% 1% 0.4% 0.1% 1% 1% Day Treatment Intensive – Full Day 15 19 18 15 14 7 10 15
0% 0% 0.1% 0.1% 0% 0% 0% 0% Day Rehabilitation – Half Day 14 15 16 17 18 19 0 11
2% 3% 2% 1% 1% 1% 0.3% 0.3% Day Rehabilitation – Full Day 16 19 16 15 15 17 16 15
Outpatient Services (hours unless otherwise noted)
43% 39% 29% 25% 24% 20% 19% 19% Targeted Case Management 4 3 3 2 2 1 2 2
31% 27% 35% 36% 33% 29% 27% 15% Collateral 3 3 2 2 2 2 2 2
0% 0% 0% 0% 0% 0% 0% 0% Professional Inpatient Visit – Collateral 0 0 0 0 0 0 0 0
59% 61% 76% 78% 74% 75% 77% 71% Mental Health Services (MHS) 8 8 7 5 4 3 4 3
0.3% 0.3% 0.1% 0.2% 0.2% 0.3% 0.1% 0.3% Professional Inpatient Visit – MHS 2 2 2 1 1 1 2 3
5% 3% 2% 1% 0.4% 0.2% 0.5% 0.4% Therapeutic Behavioral Services 33 34 34 29 28 30 51 27
39% 43% 35% 27% 20% 12% 18% 20% Medication Support (MS) 1 1 1 1 1 1 1 1
1% 0.4% 0.1% 0% 0% 0% 0% 0.2% Professional Inpatient Visit – MS 4 5 5 4 4 0 0 3
28% 12% 4% 2% 2% 1% 4% 3% Crisis Intervention (CI) 5 4 3 3 2 3 2 3
0% 0% 0% 0% 0% 0% 0% 0% Professional Inpatient Visit (CI) 0 0 0 0 0 0 0 0
195
These percentages reflect the total number of youth at each functional level that received the specified service in 2008. For example, of all youth at functional level 1, 9% received
Hospital Inpatient 24-Hour Services
CA BHNA Appendix C: CSI Data 202
Table 17a: Transitions – Adults196 Table 17b: Transitions – Youth197
FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis. FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis.
Missing 73 0 0 1 1 1 0 0 24 Missing 77 0 0 0 2 2 0 0 19
FL1 0 60 4 6 6 2 0 0 22 FL1 0 63 3 8 8 2 0 0 16
FL2 0 1 78 4 4 1 0 0 12 FL2 0 1 79 4 5 1 0 0 10
FL3 0 0 1 85 3 1 0 0 10 FL3 0 0 1 87 3 1 0 0 8
FL4 0 0 1 1 85 2 0 0 11 FL4 0 0 0 1 87 2 0 0 10
FL5 0 0 0 1 3 82 0 0 14 FL5 0 0 0 1 3 82 0 0 14
FL6 0 0 0 1 2 2 75 0 20 FL6 0 0 0 0 3 3 67 0 27
FL7 0 0 1 1 4 1 0 76 17 FL7 0 0 0 1 3 2 0 66 28
FL Disappear Stay the Same Move Forward Move Backward Total FL Disappear Stay the Same Move Forward Move Backward Total
FL1 22 60 18 0 100 FL1 16 63 21 0 100
FL2 12 78 9 1 100 FL2 10 79 10 1 100
FL3 10 85 4 1 100 FL3 8 87 4 1 100
FL4 11 85 2 2 100 FL4 10 87 2 1 100
FL5 14 82 0 4 100 FL5 14 82 0 4 100
FL6 20 75 0 5 100 FL6 27 67 0 6 100
FL7 17 76 0 7 100 FL7 28 66 0 6 100
TOTAL 106 541 33 20 TOTAL 113 531 37 19
196 197
This table presents percentages of adults who transitioned from one functional level This table presents percentages of youth who transitioned from one functional level
to another over the 12 month period. The disappearance rate (Dis.) is also presented. to another over the 12 month period. The disappearance rate (Dis.) is also presented.
The percentages presented in bold type are the percentage of adults at that functional The percentages presented in bold type are the percentage of youth at that functional
level that remained at the same level. For example, 60% of adults remained at FL1, and level that remained at the same level. For example, 63% of youth remained at FL1, and
78% remained at FL2. 79% remained at FL2.
198
Average number of new adults entering the system each month.
199
These represent the percent of adults who “arrive” in the county mental health plans system at the specified
functioning level. For example, of the 23,477 adults who “arrived” to the system in 2007, 5% (or 1,161 adults)
entered the system at Functional Level 1.
200
Average number of adult consumers continuously serviced by the system.
201
These represent the percent of adults who are continuously serviced by the system at the specified functioning
level. For example, of the 194,495 adults serviced in 2007, 2% (or 4,747 adults) were serviced at Functional Level 1.
202
Average number of new youth entering the system each month.
203
These represent the percent of youth who “arrive” in the county mental health plans system at the specified
functioning level. For example, of the 11,815 youth who “arrived” to the system in 2007, 2% (or 178 youth)
entered the system at Functional Level 1.
204
Average number of youth consumers continuously serviced by the system.
205
These represent the percent of youth who are continuously serviced by the system at the specified functioning
level. For example, of the 105,669 youth serviced in 2007, 1% (or 961 youth) were serviced at Functional Level 1.
206
These percentages reflect the total number of adults at each functional level that received the specified service in 2007. For example, of all adults at functional level 1, 12% received
Hospital Inpatient 24-Hour Services.
CA BHNA Appendix C: CSI Data 205
Table 19b: Service Utilization – Youth
207
Percent Receiving Amount Received
1 2 3 4 5 6 7 Missing Service 1 2 3 4 5 6 7 Missing
24-Hour Services (days unless otherwise noted)
10% 3% 0.2% 0% 0% 0% 0% 0% Hospital Inpatient 1 1 1 1 1 1 0 1
0.5% 0.2% 0% 0% 0% 0% 0% 0% Hospital Administrative Day 2 2 1 1 1 0 0 2
1% 0.7% 0.1% 0% 0% 0% 0% 0% Psychiatric Health Facility 3 2 1 1 1 0 1 1
0% 0% 0% 0% 0% 0% 0% 0% SNF Intensive 7 9 12 7 0 0 0 0
0.2% 0.1% 0% 0% 0% 0% 0.1% 0.1% IMD Basic (no Patch) 5 4 4 3 4 0 2 4
0.4% 0.2% 0% 0% 0% 0% 0.1% 0.1% IMD with Patch 2 3 3 3 3 0 4 4
0.1% 0.1% 0% 0% 0% 0% 0% 0% Adult Crisis Residential 2 2 1 2 2 0 0 3
0% 0% 0% 0% 0% 0% 0% 0% Jail Inpatient 0 0 0 0 0 0 0 0
0% 0% 0% 0% 0% 0% 0% 0% Residential, Other 0 17 14 18 12 0 0 13
0% 0.1% 0% 0% 0% 0% 0% 0% Adult Residential 3 5 9 9 10 0 0 12
0% 0% 0% 0% 0% 0% 0% 0% Semi-Supervised Living 3 5 5 8 12 0 0 0
0% 0% 0% 0% 0% 0% 0% 0% Independent Living 0 0 0 0 0 0 0 0
0.1% 0.1% 0% 0% 0% 0% 0% 0% Mental Health Rehab Center 5 7 6 4 4 0 0 4
Day Services (days unless otherwise noted)
7% 3% 0.6% 0.2% 0.2% 0.2% 0.1% 0.4% Crisis Stabilization – Emergency Room 2 2 1 1 1 2 0 1
3% 2% 0.4% 0.2% 0.1% 0.1% 0.1% 0% Crisis Stabilization – Urgent Care 2 1 1 1 1 1 1 2
0% 0% 0% 0% 0% 0% 0% 0% Vocational Services 1 3 4 3 3 0 0 0
0.2% 0.2% 0% 0% 0% 0% 0% 0.1% Socialization 4 3 5 6 4 0 0 4
0% 0% 0% 0% 0% 0% 0% 0% SNF Augmentation 0 4 4 4 4 0 0 0
0.2% 0.5% 0.4% 0.3% 0% 0% 0% 0% Day Treatment Intensive – Half Day 13 15 16 16 16 0 0 12
3% 6% 4% 1% 0.5% 0.1% 0.5% 0.7% Day Treatment Intensive – Full Day 17 20 16 16 16 15 15 15
0.1% 0.1% 0.1% 0.1% 0% 0% 0% 0% Day Rehabilitation – Half Day 13 13 16 15 14 0 0 17
3% 4% 2% 1% 0.9% 0.5% 0.3% 0.3% Day Rehabilitation – Full Day 15 18 19 15 14 12 14 15
Outpatient Services (hours unless otherwise noted)
40% 39% 29% 26% 24% 21% 24% 21% Targeted Case Management 4 3 3 2 2 1 2 2
30% 26% 34% 35% 33% 30% 29% 16% Collateral 3 3 2 2 2 2 2 2
0% 0% 0% 0% 0% 0% 0% 0% Professional Inpatient Visit – Collateral 0 0 2 2 1 2 0 1
58% 61% 75% 77% 74% 76% 67% 71% Mental Health Services (MHS) 7 7 6 5 4 3 4 3
0.3% 0.3% 0.1% 0.1% 0.2% 0.2% 0.3% 0.4% Professional Inpatient Visit – MHS 2 3 3 3 3 5 5 3
4% 3% 2% 1% 0.4% 0.2% 0.7% 0.2% Therapeutic Behavioral Services 31 33 35 29 30 26 23 28
39% 44% 37% 28% 21% 11% 25% 21% Medication Support (MS) 2 1 1 1 1 1 1 1
0.5% 0.5% 0% 0% 0% 0% 0% 0.3% Professional Inpatient Visit – MS 3 4 5 4 3 2 4 3
27% 11% 4% 2% 2% 2% 2% 3% Crisis Intervention (CI) 5 4 3 3 2 2 3 3
0% 0% 0% 0% 0% 0% 0% 0% Professional Inpatient Visit (CI) 0 0 0 0 1 0 0 0
207
These percentages reflect the total number of youth at each functional level that received the specified service in 2007. For example, of all youth at functional level 1, 10% received
Hospital Inpatient 24-Hour Services.
CA BHNA Appendix C: CSI Data 206
Table 20a: Transitions – Adults208 Table 20b: Transitions – Youth209
FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis. FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis.
Missing 75 0 0 1 1 1 0 0 22 Missing 77 0 0 0 2 2 0 0 18
FL1 0 61 4 6 5 2 0 0 22 FL1 0 64 4 7 7 1 0 0 15
FL2 0 1 78 4 3 1 0 0 12 FL2 0 0 79 4 5 1 0 0 9
FL3 0 0 0 85 3 1 0 0 10 FL3 0 0 0 87 4 1 0 0 8
FL4 0 1 1 1 85 1 0 0 11 FL4 0 0 0 1 87 2 0 0 10
FL5 0 0 0 1 3 83 0 0 14 FL5 0 0 0 1 3 83 0 0 13
FL6 0 0 0 0 2 2 76 0 20 FL6 0 0 0 1 2 2 71 0 24
FL7 0 0 0 1 3 3 0 74 19 FL7 0 0 0 0 2 2 0 77 19
FL Disappear Stay the Same Move Forward Move Backward Total FL Disappear Stay the Same Move Forward Move Backward Total
FL1 22 61 17 0 100 FL1 15 64 19 0 100
FL2 12 78 8 1 100 FL2 9 79 10 0 100
FL3 10 85 4 0 100 FL3 8 87 5 0 100
FL4 11 85 1 3 100 FL4 10 87 2 1 100
FL5 14 83 0 4 100 FL5 13 83 0 4 100
FL6 20 76 0 4 100 FL6 24 71 0 5 100
FL7 19 74 0 7 100 FL7 19 77 0 4 100
TOTAL 108 542 30 19 TOTAL 98 548 36 14
208 209
This table presents percentages of adults who transitioned from one functional level This table presents percentages of youth who transitioned from one functional level
to another over the 12 month period. The disappearance rate (Dis.) is also presented. to another over the 12 month period. The disappearance rate (Dis.) is also presented.
The percentages presented in bold type are the percentage of adults at that functional The percentages presented in bold type are the percentage of youth at that functional
level that remained at the same level. For example, 61% of adults remained at FL1, and level that remained at the same level. For example, 64% of youth remained at FL1, and
78% remained at FL2. 79% remained at FL2.
CA BHNA Appendix C: CSI Data 207
Table 21a: Transitions - Received Evidence Based Practices –All Table 21b: Transitions - No Evidence Based Practices – All 2009211
2009210 FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis.
FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis. Missing 75 0 0 1 1 1 0 0 22
Missing 81 0 0 1 3 2 0 0 13 FL1 0 60 4 6 6 2 0 0 22
FL1 0 80 3 4 6 2 0 0 5 FL2 0 1 78 4 4 1 0 0 12
FL2 0 1 84 3 5 1 0 0 6 FL3 0 0 1 86 3 1 0 0 9
FL3 0 0 1 89 3 1 0 0 6 FL4 0 0 0 1 86 2 0 0 11
FL4 0 0 0 1 90 2 0 0 7 FL5 0 0 0 1 3 81 0 0 15
FL5 0 0 0 1 3 87 0 0 9 FL6 0 0 0 1 2 2 69 0 26
FL6 0 0 0 1 4 3 50 0 42 FL7 0 0 0 1 4 2 0 69 24
FL7 0 0 0 0 1 3 0 46 50
210 211
This table presents percentages of the specified population who transitioned from This table presents percentages of the specified population who transitioned from
one functional level to another over the 12 month period. The disappearance rate (Dis.) one functional level to another over the 12 month period. The disappearance rate (Dis.)
is also presented. The percentages presented in bold type are the percentage of the is also presented. The percentages presented in bold type are the percentage of the
population at that functional level that remained at the same level. For example, 80% population at that functional level that remained at the same level. For example, 60%
remained at FL1, and 84% remained at FL2. remained at FL1, and 78% remained at FL2.
CA BHNA Appendix C: CSI Data 208
Table 22a: Transitions - Received Evidence Based Practices – Adults Table 22b: Transitions - No Evidence Based Practices – Adults 2009
2009212 FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis.
FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis. Missing 74 0 0 1 1 1 0 0 23
Missing 86 0 0 1 2 1 0 0 10 FL1 0 60 4 6 6 1 0 0 23
FL1 0 81 3 4 5 2 0 0 5 FL2 0 1 78 3 4 1 0 0 13
FL2 0 1 86 3 3 1 0 0 6 FL3 0 1 1 85 3 0 0 0 10
FL3 0 0 1 89 2 1 0 0 7 FL4 0 0 1 1 85 1 0 0 12
FL4 0 0 0 1 90 1 0 0 8 FL5 0 0 0 1 3 81 0 0 15
FL5 0 0 1 1 3 87 0 0 8 FL6 0 0 0 0 2 2 74 0 22
FL6 0 0 0 1 5 3 82 0 9 FL7 0 0 1 1 4 2 0 71 21
FL7 0 0 1 0 1 3 0 91 4
212
This table presents percentages of the specified population who transitioned from
one functional level to another over the 12 month period. The disappearance rate (Dis.)
is also presented. The percentages presented in bold type are the percentage of the
population at that functional level that remained at the same level. For example, 81%
remained at FL1, and 86% remained at FL2.
CA BHNA Appendix C: CSI Data 209
Table 23a: Transitions - Received Evidence Based Practices – Youth Table 23b: Transitions - No Evidence Based Practices – Youth 2009214
2009213 FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis.
FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis. Missing 78 0 0 0 2 1 0 0 19
Missing 68 0 0 1 5 5 0 0 21 FL1 0 60 4 9 9 2 0 0 16
FL1 0 77 3 4 11 2 0 0 3 FL2 0 1 78 4 5 2 0 0 10
FL2 0 1 74 5 13 3 0 0 4 FL3 0 0 1 87 3 1 0 0 8
FL3 0 0 1 85 7 2 0 0 5 FL4 0 0 0 1 87 2 0 0 10
FL4 0 0 0 1 90 2 0 0 7 FL5 0 0 0 1 3 81 0 0 15
FL5 0 0 0 1 3 86 0 0 10 FL6 0 0 0 0 3 3 63 0 31
FL6 0 0 0 1 3 3 41 0 52 FL7 0 0 0 1 3 3 0 65 28
FL7 0 0 0 0 1 3 0 33 63
213 214
This table presents percentages of the specified population who transitioned from This table presents percentages of the specified population who transitioned from
one functional level to another over the 12 month period. The disappearance rate (Dis.) one functional level to another over the 12 month period. The disappearance rate (Dis.)
is also presented. The percentages presented in bold type are the percentage of the is also presented. The percentages presented in bold type are the percentage of the
population at that functional level that remained at the same level. For example, 77% population at that functional level that remained at the same level. For example, 60%
remained at FL1, and 74% remained at FL2. remained at FL1, and 78% remained at FL2.
CA BHNA Appendix C: CSI Data 210
Table 24a: Transitions - Received Evidence Based Practices –All Table 24b: Transitions - No Evidence Based Practices – All 2008216
2008215 FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis.
FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis. Missing 74 0 0 1 1 1 0 0 23
Missing 87 0 0 1 3 2 0 0 7 FL1 0 60 4 6 7 2 0 0 21
FL1 0 77 2 10 6 2 0 0 3 FL2 0 1 78 4 4 1 0 0 12
FL2 0 2 82 5 6 2 0 0 3 FL3 0 1 1 86 3 0 0 0 9
FL3 0 1 1 87 4 2 0 0 5 FL4 0 0 0 1 86 2 0 0 11
FL4 0 0 1 1 90 3 0 0 5 FL5 0 0 0 1 3 82 0 0 14
FL5 0 0 0 1 3 89 0 0 7 FL6 0 0 0 1 2 2 71 0 24
FL6 0 0 0 0 3 1 85 0 11 FL7 0 0 0 1 3 2 0 72 22
FL7 0 0 0 7 0 0 0 73 20
215 216
This table presents percentages of the specified population who transitioned from This table presents percentages of the specified population who transitioned from
one functional level to another over the 12 month period. The disappearance rate (Dis.) one functional level to another over the 12 month period. The disappearance rate (Dis.)
is also presented. The percentages presented in bold type are the percentage of the is also presented. The percentages presented in bold type are the percentage of the
population at that functional level that remained at the same level. For example, 77% population at that functional level that remained at the same level. For example, 60%
remained at FL1, and 82% remained at FL2. remained at FL1, and 78% remained at FL2.
CA BHNA Appendix C: CSI Data 211
Table 25a: Transitions - Received Evidence Based Practices – Adults Table 25b: Transitions - No Evidence Based Practices – Adults 2008218
2008217 FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis.
FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis. Missing 73 0 0 1 1 1 0 0 24
Missing 84 0 1 1 2 3 0 0 9 FL1 0 60 4 6 6 2 0 0 22
FL1 0 78 3 6 7 1 0 0 5 FL2 0 2 77 4 4 1 0 0 12
FL2 0 1 85 4 4 1 0 0 5 FL3 0 0 1 85 3 1 0 0 10
FL3 0 0 1 89 4 1 0 0 5 FL4 0 0 1 1 85 1 0 0 12
FL4 0 0 1 1 92 1 0 0 5 FL5 0 0 0 1 3 82 0 0 14
FL5 0 0 1 1 3 88 0 0 7 FL6 0 0 0 1 2 2 75 0 20
FL6 0 0 0 3 2 2 86 0 7 FL7 0 0 1 1 4 1 0 76 17
FL7 0 0 0 0 0 0 0 86 14
217 218
This table presents percentages of the specified population who transitioned from This table presents percentages of the specified population who transitioned from
one functional level to another over the 12 month period. The disappearance rate (Dis.) one functional level to another over the 12 month period. The disappearance rate (Dis.)
is also presented. The percentages presented in bold type are the percentage of the is also presented. The percentages presented in bold type are the percentage of the
population at that functional level that remained at the same level. For example, 78% population at that functional level that remained at the same level. For example, 60%
remained at FL1, and 85% remained at FL2. remained at FL1, and 77% remained at FL2.
CA BHNA Appendix C: CSI Data 212
Table 26a: Transitions - Received Evidence Based Practices –Youth Table 26b: Transitions - No Evidence Based Practices – Youth 2008220
2008219 FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis.
FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis. Missing 77 0 0 0 2 2 0 0 19
Missing 71 0 1 2 7 6 0 0 13 FL1 0 62 4 8 8 2 0 0 16
FL1 0 76 2 5 10 1 0 0 6 FL2 0 1 79 4 5 1 0 0 10
FL2 0 1 70 7 13 5 0 0 4 FL3 0 0 1 87 4 0 0 0 8
FL3 0 1 1 84 8 3 0 0 3 FL4 0 0 0 1 87 2 0 0 10
FL4 0 0 1 1 91 3 0 0 4 FL5 0 0 0 1 3 82 0 0 14
FL5 0 0 0 1 4 89 0 0 6 FL6 0 0 0 1 2 2 67 0 28
FL6 0 0 1 2 6 4 51 0 36 FL7 0 0 0 1 3 2 0 66 28
FL7 0 0 0 0 10 6 0 45 39
219 220
This table presents percentages of the specified population who transitioned from This table presents percentages of the specified population who transitioned from
one functional level to another over the 12 month period. The disappearance rate (Dis.) one functional level to another over the 12 month period. The disappearance rate (Dis.)
is also presented. The percentages presented in bold type are the percentage of the is also presented. The percentages presented in bold type are the percentage of the
population at that functional level that remained at the same level. For example, 76% population at that functional level that remained at the same level. For example, 62%
remained at FL1, and 70% remained at FL2. remained at FL1, and 79% remained at FL2.
CA BHNA Appendix C: CSI Data 213
Table 27a: Transitions - Received Evidence Based Practices –All Table 27b: Transitions - No Evidence Based Practices – All 2007222
2007221 FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis.
FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis. Missing 76 0 0 1 1 1 0 0 21
Missing 87 0 0 1 3 2 0 0 7 FL1 0 61 4 6 6 2 0 0 21
FL1 0 77 2 10 6 2 0 0 3 FL2 0 1 78 4 4 1 0 0 12
FL2 0 2 82 5 6 2 0 0 3 FL3 0 1 1 86 2 1 0 0 9
FL3 0 1 1 87 4 2 0 0 5 FL4 0 0 0 1 86 2 0 0 11
FL4 0 0 1 1 90 3 0 0 5 FL5 0 0 0 1 3 83 0 0 13
FL5 0 0 0 1 3 89 0 0 7 FL6 0 0 0 1 2 2 73 0 22
FL6 0 0 0 0 3 1 85 0 11 FL7 0 0 0 1 2 2 0 76 19
FL7 0 0 0 7 0 0 0 73 20
221 222
This table presents percentages of the specified population who transitioned from This table presents percentages of the specified population who transitioned from
one functional level to another over the 12 month period. The disappearance rate (Dis.) one functional level to another over the 12 month period. The disappearance rate (Dis.)
is also presented. The percentages presented in bold type are the percentage of the is also presented. The percentages presented in bold type are the percentage of the
population at that functional level that remained at the same level. For example, 77% population at that functional level that remained at the same level. For example, 61%
remained at FL1, and 82% remained at FL2. remained at FL1, and 78% remained at FL2.
CA BHNA Appendix D: MH/SU Provider Data 214
Table 28a: Transitions - Received Evidence Based Practices –Adults Table 28b: Transitions - No Evidence Based Practices – Adults 2007224
2007223 FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis.
FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis. Missing 75 0 0 1 1 1 0 0 22
Missing 89 1 1 1 2 1 0 0 5 FL1 0 61 4 6 6 1 0 0 22
FL1 0 69 4 15 8 2 0 0 2 FL2 0 1 78 4 4 1 0 0 12
FL2 0 2 85 4 4 2 0 0 3 FL3 0 0 1 85 3 1 0 0 10
FL3 0 1 1 88 3 2 0 0 5 FL4 0 0 1 1 85 1 0 0 12
FL4 0 0 1 1 90 3 0 0 5 FL5 0 0 0 1 3 82 0 0 14
FL5 0 0 1 1 4 87 0 0 7 FL6 0 0 0 1 1 2 76 0 20
FL6 0 0 0 0 4 0 90 0 6 FL7 0 0 0 1 3 3 0 74 19
FL7 0 0 0 0 0 0 0 89 11
223 224
This table presents percentages of the specified population who transitioned from This table presents percentages of the specified population who transitioned from
one functional level to another over the 12 month period. The disappearance rate (Dis.) one functional level to another over the 12 month period. The disappearance rate (Dis.)
is also presented. The percentages presented in bold type are the percentage of the is also presented. The percentages presented in bold type are the percentage of the
population at that functional level that remained at the same level. For example, 69% population at that functional level that remained at the same level. For example, 61%
remained at FL1, and 85% remained at FL2. remained at FL1, and 78% remained at FL2.
CA BHNA Appendix D: MH/SU Provider Data 215
Table 29a: Transitions - Received Evidence Based Practices –Youth Table 29b: Transitions - No Evidence Based Practices – Youth 2007226
2007225 FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis.
FL Missing FL1 FL2 FL3 FL4 FL5 FL6 FL7 Dis. Missing 81 0 0 1 3 2 0 0 13
Missing 82 0 0 1 5 4 0 0 8 FL1 0 80 3 4 7 2 0 0 4
FL1 0 89 0 3 3 1 0 0 4 FL2 0 1 84 3 5 1 0 0 6
FL2 0 1 71 6 13 5 0 0 4 FL3 0 0 1 89 3 1 0 0 6
FL3 0 1 1 86 6 2 0 0 4 FL4 0 0 0 1 90 2 0 0 7
FL4 0 0 1 1 89 3 0 0 6 FL5 0 0 0 1 3 87 0 0 9
FL5 0 0 0 1 3 89 0 0 7 FL6 0 0 0 1 4 3 50 0 42
FL6 0 0 0 0 3 1 82 0 14 FL7 0 0 0 0 2 3 0 45 50
FL7 0 0 0 17 0 0 0 50 33
225 226
This table presents percentages of the specified population who transitioned from This table presents percentages of the specified population who transitioned from
one functional level to another over the 12 month period. The disappearance rate (Dis.) one functional level to another over the 12 month period. The disappearance rate (Dis.)
is also presented. The percentages presented in bold type are the percentage of the is also presented. The percentages presented in bold type are the percentage of the
population at that functional level that remained at the same level. For example, 89% population at that functional level that remained at the same level. For example, 80%
remained at FL1, and 71% remained at FL2. remained at FL1, and 84% remained at FL2.
CA BHNA Appendix D: MH/SU Provider Data 216
Methodology
The Department of Mental Health (DMH) provided us with data that enabled us to examine the utilization
pattern of services using our method for evaluating behavioral health system performance. We received 3
datasets covering the period between 2006 and 2010. These dataset contained demographic information on the
client’s date and place of birth, gender, race and ethnicity and primary and preferred language. We also
received additional information on the client reported periodically such as the highest level of education
attained, employment status, living arrangements, and whether substance use, developmental disability or
physical health conditions affect the mental health of the client during the reporting period. For youths we also
have data on whether the client has a conservatorship or juvenile court status. From the last data file we
obtained information on services received by the client over the calendar year. Services provided by county
mental health plans, including Evidence-based Practices along with assessments in GAF (Global Assessment in
Functioning), dates and specific units and amounts of services were also recorded in the services files. Lastly,
the service files also contained information indicating if the client has experienced trauma or a substance use
issue as well as primary and secondary diagnoses. All files were linked successfully to individuals through the
county client number (CCN).
The files were uploaded through a secured FTP server provided by HSRI. Once the files had been successfully
downloaded it was uploaded into both SQL and SPSS for analyses. Our first task was to report on the system at
a glance (Table 1) to establish patterns of utilization for each of the calendar years. Age categories were
calculated from birthday with age being the client’s age on January 1st of the calendar year. Gender,
race/ethnicity as well as education attainment, employment status in the past 30 days, any criminal justice
involvement, the number and percent of individuals with GAF assessment, who experienced trauma and had a
substance dependence diagnosis was reported as well. Similar data was reported on adults and youths separately
(Tables 1b and 1c).
Next we reported on the number of individuals and the proportions who received each service categorized by
service mode (24 hour, day and outpatient services). This was reported on the overall population (Table 2a),
adults (Table 2b) and youths (Table 2c). We completed our report of the mental health system at a glance by
reporting the total amount of service received for each year in Table 3. A challenge we confronted with DMH
data was the unit of service. County mental health plan services are all divided into 3 units of measure: 24 hour
service (Mode 5), Day long service (Mode 10) and Outpatient Services (Mode 15), defined as a client or support
person contact. Not only are different services delivered in multiple units (hours or a fraction of an hour, day
and episode), but services such as Therapeutic Behavioral are delivered in more than one arrangement. To
standardize unit measurement so we could represent the volume of service that are comparable, we made
modifications to 20 of the 36 service configurations provided by DMH. We did not initially modify any 24
hour service specified as Mode 5. We made changes to 6 of the services categorized as mode 10 (day long) but
which were delivered in increments that were less than a full day. We converted these 6 services to a full day
by weighting each unit by 4. Of the 14 remaining services whose units we modified in the outpatient mode of
service (Mode 15), where we took the specified units given and converted them all to hourly units. We then
converted all 24 hour and day services to hours so as to facilitate comparison with outpatient services.
To examine the utilization of evidence-based services and service strategies, we calculated the number and
proportion of individuals that received an EBP and strategies each year. We first reported on the overall
proportion of individuals (Table 4a and 5a) followed by a breakdown of adults (Table 4b and 5b) and youths
CA BHNA Appendix D: MH/SU Provider Data 217
(Table 4c and 5c). We also estimated the number and proportion of individuals, adults and youths who received
multiple EBPs (Tables 6a-6c) ranging from 2 through 7. Next, to give an impression of EBP penetration we
calculated the number of unduplicated EBP service recipients as a proportion of all service recipients served by
county mental health plans in each year (Table 7a through 7c). We reported these findings on the overall
population as well as by adults and youths. Finally, we looked at EBP recipients by County density (Table 8) by
reporting on the number of EBPs delivered and percent of users who got them in each geographic locale.
To arrive at system performance (Tables 9a and 9b), we tabulate 3 variables that described the mental health
system: snapshot, arrival & disappearance. We used snapshot, arrival and disappearance as a means of
presenting another glimpse of behavioral health utilization using methods our team has pioneered and used in
the federal Block Grant and various state and local health reform initiatives. This is based on examining the
patterns of service use by examining the number of individuals who are served using 3 consecutive months as a
barometer for gauging how many cease service use and perhaps returning in subsequent months in the same
calendar year or in a subsequent year. We therefore, assign individuals to snapshot who has 3 or more
consecutive months of service (as indicated by CSI claims). Those who experience any interruption but return
subsequently are considered arrivals. Arrivals may also include individuals who are new to services funded
through DMH. Disappearances are defined by those who receive no services for more than 3 months.
Service Utilization
Once we established the how many are in the system on average (snapshot) and how many arrive typically on a
monthly basis, we then used outcome information provided by the state through the GAF (Global Assessment
of Functioning) to examine on average how many individuals who are most vulnerable (very low functioning)
and how many are of high functioning received different service configurations. We translated the GAF into a
functional level scale developed by HSRI and used in over 25 different states and local mental health
authorities. It is known as the RAFLS (Resource Associated Functional Level Scale) and it contains 6
dimensions. Table 1 below outlines the description of the 6 functional level scale according to the RAFLS. The
RAFLS FL assessment was used to give a concise portrait of the appropriateness of service receipt. Tables 10a
and 10b were constructed to provide such a portrait. For each service categorized by service mode, we
calculated the proportion of consumers within each RAFLS level that received the service (left side of panel)
and the amount received (right side of panel). The amount was defined by the unit of service standardized to
hours. This analysis was also carried out for 2009, 2008 and 2007.
DMC/SMHS Providers
Mental Health &
Mental Health Only Substance Use Only Substance Use Total
Year N % Total $ N % Total $ N % Total $ N Total $
2009 3,097 76% $1,751,282,188 529 13% $113,704,016 428 11% $1,142,081,560 4,054 $3,007,067,764
350 319
300
Number of Providers
250
200
0
<5 6-10 11-50 51-100 101+
Number of Individuals Served
35
31
30
24
25
Number of Providers
20
14
15 Number of Providers
11
10
4 4
5
0
<5 6-10 11-20 21-30 31-40 41+
Number of Individuals Served
350 318
300 273
Number of Providers
250 222
50
120
100
80 Number of Providers
60
40 26 26
17 11
10 5
20 3
0
<5 6-10 11-20 21-30 31-40 41-50 51-100 101+
Number of Individuals Served
50
Number of Providers
40
30
Number of Providers
20 16 16 16
12
9 10
10 5
0
<5 6-10 11-20 21-30 31-40 41-50 51-100 101+
Number of Individuals Served
35
30
25
Number of Providers
25
19
20 18
17
15
15 Number of Providers
10
10
200
150
111 114
96
86 Number of Providers
100
59
50 30
300
250 201
200 169
Number of Providers
150
97 97 84
100 61
46
50 20
10 9
Number of Providers
8 7
Number of Providers
6
4 3
0
1-50 51-100 101-500 501-1,000 1,001+
Number of Individuals Served
700
587
600
511
Number of Providers
500
400 332
Number of Providers
300
179
200
119
88
100
0
1-5 6-10 11-50 51-100 101-500 501-800 801+
Number of Individuals Served
50
Number of Providers
40
30
26
30
Provider
20
10 4 2
0
< 50 51-100 101-250 251-500 500+
Number of Individuals Served
120
101
100 92
80
Number of Providers
60
Number of Providers
43 42 40
36 36
40
20
0
1-10 11-20 21-30 31-40 41-50 51-100 101+
Number of Individuals Served
12
10
Number of Providers
Number of Providers
6
4
4 3
2
2
0
1-25 26-50 51-100 101+
Number of Individuals Served
12 11 11 11
10
Number of Providers
6 5
Number of Providers
4 3
2 1
0
<5 6-10 11-20 21-30 31-40 41+
Number of Individuals Served
300
Number of Providers
250
200
150
Providers
100
45
50 29 18 25 27
17 10 13
0
30
26
25
20
Number of Providers
20
15
14
15 13
Number of Providers
10
0
< 100 101-250 251-500 501-1,000 1,001+
Total Units of Service
243 243
250 228
194
200
139
150 107 Providers
100 69
50
70
60
50
40 32
25 28 26
30 24 Providers
20
20 11 12
10
0
35
30
25 18
20 14
15 Providers
8
10 5
5
0
35
30
25
25
18
20
15 Number of Providers
15 12
9
10 6 7
5
0
300
250
Number of Providers
191
200
145
150 134 Providers
119
101
100 68
54
45
50
0
1-5 6-10 11-20 21-30 31-40 41-50 51-100 101-500 501+
Total Units of Service
10
8
6
Providers
6
0
< 100 101-500 501-1,000 1,001+
Total Units of Service
300 266
241
250
185
200 170
155
150 113 Providers
100
50
30 25
25
19
20
Providers
15
10
5
0
< 25,000 25,001-50,000 50,001-100,000 100,001+
Total Units of Service
80
70
Number of Providers
56
60
50
39 38
40
31 31
27 28
30 23 Providers
20
20 13
10
7
Number of Providers
5
4 4
4 Providers
3 3
3
0
< 50 51-100 101-500 501-1,000 1,001+
Total Units of Service
16 15
14 13
12
Number of Providers
10
8
8
6 Providers
0
< 100 101-500 501-1,000 1,001+
Total Units of Service