Skip Navigation

Exhibit 300 (BY2009) - Centers for Medicare and Medicaid Services CMS, Medicaid Data Systems

PART ONE


OVERVIEW


1. Date of Submission:
2008-02-04
2. Agency:
009
3. Bureau:
38
4. Name of this Capital Asset:
CMS Medicaid Data Systems
5. Unique Project Identifier:
009-38-01-02-01-1060-00
6. What kind of investment will this be in FY2009?
Operations and Maintenance
7. What was the first budget year this investment was submitted to OMB?
FY2001 or earlier
8. Provide a brief summary and justification for this investment, including a brief description of how this closes in part or in whole an identified agency performance gap.
The primary purpose of this investment is to establish an accurate, current, and comprehensive database containing standardized enrollment, eligibility, and paid claims of Medicare beneficiaries to be used for the administration of Medicaid at the Federal level, produce statistical reports, support Medicaid related research, and assist in the detection of fraud and abuse in the Medicare and Medicaid programs. Medicaid Data Systems includes the Medicaid Statistical Information System (MSIS), as well as data storage (flat files, data warehouse, and data marts). This investment satisfies the core business function for the information needs of Center for Medicaid and State Operations (CMSO). It is critical for CMS to develop the State Phased-down contribution by States for full dual eligibles entitled to Part D benefits to support CMS' strategic goal of promoting fiscal integrity. Besides being the core information system for CMSO, MSIS supports much of the Medicaid research and analysis performed by the Congressional Budget Office and the Congressional Research Service. MSIS and the accompanying data storage is also a key resource for other Federal agencies and research projects involving Medicaid. The first business driver is the Balanced Budget Act (BBA) of 1997. The BBA requires all States to submit MSIS files containing eligibility and claims utilization information to meet the program needs of CMS and to provide required information for congressional staffs and other Federal agencies and researchers. The second business driver is the Medicare Modernization Act (MMA) of 2003. MMA created a new drug benefit as Part D of Medicare. One of the provisions of MMA was to use MSIS data to develop a per capita payment amount for full dual eligible beneficiaries that each State will pay to CMS on a monthly basis under the State phased-down contribution provision of the MMA. If this investment was not funded, legislative mandates would not be able to be met. This investment also directly supports the PMA initiative of Expanded E-government through electronic data transmission and data sharing. Additionally, it helps achieve the HHS Strategic goal of 'Improve health care quality, safety, cost, and value'. The annual operational analysis indicates this investment continues to provide the expected benefits and fill the gap for which it was designed. It continues to be the most cost-effective solution.
9. Did the Agency's Executive/Investment Committee approve this request?
yes
9.a. If "yes," what was the date of this approval?
2007-06-26
10. Did the Project Manager review this Exhibit?
yes
11.a. What is the current FAC-P/PM certification level of the project/program manager?
TBD
12. Has the agency developed and/or promoted cost effective, energy-efficient and environmentally sustainable techniques or practices for this project.
no
12.a. Will this investment include electronic assets (including computers)?
yes
12.b. Is this investment for new construction or major retrofit of a Federal building or facility? (answer applicable to non-IT assets only)
no
13. Does this investment directly support one of the PMA initiatives?
yes
If yes, select the initiatives that apply:
Initiative Name
Budget Performance Integration
Expanded E-Government
13.a. Briefly and specifically describe for each selected how this asset directly supports the identified initiative(s)? (e.g. If E-Gov is selected, is it an approved shared service provider or the managing partner?)
Medicaid Data Systems supports the PMA initiative Expanded E-government by providing a comprehensive electronic store of information to Federal and State administrators and medical researchers about standardized Medicaid beneficiary enrollment, eligibility, and paid claims. The collaboration with the States relies on electronic data transmission and data sharing. Budget Performance Integration is supported because the data collected is used to estimate the financial effects of reform proposals
14. Does this investment support a program assessed using the Program Assessment Rating Tool (PART)?
yes
14.a. If yes, does this investment address a weakness found during the PART review?
yes
14.b. If yes, what is the name of the PARTed program?
2006: CMS - Medicaid
14.c. If yes, what rating did the PART receive?
Adequate
15. Is this investment for information technology?
yes
16. What is the level of the IT Project (per CIO Council's PM Guidance)?
Level 3
17. What project management qualifications does the Project Manager have? (per CIO Council's PM Guidance)
(1) Project manager has been validated as qualified for this investment
18. Is this investment identified as high risk on the Q4 - FY 2007 agency high risk report (per OMB memorandum M-05-23)?
no
19. Is this a financial management system?
no
20. What is the percentage breakout for the total FY2009 funding request for the following? (This should total 100%)
AreaPercentage
Hardware0
Software0
Services72
Other28
21. If this project produces information dissemination products for the public, are these products published to the Internet in conformance with OMB Memorandum 05-04 and included in your agency inventory, schedules and priorities?
n/a
22. Contact information of individual responsible for privacy related questions.
NameMaribel Franey
Phone Number410-786-0757
TitleDirector, Privacy Compliance
Emailmaribel.franey@cms.hhs.gov
23. Are the records produced by this investment appropriately scheduled with the National Archives and Records Administration's approval?
yes
24. Does this investment directly support one of the GAO High Risk Areas?
yes

SUMMARY OF SPEND


1. Provide the total estimated life-cycle cost for this investment by completing the following table. All amounts represent budget authority in millions, and are rounded to three decimal places. Federal personnel costs should be included only in the row designated Government FTE Cost, and should be excluded from the amounts shown for Planning, Full Acquisition, and Operation/Maintenance. The total estimated annual cost of the investment is the sum of costs for Planning, Full Acquisition, and Operation/Maintenance. For Federal buildings and facilities, life-cycle costs should include long term energy, environmental, decommissioning, and/or restoration costs. The costs associated with the entire life-cycle of the investment should be included in this report.

All amounts represent Budget Authority

Note: For the cross-agency investments, this table should include all funding (both managing partner and partner agencies).

Government FTE Costs should not be included as part of the TOTAL represented.
Cost TypePy-1 & Earlier
-2006
PY
2007
CY
2008
BY
2009
Planning Budgetary Resources0.0000.0000.0000.000
Acquisition Budgetary Resources0.0000.0000.0000.000
Maintenance Budgetary Resources3.3005.9816.6197.446
Government FTE Cost1.5300.0950.1000.106
# of FTEs5111
2. Will this project require the agency to hire additional FTE's?
no
3. If the summary of spending has changed from the FY2008 President's budget request, briefly explain those changes.
Not applicable

PERFORMANCE


In order to successfully address this area of the exhibit 300, performance goals must be provided for the agency and be linked to the annual performance plan. The investment must discuss the agency's mission and strategic goals, and performance measures (indicators) must be provided. These goals need to map to the gap in the agency's strategic goals and objectives this investment is designed to fill. They are the internal and external performance benefits this investment is expected to deliver to the agency (e.g., improve efficiency by 60 percent, increase citizen participation by 300 percent a year to achieve an overall citizen participation rate of 75 percent by FY 2xxx, etc.). The goals must be clearly measurable investment outcomes, and if applicable, investment outputs. They do not include the completion date of the module, milestones, or investment, or general goals, such as, significant, better, improved that do not have a quantitative measure.
Agencies must use the following table to report performance goals and measures for the major investment and use the Federal Enterprise Architecture (FEA) Performance Reference Model (PRM). Map all Measurement Indicators to the corresponding Measurement Area and Measurement Grouping identified in the PRM. There should be at least one Measurement Indicator for each of the four different Measurement Areas (for each fiscal year). The PRM is available at www.egov.gov. The table can be extended to include performance measures for years beyond FY 2009.
RowFiscal YearStrategic Goal SupportedMeasurement AreaMeasurement GroupingMeasurement IndicatorBaselinePlanned Improvement to the BaselineActual Results
12005S.O. 1.3 - Improve health care quality, safety, cost and valueCustomer ResultsAccuracy of Service or Product DeliveredAccuracy rate85%90%89%
22005S.O. 1.3 - Improve health care quality, safety, cost and valueTechnologyData Reliability and QualityPercentage of files with complete data90%95%96%
32005S.O. 1.3 - Improve health care quality, safety, cost and valueProcesses and ActivitiesInnovation and ImprovementPercentage of files included in EL file0%100%100%
42005S.O. 1.3 - Improve health care quality, safety, cost and valueMission and Business ResultsIT Infrastructure MaintenanceInfrastructure availability95%97%98%
52006S.O. 1.3 - Improve health care quality, safety, cost and valueCustomer ResultsAccuracy of Service or Product DeliveredAccuracy Rate89%90%90%
62006Effective Management of Human Capital/Information Technology/ResourcesTechnologyExternal Data SharingPercent of files transferred by direct data transfer0%25%25%
72006S.O. 1.1 - Broaden health insurance and long-term care coverageProcesses and ActivitiesInnovation and ImprovementPercentage of files containing part D data0%100%100%
82006S.O. 1.3 - Improve health care quality, safety, cost and valueMission and Business ResultsIT Infrastructure MaintenanceInfrastructure availability98%99%98%
92007S.O. 1.3 - Improve health care quality, safety, cost and valueCustomer ResultsAvailabilityPercent of Time System is available for use during normal business hours98%99%TBD
102007S.O. 1.3 - Improve health care quality, safety, cost and valueTechnologyExternal Data SharingPercent of files transferred by direct data transfer25%50%TBD
112007S.O. 1.3 - Improve health care quality, safety, cost and valueMission and Business ResultsHealth Care AdministrationPercent of claims containing NPI0%50%TBD
122007S.O. 1.3 - Improve health care quality, safety, cost and valueProcesses and ActivitiesTimelinessTime needed to edit and load state submissions120 days100 daysTBD
132008S.O. 1.3 - Improve health care quality, safety, cost and valueCustomer ResultsAvailabilityPercent of Time System is available for use during normal business hoursTBDTBDTBD
142008S.O. 1.3 - Improve health care quality, safety, cost and valueTechnologyExternal Data SharingPercent of files transferred by direct data transferTBD75%TBD
152008S.O. 1.3 - Improve health care quality, safety, cost and valueMission and Business ResultsHealth Care AdministrationPercent of claims containing NPITBD75%TBD
162008S.O. 1.3 - Improve health care quality, safety, cost and valueProcesses and ActivitiesTimelinessTime needed to edit and load state submissionsTBD95 daysTBD
172009S.O. 1.3 - Improve health care quality, safety, cost and valueCustomer ResultsAvailabilityPercent of Time System is available for use during normal business hoursTBD99%TBD
182009S.O. 1.3 - Improve health care quality, safety, cost and valueTechnologyExternal Data SharingPercent of files transferred by direct data transferTBD100%TBD
192009S.O. 1.3 - Improve health care quality, safety, cost and valueMission and Business ResultsHealth Care AdministrationPercent of claims containing NPITBDTBDTBD
202009S.O. 1.3 - Improve health care quality, safety, cost and valueProcesses and ActivitiesTimelinessTime needed to edit and load state submissionsTBD90 daysTBD
212010S.O. 1.3 - Improve health care quality, safety, cost and valueCustomer ResultsAvailabilityPercent of Time System is available for use during normal business hoursTBD100%TBD
222010S.O. 1.3 - Improve health care quality, safety, cost and valueTechnologyExternal Data SharingNumber of states participating in consolidated monthly eligibility reportingTBD10TBD
232010S.O. 1.3 - Improve health care quality, safety, cost and valueMission and Business ResultsHealth Care AdministrationPercent of claims containing NPITBD100%TBD
242010S.O. 1.3 - Improve health care quality, safety, cost and valueProcesses and ActivitiesTimelinessTime needed to edit and load state submissionsTBD86 daysTBD
252011S.O. 1.3 - Improve health care quality, safety, cost and valueCustomer ResultsAvailabilityPercent of Time System is available for use during normal business hoursTBD99%TBD
262011S.O. 1.3 - Improve health care quality, safety, cost and valueTechnologyExternal Data SharingNumber of states participating in consolidated monthly eligibility reportingTBD25TBD
272011S.O. 1.3 - Improve health care quality, safety, cost and valueMission and Business ResultsHealth Care AdministrationPercent of claims containing NPITBD100%TBD
282011S.O. 1.3 - Improve health care quality, safety, cost and valueProcesses and ActivitiesTimelinessTime needed to edit and load state submissionsTBD80 daysTBD
292012S.O. 1.3 - Improve health care quality, safety, cost and valueCustomer ResultsAvailabilityPercent of Time System is available for use during normal business hoursTBD96%TBD
302012S.O. 1.3 - Improve health care quality, safety, cost and valueTechnologyExternal Data SharingNumber of states participating in consolidated monthly eligibility reportingTBD30TBD
312012S.O. 1.3 - Improve health care quality, safety, cost and valueMission and Business ResultsHealth Care AdministrationPercent Error ToleranceTBD10%TBD
322012S.O. 1.3 - Improve health care quality, safety, cost and valueProcesses and ActivitiesTimelinessTime needed to edit and load state submissionsTBD78 daysTBD
332013S.O. 1.3 - Improve health care quality, safety, cost and valueCustomer ResultsAvailabilityPercent of Time System is available for use during normal business hoursTBD97%TBD
342013S.O. 1.3 - Improve health care quality, safety, cost and valueTechnologyExternal Data SharingNumber of states participating in consolidated monthly eligibility reportingTBD35TBD
352013S.O. 1.3 - Improve health care quality, safety, cost and valueMission and Business ResultsHealth Care AdministrationPercent Error ToleranceTBD9%TBD
362013S.O. 1.3 - Improve health care quality, safety, cost and valueProcesses and ActivitiesTimelinessTime needed to edit and load state submissionsTBD75 daysTBD

Enterprise Architecture


In order to successfully address this area of the business case and capital asset plan you must ensure the investment is included in the agency's EA and Capital Planning and Investment Control (CPIC) process, and is mapped to and supports the FEA. You must also ensure the business case demonstrates the relationship between the investment and the business, performance, data, services, application, and technology layers of the agency's EA.
1. Is this investment included in your agency's target enterprise architecture?
yes
2. Is this investment included in the agency's EA Transition Strategy?
no
2.b. If no, please explain why?
New major initiative that is being added to the target architecture and will appear in the next transition plan.
3. Is this investment identified in a completed (contains a target architecture) and approved segment architecture?
no
4. Identify the service components funded by this major IT investment (e.g., knowledge management, content management, customer relationship management, etc.). Provide this information in the format of the following table. For detailed guidance regarding components, please refer to http://www.whitehouse.gov/omb/egov/.

Component: Use existing SRM Components or identify as NEW. A NEW component is one not already identified as a service component in the FEA SRM.

Reused Name and UPI: A reused component is one being funded by another investment, but being used by this investment. Rather than answer yes or no, identify the reused service component funded by the other investment and identify the other investment using the Unique Project Identifier (UPI) code from the OMB Ex 300 or Ex 53 submission.

Internal or External Reuse?: Internal reuse is within an agency. For example, one agency within a department is reusing a service component provided by another agency within the same department. External reuse is one agency within a department reusing a service component provided by another agency in another department. A good example of this is an E-Gov initiative service being reused by multiple organizations across the federal government.

Funding Percentage: Please provide the percentage of the BY requested funding amount used for each service component listed in the table. If external, provide the funding level transferred to another agency to pay for the service.
RowAgency Component NameAgency Component DescriptionService TypeComponentReused Component NameReused UPIInternal or External Reuse?Funding %
1Data ExchangeDefines the set of capabilities that support the interchange of information between multiple systems or applications; includes verification that transmitted data was received unaltered.Data ManagementData ExchangeData Exchange009-38-02-00-01-1150-00Internal20
2Data MartDefines the set of capabilities that support a subset of a data warehouse for a single department or function within an organization.Data ManagementData MartData Mart009-38-02-00-01-1150-00Internal20
3Extraction and TransformationDefines the set of capabilities that support the manipulation and change of data.Data ManagementExtraction and TransformationExtraction and Transformation009-38-02-00-01-1150-00Internal30
4Data ClassificationDefines the set of capabilities that allow the classification of data.Data ManagementData Classification  No Reuse20
5Program / Project ManagementDefines the set of capabilities that manage and control a particular effort of an organization.Management of ProcessesProgram / Project Management  No Reuse10
5. To demonstrate how this major IT investment aligns with the FEA Technical Reference Model (TRM), please list the Service Areas, Categories, Standards, and Service Specifications supporting this IT investment.

FEA SRM Component: Service Components identified in the previous question should be entered in this column. Please enter multiple rows for FEA SRM Components supported by multiple TRM Service Specifications.

Service Specification: In the Service Specification field, Agencies should provide information on the specified technical standard or vendor product mapped to the FEA TRM Service Standard, including model or version numbers, as appropriate.
RowSRM Component>Service AreaService CategoryService StandardService Specification (i.e., vendor and product name)
1Extraction and TransformationComponent FrameworkData ManagementData ExchangeCognos PowerPlay
2Data ClassificationComponent FrameworkData ManagementReporting and AnalysisCognos PowerPlay
3Data ExchangeComponent FrameworkData InterchangeData ExchangeConnect:Direct
4Data ExchangeService Interface and IntegrationIntegrationEnterprise Application IntegrationConnect:Direct
5Program / Project ManagementComponent FrameworkBusiness LogicPlatform DependentMicrosoft Project
6Data MartService Platform and InfrastructureDatabase / StorageDatabaseOracle: CMS Enterprise License; COGNOS: CMS Enterprise License; Informatica: CMS Enterprise License; BMC: CMS Enterprise License; NDM: CMS Enterprise Solution; Connect:Direct: CMS Enterprise License; IBM TSO/IOF
6. Will the application leverage existing components and/or applications across the Government (i.e., FirstGov, Pay.Gov, etc)?
no

PART THREE


RISK


You should perform a risk assessment during the early planning and initial concept phase of the investment's life-cycle, develop a risk-adjusted life-cycle cost estimate and a plan to eliminate, mitigate or manage risk, and be actively managing risk throughout the investment's life-cycle.

Answer the following questions to describe how you are managing investment risks.
1. Does the investment have a Risk Management Plan?
yes
1.a. If yes, what is the date of the plan?
2007-05-01
1.b. Has the Risk Management Plan been significantly changed since last year's submission to OMB?
no

COST & SCHEDULE


1. Was operational analysis conducted?
yes
1.a. If yes, provide the date the analysis was completed.
2007-07-31
What were the results of your operational analysis?
The operational analysis was performed by reviewing all deliverables (including schedule and cost reporting) as well as stakeholder/customer surveys. The analysis verified the investment was meeting cost and schedule milestones in addition to achieving the minimum performance parameters. This investment continues to provide planned benefits and remains a cost-effective solution.