Evaluation Deliverable1A Brief7 INN

California’s Investment in the Public Mental Health System: Proposition 63 Brief 7 of 7: Capital Facilities/Technolog ical Needs and Innovation UCLA Center for Healthier Children, Youth and Families The following report was funded by the Mental Health Services Oversight and Accountability Commission California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation I. Activities Funded under Capital Facilities/Technological Needs and Innovation These components are combined into one brief because expenditures are limited to one fiscal year (FY 2008 – 2009). In the Capital Facilities Project Proposed Guidelines for the County's Three-Year Program and Expenditure Plan, a capital facility is: i  “a building secured to a foundation which is permanently affixed to the ground and used for the delivery of MHSA services to individuals with mental illness and their families or for administrative offices.” (p. 2) Capital Facility funds:  “may be used by the County to acquire, develop or renovate such buildings or to purchase land in anticipation of acquiring/constructing a building.” (p. 2) These funds may also be used to renovate privately owned buildings as long as the buildings provide MHSA services (p. 2). It is emphasized that expenditures that result from Capital Facilities funding must add to the County Department of Mental Health’s infrastructure in a lasting way as well as add to the scope of current services or create new ones. Also, as stated in the Proposed Guidelines for Completing the Capital Facilities and Technological Needs Component Proposal of the County's Three-Year Program and Expenditure Plan, funds for Capital Facilities are organized together with those for Technological Needs although the two components have their own regulations, requirements, and purposes (p. 3). In the Guidelines for Completing the Technological Needs Project Proposal for the County Three- Year Program and Expenditure Plan,ii the goal of the Technological Needs component of the MHSA is said to be twofold: 1. Technological Needs Projects should increase client and family empowerment: a. “by providing the tools for secure client and family access to health information that is culturally and linguistically competent within a wide variety of public and private settings” (p. 2). This can be done by providing complete, accurate, and the most up-to-date information about a client’s mental health history to the service provider or the client and his/her family in order to reduce error, improve care coordination, increase client and family mental health literacy, and improve communication between clients and service providers (p. 2). b. What is also crucial here is that information is available in a language that the client and his/her family understand for this “allows for client and family input and communication with their service provider in a culturally and linguistically competent manner.” (p. 3) 1 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation 2. The second goal of Technological Need Projects is to: “modernize and transform clinical and administrative information systems to ensure quality of care, parity, operational efficiency and cost effectiveness” through various projects such as the Electronic Health Record System Project (pp. 2, 6). Innovation is defined in the Proposed Guidelines for the Mental Health Services Act Innovation (INN) Component of the Three-Year Program and Expenditure Plan iii as a project that aims to contribute to learning, not necessarily in providing a lasting service (p. 5). In other words, it is a chance to “try-out” different strategies by:  introducing entirely new practices/approaches,  altering an existing practice/approach, or  introducing a new application of a practice/approach that shows potential or has been successful in a non-mental health context (pp. 5-6). A clarification is made that:  “a practice/approach that has been successful in one community mental health setting cannot be funded as an INN project in a different community even if the practice/approach is new to that community, unless it is changed in a way that contributes to the learning process.” (p. 6) Also, many INN projects will not be successful but are still seen as worthwhile if they somehow contribute to the learning process (p. 6). Basically, if INN projects in one way or another add to learning and meet certain standards, they can be applied in almost any area of the mental health system (p. 7). Finally, for INN projects that are successful, they may only be continued in the long- term if funding is supplied by a different source (p. 10). Table 7.1 displays the number of counties who, through the Revenue and Expenditure Reports, documented spending money on Capital Facilities, Technological Needs, or Innovation projects during the time period for which data was provided. Note that Capital Facilities and Technological Needs are considered to be, together, one component. But for the purpose of showing whether or not funds were expended, they are shown throughout this report separately. Also note that although there are 58 counties in California, two counties jointly receive funding. There are a total of two city-run programs, bringing the total number of counties/municipalities to 59.iv Table 7.1 Number of Counties/Municipalities Expending Funds on Capital Facilities, Technological Needs, and Innovation (FY 08-09) Acronym Service/Component 06-07 07-08 08-09 CF Capital Facilities -- -- -- -- 8 14% TN Technological Needs -- -- -- -- 8 14% INN Innovation -- -- -- -- 6 10% 2 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation Below is a timeline displaying key events leading up to, and including Capital Facilities and Technological Needs expenditures in FY 2008 – 2009: Table 7.2 CF/TN Timeline of Key Fiscal Events Key CF/TN Event Date Fiscal Year Citation Planning Estimates Released January 2008 2007 - 2008 v Plan Guidance Released March 2008 2007 - 2008 vi Allocations Released July 2008 2008 - 2009 vii 8 Counties Expend CF/TN Funds -- 2008 - 2009 -- Below is a timeline displaying key events leading up to, and including Innovation expenditures in FY 2008 – 2009: Table 7.3 INN Timeline of Key Fiscal Events Key Innovation Event Date Fiscal Year Citation Allocations Released December 2008 2008 - 2009 viii Plan Guidance Released January 2009 2008 - 2009 ix 6 Counties Expend INN Funds -- 2008 - 2009 -- Table 7.4 provides a brief explanation of expended and unexpended funds, and Table 7.5 displays (in each of the State’s Fiscal Years) component expenditures and the amount of money that was available to be spent, but was not spent. Note that the data source used for this brief was the Revenue and Expenditure Reports submitted by counties and municipalities for FY 2006 – 2007, 2007 – 2008 and 2008 – 2009. Table 7.4 Expended and Unexpended Funds – Brief Summary x Expended Funds Approving Component Action Taken DMH Counties -- Entity sends $ Expend Funds DMH CF/TN Approval for MHSA funding X X -- MHSOAC INN Approval for MHSA funding X X -- Unexpended Funds Approving Component Action Taken DMH Counties can’t Carry-over/ Entity sends $ expend funds* prior FY** DMH CF/TN Approval for MHSA funding X X X MHSOAC INN Approval for MHSA funding X X X *for various reasons, but funds are available to be spent; **MHSA carry over monies; not subject to reversion Unexpended funds do not include “undistributed” funds – monies at DMH that have not yet been sent to counties/municipalities. Undistributed funds are not included in the analysis because they are not included in the Revenue and Expenditure Report. The Revenue and Expenditure Report was chosen as the primary data source because it provides an accounting of expended funds (monies spent). The key questions for the Cost series of briefs (Overview and Summary Brief, p. 2) are all related to monies spent. Analysis of undistributed funds was not deemed essential to answering these questions at this point in time. 3 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation With regard to funds subject to reversion, which fall under the unexpended funds category, the California Welfare and Institutions Code, under section 5892(h), states: xi “Other than funds placed in a reserve in accordance with an approved plan, any funds allocated to a county which have not been spent for their authorized purpose within three years shall revert to the state to be deposited into the fund and available for other counties in future years, provided however, that funds for capital facilities, technological needs, or education and training may be retained for up to 10 years before reverting to the fund.” [underline added for emphasis] Therefore, funds allocated to be spent on CF/TN, but remain unspent for ten years, revert back to the State after that time period has elapsed. Distribution of CF/TN funds to counties was based on full project funding for multiple years, rather than the year by year distributions (latter is the distribution format for CSS and PEI, for example).xii Innovation has a three-year reversion period.xiii Distribution of Innovation funds to counties was based on full project funding for multiple years (like CF/TN), rather than yearly distributions.xiv Table 7.5 Monies Expended and Unexpended (FY 08-09) MHSA Expenditures FY 08-09 Expended Unexpended Capital Facilities $3,009,714.89 $6,516,570.51 Technological Needs $7,691,427.34 $15,398,299.85 Innovation $34,973.11 $29,495,784.83 The component allocations (from the California Department of Mental Health’s Excel files, downloaded from their website)xv are compared to the total amount expended and unexpended in each Fiscal Year. Table 7.6 (FY 07-08) shows the component allocation for Capital Facilities and Technological Needs – recall that planning estimates were released at the start of FY 2008 – 2009 (see Table 7.2). Table 7.7 displays expended and unexpended monies and component allocations for FY 2008 - 2009.xvi Table 7.6 CF/TN Component Allocation (FY 07-08) FY 07-08 Component Allocations CF/TN $343,115,862 4 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation Table 7.6 Monies Expended and Unexpended Relative to Component Allocation (FY 08-09) MHSA Expenditures* FY 08-09 Component Expended Unexpended Total Allocations CF/TN $10,701,142 $21,914,870 $32,616,013 $114,091,446 INN $34,973 $29,495,785 $29,530,758 $71,000,000 *Expenditures have been rounded for comparison Figure 7.1a illustrates the proportion of unexpended to expended funds for Capital Facilities. Figure 7.1a Proportion of Capital Facilities Expended Funds to Unexpended Funds (FY 08-09) Expended 32% Unxpended 68% It is important to note that distribution of CF/TN funds to counties was based on full project funding for multiple years, rather than the year by year distributions (latter is the distribution format for CSS and PEI, for example).xvii Figure 7.1b illustrates the proportion of unexpended to expended funds for Technological Needs. Figure 7.1b Proportion of Technology Expended Funds to Unexpended Funds (FY 08-09) Expended 33% Unxpended 67% There is no figure to illustrate the proportion of unexpended to expended funds for Innovation because only 0.1 percent of Innovation funds were expended, too small to be visible on the graph. 5 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation Table 7.7 depicts expenditures within each of the major areas authorized under each component. Innovation expenditures are displayed separately from Technological Needs and Capital Facilities because the activities upon which funds are expended are different. Table 7.7a Total Amount Expended by Category (FY 08-09) MHSA Expenditures MHSA Expenditures FY 08-09 FY 08-09 Capital Facilities (CF) Technological Needs (TN) Percent N of N of Percent of Amount of Total Amount Counties Counties Total TN CF Personnel $101,288.27 3 3.4% $5,261.00 1 0.1% Operating costs $17,817.77 3 0.6% $51,553.33 2 0.7% City/County Allocated $137.00 1 0.0% $74,258.00 2 1.0% Administration Total Administration $119,243.04 5 4.0% $131,072.33 3 1.7% Total Projects $2,890,471.85 6 96.0% $7,560,355.01 8 98.3% Total $3,009,714.89 8 100.0% $7,691,427.34 8 100.0% Among the few counties expending funds, the majority of expenditures were for Capital Facilities and Technology projects (rather than personnel, operating costs, or administration). Table 7.7b Total Innovation Expenditures (FY 08-09) MHSA Expenditures FY 08-09 N of Amount Percent Counties INN Planning $34,973.11 6 100.0% Given the launch year and early implementation status of Innovation, it is appropriate that counties focused efforts on planning. 6 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation II. Contextual Considerations In order to determine potential contextual factors of importance, the UCLA/EMT Team looked to DMH funding guidelines for the Mental Health Services Act. Guidance for funding distribution was described in the Overview/Summary Brief (p. 23). xviii Population is one critical factor in the MHSA funding distribution formula, and is used as a basis for categorizing counties for the purpose of analysis throughout the remainder of this brief. Figure 7.2a depicts Capital Facilities expenditures as a proportion of the MHSA dollar.xix Figure 7.2a The Mental Health Services Act Dollar – Capital Facilities Expenditures by County Population (FY 08-09) $1.00 $0.90 $0.80 $0.70 Projects $0.60 Expenditures $0.50 $0.40 $0.30 Administration $0.20 Expenditures $0.10 $0.00 < 45,000 > 4 5 , 000 - > 150,000 - > 400,000 - >1,000,000 - > 5,000,000 (13 Counties) 150,000 4 0 0,000 1 , 0 00,000 5 , 0 0 0,000 ( L o s Angeles (11 Counties)(11 Counties)(12 Counties) (8 Counties) County) a Administration expenditures in the smallest and medium-sized counties may reflect particular needs encountered related to infrastructure. Plans and Annual Updates will be systematically reviewed in order to further determine unique factors facing these counties. Figure 7.2b The Mental Health Services Act Dollar – Technological Needs Expenditures by County Population (FY 08-09) $1.00 $0.90 $0.80 $0.70 Projects $0.60 Expenditures $0.50 $0.40 Administration $0.30 Expenditures $0.20 $0.10 $0.00 < 45,000 > 4 5 ,000 - > 150,000 - > 400,000 - >1,000,000 - > 5,000,000 (13 Counties) 150,000 4 00,000 1 ,000,000 5 , 0 00,000 ( L o s Angeles (11 Counties)(11 Counties)(12 Counties) (8 Counties) County) 7 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation Whether expenditures are illustrated by region or population, the end result is the same. The bulk of the Technology Mental Health dollar was expended on projects. However, these findings are only applicable for the eight counties who expended CF/TN funds. Although the UCLA/EMT Team does not yet have access to data on individuals served under the Mental Health Services Act, monies spent can still be examined by region in the context of that region’s population through the use of census data. This technique provides a snapshot of spending in relationship to population, in order to arrive at a dollar amount per capita spent on mental health services. “Per capita” means per person.xx This technique is used for preliminary comparison purposes only. Figure 7.3 Capital Facilities and Technological Needs Expenditures Per Capita by State and Region (FY 08-09) $0.40 $0.35 a t ip a $0.30 C r e $0.25 P s e $0.20 r u t id $0.15 n e $0.10 p x E $0.05 $0.00 California Superior State Central Counties Counties Bay Area Counties Southern Counties Los Angeles Region Capital Facilities Technological Needs Figure 7.3 illustrates per capita expenditures within county regions (with one exception) and California overall are larger for Technological Needs compared to Capital Facilities. However, these findings are only applicable for the eight counties who expended CF/TN funds. Note that Innovation could not be included in the figure because the amount per capita is well below a penny – at $0.0009. A number this small cannot be displayed to scale. 8 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation The impact of county population on overall CF/TN expenditures is displayed in Figure 7.4. Innovation is not included because there are only six counties reporting expenditures, which is insufficient to spread across the population categories. Examination of expenditures by county population revealed that more populous counties tended to spend more on Technology average (see Figure 7.4). This finding suggests county average total Technology expenditures seem to be associated with population size. This finding does not hold for Capital Facilities. However, recall that only eight counties expended funds on CF/TN – hence, these results are preliminary. Figure 7.4 Average Capital Facilities and Technological Needs Expenditures by County Population (FY 08-09) s e $600.00 r u tid $500.00 n) e p x E s d n a s $400.00 Capital Facilities Nu $300.00 o Th FT $200.00 C n e g i( $100.00 Technological a r Needs e v $0.00 A < 45,000 > 45,000 - (13 > 150,000 - Counties) C 1 o 5 u ( 0 1 n ,0 1 ti 0 e 0 s ) C 4 o 0 u ( 0 1 n ,0 1 ti 0 e 0 s ) > 1 , 4 0 0 0 ( 0 1 0 , 2 , 0 0 0 0 0 0 - ( > - 8 5 1 C , , 0 0 o 0 0 u 0 0 n , , 0 t 0 i 0 0 e 0 s 0 ) > 5, ( 0 L 0 o 0 s , 000 Counties) Angeles County) County Population 9 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation The UCLA/EMT team further examined the number of TN and CF projects for which funds were expended. Information about unique projects was only available for FY 2008 – 2009. Innovation is not included because only Planning was funded in FY 2008 – 2009, and no projects. Figure 7.5 Capital Facilities and Technological Needs – Number of Projects on which Funds were Expended (FY 08-09)xxi 9 8 s e itn 7 u 6 o C 5 fo re b 3 4 m u 2 N 1 0 1 2 Number of Projects Capital Facilities Technological Needs Among counties and municipalities who expended funds on CF/TN, they tended to focus their efforts on a single project, rather than spreading their resources across multiple projects. However, these findings are only applicable for the eight counties who expended CF/TN funds. 10 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation III. Summary  Average total CF/TN expenditures tend to be associated with county size. However, thus far funds have been expended only by eight counties, so these results are preliminary.  Most technology funds were expended on projects, whereas most capital facilities funds were expended on administration or projects, depending upon the size of the county and (presumed) implementation needs.  Among counties and municipalities who launched CF/TN efforts, they tended to focus their efforts on a single projects rather than spreading their resources across multiple projects. 11 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation Appendix A: Capital Facilities Total Expenditures by County and Municipality: FY 2008 - 2009 Category Total Capital Administration Administration Administration Total Total County Facilities (CF) Personnel Operating Costs City/County Allocated Administration Projects Alameda -- -- -- -- -- -- Alpine -- -- -- -- -- -- Amador -- -- -- -- -- -- Berkeley City -- -- -- -- -- -- Butte -- -- -- -- -- -- Calaveras -- -- -- -- -- -- Colusa -- -- -- -- -- -- Contra Costa $102,994.00 -- $2,994.00 -- $2,994.00 $100,000.00 Del Norte -- -- -- -- -- -- El Dorado -- -- -- -- -- -- Fresno -- -- -- -- -- -- Glenn -- -- -- -- -- -- Humboldt -- -- -- -- -- -- Imperial -- -- -- -- -- -- Inyo -- -- -- -- -- -- Kern -- -- -- -- -- -- Kings -- -- -- -- -- -- Lake -- -- -- -- -- -- Lassen -- -- -- -- -- -- Los Angeles -- -- -- -- -- -- Madera -- -- -- -- -- -- Marin -- -- -- -- -- -- Mariposa $690.00 -- $690.00 -- $690.00 -- Mendocino -- -- -- -- -- -- Merced $5,146.54 $3,829.00 -- $137.00 $3,966.00 $1,180.54 Modoc -- -- -- -- -- -- Mono -- -- -- -- -- -- Monterey $83,674.99 $69,541.22 $14,133.77 -- $83,674.99 -- Napa -- -- -- -- -- -- Nevada $230,630.50 -- -- -- -- $230,630.50 Orange $1,247,646.86 $27,918.05 -- -- $27,918.05 $1,219,728.81 Placer -- -- -- -- -- -- Plumas -- -- -- -- -- -- Riverside $942,266.00 -- -- -- -- $942,266.00 Sacramento -- -- -- -- -- -- San Benito -- -- -- -- -- -- San Bernardino -- -- -- -- -- -- San Diego -- -- -- -- -- -- San Francisco -- -- -- -- -- -- San Joaquin -- -- -- -- -- -- San Luis Obispo -- -- -- -- -- -- San Mateo -- -- -- -- -- -- Santa Barbara -- -- -- -- -- -- Santa Clara -- -- -- -- -- -- Santa Cruz -- -- -- -- -- -- Shasta -- -- -- -- -- -- Sierra -- -- -- -- -- -- Siskiyou -- -- -- -- -- -- Solano -- -- -- -- -- -- Sonoma $396,666.00 -- -- -- -- $396,666.00 Stanislaus -- -- -- -- -- -- Sutter-Yuba -- -- -- -- -- -- Tehama -- -- -- -- -- -- Tri-Cities -- -- -- -- -- -- 12 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation Capital Facilities Total Expenditures by County: FY 2008 – 2009 Category Total Capital Administration Administration Administration Total Total County Facilities (CF) Personnel Operating Costs City/County Allocated Administration Projects Trinity -- -- -- -- -- -- Tulare -- -- -- -- -- -- Tuolumne -- -- -- -- -- -- Ventura -- -- -- -- -- -- Yolo -- -- -- -- -- -- 13 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation Technological Needs Total Expenditures by County and Municipality: FY 2008 - 2009 Total Category Technological Administration Administration Administration Total Total County Needs (TN) Personnel Operating Costs City/County Allocated Administration Projects Alameda -- -- -- -- -- -- Alpine -- -- -- -- -- -- Amador -- -- -- -- -- -- Berkeley City -- -- -- -- -- -- Butte -- -- -- -- -- -- Calaveras -- -- -- -- -- -- Colusa -- -- -- -- -- -- Contra Costa -- -- -- -- -- -- Del Norte -- -- -- -- -- -- El Dorado -- -- -- -- -- -- Fresno -- -- -- -- -- -- Glenn -- -- -- -- -- -- Humboldt -- -- -- -- -- -- Imperial -- -- -- -- -- -- Inyo -- -- -- -- -- -- Kern -- -- -- -- -- -- Kings -- -- -- -- -- -- Lake -- -- -- -- -- -- Lassen -- -- -- -- -- -- Los Angeles -- -- -- -- -- -- Madera -- -- -- -- -- -- Marin -- -- -- -- -- -- Mariposa -- -- -- -- -- -- Mendocino -- -- -- -- -- -- Merced $87,731.00 $5,261.00 $179.00 $2,328.00 $7,768.00 $79,963.00 Modoc -- -- -- -- -- -- Mono -- -- -- -- -- -- Monterey $857,207.43 -- $51,374.33 -- $51,374.33 $805,833.10 Napa -- -- -- -- -- -- Nevada -- -- -- -- -- -- Orange -- -- -- -- -- -- Placer -- -- -- -- -- -- Plumas -- -- -- -- -- -- Riverside $641,612.00 -- -- $71,930.00 $71,930.00 $569,682.00 Sacramento $632,940.00 -- -- -- -- $632,940.00 San Benito -- -- -- -- -- -- San Bernardino -- -- -- -- -- -- San Diego $3,316,334.92 -- -- -- -- $3,316,334.92 San Francisco -- -- -- -- -- -- San Joaquin -- -- -- -- -- -- San Luis Obispo $175,244.99 -- -- -- -- $175,244.99 San Mateo $1,907,871.00 -- -- -- -- $1,907,871.00 Santa Barbara -- -- -- -- -- -- Santa Clara -- -- -- -- -- -- Santa Cruz -- -- -- -- -- -- Shasta -- -- -- -- -- -- Sierra -- -- -- -- -- -- Siskiyou -- -- -- -- -- -- Solano -- -- -- -- -- -- Sonoma -- -- -- -- -- -- Stanislaus -- -- -- -- -- -- Sutter-Yuba -- -- -- -- -- -- Tehama -- -- -- -- -- -- Tri-Cities -- -- -- -- -- -- Trinity $72,486.00 -- -- -- -- $72,486.00 Tulare -- -- -- -- -- -- 14 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation Technological Needs Total Expenditures by County: FY 2008 - 2009 Total Category Technological Administration Administration Administration Total Total County Needs (TN) Personnel Operating Costs City/County Allocated Administration Projects Tuolumne -- -- -- -- -- -- Ventura -- -- -- -- -- -- Yolo -- -- -- -- -- -- 15 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation Innovation Total Expenditures by County and Municipality: FY 2008 - 2009 County Planning Alameda -- Alpine -- Amador -- Berkeley City -- Butte -- Calaveras -- Colusa -- Contra Costa -- Del Norte -- El Dorado -- Fresno -- Glenn -- Humboldt -- Imperial -- Inyo -- Kern -- Kings -- Lake -- Lassen -- Los Angeles -- Madera -- Marin -- Mariposa $225.00 Mendocino -- Merced $1,185.00 Modoc -- Mono $18,250.00 Monterey $3,996.49 Napa -- Nevada -- Orange -- Placer -- Plumas -- Riverside -- Sacramento -- San Benito -- San Bernardino $6,166.62 San Diego $5,150.00 San Francisco -- San Joaquin -- San Luis Obispo -- San Mateo -- Santa Barbara -- Santa Clara -- Santa Cruz -- Shasta -- Sierra -- Siskiyou -- Solano -- Sonoma -- Stanislaus -- Sutter-Yuba -- Tehama -- Tri-Cities -- Trinity -- Tulare -- Tuolumne -- Ventura -- Yolo -- 16 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation Appendix B: Revenue and Expenditure Reports Process of Transferring Individual County Excel Files into Master Cross-Site File The MHSA (FY: 06/07, 07/08, 08/09) Database is an aggregated database containing fiscal data from a total of 59 California counties/municipalities spanning three fiscal year periods, covering 25 program data sets, sourced from 589 distinct file locations, containing a total of 4,498 unique variables, encompassing a grand total of 287,265 distinct data points. Fiscal Year 2006-2007 contained 1,325 distinct variables provided by 57 counties/municipalities across 6 programs located within 57 separate files containing a total of 72,525 distinct data points. Fiscal Year 2007-2008 contained 1,265 distinct variables provided by 59 counties/municipalities across 7 programs located within 60 separate files containing a total of 75,900 distinct data points. Fiscal Year 2008-2009 contained 2,264 distinct variables provided by 59 counties/municipalities across 11 programs located within 472 separate files containing a total of 135,840 distinct data points. The MHSA Database was constructed through a process of template creation, formula crafting, running transfer protocols and performing validity checks. Templates were formed via construction of a list of all variables across each program over all three fiscal years. Formula were generated to transfer the values of individual cells to the database template and were compiled to transfer all the relevant data points within a given workbook and, subsequently, entire source-file. Formulas were crafted for each of the unique variables contained within each program or workbook. Master formulae were crafted for each workbook within a file or fiscal year. The master formulae performed the relocation of each relevant data point, across all programs, within a given file or fiscal year. Transfer protocols were generated to perform manual and semi-automated opening and closing of files, updating formula and transferring the relevant data values of each fiscal year to the database. Validity checks were performed throughout each stage of the process with full checks on each new formula, random spot checks, specific value checks and redundant report checks. 17 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation Challenges/Limitations Complications in the construction of the database template arose from the systemic variance within a specific program across multiple fiscal years. Each program contains differing sets of reported variables across each fiscal year. Such complexity required the database construction and formulae formats to account for the disparate data formats. This was accomplished through the merger of otherwise identical variables names that were renamed and through the adjustment of cell-specific spacing references in all formulae. Further complicating the construction of the database was the systemic variance between the three fiscal years in file sets and data locations. While fiscal years 2006-2007 and 2007-2008 are rather similar the 2008-2009 fiscal year is provided in an entirely different file set format. Additionally, each fiscal year contains noteworthy variance in data locations from the other fiscal years. This complexity required the substantial retooling of the formula sets and numerous additional, unique formula sets to be constructed. However, the most severe complications came as a result of modifications performed by reporting counties to the file names, workbook names and, most significantly, workbook formats. Variances which caused transfer protocols to report incorrect and invalid data points, if not miss the source- data entirely. These issues necessitated the manual reformatting of all files and workbooks locations found to be employing deviant standards and the subsequent manual operation of all associated transfer protocols. In addition, the FY 2006-2007 and FY 2007-2008 formula cells were not locked. Therefore, counties could modify the formulas and mistakes were made. The UCLA/EMT team therefore had to create summary variables, rather than rely upon the formulas as included in the Revenue and Expenditure Reports. 18 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation Appendix C: Component Allocations and Approved Amounts for Capital Facilities/Technological Needs, and Innovation Component Allocations and Approved Amounts – CF & TN FY 2007-2008 *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amount County FY Component Data Total Alameda FY 07/08 CF & TN *Component Allocations $ 1 2,327,100 Approved Amounts $ 1 2,327,100 FY 07/08 *Component Allocations $ 1 2,327,100 FY 07/08 Approved Amounts $ 1 2,327,100 Alameda *Component Allocations $ 1 2,327,100 Alameda Approved Amounts $ 1 2,327,100 Alpine FY 07/08 CF & TN *Component Allocations $ 6 00,000 Approved Amounts $ 6 00,000 FY 07/08 *Component Allocations $ 6 00,000 FY 07/08 Approved Amounts $ 6 00,000 Alpine *Component Allocations $ 6 00,000 Alpine Approved Amounts $ 6 00,000 Amador FY 07/08 CF & TN *Component Allocations $ 6 00,000 Approved Amounts $ 6 00,000 FY 07/08 *Component Allocations $ 6 00,000 FY 07/08 Approved Amounts $ 6 00,000 Amador *Component Allocations $ 6 00,000 Amador Approved Amounts $ 6 00,000 Berkeley City FY 07/08 CF & TN *Component Allocations $ 1 ,089,700 Approved Amounts $ 1 ,089,700 FY 07/08 *Component Allocations $ 1 ,089,700 FY 07/08 Approved Amounts $ 1 ,089,700 Berkeley City *Component Allocations $ 1 ,089,700 Berkeley City Approved Amounts $ 1 ,089,700 Butte FY 07/08 CF & TN *Component Allocations $ 1 ,849,700 Approved Amounts $ 1 ,849,700 FY 07/08 *Component Allocations $ 1 ,849,700 FY 07/08 Approved Amounts $ 1 ,849,700 Butte *Component Allocations $ 1 ,849,700 Butte Approved Amounts $ 1 ,849,700 Calaveras FY 07/08 CF & TN *Component Allocations $ 6 00,000 Approved Amounts $ 6 00,000 FY 07/08 *Component Allocations $ 6 00,000 FY 07/08 Approved Amounts $ 6 00,000 Calaveras *Component Allocations $ 6 00,000 Calaveras Approved Amounts $ 6 00,000 Colusa FY 07/08 CF & TN *Component Allocations $ 6 00,000 Approved Amounts $ 6 00,000 FY 07/08 *Component Allocations $ 6 00,000 FY 07/08 Approved Amounts $ 6 00,000 Colusa *Component Allocations $ 6 00,000 Colusa Approved Amounts $ 6 00,000 Contra Costa FY 07/08 CF & TN *Component Allocations $ 7 ,778,300 Approved Amounts $ 7 ,778,300 FY 07/08 *Component Allocations $ 7 ,778,300 FY 07/08 Approved Amounts $ 7 ,778,300 Contra Costa *Component Allocations $ 7 ,778,300 Contra Costa Approved Amounts $ 7 ,778,300 19 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amount Del Norte FY 07/08 CF & TN *Component Allocations $ 6 00,000 Approved Amounts $ 6 00,000 FY 07/08 *Component Allocations $ 6 00,000 FY 07/08 Approved Amounts $ 6 00,000 Del Norte *Component Allocations $ 6 00,000 Del Norte Approved Amounts $ 6 00,000 El Dorado FY 07/08 CF & TN *Component Allocations $ 1 ,235,800 Approved Amounts $ 1 ,235,800 FY 07/08 *Component Allocations $ 1 ,235,800 FY 07/08 Approved Amounts $ 1 ,235,800 El Dorado *Component Allocations $ 1 ,235,800 El Dorado Approved Amounts $ 1 ,235,800 Fresno FY 07/08 CF & TN *Component Allocations $ 8 ,406,100 Approved Amounts $ 8 ,406,100 FY 07/08 *Component Allocations $ 8 ,406,100 FY 07/08 Approved Amounts $ 8 ,406,100 Fresno *Component Allocations $ 8 ,406,100 Fresno Approved Amounts $ 8 ,406,100 Glenn FY 07/08 CF & TN *Component Allocations $ 6 00,000 Approved Amounts $ 6 00,000 FY 07/08 *Component Allocations $ 6 00,000 FY 07/08 Approved Amounts $ 6 00,000 Glenn *Component Allocations $ 6 00,000 Glenn Approved Amounts $ 6 00,000 Humboldt FY 07/08 CF & TN *Component Allocations $ 1 ,068,100 Approved Amounts $ 1 ,068,100 FY 07/08 *Component Allocations $ 1 ,068,100 FY 07/08 Approved Amounts $ 1 ,068,100 Humboldt *Component Allocations $ 1 ,068,100 Humboldt Approved Amounts $ 1 ,068,100 Imperial FY 07/08 CF & TN *Component Allocations $ 1 ,568,900 Approved Amounts $ 1 ,568,900 FY 07/08 *Component Allocations $ 1 ,568,900 FY 07/08 Approved Amounts $ 1 ,568,900 Imperial *Component Allocations $ 1 ,568,900 Imperial Approved Amounts $ 1 ,568,900 Inyo FY 07/08 CF & TN *Component Allocations $ 6 00,000 Approved Amounts $ 6 00,000 FY 07/08 *Component Allocations $ 6 00,000 FY 07/08 Approved Amounts $ 6 00,000 Inyo *Component Allocations $ 6 00,000 Inyo Approved Amounts $ 6 00,000 Kern FY 07/08 CF & TN *Component Allocations $ 7 ,165,600 Approved Amounts $ 7 ,165,600 FY 07/08 *Component Allocations $ 7 ,165,600 FY 07/08 Approved Amounts $ 7 ,165,600 Kern *Component Allocations $ 7 ,165,600 Kern Approved Amounts $ 7 ,165,600 Kings FY 07/08 CF & TN *Component Allocations $ 1 ,254,300 Approved Amounts $ 1 ,254,300 FY 07/08 *Component Allocations $ 1 ,254,300 FY 07/08 Approved Amounts $ 1 ,254,300 Kings *Component Allocations $ 1 ,254,300 Kings Approved Amounts $ 1 ,254,300 20 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amount Lake FY 07/08 CF & TN *Component Allocations $ 6 00,000 Approved Amounts $ 6 00,000 FY 07/08 *Component Allocations $ 6 00,000 FY 07/08 Approved Amounts $ 6 00,000 Lake *Component Allocations $ 6 00,000 Lake Approved Amounts $ 6 00,000 Lassen FY 07/08 CF & TN *Component Allocations $ 6 00,000 Approved Amounts $ 6 00,000 FY 07/08 *Component Allocations $ 6 00,000 FY 07/08 Approved Amounts $ 6 00,000 Lassen *Component Allocations $ 6 00,000 Lassen Approved Amounts $ 6 00,000 Los Angeles FY 07/08 CF & TN *Component Allocations $ 9 8,053,039 Approved Amounts $ 9 8,053,039 FY 07/08 *Component Allocations $ 9 8,053,039 FY 07/08 Approved Amounts $ 9 8,053,039 Los Angeles *Component Allocations $ 9 8,053,039 Los Angeles Approved Amounts $ 9 8,053,039 Madera FY 07/08 CF & TN *Component Allocations $ 1 ,367,200 Approved Amounts $ 1 ,367,200 FY 07/08 *Component Allocations $ 1 ,367,200 FY 07/08 Approved Amounts $ 1 ,367,200 Madera *Component Allocations $ 1 ,367,200 Madera Approved Amounts $ 1 ,367,200 Marin FY 07/08 CF & TN *Component Allocations $ 1 ,893,900 Approved Amounts $ 1 ,893,900 FY 07/08 *Component Allocations $ 1 ,893,900 FY 07/08 Approved Amounts $ 1 ,893,900 Marin *Component Allocations $ 1 ,893,900 Marin Approved Amounts $ 1 ,893,900 Mariposa FY 07/08 CF & TN *Component Allocations $ 6 00,000 Approved Amounts $ 6 00,000 FY 07/08 *Component Allocations $ 6 00,000 FY 07/08 Approved Amounts $ 6 00,000 Mariposa *Component Allocations $ 6 00,000 Mariposa Approved Amounts $ 6 00,000 Mendocino FY 07/08 CF & TN *Component Allocations $ 7 04,500 Approved Amounts $ 7 04,500 FY 07/08 *Component Allocations $ 7 04,500 FY 07/08 Approved Amounts $ 7 04,500 Mendocino *Component Allocations $ 7 04,500 Mendocino Approved Amounts $ 7 04,500 Merced FY 07/08 CF & TN *Component Allocations $ 2 ,385,600 Approved Amounts $ 2 ,385,600 FY 07/08 *Component Allocations $ 2 ,385,600 FY 07/08 Approved Amounts $ 2 ,385,600 Merced *Component Allocations $ 2 ,385,600 Merced Approved Amounts $ 2 ,385,600 Modoc FY 07/08 CF & TN *Component Allocations $ 6 00,000 Approved Amounts $ 6 00,000 FY 07/08 *Component Allocations $ 6 00,000 FY 07/08 Approved Amounts $ 6 00,000 Modoc *Component Allocations $ 6 00,000 Modoc Approved Amounts $ 6 00,000 21 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amount Mono FY 07/08 CF & TN *Component Allocations $ 6 00,000 Approved Amounts $ 6 00,000 FY 07/08 *Component Allocations $ 6 00,000 FY 07/08 Approved Amounts $ 6 00,000 Mono *Component Allocations $ 6 00,000 Mono Approved Amounts $ 6 00,000 Monterey FY 07/08 CF & TN *Component Allocations $ 3 ,882,200 Approved Amounts $ 3 ,882,200 FY 07/08 *Component Allocations $ 3 ,882,200 FY 07/08 Approved Amounts $ 3 ,882,200 Monterey *Component Allocations $ 3 ,882,200 Monterey Approved Amounts $ 3 ,882,200 Napa FY 07/08 CF & TN *Component Allocations $ 1 ,031,000 Approved Amounts $ 1 ,031,000 FY 07/08 *Component Allocations $ 1 ,031,000 FY 07/08 Approved Amounts $ 1 ,031,000 Napa *Component Allocations $ 1 ,031,000 Napa Approved Amounts $ 1 ,031,000 Nevada FY 07/08 CF & TN *Component Allocations $ 7 45,100 Approved Amounts $ 7 45,100 FY 07/08 *Component Allocations $ 7 45,100 FY 07/08 Approved Amounts $ 7 45,100 Nevada *Component Allocations $ 7 45,100 Nevada Approved Amounts $ 7 45,100 Orange FY 07/08 CF & TN *Component Allocations $ 2 8,308,300 Approved Amounts $ 2 8,308,300 FY 07/08 *Component Allocations $ 2 8,308,300 FY 07/08 Approved Amounts $ 2 8,308,300 Orange *Component Allocations $ 2 8,308,300 Orange Approved Amounts $ 2 8,308,300 Placer FY 07/08 CF & TN *Component Allocations $ 2 ,276,500 Approved Amounts $ 2 ,276,500 FY 07/08 *Component Allocations $ 2 ,276,500 FY 07/08 Approved Amounts $ 2 ,276,500 Placer *Component Allocations $ 2 ,276,500 Placer Approved Amounts $ 2 ,276,500 Plumas FY 07/08 CF & TN *Component Allocations $ 6 00,000 Approved Amounts $ 6 00,000 FY 07/08 *Component Allocations $ 6 00,000 FY 07/08 Approved Amounts $ 6 00,000 Plumas *Component Allocations $ 6 00,000 Plumas Approved Amounts $ 6 00,000 Riverside FY 07/08 CF & TN *Component Allocations $ 1 8,358,100 Approved Amounts $ 1 8,358,100 FY 07/08 *Component Allocations $ 1 8,358,100 FY 07/08 Approved Amounts $ 1 8,358,100 Riverside *Component Allocations $ 1 8,358,100 Riverside Approved Amounts $ 1 8,358,100 Sacramento FY 07/08 CF & TN *Component Allocations $ 1 1,242,700 Approved Amounts $ 1 1,242,700 FY 07/08 *Component Allocations $ 1 1,242,700 FY 07/08 Approved Amounts $ 1 1,242,700 Sacramento *Component Allocations $ 1 1,242,700 Sacramento Approved Amounts $ 1 1,242,700 22 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amount San Benito FY 07/08 CF & TN *Component Allocations $ 6 00,000 Approved Amounts $ 6 00,000 FY 07/08 *Component Allocations $ 6 00,000 FY 07/08 Approved Amounts $ 6 00,000 San Benito *Component Allocations $ 6 00,000 San Benito Approved Amounts $ 6 00,000 San Bernardino FY 07/08 CF & TN *Component Allocations $ 1 8,162,500 Approved Amounts $ 1 8,162,500 FY 07/08 *Component Allocations $ 1 8,162,500 FY 07/08 Approved Amounts $ 1 8,162,500 San Bernardino *Component Allocations $ 1 8,162,500 San Bernardino Approved Amounts $ 1 8,162,500 San Diego FY 07/08 CF & TN *Component Allocations $ 2 8,417,800 Approved Amounts $ 2 8,417,800 FY 07/08 *Component Allocations $ 2 8,417,800 FY 07/08 Approved Amounts $ 2 8,417,800 San Diego *Component Allocations $ 2 8,417,800 San Diego Approved Amounts $ 2 8,417,800 San Francisco FY 07/08 CF & TN *Component Allocations $ 6 ,313,100 Approved Amounts $ 6 ,313,100 FY 07/08 *Component Allocations $ 6 ,313,100 FY 07/08 Approved Amounts $ 6 ,313,100 San Francisco *Component Allocations $ 6 ,313,100 San Francisco Approved Amounts $ 6 ,313,100 San Joaquin FY 07/08 CF & TN *Component Allocations $ 5 ,673,500 Approved Amounts $ 5 ,673,500 FY 07/08 *Component Allocations $ 5 ,673,500 FY 07/08 Approved Amounts $ 5 ,673,500 San Joaquin *Component Allocations $ 5 ,673,500 San Joaquin Approved Amounts $ 5 ,673,500 San Luis Obispo FY 07/08 CF & TN *Component Allocations $ 2 ,168,000 Approved Amounts $ 2 ,168,000 FY 07/08 *Component Allocations $ 2 ,168,000 FY 07/08 Approved Amounts $ 2 ,168,000 San Luis Obispo *Component Allocations $ 2 ,168,000 San Luis Obispo Approved Amounts $ 2 ,168,000 San Mateo FY 07/08 CF & TN *Component Allocations $ 5 ,539,300 Approved Amounts $ 5 ,539,300 FY 07/08 *Component Allocations $ 5 ,539,300 FY 07/08 Approved Amounts $ 5 ,539,300 San Mateo *Component Allocations $ 5 ,539,300 San Mateo Approved Amounts $ 5 ,539,300 Santa Barbara FY 07/08 CF & TN *Component Allocations $ 3 ,830,200 Approved Amounts $ 3 ,830,200 FY 07/08 *Component Allocations $ 3 ,830,200 FY 07/08 Approved Amounts $ 3 ,830,200 Santa Barbara *Component Allocations $ 3 ,830,200 Santa Barbara Approved Amounts $ 3 ,830,200 23 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amount Santa Clara FY 07/08 CF & TN *Component Allocations $ 1 6,205,300 Approved Amounts $ 1 6,205,300 FY 07/08 *Component Allocations $ 1 6,205,300 FY 07/08 Approved Amounts $ 1 6,205,300 Santa Clara *Component Allocations $ 1 6,205,300 Santa Clara Approved Amounts $ 1 6,205,300 Santa Cruz FY 07/08 CF & TN *Component Allocations $ 2 ,394,000 Approved Amounts $ 2 ,394,000 FY 07/08 *Component Allocations $ 2 ,394,000 FY 07/08 Approved Amounts $ 2 ,394,000 Santa Cruz *Component Allocations $ 2 ,394,000 Santa Cruz Approved Amounts $ 2 ,394,000 Shasta FY 07/08 CF & TN *Component Allocations $ 1 ,501,000 Approved Amounts $ 1 ,501,000 FY 07/08 *Component Allocations $ 1 ,501,000 FY 07/08 Approved Amounts $ 1 ,501,000 Shasta *Component Allocations $ 1 ,501,000 Shasta Approved Amounts $ 1 ,501,000 Sierra FY 07/08 CF & TN *Component Allocations $ 6 00,000 Approved Amounts $ 6 00,000 FY 07/08 *Component Allocations $ 6 00,000 FY 07/08 Approved Amounts $ 6 00,000 Sierra *Component Allocations $ 6 00,000 Sierra Approved Amounts $ 6 00,000 Siskiyou FY 07/08 CF & TN *Component Allocations $ 6 00,000 Approved Amounts $ 6 00,000 FY 07/08 *Component Allocations $ 6 00,000 FY 07/08 Approved Amounts $ 6 00,000 Siskiyou *Component Allocations $ 6 00,000 Siskiyou Approved Amounts $ 6 00,000 Solano FY 07/08 CF & TN *Component Allocations $ 3 ,165,123 Approved Amounts $ 3 ,165,123 FY 07/08 *Component Allocations $ 3 ,165,123 FY 07/08 Approved Amounts $ 3 ,165,123 Solano *Component Allocations $ 3 ,165,123 Solano Approved Amounts $ 3 ,165,123 Sonoma FY 07/08 CF & TN *Component Allocations $ 3 ,741,900 Approved Amounts $ 3 ,741,900 FY 07/08 *Component Allocations $ 3 ,741,900 FY 07/08 Approved Amounts $ 3 ,741,900 Sonoma *Component Allocations $ 3 ,741,900 Sonoma Approved Amounts $ 3 ,741,900 Stanislaus FY 07/08 CF & TN *Component Allocations $ 4 ,327,200 Approved Amounts $ 4 ,327,200 FY 07/08 *Component Allocations $ 4 ,327,200 FY 07/08 Approved Amounts $ 4 ,327,200 Stanislaus *Component Allocations $ 4 ,327,200 Stanislaus Approved Amounts $ 4 ,327,200 24 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amount Sutter-Yuba FY 07/08 CF & TN *Component Allocations $ 1 ,343,200 Approved Amounts $ 1 ,343,200 FY 07/08 *Component Allocations $ 1 ,343,200 FY 07/08 Approved Amounts $ 1 ,343,200 Sutter-Yuba *Component Allocations $ 1 ,343,200 Sutter-Yuba Approved Amounts $ 1 ,343,200 Tehama FY 07/08 CF & TN *Component Allocations $ 6 00,000 Approved Amounts $ 6 00,000 FY 07/08 *Component Allocations $ 6 00,000 FY 07/08 Approved Amounts $ 6 00,000 Tehama *Component Allocations $ 6 00,000 Tehama Approved Amounts $ 6 00,000 Tri City FY 07/08 CF & TN *Component Allocations $ 2 ,059,600 Approved Amounts $ 2 ,059,600 FY 07/08 *Component Allocations $ 2 ,059,600 FY 07/08 Approved Amounts $ 2 ,059,600 Tri City *Component Allocations $ 2 ,059,600 Tri City Approved Amounts $ 2 ,059,600 Trinity FY 07/08 CF & TN *Component Allocations $ 6 00,000 Approved Amounts $ 6 00,000 FY 07/08 *Component Allocations $ 6 00,000 FY 07/08 Approved Amounts $ 6 00,000 Trinity *Component Allocations $ 6 00,000 Trinity Approved Amounts $ 6 00,000 Tulare FY 07/08 CF & TN *Component Allocations $ 4 ,060,300 Approved Amounts $ 4 ,060,300 FY 07/08 *Component Allocations $ 4 ,060,300 FY 07/08 Approved Amounts $ 4 ,060,300 Tulare *Component Allocations $ 4 ,060,300 Tulare Approved Amounts $ 4 ,060,300 Tuolumne FY 07/08 CF & TN *Component Allocations $ 6 00,000 Approved Amounts $ 6 00,000 FY 07/08 *Component Allocations $ 6 00,000 FY 07/08 Approved Amounts $ 6 00,000 Tuolumne *Component Allocations $ 6 00,000 Tuolumne Approved Amounts $ 6 00,000 Ventura FY 07/08 CF & TN *Component Allocations $ 7 ,091,300 Approved Amounts $ 7 ,091,300 FY 07/08 *Component Allocations $ 7 ,091,300 FY 07/08 Approved Amounts $ 7 ,091,300 Ventura *Component Allocations $ 7 ,091,300 Ventura Approved Amounts $ 7 ,091,300 Yolo FY 07/08 CF & TN *Component Allocations $ 1 ,730,800 Approved Amounts $ 1 ,730,800 FY 07/08 *Component Allocations $ 1 ,730,800 FY 07/08 Approved Amounts $ 1 ,730,800 Yolo *Component Allocations $ 1 ,730,800 Yolo Approved Amounts $ 1 ,730,800 Total *Component Allocations $ 3 43,115,862 Total Approved Amounts $ 3 43,115,862 25 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation Component Allocations and Approved Amounts – CF & TN FY 2008-2009 *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amounts County FY Component Data Total Alameda FY 08/09 CF & TN *Component Allocations $ 3 ,873,200 Approved Amounts $ 3 ,873,200 FY 08/09 *Component Allocations $ 3 ,873,200 FY 08/09 Approved Amounts $ 3 ,873,200 Alameda *Component Allocations $ 3 ,873,200 Alameda Approved Amounts $ 3 ,873,200 Alpine FY 08/09 CF & TN *Component Allocations $ 1 88,500 Approved Amounts $ 1 88,500 FY 08/09 *Component Allocations $ 1 88,500 FY 08/09 Approved Amounts $ 1 88,500 Alpine *Component Allocations $ 1 88,500 Alpine Approved Amounts $ 1 88,500 Amador FY 08/09 CF & TN *Component Allocations $ 1 88,500 Approved Amounts $ 1 88,500 FY 08/09 *Component Allocations $ 1 88,500 FY 08/09 Approved Amounts $ 1 88,500 Amador *Component Allocations $ 1 88,500 Amador Approved Amounts $ 1 88,500 Berkeley City FY 08/09 CF & TN *Component Allocations $ 3 42,400 Approved Amounts $ 3 42,400 FY 08/09 *Component Allocations $ 3 42,400 FY 08/09 Approved Amounts $ 3 42,400 Berkeley City *Component Allocations $ 3 42,400 Berkeley City Approved Amounts $ 3 42,400 Butte FY 08/09 CF & TN *Component Allocations $ 5 81,200 Approved Amounts $ 5 81,200 FY 08/09 *Component Allocations $ 5 81,200 FY 08/09 Approved Amounts $ 5 81,200 Butte *Component Allocations $ 5 81,200 Butte Approved Amounts $ 5 81,200 Calaveras FY 08/09 CF & TN *Component Allocations $ 1 88,500 Approved Amounts $ 1 88,500 FY 08/09 *Component Allocations $ 1 88,500 FY 08/09 Approved Amounts $ 1 88,500 Calaveras *Component Allocations $ 1 88,500 Calaveras Approved Amounts $ 1 88,500 Colusa FY 08/09 CF & TN *Component Allocations $ 1 88,500 Approved Amounts $ 1 88,500 FY 08/09 *Component Allocations $ 1 88,500 FY 08/09 Approved Amounts $ 1 88,500 Colusa *Component Allocations $ 1 88,500 Colusa Approved Amounts $ 1 88,500 Contra Costa FY 08/09 CF & TN *Component Allocations $ 2 ,443,900 Approved Amounts $ 2 ,443,900 FY 08/09 *Component Allocations $ 2 ,443,900 FY 08/09 Approved Amounts $ 2 ,443,900 Contra Costa *Component Allocations $ 2 ,443,900 Contra Costa Approved Amounts $ 2 ,443,900 26 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amounts Del Norte FY 08/09 CF & TN *Component Allocations $ 1 88,500 Approved Amounts $ 1 88,500 FY 08/09 *Component Allocations $ 1 88,500 FY 08/09 Approved Amounts $ 1 88,500 Del Norte *Component Allocations $ 1 88,500 Del Norte Approved Amounts $ 1 88,500 El Dorado FY 08/09 CF & TN *Component Allocations $ 3 88,300 Approved Amounts $ 3 88,300 FY 08/09 *Component Allocations $ 3 88,300 FY 08/09 Approved Amounts $ 3 88,300 El Dorado *Component Allocations $ 3 88,300 El Dorado Approved Amounts $ 3 88,300 Fresno FY 08/09 CF & TN *Component Allocations $ 2 ,641,200 Approved Amounts $ 2 ,641,200 FY 08/09 *Component Allocations $ 2 ,641,200 FY 08/09 Approved Amounts $ 2 ,641,200 Fresno *Component Allocations $ 2 ,641,200 Fresno Approved Amounts $ 2 ,641,200 Glenn FY 08/09 CF & TN *Component Allocations $ 1 88,500 Approved Amounts $ 1 88,500 FY 08/09 *Component Allocations $ 1 88,500 FY 08/09 Approved Amounts $ 1 88,500 Glenn *Component Allocations $ 1 88,500 Glenn Approved Amounts $ 1 88,500 Humboldt FY 08/09 CF & TN *Component Allocations $ 3 35,600 Approved Amounts $ 3 35,600 FY 08/09 *Component Allocations $ 3 35,600 FY 08/09 Approved Amounts $ 3 35,600 Humboldt *Component Allocations $ 3 35,600 Humboldt Approved Amounts $ 3 35,600 Imperial FY 08/09 CF & TN *Component Allocations $ 4 92,900 Approved Amounts $ 4 92,900 FY 08/09 *Component Allocations $ 4 92,900 FY 08/09 Approved Amounts $ 4 92,900 Imperial *Component Allocations $ 4 92,900 Imperial Approved Amounts $ 4 92,900 Inyo FY 08/09 CF & TN *Component Allocations $ 1 88,500 Approved Amounts $ 1 88,500 FY 08/09 *Component Allocations $ 1 88,500 FY 08/09 Approved Amounts $ 1 88,500 Inyo *Component Allocations $ 1 88,500 Inyo Approved Amounts $ 1 88,500 Kern FY 08/09 CF & TN *Component Allocations $ 2 ,251,400 Approved Amounts $ 2 ,251,400 FY 08/09 *Component Allocations $ 2 ,251,400 FY 08/09 Approved Amounts $ 2 ,251,400 Kern *Component Allocations $ 2 ,251,400 Kern Approved Amounts $ 2 ,251,400 Kings FY 08/09 CF & TN *Component Allocations $ 3 94,100 Approved Amounts $ 3 94,100 FY 08/09 *Component Allocations $ 3 94,100 FY 08/09 Approved Amounts $ 3 94,100 Kings *Component Allocations $ 3 94,100 Kings Approved Amounts $ 3 94,100 27 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amounts Lake FY 08/09 CF & TN *Component Allocations $ 1 88,500 Approved Amounts $ 1 88,500 FY 08/09 *Component Allocations $ 1 88,500 FY 08/09 Approved Amounts $ 1 88,500 Lake *Component Allocations $ 1 88,500 Lake Approved Amounts $ 1 88,500 Lassen FY 08/09 CF & TN *Component Allocations $ 1 88,500 Approved Amounts $ 1 88,500 FY 08/09 *Component Allocations $ 1 88,500 FY 08/09 Approved Amounts $ 1 88,500 Lassen *Component Allocations $ 1 88,500 Lassen Approved Amounts $ 1 88,500 Los Angeles FY 08/09 CF & TN *Component Allocations $ 3 3,479,200 Approved Amounts $ 3 3,479,200 FY 08/09 *Component Allocations $ 3 3,479,200 FY 08/09 Approved Amounts $ 3 3,479,200 Los Angeles *Component Allocations $ 3 3,479,200 Los Angeles Approved Amounts $ 3 3,479,200 Madera FY 08/09 CF & TN *Component Allocations $ 4 29,600 Approved Amounts $ 4 29,600 FY 08/09 *Component Allocations $ 4 29,600 FY 08/09 Approved Amounts $ 4 29,600 Madera *Component Allocations $ 4 29,600 Madera Approved Amounts $ 4 29,600 Marin FY 08/09 CF & TN *Component Allocations $ 5 95,100 Approved Amounts $ 5 95,100 FY 08/09 *Component Allocations $ 5 95,100 FY 08/09 Approved Amounts $ 5 95,100 Marin *Component Allocations $ 5 95,100 Marin Approved Amounts $ 5 95,100 Mariposa FY 08/09 CF & TN *Component Allocations $ 1 88,500 Approved Amounts $ 1 88,500 FY 08/09 *Component Allocations $ 1 88,500 FY 08/09 Approved Amounts $ 1 88,500 Mariposa *Component Allocations $ 1 88,500 Mariposa Approved Amounts $ 1 88,500 Mendocino FY 08/09 CF & TN *Component Allocations $ 2 21,400 Approved Amounts $ 2 21,400 FY 08/09 *Component Allocations $ 2 21,400 FY 08/09 Approved Amounts $ 2 21,400 Mendocino *Component Allocations $ 2 21,400 Mendocino Approved Amounts $ 2 21,400 Merced FY 08/09 CF & TN *Component Allocations $ 7 49,600 Approved Amounts $ 7 49,600 FY 08/09 *Component Allocations $ 7 49,600 FY 08/09 Approved Amounts $ 7 49,600 Merced *Component Allocations $ 7 49,600 Merced Approved Amounts $ 7 49,600 Modoc FY 08/09 CF & TN *Component Allocations $ 1 88,500 Approved Amounts $ 1 88,500 FY 08/09 *Component Allocations $ 1 88,500 FY 08/09 Approved Amounts $ 1 88,500 Modoc *Component Allocations $ 1 88,500 Modoc Approved Amounts $ 1 88,500 28 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amounts Mono FY 08/09 CF & TN *Component Allocations $ 1 88,500 Approved Amounts $ 1 88,500 FY 08/09 *Component Allocations $ 1 88,500 FY 08/09 Approved Amounts $ 1 88,500 Mono *Component Allocations $ 1 88,500 Mono Approved Amounts $ 1 88,500 Monterey FY 08/09 CF & TN *Component Allocations $ 1 ,219,800 Approved Amounts $ 1 ,219,800 FY 08/09 *Component Allocations $ 1 ,219,800 FY 08/09 Approved Amounts $ 1 ,219,800 Monterey *Component Allocations $ 1 ,219,800 Monterey Approved Amounts $ 1 ,219,800 Napa FY 08/09 CF & TN *Component Allocations $ 3 23,900 Approved Amounts $ 3 23,900 FY 08/09 *Component Allocations $ 3 23,900 FY 08/09 Approved Amounts $ 3 23,900 Napa *Component Allocations $ 3 23,900 Napa Approved Amounts $ 3 23,900 Nevada FY 08/09 CF & TN *Component Allocations $ 2 34,100 Approved Amounts $ 2 34,100 FY 08/09 *Component Allocations $ 2 34,100 FY 08/09 Approved Amounts $ 2 34,100 Nevada *Component Allocations $ 2 34,100 Nevada Approved Amounts $ 2 34,100 Orange FY 08/09 CF & TN *Component Allocations $ 8 ,894,500 Approved Amounts $ 8 ,894,500 FY 08/09 *Component Allocations $ 8 ,894,500 FY 08/09 Approved Amounts $ 8 ,894,500 Orange *Component Allocations $ 8 ,894,500 Orange Approved Amounts $ 8 ,894,500 Placer FY 08/09 CF & TN *Component Allocations $ 7 15,300 Approved Amounts $ 7 15,300 FY 08/09 *Component Allocations $ 7 15,300 FY 08/09 Approved Amounts $ 7 15,300 Placer *Component Allocations $ 7 15,300 Placer Approved Amounts $ 7 15,300 Plumas FY 08/09 CF & TN *Component Allocations $ 1 88,500 Approved Amounts $ 1 88,500 FY 08/09 *Component Allocations $ 1 88,500 FY 08/09 Approved Amounts $ 1 88,500 Plumas *Component Allocations $ 1 88,500 Plumas Approved Amounts $ 1 88,500 Riverside FY 08/09 CF & TN *Component Allocations $ 5 ,768,100 Approved Amounts $ 5 ,768,100 FY 08/09 *Component Allocations $ 5 ,768,100 FY 08/09 Approved Amounts $ 5 ,768,100 Riverside *Component Allocations $ 5 ,768,100 Riverside Approved Amounts $ 5 ,768,100 Sacramento FY 08/09 CF & TN *Component Allocations $ 4 ,174,871 Approved Amounts $ 4 ,174,871 FY 08/09 *Component Allocations $ 4 ,174,871 FY 08/09 Approved Amounts $ 4 ,174,871 Sacramento *Component Allocations $ 4 ,174,871 Sacramento Approved Amounts $ 4 ,174,871 29 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amounts San Benito FY 08/09 CF & TN *Component Allocations $ 1 88,500 Approved Amounts $ 1 88,500 FY 08/09 *Component Allocations $ 1 88,500 FY 08/09 Approved Amounts $ 1 88,500 San Benito *Component Allocations $ 1 88,500 San Benito Approved Amounts $ 1 88,500 San Bernardino FY 08/09 CF & TN *Component Allocations $ 5 ,706,700 Approved Amounts $ 5 ,706,700 FY 08/09 *Component Allocations $ 5 ,706,700 FY 08/09 Approved Amounts $ 5 ,706,700 San Bernardino *Component Allocations $ 5 ,706,700 San Bernardino Approved Amounts $ 5 ,706,700 San Diego FY 08/09 CF & TN *Component Allocations $ 8 ,928,900 Approved Amounts $ 8 ,928,900 FY 08/09 *Component Allocations $ 8 ,928,900 FY 08/09 Approved Amounts $ 8 ,928,900 San Diego *Component Allocations $ 8 ,928,900 San Diego Approved Amounts $ 8 ,928,900 San Francisco FY 08/09 CF & TN *Component Allocations $ 1 ,983,600 Approved Amounts $ 1 ,983,600 FY 08/09 *Component Allocations $ 1 ,983,600 FY 08/09 Approved Amounts $ 1 ,983,600 San Francisco *Component Allocations $ 1 ,983,600 San Francisco Approved Amounts $ 1 ,983,600 San Joaquin FY 08/09 CF & TN *Component Allocations $ 1 ,782,600 Approved Amounts $ 1 ,782,600 FY 08/09 *Component Allocations $ 1 ,782,600 FY 08/09 Approved Amounts $ 1 ,782,600 San Joaquin *Component Allocations $ 1 ,782,600 San Joaquin Approved Amounts $ 1 ,782,600 San Luis Obispo FY 08/09 CF & TN *Component Allocations $ 1 ,126,675 Approved Amounts $ 1 ,126,675 FY 08/09 *Component Allocations $ 1 ,126,675 FY 08/09 Approved Amounts $ 1 ,126,675 San Luis Obispo *Component Allocations $ 1 ,126,675 San Luis Obispo Approved Amounts $ 1 ,126,675 San Mateo FY 08/09 CF & TN *Component Allocations $ 1 ,740,400 Approved Amounts $ 1 ,740,400 FY 08/09 *Component Allocations $ 1 ,740,400 FY 08/09 Approved Amounts $ 1 ,740,400 San Mateo *Component Allocations $ 1 ,740,400 San Mateo Approved Amounts $ 1 ,740,400 Santa Barbara FY 08/09 CF & TN *Component Allocations $ 1 ,203,400 Approved Amounts $ 1 ,203,400 FY 08/09 *Component Allocations $ 1 ,203,400 FY 08/09 Approved Amounts $ 1 ,203,400 Santa Barbara *Component Allocations $ 1 ,203,400 Santa Barbara Approved Amounts $ 1 ,203,400 30 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amounts Santa Clara FY 08/09 CF & TN *Component Allocations $ 5 ,091,700 Approved Amounts $ 5 ,091,700 FY 08/09 *Component Allocations $ 5 ,091,700 FY 08/09 Approved Amounts $ 5 ,091,700 Santa Clara *Component Allocations $ 5 ,091,700 Santa Clara Approved Amounts $ 5 ,091,700 Santa Cruz FY 08/09 CF & TN *Component Allocations $ 7 52,200 Approved Amounts $ 7 52,200 FY 08/09 *Component Allocations $ 7 52,200 FY 08/09 Approved Amounts $ 7 52,200 Santa Cruz *Component Allocations $ 7 52,200 Santa Cruz Approved Amounts $ 7 52,200 Shasta FY 08/09 CF & TN *Component Allocations $ 4 71,600 Approved Amounts $ 4 71,600 FY 08/09 *Component Allocations $ 4 71,600 FY 08/09 Approved Amounts $ 4 71,600 Shasta *Component Allocations $ 4 71,600 Shasta Approved Amounts $ 4 71,600 Sierra FY 08/09 CF & TN *Component Allocations $ 1 88,500 Approved Amounts $ 1 88,500 FY 08/09 *Component Allocations $ 1 88,500 FY 08/09 Approved Amounts $ 1 88,500 Sierra *Component Allocations $ 1 88,500 Sierra Approved Amounts $ 1 88,500 Siskiyou FY 08/09 CF & TN *Component Allocations $ 1 88,500 Approved Amounts $ 1 88,500 FY 08/09 *Component Allocations $ 1 88,500 FY 08/09 Approved Amounts $ 1 88,500 Siskiyou *Component Allocations $ 1 88,500 Siskiyou Approved Amounts $ 1 88,500 Solano FY 08/09 CF & TN *Component Allocations $ 1 ,073,800 Approved Amounts $ 1 ,073,800 FY 08/09 *Component Allocations $ 1 ,073,800 FY 08/09 Approved Amounts $ 1 ,073,800 Solano *Component Allocations $ 1 ,073,800 Solano Approved Amounts $ 1 ,073,800 Sonoma FY 08/09 CF & TN *Component Allocations $ 1 ,175,700 Approved Amounts $ 1 ,175,700 FY 08/09 *Component Allocations $ 1 ,175,700 FY 08/09 Approved Amounts $ 1 ,175,700 Sonoma *Component Allocations $ 1 ,175,700 Sonoma Approved Amounts $ 1 ,175,700 Stanislaus FY 08/09 CF & TN *Component Allocations $ 1 ,359,600 Approved Amounts $ 1 ,359,600 FY 08/09 *Component Allocations $ 1 ,359,600 FY 08/09 Approved Amounts $ 1 ,359,600 Stanislaus *Component Allocations $ 1 ,359,600 Stanislaus Approved Amounts $ 1 ,359,600 Sutter-Yuba FY 08/09 CF & TN *Component Allocations $ 4 22,100 Approved Amounts $ 4 22,100 FY 08/09 *Component Allocations $ 4 22,100 FY 08/09 Approved Amounts $ 4 22,100 Sutter-Yuba *Component Allocations $ 4 22,100 Sutter-Yuba Approved Amounts $ 4 22,100 31 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amounts Tehama FY 08/09 CF & TN *Component Allocations $ 1 88,500 Approved Amounts $ 1 88,500 FY 08/09 *Component Allocations $ 1 88,500 FY 08/09 Approved Amounts $ 1 88,500 Tehama *Component Allocations $ 1 88,500 Tehama Approved Amounts $ 1 88,500 Tri City FY 08/09 CF & TN *Component Allocations $ 6 47,100 Approved Amounts $ 6 47,100 FY 08/09 *Component Allocations $ 6 47,100 FY 08/09 Approved Amounts $ 6 47,100 Tri City *Component Allocations $ 6 47,100 Tri City Approved Amounts $ 6 47,100 Trinity FY 08/09 CF & TN *Component Allocations $ 1 88,500 Approved Amounts $ 1 88,500 FY 08/09 *Component Allocations $ 1 88,500 FY 08/09 Approved Amounts $ 1 88,500 Trinity *Component Allocations $ 1 88,500 Trinity Approved Amounts $ 1 88,500 Tulare FY 08/09 CF & TN *Component Allocations $ 1 ,775,700 Approved Amounts $ 1 ,775,700 FY 08/09 *Component Allocations $ 1 ,775,700 FY 08/09 Approved Amounts $ 1 ,775,700 Tulare *Component Allocations $ 1 ,775,700 Tulare Approved Amounts $ 1 ,775,700 Tuolumne FY 08/09 CF & TN *Component Allocations $ 1 88,500 Approved Amounts $ 1 88,500 FY 08/09 *Component Allocations $ 1 88,500 FY 08/09 Approved Amounts $ 1 88,500 Tuolumne *Component Allocations $ 1 88,500 Tuolumne Approved Amounts $ 1 88,500 Ventura FY 08/09 CF & TN *Component Allocations $ 4 ,174,700 Approved Amounts $ 4 ,174,700 FY 08/09 *Component Allocations $ 4 ,174,700 FY 08/09 Approved Amounts $ 4 ,174,700 Ventura *Component Allocations $ 4 ,174,700 Ventura Approved Amounts $ 4 ,174,700 Yolo FY 08/09 CF & TN *Component Allocations $ 5 43,800 Approved Amounts $ 5 43,800 FY 08/09 *Component Allocations $ 5 43,800 FY 08/09 Approved Amounts $ 5 43,800 Yolo *Component Allocations $ 5 43,800 Yolo Approved Amounts $ 5 43,800 Total *Component Allocations $ 1 14,091,446 Total Approved Amounts $ 1 14,091,446 32 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation Component Allocations and Approved Amounts – INN FY 2008-2009 *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amounts County FY Component Data Total Alameda FY 08/09 INN *Component Allocations $ 2,543,800 Approved Amounts $ 2,543,800 FY 08/09 *Component Allocations $ 2,543,800 FY 08/09 Approved Amounts $ 2,543,800 Alameda *Component Allocations $ 2,543,800 Alameda Approved Amounts $ 2,543,800 Alpine FY 08/09 INN *Component Allocations $ 62,000 Approved Amounts $ 62,000 FY 08/09 *Component Allocations $ 62,000 FY 08/09 Approved Amounts $ 62,000 Alpine *Component Allocations $ 62,000 Alpine Approved Amounts $ 62,000 Amador FY 08/09 INN *Component Allocations $ 115,200 Approved Amounts $ 115,200 FY 08/09 *Component Allocations $ 115,200 FY 08/09 Approved Amounts $ 115,200 Amador *Component Allocations $ 115,200 Amador Approved Amounts $ 115,200 Berkeley City FY 08/09 INN *Component Allocations $ 214,800 Approved Amounts $ 214,800 FY 08/09 *Component Allocations $ 214,800 FY 08/09 Approved Amounts $ 214,800 Berkeley City *Component Allocations $ 214,800 Berkeley City Approved Amounts $ 214,800 Butte FY 08/09 INN *Component Allocations $ 418,100 Approved Amounts $ 418,100 FY 08/09 *Component Allocations $ 418,100 FY 08/09 Approved Amounts $ 418,100 Butte *Component Allocations $ 418,100 Butte Approved Amounts $ 418,100 Calaveras FY 08/09 INN *Component Allocations $ 126,400 Approved Amounts $ 126,400 FY 08/09 *Component Allocations $ 126,400 FY 08/09 Approved Amounts $ 126,400 Calaveras *Component Allocations $ 126,400 Calaveras Approved Amounts $ 126,400 Colusa FY 08/09 INN *Component Allocations $ 101,500 Approved Amounts $ 101,500 FY 08/09 *Component Allocations $ 101,500 FY 08/09 Approved Amounts $ 101,500 Colusa *Component Allocations $ 101,500 Colusa Approved Amounts $ 101,500 Contra Costa FY 08/09 INN *Component Allocations $ 1,616,400 Approved Amounts $ 1,616,400 FY 08/09 *Component Allocations $ 1,616,400 FY 08/09 Approved Amounts $ 1,616,400 Contra Costa *Component Allocations $ 1,616,400 Contra Costa Approved Amounts $ 1,616,400 33 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amounts Del Norte FY 08/09 INN *Component Allocations $ 108,100 Approved Amounts $ 108,100 FY 08/09 *Component Allocations $ 108,100 FY 08/09 Approved Amounts $ 108,100 Del Norte *Component Allocations $ 108,100 Del Norte Approved Amounts $ 108,100 El Dorado FY 08/09 INN *Component Allocations $ 292,000 Approved Amounts $ 292,000 FY 08/09 *Component Allocations $ 292,000 FY 08/09 Approved Amounts $ 292,000 El Dorado *Component Allocations $ 292,000 El Dorado Approved Amounts $ 292,000 Fresno FY 08/09 INN *Component Allocations $ 1,739,800 Approved Amounts $ 1,739,800 FY 08/09 *Component Allocations $ 1,739,800 FY 08/09 Approved Amounts $ 1,739,800 Fresno *Component Allocations $ 1,739,800 Fresno Approved Amounts $ 1,739,800 Glenn FY 08/09 INN *Component Allocations $ 108,700 Approved Amounts $ 108,700 FY 08/09 *Component Allocations $ 108,700 FY 08/09 Approved Amounts $ 108,700 Glenn *Component Allocations $ 108,700 Glenn Approved Amounts $ 108,700 Humboldt FY 08/09 INN *Component Allocations $ 258,700 Approved Amounts $ 258,700 FY 08/09 *Component Allocations $ 258,700 FY 08/09 Approved Amounts $ 258,700 Humboldt *Component Allocations $ 258,700 Humboldt Approved Amounts $ 258,700 Imperial FY 08/09 INN *Component Allocations $ 353,200 Approved Amounts $ 353,200 FY 08/09 *Component Allocations $ 353,200 FY 08/09 Approved Amounts $ 353,200 Imperial *Component Allocations $ 353,200 Imperial Approved Amounts $ 353,200 Inyo FY 08/09 INN *Component Allocations $ 72,800 Approved Amounts $ 72,800 FY 08/09 *Component Allocations $ 72,800 FY 08/09 Approved Amounts $ 72,800 Inyo *Component Allocations $ 72,800 Inyo Approved Amounts $ 72,800 Kern FY 08/09 INN *Component Allocations $ 1,503,100 Approved Amounts $ 1,503,100 FY 08/09 *Component Allocations $ 1,503,100 FY 08/09 Approved Amounts $ 1,503,100 Kern *Component Allocations $ 1,503,100 Kern Approved Amounts $ 1,503,100 Kings FY 08/09 INN *Component Allocations $ 298,300 Approved Amounts $ 298,300 FY 08/09 *Component Allocations $ 298,300 FY 08/09 Approved Amounts $ 298,300 Kings *Component Allocations $ 298,300 Kings Approved Amounts $ 298,300 34 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amounts Lake FY 08/09 INN *Component Allocations $ 150,000 Approved Amounts $ 150,000 FY 08/09 *Component Allocations $ 150,000 FY 08/09 Approved Amounts $ 150,000 Lake *Component Allocations $ 150,000 Lake Approved Amounts $ 150,000 Lassen FY 08/09 INN *Component Allocations $ 108,200 Approved Amounts $ 108,200 FY 08/09 *Component Allocations $ 108,200 FY 08/09 Approved Amounts $ 108,200 Lassen *Component Allocations $ 108,200 Lassen Approved Amounts $ 108,200 Los Angeles FY 08/09 INN *Component Allocations $ 20,294,900 Approved Amounts $ 20,294,900 FY 08/09 *Component Allocations $ 20,294,900 FY 08/09 Approved Amounts $ 20,294,900 Los Angeles *Component Allocations $ 20,294,900 Los Angeles Approved Amounts $ 20,294,900 Madera FY 08/09 INN *Component Allocations $ 311,100 Approved Amounts $ 311,100 FY 08/09 *Component Allocations $ 311,100 FY 08/09 Approved Amounts $ 311,100 Madera *Component Allocations $ 311,100 Madera Approved Amounts $ 311,100 Marin FY 08/09 INN *Component Allocations $ 402,000 Approved Amounts $ 402,000 FY 08/09 *Component Allocations $ 402,000 FY 08/09 Approved Amounts $ 402,000 Marin *Component Allocations $ 402,000 Marin Approved Amounts $ 402,000 Mariposa FY 08/09 INN *Component Allocations $ 73,400 Approved Amounts $ 73,400 FY 08/09 *Component Allocations $ 73,400 FY 08/09 Approved Amounts $ 73,400 Mariposa *Component Allocations $ 73,400 Mariposa Approved Amounts $ 73,400 Mendocino FY 08/09 INN *Component Allocations $ 181,400 Approved Amounts $ 181,400 FY 08/09 *Component Allocations $ 181,400 FY 08/09 Approved Amounts $ 181,400 Mendocino *Component Allocations $ 181,400 Mendocino Approved Amounts $ 181,400 Merced FY 08/09 INN *Component Allocations $ 522,700 Approved Amounts $ 522,700 FY 08/09 *Component Allocations $ 522,700 FY 08/09 Approved Amounts $ 522,700 Merced *Component Allocations $ 522,700 Merced Approved Amounts $ 522,700 Modoc FY 08/09 INN *Component Allocations $ 68,000 Approved Amounts $ 68,000 FY 08/09 *Component Allocations $ 68,000 FY 08/09 Approved Amounts $ 68,000 Modoc *Component Allocations $ 68,000 Modoc Approved Amounts $ 68,000 35 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amounts Mono FY 08/09 INN *Component Allocations $ 71,200 Approved Amounts $ 71,200 FY 08/09 *Component Allocations $ 71,200 FY 08/09 Approved Amounts $ 71,200 Mono *Component Allocations $ 71,200 Mono Approved Amounts $ 71,200 Monterey FY 08/09 INN *Component Allocations $ 837,400 Approved Amounts $ 837,400 FY 08/09 *Component Allocations $ 837,400 FY 08/09 Approved Amounts $ 837,400 Monterey *Component Allocations $ 837,400 Monterey Approved Amounts $ 837,400 Napa FY 08/09 INN *Component Allocations $ 240,500 Approved Amounts $ 240,500 FY 08/09 *Component Allocations $ 240,500 FY 08/09 Approved Amounts $ 240,500 Napa *Component Allocations $ 240,500 Napa Approved Amounts $ 240,500 Nevada FY 08/09 INN *Component Allocations $ 199,100 Approved Amounts $ 199,100 FY 08/09 *Component Allocations $ 199,100 FY 08/09 Approved Amounts $ 199,100 Nevada *Component Allocations $ 199,100 Nevada Approved Amounts $ 199,100 Orange FY 08/09 INN *Component Allocations $ 5,787,600 Approved Amounts $ 5,787,600 FY 08/09 *Component Allocations $ 5,787,600 FY 08/09 Approved Amounts $ 5,787,600 Orange *Component Allocations $ 5,787,600 Orange Approved Amounts $ 5,787,600 Placer FY 08/09 INN *Component Allocations $ 483,800 Approved Amounts $ 483,800 FY 08/09 *Component Allocations $ 483,800 FY 08/09 Approved Amounts $ 483,800 Placer *Component Allocations $ 483,800 Placer Approved Amounts $ 483,800 Plumas FY 08/09 INN *Component Allocations $ 98,000 Approved Amounts $ 98,000 FY 08/09 *Component Allocations $ 98,000 FY 08/09 Approved Amounts $ 98,000 Plumas *Component Allocations $ 98,000 Plumas Approved Amounts $ 98,000 Riverside FY 08/09 INN *Component Allocations $ 3,673,500 Approved Amounts $ 3,673,500 FY 08/09 *Component Allocations $ 3,673,500 FY 08/09 Approved Amounts $ 3,673,500 Riverside *Component Allocations $ 3,673,500 Riverside Approved Amounts $ 3,673,500 Sacramento FY 08/09 INN *Component Allocations $ 2,267,300 Approved Amounts $ 2,267,300 FY 08/09 *Component Allocations $ 2,267,300 FY 08/09 Approved Amounts $ 2,267,300 Sacramento *Component Allocations $ 2,267,300 Sacramento Approved Amounts $ 2,267,300 36 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amounts San Benito FY 08/09 INN *Component Allocations $ 145,000 Approved Amounts $ 145,000 FY 08/09 *Component Allocations $ 145,000 FY 08/09 Approved Amounts $ 145,000 San Benito *Component Allocations $ 145,000 San Benito Approved Amounts $ 145,000 San Bernardino FY 08/09 INN *Component Allocations $ 3,737,900 Approved Amounts $ 3,737,900 FY 08/09 *Component Allocations $ 3,737,900 FY 08/09 Approved Amounts $ 3,737,900 San Bernardino *Component Allocations $ 3,737,900 San Bernardino Approved Amounts $ 3,737,900 San Diego FY 08/09 INN *Component Allocations $ 5,816,200 Approved Amounts $ 5,816,200 FY 08/09 *Component Allocations $ 5,816,200 FY 08/09 Approved Amounts $ 5,816,200 San Diego *Component Allocations $ 5,816,200 San Diego Approved Amounts $ 5,816,200 San Francisco FY 08/09 INN *Component Allocations $ 1,313,800 Approved Amounts $ 1,313,800 FY 08/09 *Component Allocations $ 1,313,800 FY 08/09 Approved Amounts $ 1,313,800 San Francisco *Component Allocations $ 1,313,800 San Francisco Approved Amounts $ 1,313,800 San Joaquin FY 08/09 INN *Component Allocations $ 1,197,800 Approved Amounts $ 1,197,800 FY 08/09 *Component Allocations $ 1,197,800 FY 08/09 Approved Amounts $ 1,197,800 San Joaquin *Component Allocations $ 1,197,800 San Joaquin Approved Amounts $ 1,197,800 San Luis Obispo FY 08/09 INN *Component Allocations $ 487,300 Approved Amounts $ 487,300 FY 08/09 *Component Allocations $ 487,300 FY 08/09 Approved Amounts $ 487,300 San Luis Obispo *Component Allocations $ 487,300 San Luis Obispo Approved Amounts $ 487,300 San Mateo FY 08/09 INN *Component Allocations $ 1,163,000 Approved Amounts $ 1,163,000 FY 08/09 *Component Allocations $ 1,163,000 FY 08/09 Approved Amounts $ 1,163,000 San Mateo *Component Allocations $ 1,163,000 San Mateo Approved Amounts $ 1,163,000 Santa Barbara FY 08/09 INN *Component Allocations $ 829,800 Approved Amounts $ 829,800 FY 08/09 *Component Allocations $ 829,800 FY 08/09 Approved Amounts $ 829,800 Santa Barbara *Component Allocations $ 829,800 Santa Barbara Approved Amounts $ 829,800 37 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amounts Santa Clara FY 08/09 INN *Component Allocations $ 3,263,200 Approved Amounts $ 3,263,200 FY 08/09 *Component Allocations $ 3,263,200 FY 08/09 Approved Amounts $ 3,263,200 Santa Clara *Component Allocations $ 3,263,200 Santa Clara Approved Amounts $ 3,263,200 Santa Cruz FY 08/09 INN *Component Allocations $ 527,600 Approved Amounts $ 527,600 FY 08/09 *Component Allocations $ 527,600 FY 08/09 Approved Amounts $ 527,600 Santa Cruz *Component Allocations $ 527,600 Santa Cruz Approved Amounts $ 527,600 Shasta FY 08/09 INN *Component Allocations $ 346,800 Approved Amounts $ 346,800 FY 08/09 *Component Allocations $ 346,800 FY 08/09 Approved Amounts $ 346,800 Shasta *Component Allocations $ 346,800 Shasta Approved Amounts $ 346,800 Sierra FY 08/09 INN *Component Allocations $ 63,500 Approved Amounts $ 63,500 FY 08/09 *Component Allocations $ 63,500 FY 08/09 Approved Amounts $ 63,500 Sierra *Component Allocations $ 63,500 Sierra Approved Amounts $ 63,500 Siskiyou FY 08/09 INN *Component Allocations $ 122,800 Approved Amounts $ 122,800 FY 08/09 *Component Allocations $ 122,800 FY 08/09 Approved Amounts $ 122,800 Siskiyou *Component Allocations $ 122,800 Siskiyou Approved Amounts $ 122,800 Solano FY 08/09 INN *Component Allocations $ 718,900 Approved Amounts $ 718,900 FY 08/09 *Component Allocations $ 718,900 FY 08/09 Approved Amounts $ 718,900 Solano *Component Allocations $ 718,900 Solano Approved Amounts $ 718,900 Sonoma FY 08/09 INN *Component Allocations $ 813,300 Approved Amounts $ 813,300 FY 08/09 *Component Allocations $ 813,300 FY 08/09 Approved Amounts $ 813,300 Sonoma *Component Allocations $ 813,300 Sonoma Approved Amounts $ 813,300 Stanislaus FY 08/09 INN *Component Allocations $ 914,400 Approved Amounts $ 914,400 FY 08/09 *Component Allocations $ 914,400 FY 08/09 Approved Amounts $ 914,400 Stanislaus *Component Allocations $ 914,400 Stanislaus Approved Amounts $ 914,400 Sutter-Yuba FY 08/09 INN *Component Allocations $ 344,500 Approved Amounts $ 344,500 FY 08/09 *Component Allocations $ 344,500 FY 08/09 Approved Amounts $ 344,500 Sutter-Yuba *Component Allocations $ 344,500 Sutter-Yuba Approved Amounts $ 344,500 38 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation *Component Allocations shown are Published Component Allocations less discretionary transfers and reversion amounts Tehama FY 08/09 INN *Component Allocations $ 144,500 Approved Amounts $ 144,500 FY 08/09 *Component Allocations $ 144,500 FY 08/09 Approved Amounts $ 144,500 Tehama *Component Allocations $ 144,500 Tehama Approved Amounts $ 144,500 Tri City FY 08/09 INN *Component Allocations $ 402,600 Approved Amounts $ 402,600 FY 08/09 *Component Allocations $ 402,600 FY 08/09 Approved Amounts $ 402,600 Tri City *Component Allocations $ 402,600 Tri City Approved Amounts $ 402,600 Trinity FY 08/09 INN *Component Allocations $ 70,900 Approved Amounts $ 70,900 FY 08/09 *Component Allocations $ 70,900 FY 08/09 Approved Amounts $ 70,900 Trinity *Component Allocations $ 70,900 Trinity Approved Amounts $ 70,900 Tulare FY 08/09 INN *Component Allocations $ 865,300 Approved Amounts $ 865,300 FY 08/09 *Component Allocations $ 865,300 FY 08/09 Approved Amounts $ 865,300 Tulare *Component Allocations $ 865,300 Tulare Approved Amounts $ 865,300 Tuolumne FY 08/09 INN *Component Allocations $ 138,200 Approved Amounts $ 138,200 FY 08/09 *Component Allocations $ 138,200 FY 08/09 Approved Amounts $ 138,200 Tuolumne *Component Allocations $ 138,200 Tuolumne Approved Amounts $ 138,200 Ventura FY 08/09 INN *Component Allocations $ 1,483,000 Approved Amounts $ 1,483,000 FY 08/09 *Component Allocations $ 1,483,000 FY 08/09 Approved Amounts $ 1,483,000 Ventura *Component Allocations $ 1,483,000 Ventura Approved Amounts $ 1,483,000 Yolo FY 08/09 INN *Component Allocations $ 386,700 Approved Amounts $ 386,700 FY 08/09 *Component Allocations $ 386,700 FY 08/09 Approved Amounts $ 386,700 Yolo *Component Allocations $ 386,700 Yolo Approved Amounts $ 386,700 Total *Component Allocations $ 71,000,000 Total Approved Amounts $ 71,000,000 39 California’s Investment in the Public Mental Health System: Proposition 63 Brief 7: Capital Facilities/Technological Needs and Innovation End Notes i http://www.dmh.ca.gov/DMHDocs/docs/notices08/08-09_Enclosure_2.pdf http://www.dmh.ca.gov/DMHDocs/docs/notices08/08-09_Enclosure_1.pdf ii http://www.dmh.ca.gov/DMHDocs/docs/notices08/08-09_Enclosure_3.pdf iii http://www.dmh.ca.gov/DMHDocs/docs/notices09/09-02_Enclosure_1.pdf iv The number of counties in Fiscal Year 2008 – 2009 is 59 (there are 58 counties in California) because two counties receive joint funding, and two cities receive funding under the Mental Health Services Act. v http://www.dmh.ca.gov/DMHDocs/docs/notices08/08-02.pdf http://www.dmh.ca.gov/DMHDocs/docs/notices08/08-02_Enclosure2.pdf vi http://www.dmh.ca.gov/DMHDocs/docs/notices08/08-09_Enclosure_1.pdf http://www.dmh.ca.gov/DMHDocs/docs/notices08/08-09_Enclosure_2.pdf http://www.dmh.ca.gov/DMHDocs/docs/notices08/08-09_Enclosure_3.pdf vii http://www.dmh.ca.gov/dmhdocs/docs/notices08/08-21_Enclosure1.pdf viii http://www.dmh.ca.gov/dmhdocs/docs/notices08/08-36_Enclosure4.pdf ix http://www.dmh.ca.gov/DMHDocs/docs/notices09/09-02_Enclosure_1.pdf x p. 3, http://www.dmh.ca.gov/DMHDocs/docs/notices08/08-28.pdf xi http://www.leginfo.ca.gov/cgi-bin/displaycode?section=wic&group=05001-06000&file=5890-5898 xii http://www.dmh.ca.gov/DMHDocs/docs/notices08/08-16.pdf xiii http://www.dmh.ca.gov/DMHDocs/docs/notices09/09-02_Enclosure_1.pdf xiv “Up to 100 percent of available funding may be requested in the initial work plan submission for the INN component. Any remaining funds may be requested in subsequent updates expanding the initial INN work plan or beginning an entirely new work plan.” pp. 9-10 http://www.dmh.ca.gov/DMHDocs/docs/notices09/09-02_Enclosure_1.pdf xv http://www.dmh.ca.gov/Prop_63/MHSA/MHSA_Fiscal_References.asp. To access the Excel file, click on “Component Allocations and Approved Amounts” under “County Level Information” under “Other Fiscal Information and Reports.” xvi Expended, Unexpended and the Total presented in Tables 4 through 6 are rounded to nearest dollar since it is unclear what the cents values are for the Component Allocation amounts. xvii http://www.dmh.ca.gov/DMHDocs/docs/notices08/08-16.pdf xviii http://www.dmh.ca.gov/dmhdocs/docs/letters05/05-02.pdf xix Figures cannot be created for Innovation due to: 1. Small number of counties (6), and 2. Expenditures are only for Planning, hence there are no breakout proportions of a dollar to show. xx http://en.wikipedia.org/wiki/Per_capita xxi Capital Technological # of Projects Facilities Needs 0 53 (89.8%) 51 (86.4%) 1 5 (8.5%) 8 (13.6%) 2 1 (1.7%) -- Total N of 59 59 Counties 40