{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Overview","Instructions","A_COVER","B_STATE_set-indc","C1_PROG_set-indc","C2_PROG_free-indc_accs","D1_PLAN_set-indc","D2_PLAN_free-indc_qual","D3_PLAN_free-indc_sanc","E_BSS_set-indc","Glossary","Crosswalk","Set values"],"not_rendered":{"macros":1,"defined_names":1,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Overview","index":0,"n_rows":24,"n_cols":2,"rows_kept":24,"merged":[[0,0,0,1],[3,0,3,1],[5,0,5,1],[7,0,7,1],[10,0,10,1]]}
["The Managed Care Program Annual Report (MCPAR): A requirement of 42 CFR 438.66(e)"]
[]
["MCPAR Overview"]
["Beginning [CMS TO INSERT DATE THIS FORM IS PUBLISHED], the Centers for Medicare and Medicaid Services (CMS) is requiring that, as part of its monitoring system for all Medicaid managed care programs, each state must submit to CMS no later than 180 days after each contract year, a report on each managed care program administered by the State, regardless of the authority under which the program operates. (For purposes of the MCPAR, a program is defined by a specified set of benefits and eligibility criteria that is articulated in a contract between the state and managed care plans, and that has associated rate cells.) The initial report  will be due for the contract year beginning on or after [CMS TO INSERT DATE THIS FORM IS PUBLISHED]; reports are required annually thereafter and aligned with state contract cycles (42 CFR 438.68(e)(1)). (See the Glossary tab for a definition of \"reporting year;\" see Instructions tab for example reporting timeframes.)"]
[]
["This document provides instructions for data collection and a template for states to use to submit the required information, hereafter referred to as the Managed Care Program Annual Report (MCPAR). States must complete one MCPAR workbook (i.e., complete lettered sheets A-E in this excel file) for each managed care program operating in the state during the year. Data should cover the 12-month period of the contract term during which the state is reporting information to CMS; this is referred to as the \"reporting year.\""]
[]
["Completed forms should be submitted to [CMS TO INSERT INSTRUCTIONS RE: HOW TO SUBMIT FORM]. Questions about this form may be directed to ManagedCareTA@mathematica-mpr.com. This form, or the information contained therein, must also be posted on the state's website as required at 438.66(e)(3)(i), and provided to the Medical Care Advisory Committee as required at 438.66(e)(i) and, if applicable, the MLTSS consultation group as required at 438.66(e)(iii)."]
[]
["MCPAR Template Organization"]
["Consistent with 438.66(e), this template provides space for states to report indicators related to the following ten topics:  (I) Program Characteristics and Enrollment; (II) Financial Performance; (III) Encounter Data Reporting; (IV) Grievance, Appeals, and State Fair Hearings; (V) Availability, Accessibility, and Network adequacy; (VI) Quality and Performance Measures; (VII) Sanctions and Corrective Action Plans; (VIII) Beneficiary Support System; and (IX) Program Integrity. \n\nData on each topic is organized by reporting level: state, program, plan, and other entity (i.e. beneficiary support system). Within this report, states will find data elements with specific drop downs that CMS has pre-selected to standardize data across states, as well as places with instructions for states to report state-specific indicators or free text. Tabs are organized as follows:"]
["Tab topic: ","Tab name"]
["Reporting instructions","Instructions"]
["A. Cover sheet and identifying information ","A_COVER"]
["B. State level, set indicators ","B_STATE_set-indc"]
["C1. Program-level, set indicators ","C1_PROG_set-indc"]
["C2. Program-level, state-specific indicators: Availability, accessibility, and network adequacy ","C2_PROG_free-indc_accs"]
["D1. Plan-level, set indicators","D1_PLAN_set-indc"]
["D2. Plan-level, state-specific indicators: Quality and Performance Measures","D2_PLAN_free-indc_qual"]
["D3. Plan-level, state-specific indicators: Sanctions and Corrective Action Plans","D3_PLAN_free-indc_sanc"]
["E. BSS-entities, set indicators","E_BSS_set-indc"]
["Glossary","Glossary"]
["List of all indicators in the MCPAR, crosswalked to the tab on which they appear","Crosswalk"]
[" "]

{"sheet":"Instructions","index":1,"n_rows":11,"n_cols":2,"rows_kept":11,"merged":[[0,0,0,1]]}
["Reporting Instructions"]
[]
["Item","Instruction or description"]
["Inputting data","Enter information into tabs A-E, and only input values in BEIGE CELLS (white cells with black text provide explanatory text or calculated values). Key terms are defined in the glossary. "]
["Reporting timeframe","The State must submit MPCAR reports to CMS no later than 180 days after each contract year. The initial MCPAR report will be due after the contract year following the release of CMS guidance on the content and form of the report (i.e. after release of this form) (42 CFR 438.68(e)(1).  Example timeframe: If CMS releases guidance on the MCPAR in the beginning 2021, states that have contracts on a calendar cycle (for example, states with contracts running from July, 2021 to June, 2022), would have their first required report due December 31, 2022. For states with calendar year contracts, the calendar year following release of the guidance would be 2022, and their first reports would be due June 2023.  "]
["Program definition","For purposes of the MCPAR, a program is defined by a distinct set of benefits and eligibilty criteria that is articulated in a contract between the state and managed care plans. \"Programs\" may also be differentiated from one another based on their associated rate cells."]
["Exclusion of CHIP from MCPAR","Separate CHIP enrollees and programs should not be reported in the MCPAR. Please use free text to flag any items for which the state is unable to remove information about Separate CHIP from required reporting for Medicaid-only or Medicaid Expansion CHIP programs."]
["Preparing the first MCPAR","CMS acknowledges that states may need to update their contracts with plans to collect some information requested in the MCPAR and that states will need time to create the first MCPAR report. CMS will be available to provide technical assistance to states to help prepare the MCPAR.  Requests for technical assistance can be submitted to ManagedCareTA@mathematica-mpr.com."]
["Overlap with other state reporting requirements","CMS acknowledges that some of the indicators requested in the MCPAR are also reported to CMS through other means. For example, state EQRO reports include measure validation results and measure rates for some or all measures collected by states, although measure rates may not be program specific and may not be reported for all managed care programs operating in the state in a given year. States should consider leveraging existing reports and/or contractors (such as EQROs) to populate the MCPAR. CMS will explore opportunities to align the MCPAR with other data collection efforts in future years."]
["1115 reports overlap","Per 42 CFR 438.66(e)(1)(ii), states that operate managed care programs under 1115(a) authority may reference 1115 reports required by its Special Terms and Conditions (STCs) in lieu of entering an indicator into the MCPAR if the report includes the information required by the indicator including the same level of detail (e.g. plan-level data). However, CMS has worked to ensure that most of the managed care reporting requirements in the MCPAR are not duplicated in STCs; therefore, CMS anticipates few instances where the information required in 1115 quarterly and annual reports will directly overlap with what is required in the MCPAR. If a state would like assistance in determining whether an existing 1115 reporting requirement can be deemed to satisfy requirements of the MCPAR, please request technical assistance via ManagedCareTA@mathematica-mpr.com. "]
["Data lags","If the state does not have data available over the time period with which it is requested in the MCPAR, use the most recent data available and note the reporting period that the data cover."]

{"sheet":"A_COVER","index":2,"n_rows":55,"n_cols":4,"rows_kept":55,"merged":[[10,1,44,1],[45,1,54,1]]}
["A. Cover sheet and identifying information"]
[{"$nulls":3},"Input data in beige cells in this column. These values will autopopulate other tabs. "]
["Item or entity","Instructions and definition","Data format","Response"]
["State name ","Enter the name of state submitting the report.","Set value (select one)"]
["Contact name","Enter the name and email address of the person or position to contact with questions regarding information reported in the MCPAR. States that do not wish to list a specific individual on the report are encouraged to use a department or program-wide email address that will allow anyone with questions to quickly reach someone who can provide answers.","Free text"]
["Contact email address","Enter the email address of the individual filling out this document.","Free text"]
["Date of report submission","Enter the date on which this document is being submitted to CMS.","Date (MM/DD/YYYY)"]
["Reporting period start date","Enter the start date of the reporting period represented in this document.","Date (MM/DD/YYYY)"]
["Reporting period end date","Enter the end date of the reporting period represented in this document.","Date (MM/DD/YYYY)"]
["Program name ","Enter the name of the program for which the state is reporting data in the MCPAR. For purposes of the MCPAR, a program is defined by a contract between the state and a managed care plan (or group of plans), which articulates a standard set of benefits, eligibility criteria, reporting requirements, and has a set of rate cells specific to that program. ","Free text"]
["Plan 1","Enter the name of each plan that participates in the program for which the state is reporting data. If the program contracts with fewer than 35 plans, leave unused fields blank.","Free text"]
["Plan 2",null,"Free text"]
["Plan 3",null,"Free text"]
["Plan 4",null,"Free text"]
["Plan 5",null,"Free text"]
["Plan 6",null,"Free text"]
["Plan 7",null,"Free text"]
["Plan 8",null,"Free text"]
["Plan 9",null,"Free text"]
["Plan 10",null,"Free text"]
["Plan 11",null,"Free text"]
["Plan 12",null,"Free text"]
["Plan 13",null,"Free text"]
["Plan 14",null,"Free text"]
["Plan 15",null,"Free text"]
["Plan 16",null,"Free text"]
["Plan 17",null,"Free text"]
["Plan 18",null,"Free text"]
["Plan 19",null,"Free text"]
["Plan 20",null,"Free text"]
["Plan 21",null,"Free text"]
["Plan 22",null,"Free text"]
["Plan 23",null,"Free text"]
["Plan 24",null,"Free text"]
["Plan 25",null,"Free text"]
["Plan 26",null,"Free text"]
["Plan 27",null,"Free text"]
["Plan 28",null,"Free text"]
["Plan 29",null,"Free text"]
["Plan 30",null,"Free text"]
["Plan 31",null,"Free text"]
["Plan 32",null,"Free text"]
["Plan 33",null,"Free text"]
["Plan 34",null,"Free text"]
["Plan 35",null,"Free text"]
["BSS entity 1","Enter the names of the beneficiary support system (BSS) entities that  support enrollees in the program for which the state is reporting data. If the program contracts with fewer than 10 BSS entities, leave unused fields blank. If the program includes more than 10 BSS entities, states may contact CMS for guidance.","Free text"]
["BSS entity 2",null,"Free text"]
["BSS entity 3",null,"Free text"]
["BSS entity 4",null,"Free text"]
["BSS entity 5",null,"Free text"]
["BSS entity 6",null,"Free text"]
["BSS entity 7",null,"Free text"]
["BSS entity 8",null,"Free text"]
["BSS entity 9",null,"Free text"]
["BSS entity 10",null,"Free text"]

{"sheet":"B_STATE_set-indc","index":3,"n_rows":24,"n_cols":5,"rows_kept":24}
["B. State-level indicators"]
[{"$nulls":4},"Input data only in beige cells in this column "]
["#","Indicator","Instructions and definition","Data format",{"$f":"IF(A_COVER!D4=\"\",\"[STATE]\",A_COVER!D4)","v":"[STATE]"}]
["Topic I. Program Characteristics and Enrollment"]
["B.I.1","Statewide Medicaid enrollment ","Enter the total number of individuals enrolled in Medicaid as of the first day of the last month of the reporting year. Include all FFS and managed care enrollees, and count each person only once, regardless of the delivery system(s) in which they are enrolled.","Count"]
["B.I.2","Statewide Medicaid managed care enrollment ","Enter the total, unduplicated number of individuals enrolled in any type of Medicaid managed care as of the first day of the last month of the reporting year. Include enrollees in all programs, and count each person only once, even if they are enrolled in more than one managed care program or more than one managed care plan.","Count"]
["Topic III. Encounter Data Reporting"]
["B.III.1","Data validation entity","Select the state agency/division or contractor) tasked with evaluating the validity of encounter data submitted by MCPs. Encounter data validation includes verifying the accuracy, completeness, timeliness, and/or consistency of encounter data records submitted to the state by Medicaid managed care plans. Validation steps may include pre-acceptance edits and post-acceptance analyses. (See Glossary defintion for more information.)","Set values (select multiple) or use free text for \"other\" response"]
["B.III.2","HIPAA compliance of proprietary system(s) for encounter data validation","If state selected “proprietary system(s)” in indicator B.III.1, indicate whether the system(s) utilized are fully HIPAA compliant.","Set values (select one)"]
["Topic X. Program Integrity"]
["B.X.1","Payment risks between the state and plans","Describe service-specific or other focused PI activities that the state conducted during the past year in this managed care program (such as analyses focused on use of long-term services and supports [LTSS] or prescription drugs) or activities that focused on specific payment issues to identify, address, and prevent fraud, waste or abuse. Consider data analytics, reviews of under/overutilization, and other activities.","Free text"]
["B.X.2","Contract standard for overpayments","Indicate whether the state allows plans to retain overpayments, requires the return of overpayments, or has established a hybrid system.","Set values (select one)"]
["B.X.3","Contract locations of overpayment standard","Identify where the overpayment standard in indicator B.X.2 is located in plan contracts, as required by 42 CFR 438.608(d)(1)(i).","Free text"]
["B.X.4","Description of overpayment contract standard","Briefly describe the overpayment standard (for example, details on whether the state allows plans to retain overpayments, requires the plans to return overpayments, or administers a hybrid system) selected  in indicator B.X.2","Free text"]
["B.X.5","State overpayment reporting monitoring","Describe how the state monitors plan performance in reporting overpayments to the state. For example, does the state track compliance with this requirement and/or timeliness of reporting?","Free text"]
["B.X.6","Changes in beneficiary circumstances","Describe how the state ensures timely and accurate reconciliation of enrollment files between the state and plans to ensure appropriate payments for enrollees experiencing a change in status (e.g., incarcerated, deceased, switching plans).","Free text"]
["B.X.7.a","Changes in provider circumstances: Part 1","Indicate if the state monitors whether plans report provider “for cause” terminations in a timely manner under 42 CFR 438.608(a)(4).","Set values (select one)"]
["B.X.7.b","Changes in provider circumstances: Part 2","If the state monitors whether plans report provider “for cause” terminations in a timely manner in indicator B.X.7.a, indicate whether the state uses a metric or indicator to assess plan reporting performance.","Set values (select one)"]
["B.X.7.c","Changes in provider circumstances: Part 3","If the state uses a metric or indicator to assess plan reporting performance in indicator B.X.7.b, describe the metric or indicator that the state uses.","Free text"]
["B.X.8a","Federal database checks: Part 1","Consistent with the requirements at  42 CFR 455.436 and 438.602, the State must confirm the identity and determine the exclusion status of the MCO, PIHP, PAHP, PCCM or PCCM entity, any subcontractor, as well as any person with an ownership or control interest, or who is an agent or managing employee of the MCO, PIHP, PAHP, PCCM or PCCM entity through routine checks of Federal databases. In the course of the state's federal database checks, did the state find any person or entity excluded?","Set values (select one)"]
["B.X.8b","Federal database checks: Part 2","If in the course of the state's federal database checks the state found any person or entity excluded, please summarize the instances and whether the entity was notified as required in 438.602(d). Report actions taken, such as plan-level sanctions and corrective actions in Tab D3 as applicable. Enter N/A if not applicable.","Free text"]
["B.X.9a","Website posting of 5 percent or more ownership control [Y/N]","Report whether the state posts on its website the names of individuals and entities with 5% or more ownership or control interest in MCOs, PIHPs, PAHPs, PCCMs and PCCM entities and subcontractors following §455.104 and required by 42 CFR 438.602(g)(3).","Set values (select one)"]
["B.X.9b","Website posting of 5 percent or more ownership control [link]","If the state posts on its website the names of the plan individuals with 5% or more ownership or control, under 42 CFR 602(g)(3), provide a link to the website. Enter N/A if not applicable.","Free text"]
["B.X.10","Periodic audits [link]","If the state conducted any audits during the contract year to determine the accuracy, truthfulness, and completeness of the encounter and financial data submitted by the plans under 42 CFR 438.602(e), provide the link(s) to the audit results. ","Free text"]

{"sheet":"C1_PROG_set-indc","index":4,"n_rows":33,"n_cols":5,"rows_kept":33}
["C1.  Program-level, set indicators"]
[{"$nulls":4},"Input data only in beige cells in this column "]
["#","Indicator","Instructions and definition","Data format",{"$f":"IF(A_COVER!D10=\"\",\"[Program]\",A_COVER!D10)","v":"[Program]"}]
["Topic I. Program Characteristics and Enrollment"]
["C1.I.1","Program contract","Enter the title and date of the contract between the state and plans participating in the managed care program.","Free Text"]
["C1.I.2","Contract URL","Enter the hyperlink to the model contract or landing page for executed contracts for the program being reported in the MCPAR.  ","Free Text (hyperlink)"]
["C1.I.3","Program type","Select the type of MCPs that contract with the state to provide the services covered under the program. Select one of the allowed values.","Set values (select one)"]
["C1.I.4.a","Special program benefits","CMS is interested in knowing whether one or more of the following four special benefit types are covered by the managed care program: (1) behavioral health, (2) long-term services and supports, (3) dental, and (4) transportation, or (5) none of the above. Select one or more of the allowed values.  (Note: Only list the benefit type if it is a covered service as specified in a contract between the state and managed care plans participating in the program. Benefits available to eligible program enrollees via fee-for-service should not be listed here.)","Set values (select multiple)"]
["C1.I.4.b","Variation in special benefits","Please note any variation in the availability of special benefits  within the program (e.g. by service area or population). Enter \"N/A\" if not applicable.","Free text"]
["C1.I.5","Program enrollment","Enter the total number of individuals enrolled in the managed care program as of the first day of the last month of the reporting year. ","Count"]
["C1.I.6","Changes to enrollment or benefits ","Provide a brief explanation of any major changes to the population enrolled in or benefits provided by the managed care program during the reporting year. ","Free text"]
["Topic III. Encounter Data Reporting"]
["C1.III.1","Uses of encounter data","Federal regulations require that states, through their contracts with MCPs, collect and maintain sufficient enrollee encounter data to identify the provider who delivers any item(s) or service(s) to enrollees (42 CFR 438.242(c)(1)). Select purposes for which the state uses encounter data collected from managed care plans (MCPs).","Set values (select multiple) or use free text for \"other\" response"]
["C1.III.2","Criteria/ measures used to evaluate MCP performance","Federal regulations also require that states validate that submitted enrollee encounter data they receive is a complete and accurate representation of the services provided to enrollees under the contract between the state and the MCO, PIHP, or PAHP. 42 CFR 438.242(d). Select types of measures used by the state to evaluate managed care plan performance in encounter data submission and correction.","Set values (select multiple) or use free text for \"other\" response"]
["C1.III.3","Encounter data performance criteria contract language","Enter reference(s) to the contract section(s) that describe the criteria by which managed care plan performance on encounter data submission and correction will be measured. Use contract section references, not page numbers.","Free text"]
["C1.III.4","Financial penalties contract language ","Enter reference to the contract section that describes the types of failures to meet encounter data submission standards for which states may impose financial sanction(s) related to encounter data quality. \nUse contract section references, not page numbers.","Free text"]
["C1.III.5","Incentives for encounter data quality","Describe the types of incentives that may be awarded to managed care plans for encounter data quality","Free text"]
["C1.III.6","Barriers to collecting/validating encounter data","Describe any barriers to collecting and/or validating managed care plan encounter data that the state has experienced during the reporting period.","Free text"]
["Topic IV. Grievance, Appeals, and State Fair Hearings"]
["C1.IV.1","State's definition of \"critical incident,\" as used for reporting purposes in its MLTSS program","If this report is being completed for a managed care program that covers LTSS, provide the definition that the state uses for \"critical incidents\" within the managed care program. If the managed care program does not cover LTSS, the state should respond \"N/A.\"","Free text or N/A"]
["C1.IV.2","State definition of \"timely\" resolution for standard appeals","Per 42 CFR §438.408(b)(2), states must establish a timeframe for timely resolution of standard appeals that is no longer than 30 calendar days from the day the MCO, PIHP or PAHP receives the appeal. Describe the state's definition of timely resolution for standard appeals in the managed care program.","Free text"]
["C1.IV.3","State definition of \"timely\" resolution for expedited appeals","Per 42 CFR §438.408(b)(3), states must establish a timeframe for timely resolution of expedited appeals that is no longer than 72 hours after the MCO, PIHP or PAHP receives the appeal. Describe in the state's definition of timely resolution for expedited appeals in the managed care program.","Free text"]
["C1.IV.4","State definition of \"timely\" resolution for grievances","Per 42 CFR §438.408(b)(1), states must establish a timeframe for timely resolution of grievances that is no longer than 90 calendar days from the day the MCO, PIHP or PAHP receives the grievance. Describe the state's definition of timely resolution for grievances in the managed care program.","Free text"]
["Topic V. Availability, Accessibility, and Network Adequacy"]
["C1.V.1","Gaps/challenges in network adequacy","Describe any challenges to maintaining adequate networks and meeting standards. What are the state’s biggest challenges? ","Free text"]
["C1.V.2","State response to gaps in network adequacy","Describe how the state works with MCPs to address these gaps.","Free text"]
["Topic IX. Beneficiary Support System (BSS)"]
["C1.IX.1","BSS website","Indentify the website and/or email address that beneficiaries use to seek assistance from the BSS through electronic means. ","Free text"]
["C1.IX.2","BSS auxiliary aids and services","42 CFR 438.71 requires that the beneficiary support system be accessible in multiple ways including phone, Internet, in-person, and via auxiliary aids and services when requested. Describe how BSS entities offer services in a manner that is accessible to all beneficiaries who need their services, including beneficiaries with disabilities, as required by 42 CFR 438.71(b)(2)).","Free text"]
["C1.IX.3","BSS LTSS program data","Describe how BSS entities assist the state with identifying, remediating, and resolving systemic issues based on a review of LTSS program data such as grievances and appeals or critical incident data, as required by 42 CFR 438.71(d)(4).","Free text"]
["C1.IX.4","State evaluation of BSS entity performance","Describe steps taken by the state to evaluate the quality, effectiveness, and efficiency of the BSS entities' performance.","Free text"]
["Topic X. Program Integrity"]
["C1.X.3","Prohibited affiliation disclosure","Did any plans disclose prohibited affiliations? If the state took action, as required under 42 CFR 438.610(d), please enter interventions on Tab D3 Sanctions and Corrective Action Plans.","Set values (select one)"]

{"sheet":"C2_PROG_free-indc_accs","index":5,"n_rows":101,"n_cols":9,"rows_kept":101,"merged":[[1,0,1,8]]}
["C2. Program-level, state-specific indicators: Availability, accessibility, and network adequacy"]
["Context: Revisions to the Medicaid managed care regulations in 2016 and 2020 built on existing requirements that managed care plans maintain provider networks sufficient to ensure adequate access to covered services by: (1) requiring states to develop quantitative network adequacy standards for at least eight specified provider types if covered under the contract, and to make these standards available online; (2) strengthening network adequacy monitoring requirements; and (3) addressing the needs of people with long-term care service needs (42 CFR 438.66; 42 CFR 438.68). 42 CFR 438.66(e) specifies that the MCPAR must provide information on and an assessment of the availability and accessibility of covered services within the MCO, PHIP, or PAHP contracts, including network adequacy standards for each managed care program. "]
[]
["Instructions: Describe the measures the state uses to monitor availability, accessibility, and network adequacy. Report at the program level, with each indicator on a separate row. Select drop downs or enter information in the beige cells in columns B-I >>"]
[null,"Domain or standard type","Standard","Standard type ","Provider type","Applicable region(s) ","Population","Monitoring methods","Frequency of oversight methods"]
["Data format:","Set values (select one)","Free text","Set values (select one) or use free text for \"other\" response","Set values (select one) or use free text for \"other\" response","Set values (select one) or use free text for \"other\" response","Set values (select one) or use free text for \"other\" response","Set values (allow multiple) or use free text for \"other\" response","Set values (select one) or use free text for \"other\" response"]
["Topic V. Availability, Accessibility, and Network Adequacy"]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B8=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B9=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B10=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B11=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B12=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B13=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B14=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B15=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B16=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B17=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B18=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B19=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B20=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B21=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B22=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B23=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B24=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B25=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B26=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B27=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B28=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B29=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B30=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B31=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B32=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B33=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B34=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B35=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B36=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B37=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B38=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B39=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B40=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B41=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B42=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B43=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B44=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B45=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B46=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B47=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B48=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B49=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B50=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B51=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B52=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B53=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B54=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B55=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B56=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B57=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B58=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B59=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B60=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B61=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B62=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B63=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B64=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B65=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B66=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B67=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B68=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B69=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B70=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B71=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B72=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B73=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B74=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B75=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B76=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B77=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B78=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B79=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B80=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B81=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B82=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B83=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B84=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B85=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B86=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B87=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B88=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B89=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B90=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B91=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B92=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B93=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B94=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B95=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B96=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B97=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B98=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B99=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B100=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]
[{"$f":"IF(OR(A_COVER!$D$10=\"\",$B101=\"\"),\"[placeholder]\",A_COVER!$D$10)","v":"[placeholder]"}]

{"sheet":"D1_PLAN_set-indc","index":6,"n_rows":89,"n_cols":39,"rows_kept":89,"merged":[[31,0,31,2],[55,0,55,2],[66,0,66,2]]}
["D1. Plan-level, set indicators"]
[{"$nulls":4},"Input plan-level data in beige cells in these columns >>"]
["#","Indicator","Instructions and definition","Data format",{"$f":"IF(A_COVER!$D11=\"\",\"[Plan 1]\",A_COVER!$D11)","v":"[Plan 1]"},{"$f":"IF(A_COVER!$D12=\"\",\"[Plan 2]\",A_COVER!$D12)","v":"[Plan 2]"},{"$f":"IF(A_COVER!$D13=\"\",\"[Plan 3]\",A_COVER!$D13)","v":"[Plan 3]"},{"$f":"IF(A_COVER!$D14=\"\",\"[Plan 4]\",A_COVER!$D14)","v":"[Plan 4]"},{"$f":"IF(A_COVER!$D15=\"\",\"[Plan 5]\",A_COVER!$D15)","v":"[Plan 5]"},{"$f":"IF(A_COVER!$D16=\"\",\"[Plan 6]\",A_COVER!$D16)","v":"[Plan 6]"},{"$f":"IF(A_COVER!$D17=\"\",\"[Plan 7]\",A_COVER!$D17)","v":"[Plan 7]"},{"$f":"IF(A_COVER!$D18=\"\",\"[Plan 8]\",A_COVER!$D18)","v":"[Plan 8]"},{"$f":"IF(A_COVER!$D19=\"\",\"[Plan 9]\",A_COVER!$D19)","v":"[Plan 9]"},{"$f":"IF(A_COVER!$D20=\"\",\"[Plan 10]\",A_COVER!$D20)","v":"[Plan 10]"},{"$f":"IF(A_COVER!$D21=\"\",\"[Plan 11]\",A_COVER!$D21)","v":"[Plan 11]"},{"$f":"IF(A_COVER!$D22=\"\",\"[Plan 12]\",A_COVER!$D22)","v":"[Plan 12]"},{"$f":"IF(A_COVER!$D23=\"\",\"[Plan 13]\",A_COVER!$D23)","v":"[Plan 13]"},{"$f":"IF(A_COVER!$D24=\"\",\"[Plan 14]\",A_COVER!$D24)","v":"[Plan 14]"},{"$f":"IF(A_COVER!$D25=\"\",\"[Plan 15]\",A_COVER!$D25)","v":"[Plan 15]"},{"$f":"IF(A_COVER!$D26=\"\",\"[Plan 16]\",A_COVER!$D26)","v":"[Plan 16]"},{"$f":"IF(A_COVER!$D27=\"\",\"[Plan 17]\",A_COVER!$D27)","v":"[Plan 17]"},{"$f":"IF(A_COVER!$D28=\"\",\"[Plan 18]\",A_COVER!$D28)","v":"[Plan 18]"},{"$f":"IF(A_COVER!$D29=\"\",\"[Plan 19]\",A_COVER!$D29)","v":"[Plan 19]"},{"$f":"IF(A_COVER!$D30=\"\",\"[Plan 20]\",A_COVER!$D30)","v":"[Plan 20]"},{"$f":"IF(A_COVER!$D31=\"\",\"[Plan 21]\",A_COVER!$D31)","v":"[Plan 21]"},{"$f":"IF(A_COVER!$D32=\"\",\"[Plan 22]\",A_COVER!$D32)","v":"[Plan 22]"},{"$f":"IF(A_COVER!$D33=\"\",\"[Plan 23]\",A_COVER!$D33)","v":"[Plan 23]"},{"$f":"IF(A_COVER!$D34=\"\",\"[Plan 24]\",A_COVER!$D34)","v":"[Plan 24]"},{"$f":"IF(A_COVER!$D35=\"\",\"[Plan 25]\",A_COVER!$D35)","v":"[Plan 25]"},{"$f":"IF(A_COVER!$D36=\"\",\"[Plan 26]\",A_COVER!$D36)","v":"[Plan 26]"},{"$f":"IF(A_COVER!$D37=\"\",\"[Plan 27]\",A_COVER!$D37)","v":"[Plan 27]"},{"$f":"IF(A_COVER!$D38=\"\",\"[Plan 28]\",A_COVER!$D38)","v":"[Plan 28]"},{"$f":"IF(A_COVER!$D39=\"\",\"[Plan 29]\",A_COVER!$D39)","v":"[Plan 29]"},{"$f":"IF(A_COVER!$D40=\"\",\"[Plan 30]\",A_COVER!$D40)","v":"[Plan 30]"},{"$f":"IF(A_COVER!$D41=\"\",\"[Plan 31]\",A_COVER!$D41)","v":"[Plan 31]"},{"$f":"IF(A_COVER!$D42=\"\",\"[Plan 32]\",A_COVER!$D42)","v":"[Plan 32]"},{"$f":"IF(A_COVER!$D43=\"\",\"[Plan 33]\",A_COVER!$D43)","v":"[Plan 33]"},{"$f":"IF(A_COVER!$D44=\"\",\"[Plan 34]\",A_COVER!$D44)","v":"[Plan 34]"},{"$f":"IF(A_COVER!$D45=\"\",\"[Plan 35]\",A_COVER!$D45)","v":"[Plan 35]"}]
["Topic I: Program Characteristics and Enrollment"]
["D1.I.1","Plan enrollment","Enter total number of individuals enrolled in each plan as of the first day of the last month of the reporting year. ","Count"]
["D1.I.2","Plan share of Medicaid","Sum of enrollment in the plan (within the specific program) as a percentage of total Medicaid enrollment in the state \n• Numerator: Plan enrollment (indicator D1.I.1)\n• Denominator: Statewide Medicaid enrollment (indicator B.I.1) ","Percentage (calculated) \nNote: No data entry required; this cell is autopopulated",{"$f":"'D1_PLAN_set-indc'!E5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!F5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!G5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!H5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!I5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!J5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!K5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!L5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!M5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!N5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!O5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!P5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!Q5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!R5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!S5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!T5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!U5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!V5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!W5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!X5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!Y5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!Z5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!AA5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!AB5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!AC5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!AD5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!AE5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!AF5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!AG5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!AH5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!AI5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!AJ5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!AK5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!AL5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}},{"$f":"'D1_PLAN_set-indc'!AM5/'B_STATE_set-indc'!$E$5","v":{"$error":"#DIV/0!"}}]
["D1.I.3","Plan share of any Medicaid managed care","Sum of enrollment in a given plan (regardless of program) as a percentage of total Medicaid enrollment in any type of managed care. \n• Numerator: Plan enrollment (indicator D1.I.1)\n• Denominator: Statewide Medicaid managed care enrollment (indicator B.I.2) ","Percentage (calculated) \nNote: No data entry required; this cell is autopopulated",{"$f":"E5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"F5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"G5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"H5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"I5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"J5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"K5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"L5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"M5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"N5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"O5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"P5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"Q5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"R5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"S5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"T5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"U5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"V5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"W5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"X5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"Y5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"Z5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"AA5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"AB5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"AC5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"AD5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"AE5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"AF5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"AG5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"AH5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"AI5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"AJ5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"AK5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"AL5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"AM5/'B_STATE_set-indc'!$E$6","v":{"$error":"#DIV/0!"}}]
["Topic II. Financial Performance"]
["D1.II.1a","Medical Loss Ratio (MLR): Aggregate value","Per 42 CFR 438.66(e)(2)(i), the Managed Care Program Annual Report must provide information on the Financial performance of each MCO, PIHP, and PAHP, including MLR experience. Indicate below in D1.II.1b the level of aggregation of the reported MLR. If MLR data are not available for this reporting period due to data lags, enter the MLR calculated for the most recently available reporting period and indicate the reporting period in item D1.II.4 below. See glossary for the regulatory definition of MLR. ","Percentage "]
["D1.II.1b","Aggregate MLR value: Level of aggregation","As permitted under 42 CFR 438.8(i), states are allowed to aggregate data for reporting purposes across programs and populations.  Select the aggregation level that best describes the MLR being reported in indicator D1.II.1a for each plan.","Set values (select one) or use free text for \"other\" response"]
["D1.II.2","Population specific MLR description","If the state requires plans to submit separate MLR calculations for specific populations served within this program, for example, MLTSS or Group VIII expansion enrollees, describe the populations here. If the state does not require this, write \"N/A.\" See glossary for the regulatory definition of MLR. ","Free text"]
["D1.II.3","MLR reporting period discrepancies","If the data reported in item D1.II.1a covers a different time period than the MCPAR report, use this space to note the start and end date for that data.","Free text"]
["Topic III. Encounter Data"]
["D.1.III.1","Definition of timely encounter data submissions","Describe the state's standard for timely encounter data submissions.","Free text"]
["D1.III.2","Share of encounter data submissions that met state’s timely submission requirements","Enter the percentage of the plan’s encounter data file submissions (submitted during the reporting period) that met state requirements for timely submission. If the state has not yet received any encounter data file submissions for the entire contract period when it submits this report, the state should enter here the percentage of encounter data submissions that were compliant out of the file submissions it has received from the managed care plan for the reporting period.","Percentage "]
["D1.III.3","Share of encounter data submissions that were HIPAA compliant","Enter the percentage of the plan’s encounter data submissions (submitted during the reporting period) that met state requirements for HIPAA compliance. If the state has not yet received encounter data submissions for the entire contract period when it submits this report, enter here percentage of encounter data submissions that were compliant out of the proportion received from the managed care plan for the reporting period.","Percentage"]
["Topic IV. Grievance, Appeals, and State Fair Hearings"]
["Subtopic: Appeals "]
["D1.IV.1","Appeals resolved (at the plan level)","Enter the total number of appeals resolved as of the first day of the last month of the reporting year. An appeal is \"resolved\" at the plan level when the plan has issued a decision, regardless of whether the decision was wholly or partially favorable or adverse to the beneficiary, and regardless of whether the beneficiary (or the beneficiary's representative) chooses to file a request for a State Fair Hearing or External Medical Review.","Count"]
["D1.IV.2","Active appeals","Enter the total number of appeals still pending or in process (not yet resolved) as of the first day of the last month of the reporting year. ","Count"]
["D1.IV.3","Appeals filed on behalf of LTSS users","Enter the total number of appeals filed during the reporting year by or on behalf of LTSS users. An LTSS user is an enrollee who received at least one LTSS service at any point during the reporting year (regardless of whether the enrollee was actively receiving LTSS at the time that the appeal was filed). If not applicable, write \"N/A.\"","Count"]
["D1.IV.4","Number of critical incidents filed during the reporting period by (or on behalf of) an LTSS user who previously filed an appeal","For managed care plans that cover LTSS, enter the number of critical incidents filed within the reporting period by (or on behalf of) LTSS users who previously filed appeals in the reporting year. The appeal and critical incident do not have to have been \"related\" to the same issue  - they only need to have been filed by (or on behalf of) the same enrollee. Neither the critical incident nor the appeal need to have been filed in relation to delivery of LTSS - they may have been filed for any reason, related to any service received (or desired) by an LTSS user.  If the managed care plan does not cover LTSS, the state should write \"N/A\" in this field. Additionally, if the state already submitted this data for the reporting year via the CMS readiness review appeal and grievance report (because the managed care program or plan were new or serving new populations during the reporting year), and the readiness review tool was submitted for at least 6 months of the reporting year, the state can write \"N/A\" in this field. To calculate this number, states or managed care plans should first identify the LTSS users for whom critical incidents were filed during the reporting year, then determine whether those enrollees had filed an appeal during the reporting year, and whether the filing of the appeal preceded the filing of the critical incident.","Count"]
["D1.IV.5a","Standard appeals for which timely resolution was provided","Enter the total number of standard appeals for which timely resolution was provided by plan during the reporting period. (See 42 CFR §438.408(b)(2) for requirements related to timely resolution of standard appeals.)","Count"]
["D1.IV.5b","Expedited appeals for which timely resolution was provided","Enter the total number of expedited appeals for which timely resolution was provided by plan during the reporting period. (See 42 CFR §438.408(b)(3) for requirements related to timely resolution of standard appeals.)","Count"]
["D1.IV.6a","Appeals related to denial of authorization or limited authorization of a service ","Enter the total number of appeals resolved by the plan during the reporting year that were related to the plan's denial of authorization for a service not yet rendered or limited authorization of a service. (Appeals related to denial of payment for a service already rendered should be counted in indicator D1.IV.6c)","Count"]
["D1.IV.6b","Appeals related to reduction, suspension, or termination of a previously authorized service","Enter the total number of appeals resolved by the plan during the reporting year that were related to the plan's reduction, suspension, or termination of a previously authorized service.","Count"]
["D1.IV.6c","Appeals related to payment denial","Enter the total number of appeals resolved by the plan during the reporting year that were related to the plan's denial, in whole or in part, of payment for a service that was already rendered.","Count"]
["D1.IV.6d","Appeals related to service timeliness","Enter the total number of appeals resolved by the plan during the reporting year that were related to the plan's failure to provide services in a timely manner (as defined by the state).","Count"]
["D1.IV.6e","Appeals related to lack of timely plan response to an appeal or grievance","Enter the total number of appeals resolved by the plan during the reporting year that were related to the plan's failure to act within the timeframes provided at 42 CFR §438.408(b)(1) and (2) regarding the standard resolution of grievances and appeals.","Count"]
["D1.IV.6f","Appeals related to plan denial of an enrollee's right to request out-of-network care","Enter the total number of appeals resolved by the plan during the reporting year that were related to the plan's denial of an enrollee's request to exercise their right, under 42 CFR §438.52(b)(2)(ii), to obtain services outside the network (only applicable to residents of rural areas with only one MCO)","Count"]
["D1.IV.6g","Appeals related to denial of an enrollee's request to dispute financial liability","Enter the total number of appeals resolved by the plan during the reporting year that were related to the plan's denial of an enrollee's request to dispute a financial liability.","Count"]
["Number of appeals resolved during the reporting period related to the following services: \n(A single appeal may be related to multiple service types and may therefore be counted in multiple categories below.)",null,null,"(none) ","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)"]
["D1.IV.7a","Appeals related to general inpatient services","Enter the total number of appeals resolved by the plan during the reporting year that were related to general inpatient care, including diagnostic and laboratory services. Please do not include appeals related to inpatient behavioral health services  – those should be included in indicator D1.IV.7c. If the managed care plan does not cover general inpatient services, enter \"N/A\".","Count"]
["D1.IV.7b","Appeals related to general outpatient services","Enter the total number of appeals resolved by the plan during the reporting year that were related to general outpatient care, including diagnostic and laboratory services. Please do not include appeals related to outpatient behavioral health services  – those should be included in indicator D1.IV.7d. If the managed care plan does not cover general outpatient services, enter \"N/A\".","Count"]
["D1.IV.7c","Appeals related to inpatient behavioral health services","Enter the total number of appeals resolved by the plan during the reporting year that were related to inpatient mental health and/or substance use services. If the managed care plan does not cover inpatient behavioral health services, enter \"N/A\".","Count"]
["D1.IV.7d","Appeals related to outpatient behavioral health services","Enter the total number of appeals resolved by the plan during the reporting year that were related to outpatient mental health and/or substance use services. If the managed care plan does not cover outpatient behavioral health services, enter \"N/A\".","Count"]
["D1.IV.7e","Appeals related to covered outpatient prescription drugs","Enter the total number of appeals resolved by the plan during the reporting year that were related to outpatient prescription drugs covered by the managed care plan. If the managed care plan does not cover oupatient prescription drugs, enter \"N/A\".","Count"]
["D1.IV.7f","Appeals related to skilled nursing facility (SNF) services","Enter the total number of appeals resolved by the plan during the reporting year that were related to SNF services. If the managed care plan does not cover skilled nursing services, enter \"N/A\".","Count"]
["D1.IV.7g","Appeals related to long-term services and supports (LTSS)","Enter the total number of appeals resolved by the plan during the reporting year that were related to institutional LTSS or LTSS provided through home and community-based (HCBS) services, including personal care and self-directed services. If the managed care plan does not cover LTSS services, enter \"N/A\".","Count"]
["D1.IV.7h","Appeals related to dental services","Enter the total number of appeals resolved by the plan during the reporting year that were related to dental services. If the managed care plan does not cover dental services, enter \"N/A\".","Count"]
["D1.IV.7i","Appeals related to non-emergency medical transportation (NEMT)","Enter the total number of appeals resolved by the plan during the reporting year that were related to NEMT. If the managed care plan does not cover NEMT, enter \"N/A\".","Count"]
["D1.IV.7j","Appeals related to other service types","Enter the total number of appeals resolved by the plan during the reporting year that were related to services that do not fit into one of the categories listed above. If the managed care plan does not cover services other than those in items D1.IV.7a-i, enter \"N/A\".","Count"]
["Subtopic: State Fair Hearings and External Medical Reviews By Originating Plan"]
["D1.IV.8a","State Fair Hearing requests","Enter the total number of requests for a  State Fair Hearing filed during the reporting year by or on behalf of enrollees from the plan that issued the adverse benefit determination.","Count"]
["D1.IV.8b","State Fair Hearings resulting in a favorable decision  for the enrollee","Enter the total number of State Fair Hearing decisions rendered during the reporting year that were partially or fully favorable to the enrollee. ","Count"]
["D1.IV.8c","State Fair Hearings resulting in an adverse decision for the enrollee","Enter the total number of State Fair Hearing decisions rendered during the reporting year that were adverse for the enrollee. ","Count"]
["D1.IV.8d","State Fair Hearings retracted prior to reaching a decision","Enter the total number of State Fair Hearing decisions retracted (by the enrollee or the representative who filed a State Fair Hearing request on behalf of the enrollee) prior to reaching a decision","Count"]
["D1.IV.9a","External Medical Reviews resulting in a favorable decision for the enrollee","External medical review is defined and described at 42 CFR §438.402(c)(i)(B). If your state does not offer an external medical review process, please enter \"N/A\". If your state does offer an external medical review process, provide the total number of external medical review decisions rendered during the reporting year that were partially or fully favorable to the enrollee.","Count or N/A"]
["D1.IV.9b","External Medical Reviews resulting in an  adverse decision for the enrollee","External medical review is defined and described at 42 CFR §438.402(c)(i)(B). If your state does not offer an external medical review process, please enter \"N/A\". If your state does offer an external medical review process, enter the total number of external medical review decisions rendered during the reporting year that were adverse to the enrollee.","Count or N/A"]
["Subtopic: Grievances"]
["D1.IV.10","Grievances resolved","Enter the total number of grievances resolved by the plan during the reporting year. A grievance is \"resolved\" when it has reached completion and been closed by the plan.","Count"]
["D1.IV.11","Active grievances","Enter the total number of grievances still pending or in process (not yet resolved) as of the first day of the last month of the reporting year. ","Count"]
["D1.IV.12","Grievances filed on behalf of LTSS users","Enter the total number of grievances filed during the reporting year by or on behalf of LTSS users. An LTSS user is an enrollee who received at least one LTSS service at any point during the reporting year (regardless of whether the enrollee was actively receiving LTSS at the time that the grievance was filed).","Count"]
["D1.IV.13","Number of critical incidents filed during the reporting period by (or on behalf of) an LTSS user who previously filed a grievance","For managed care plans that cover LTSS, enter the number of critical incidents filed within the reporting period by (or on behalf of) LTSS users who previously filed grievances in the reporting year. The grievance and critical incident do not have to have been \"related\" to the same issue  - they only need to have been filed by (or on behalf of) the same enrollee. Neither the critical incident nor the grievance need to have been filed in relation to delivery of LTSS - they may have been filed for any reason, related to any service received (or desired) by an LTSS user.  If the managed care plan does not cover LTSS, the state should enter \"N/A\" in this field. Additionally, if the state already submitted this data for the reporting year via the CMS readiness review appeal and grievance report (because the managed care program or plan were new or serving new populations during the reporting year), and the readiness review tool was submitted for at least 6 months of the reporting year, the state can enter \"N/A\" in this field.  To calculate this number, states or managed care plans should first identify the LTSS users for whom critical incidents were filed during the reporting year, then determine whether those enrollees had filed an appeal during the reporting year, and whether the filing of the appeal preceded the filing of the critical incident.","Count"]
["D1.IV.14","Number of grievances for which timely resolution was provided","Enter the number of grievances for which timely resolution was provided by plan  during the reporting period. (See 42 CFR §438.408(b)(1) for requirements related to the timely resolution of grievances.)","Count"]
["Number of grievances resolved by plan during the reporting period related to the following services: \n(A single grievance may be related to multiple service types and may therefore be counted in multiple categories below.)",null,null,"(none)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)"]
["D1.IV.15a","Grievances related to general inpatient services","Enter the total number of grievances resolved by the plan during the reporting year that were related to general inpatient care, including diagnostic and laboratory services. Please do not include grievances related to inpatient behavioral health services – those should be included in indicator D1.IV.15c. If the managed care plan does not cover this type of service, enter \"N/A\".","Count"]
["D1.IV.15b","Grievances related to general outpatient services","Enter the total number of grievances resolved by the plan during the reporting year that were related to general outpatient care, including diagnostic and laboratory services. Please do not include grievances related to outpatient behavioral health services – those should be included in indicator D1.IV.15d.  If the managed care plan does not cover this type of service, enter \"N/A\".","Count"]
["D1.IV.15c","Grievances related to inpatient behavioral health services","Enter the total number of grievances resolved by the plan during the reporting year that were related to inpatient mental health and/or substance use services. If the managed care plan does not cover this type of service, enter \"N/A\".","Count"]
["D1.IV.15d","Grievances related to outpatient behavioral health services","Enter the total number of grievances resolved by the plan during the reporting year that were related to outpatient mental health and/or substance use services. If the managed care plan does not cover this type of service, enter \"N/A\".","Count"]
["D1.IV.15e","Grievances related to coverage of outpatient prescription drugs","Enter the total number of grievances resolved by the plan during the reporting year that were related to outpatient prescription drugs covered by the managed care plan. If the managed care plan does not cover this type of service, enter \"N/A\".","Count"]
["D1.IV.15f","Grievances related to skilled nursing facility (SNF) services","Enter the total number of grievances resolved by the plan during the reporting year that were related to SNF services. If the managed care plan does not cover this type of service, enter \"N/A\".","Count"]
["D1.IV.15g","Grievances related to long-term services and supports (LTSS)","Enter the total number of grievances resolved by the plan during the reporting year that were related to institutional LTSS or LTSS provided through home and community-based (HCBS) services, including personal care and self-directed services. If the managed care plan does not cover this type of service, enter \"N/A\".","Count"]
["D1.IV.15h","Grievances related to dental services","Enter the total number of grievances resolved by the plan during the reporting year that were related to dental services.  If the managed care plan does not cover this type of service, enter \"N/A\".","Count"]
["D1.IV.15i","Grievances related to non-emergency medical transportation (NEMT)","Enter the total number of grievances resolved by the plan during the reporting year that were related to NEMT. If the managed care plan does not cover this type of service, enter \"N/A\".","Count"]
["D1.IV.15j","Grievances related to other service types","Enter the total number of grievances resolved by the plan during the reporting year that were related to services that do not fit into one of the categories listed above. If the managed care plan does not cover services other than those in items D1.IV.15a-i, enter \"N/A\".","Count"]
["Number of grievances resolved by plan during the reporting period related to the following reasons: \n(A single grievance may be related to multiple reasons and may therefore be counted in multiple categories below.)",null,null,"(none)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)","(header/blank cell)"]
["D1.IV.16a","Grievances related to plan or provider customer service","Enter the total number of grievances resolved by the plan during the reporting year that were related to plan or provider customer service. Customer service grievances include complaints about interactions with the plan's Member Services department, provider offices or facilities, plan marketing agents, or any other plan or provider representatives. ","Count"]
["D1.IV.16b","Grievances related to plan or provider care management/case management","Enter the total number of grievances resolved by the plan during the reporting year that were related to plan or provider care management/case management. Care management/case management grievances include complaints about the timeliness of an assessment or complaints about the plan or provider care or case management process. ","Count"]
["D1.IV.16c","Grievances related to access to care/services from plan or provider","Enter the total number of grievances resolved by the plan during the reporting year that were related to access to care. Access to care grievances include complaints about difficulties finding qualified in-network providers, excessive travel or wait times, or other access issues. ","Count"]
["D1.IV.16d","Grievances related to quality of care","Enter the total number of grievances resolved by the plan during the reporting year that were related to quality of care. Quality of care grievances include complaints about the effectiveness, efficiency, equity, patient-centeredness, safety, and/or acceptability of care provided by a provider or the plan. ","Count"]
["D1.IV.16e","Grievances related to plan communications","Enter the total number of grievances resolved by the plan during the reporting year that were related to plan communications. Plan communication grievances include grievances related to the clarity or accuracy of enrollee materials or other plan communications or to an enrollee's access to or the accessibility of enrollee materials or plan communications.","Count"]
["D1.IV.16f","Grievances related to payment or billing issues","Enter the total number of grievances resolved during the reporting period that were filed for a reason related to payment or billing issues.","Count"]
["D1.IV.16g","Grievances related to suspected fraud","Enter the total number of grievances resolved during the reporting year that were related to suspected fraud. Suspected fraud grievances include suspected cases of financial/payment fraud perpetuated by a provider, payer, or other entity. Note: grievances reported in this row should only include grievances submitted to the managed care plan, not grievances submitted to another entity, such as a state Ombudsman or Office of the Inspector General.","Count"]
["D1.IV.16h","Grievances related to abuse, neglect or exploitation","Enter the total number of grievances resolved during the reporting year that were related to abuse, neglect or exploitation. Abuse/neglect/exploitation grievances include cases involving potential or actual patient harm.","Count"]
["D1.IV.16i","Grievances related to lack of timely plan response to a service authorization or appeal request (including requests to expedite or extend appeals)","Enter the total number of grievances resolved during the reporting year that were filed due to a lack of timely plan response to a service authorization or appeal request (including requests to expedite or extend appeals).","Count"]
["D1.IV.16j","Grievances related to plan denial of request for an expedited appeal","Enter the total number of grievances resolved during the reporting year that were related to the plan's denial of an enrollee's request for an expedited appeal. (Per 42 CFR §438.408(b)(3), states must establish a timeframe for timely resolution of expedited appeals that is no longer than 72 hours after the MCO, PIHP or PAHP receives the appeal. If a plan denies a request for an expedited appeal, the enrollee or their representative have the right to file a grievance.)","Count"]
["D1.IV.16k","Grievances filed for other reasons","Enter the total number of grievances resolved during the reporting period that were filed for a reason other than the reasons listed above.","Count"]
["Topic X. Program Integrity"]
["D1.X.1","Dedicated program integrity staff","Report the number of dedicated program integrity staff for routine internal monitoring and compliance risks as required under 42 CFR 438.608(a)(1)(vii). ","Count"]
["D1.X.2","Count of opened program integrity investigations","Enter the count of program integrity investigations opened by the plan in the past year. ","Count"]
["D1.X.3","Ratio of opened program integrity investigations ","Enter the ratio of program integrity investigations opened by the plan in the past year per 1,000 beneficiaries enrolled in the plan on the first day of the last month of the reporting year.","Ratio"]
["D1.X.4","Count of resolved program integrity investigations","Enter the count of program integrity investigations resolved by the plan in the past year.","Count "]
["D1.X.5","Ratio of resolved program integrity investigations ","Enter the ratio of program integrity investigations resolved by the plan in the past year per 1,000 beneficiaries enrolled in the plan at the beginning of the reporting year.","Ratio"]
["D1.X.6","Referral path for program integrity referrals to the state","Select the referral path that the plan uses to make program integrity referrals to the state:\n· If the plan makes referrals to the Medicaid Fraud Control Unit (MFCU) only.\n· If the plan makes referrals to the State Medicaid Agency (SMA) and MFCU concurrently.\n· If the plan makes some referrals to the SMA and others directly to the MFCU.","Set value (select one)"]
["D1.X.7","Count of program integrity referrals to the state","Enter the count of program integrity referrals that the plan made to the state in the past year using the referral path selected in indicator D1.X.6\n· If the plan makes referrals to the MFCU only, enter the count of referrals made. \n· If the plan makes referrals to the SMA and MFCU concurrently, enter the count of unduplicated referrals.\n· If the plan makes some referrals to the SMA and others directly to the MFCU, enter the count of referrals made to the SMA and the MFCU in aggregate.","Count"]
["D1.X.8","Ratio of program integrity referrals to the state","Enter the ratio of program integrity referrals listed in indicator D1.X.7 made to the state in the past year per 1,000 beneficiaries, using the plan's total enrollment as of the first day of the last month of the reporting year (reported in indicator D1.I.1) as the denominator.","Ratio"]
["D1.X.9","Plan overpayment reporting to the state","Summarize the plan’s latest annual overpayment recovery report submitted to the state as required under 42 CFR 438.608(d)(3). Include, for example, the following information:\n· The date of the report (rating period or calendar year).\n· The dollar amount of overpayments recovered.\n· The ratio of the dollar amount of overpayments recovered as a percent of premium revenue as defined in MLR reporting under 438.8(f)(2).","Free text"]
["D1.X.10","Changes in beneficiary circumstances","Select the frequency the plan reports changes in beneficiary circumstances to the state. ","Set values (select one)"]

{"sheet":"D2_PLAN_free-indc_qual","index":7,"n_rows":15,"n_cols":42,"rows_kept":15,"merged":[[1,0,1,6],[3,0,3,6]]}
["D2. Plan-level, state-specific indicators: Quality and Performance Measures"]
["Context: Per 42 CFR 438.66(e)(2)(vii), the Managed Care Program Annual Report must provide information on and an assessment of the operation of the managed care program including evaluation of MCO, PIHP, or PAHP performance on quality measures, including as applicable, consumer report card, surveys, or other reasonable measures of performance."]
[]
["Describe the measures the state uses to monitor quality and performance by selecting drop downs or entering information in the beige cells in columns A-G. Consider measures in each of the following eight domains: (1) Primary care access and preventive care, (2) Maternal and perinatal health, (3) Care of acute and chronic conditions, (4) Behavioral health care, (5) Dental and oral health services, (6) Health plan enrollee experience of care, (7) Long-term services and supports, and (8) Other. Report one row per measure. Note: if no measures are reported in a particular domain, list \"N/A\" under that domain. If the state does not have data available over the time period with which it is requested in the MCPAR, use the most recent data available and note the reporting period that the data cover.",{"$nulls":6},"Input plan-level measure values in beige cells in these columns >>"]
["Domain","NQF #","Measure name","Measure reporting (program-specific or cross-program)","If measure reporting is cross-program, list which programs","Measure set","Measure description",{"$f":"IF(A_COVER!$D11=\"\",\"[Plan 1]\",A_COVER!$D11)","v":"[Plan 1]"},{"$f":"IF(A_COVER!$D12=\"\",\"[Plan 2]\",A_COVER!$D12)","v":"[Plan 2]"},{"$f":"IF(A_COVER!$D13=\"\",\"[Plan 3]\",A_COVER!$D13)","v":"[Plan 3]"},{"$f":"IF(A_COVER!$D14=\"\",\"[Plan 4]\",A_COVER!$D14)","v":"[Plan 4]"},{"$f":"IF(A_COVER!$D15=\"\",\"[Plan 5]\",A_COVER!$D15)","v":"[Plan 5]"},{"$f":"IF(A_COVER!$D16=\"\",\"[Plan 6]\",A_COVER!$D16)","v":"[Plan 6]"},{"$f":"IF(A_COVER!$D17=\"\",\"[Plan 7]\",A_COVER!$D17)","v":"[Plan 7]"},{"$f":"IF(A_COVER!$D18=\"\",\"[Plan 8]\",A_COVER!$D18)","v":"[Plan 8]"},{"$f":"IF(A_COVER!$D19=\"\",\"[Plan 9]\",A_COVER!$D19)","v":"[Plan 9]"},{"$f":"IF(A_COVER!$D20=\"\",\"[Plan 10]\",A_COVER!$D20)","v":"[Plan 10]"},{"$f":"IF(A_COVER!$D21=\"\",\"[Plan 11]\",A_COVER!$D21)","v":"[Plan 11]"},{"$f":"IF(A_COVER!$D22=\"\",\"[Plan 12]\",A_COVER!$D22)","v":"[Plan 12]"},{"$f":"IF(A_COVER!$D23=\"\",\"[Plan 13]\",A_COVER!$D23)","v":"[Plan 13]"},{"$f":"IF(A_COVER!$D24=\"\",\"[Plan 14]\",A_COVER!$D24)","v":"[Plan 14]"},{"$f":"IF(A_COVER!$D25=\"\",\"[Plan 15]\",A_COVER!$D25)","v":"[Plan 15]"},{"$f":"IF(A_COVER!$D26=\"\",\"[Plan 16]\",A_COVER!$D26)","v":"[Plan 16]"},{"$f":"IF(A_COVER!$D27=\"\",\"[Plan 17]\",A_COVER!$D27)","v":"[Plan 17]"},{"$f":"IF(A_COVER!$D28=\"\",\"[Plan 18]\",A_COVER!$D28)","v":"[Plan 18]"},{"$f":"IF(A_COVER!$D29=\"\",\"[Plan 19]\",A_COVER!$D29)","v":"[Plan 19]"},{"$f":"IF(A_COVER!$D30=\"\",\"[Plan 20]\",A_COVER!$D30)","v":"[Plan 20]"},{"$f":"IF(A_COVER!$D31=\"\",\"[Plan 21]\",A_COVER!$D31)","v":"[Plan 21]"},{"$f":"IF(A_COVER!$D32=\"\",\"[Plan 22]\",A_COVER!$D32)","v":"[Plan 22]"},{"$f":"IF(A_COVER!$D33=\"\",\"[Plan 23]\",A_COVER!$D33)","v":"[Plan 23]"},{"$f":"IF(A_COVER!$D34=\"\",\"[Plan 24]\",A_COVER!$D34)","v":"[Plan 24]"},{"$f":"IF(A_COVER!$D35=\"\",\"[Plan 25]\",A_COVER!$D35)","v":"[Plan 25]"},{"$f":"IF(A_COVER!$D36=\"\",\"[Plan 26]\",A_COVER!$D36)","v":"[Plan 26]"},{"$f":"IF(A_COVER!$D37=\"\",\"[Plan 27]\",A_COVER!$D37)","v":"[Plan 27]"},{"$f":"IF(A_COVER!$D38=\"\",\"[Plan 28]\",A_COVER!$D38)","v":"[Plan 28]"},{"$f":"IF(A_COVER!$D39=\"\",\"[Plan 29]\",A_COVER!$D39)","v":"[Plan 29]"},{"$f":"IF(A_COVER!$D40=\"\",\"[Plan 30]\",A_COVER!$D40)","v":"[Plan 30]"},{"$f":"IF(A_COVER!$D41=\"\",\"[Plan 31]\",A_COVER!$D41)","v":"[Plan 31]"},{"$f":"IF(A_COVER!$D42=\"\",\"[Plan 32]\",A_COVER!$D42)","v":"[Plan 32]"},{"$f":"IF(A_COVER!$D43=\"\",\"[Plan 33]\",A_COVER!$D43)","v":"[Plan 33]"},{"$f":"IF(A_COVER!$D44=\"\",\"[Plan 34]\",A_COVER!$D44)","v":"[Plan 34]"},{"$f":"IF(A_COVER!$D45=\"\",\"[Plan 35]\",A_COVER!$D45)","v":"[Plan 35]"}]
["Set values (select one) or use free text for \"other\" response","Free text","Free text","Set values (select one)","Free text","Set values (select one) or use free text for \"other\" response","Free text. For measures that are not part of standardized national measure sets (i.e. state-specific measures), states should provide a description of the measure (for example, numerator and denominator).","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text","Free text"]
["Topic VII. Quality and Performance Measures"]
["Primary care access and preventive care"]
["Maternal and perinatal health"]
["Care of acute and chronic conditions"]
["Behavioral health care"]
["Dental and oral health services"]
["Health plan enrollee experience of care"]
["Long-term services and supports"]
["Other (free text, specify)"]

{"sheet":"D3_PLAN_free-indc_sanc","index":8,"n_rows":7,"n_cols":10,"rows_kept":7,"merged":[[1,0,1,9],[3,0,3,9]]}
["D3. Plan-level, state-specific indicators: Sanctions and Corrective Action Plans "]
["Context: 42 CFR 438.66(e)(2)(viii) specifies that the MCPAR include the results of any sanctions or corrective action plans imposed by the State or other formal or informal intervention with a contracted MCO, PIHP, PAHP, or PCCM entity to improve performance."]
[]
["Describe sanctions and corrective action plans that the state has issued to the plan by selecting drop downs or entering information in the beige cells in columns A-J. Report all known actions across the following domains: sanctions, administrative penalties, corrective action plans, other. Use one row per action. "]
["Domain","Intervention type","Intervention topic","Plan name","Reason for intervention","Instances (#) of noncompliance","Amount","Date assessed","Remediation date non-compliance was corrected","Has plan had CAP or had an intervention for similar reasons within the previous two years"]
["Set values (select one) or use free text for \"other\" response","Set values (select one) or use free text for \"other\" response","Set values (select multiple) or use free text for \"other\" response","Set values (select one)\nNote: list will autopopulate with plan names listed on the cover","Free text","Count","Dollar","Date (MM/DD/YYYY)","Date (MM/DD/YYYY)","Set values (select one)"]
["Topic VIII. Sanctions and Corrective Action Plans"]

{"sheet":"E_BSS_set-indc","index":9,"n_rows":7,"n_cols":14,"rows_kept":7,"merged":[[1,0,1,3]]}
["E. Beneficiary support system (BSS) entities, set indicators"]
["Context: Per 42 CFR 438.66(e)(2)(ix), the Managed Care Program Annual Report must provide information on and an assessment of the operation of the managed care program including activities and performance of the beneficiary support system. Information on how BSS entities support program-level functions is reported in tab C1, Topic IX."]
[{"$nulls":4},"Input data in the beige cells in these columns >>"]
["#","Indicator","Instructions and definition","Data format",{"$f":"IF(A_COVER!$D46=\"\",\"[BSS Entity 1]\",A_COVER!$D46)","v":"[BSS Entity 1]"},{"$f":"IF(A_COVER!$D47=\"\",\"[BSS Entity 2]\",A_COVER!$D47)","v":"[BSS Entity 2]"},{"$f":"IF(A_COVER!$D48=\"\",\"[BSS Entity 3]\",A_COVER!$D48)","v":"[BSS Entity 3]"},{"$f":"IF(A_COVER!$D49=\"\",\"[BSS Entity 4]\",A_COVER!$D49)","v":"[BSS Entity 4]"},{"$f":"IF(A_COVER!$D50=\"\",\"[BSS Entity 5]\",A_COVER!$D50)","v":"[BSS Entity 5]"},{"$f":"IF(A_COVER!$D51=\"\",\"[BSS Entity 6]\",A_COVER!$D51)","v":"[BSS Entity 6]"},{"$f":"IF(A_COVER!$D52=\"\",\"[BSS Entity 7]\",A_COVER!$D251)","v":"[BSS Entity 7]"},{"$f":"IF(A_COVER!$D53=\"\",\"[BSS Entity 8]\",A_COVER!$D53)","v":"[BSS Entity 8]"},{"$f":"IF(A_COVER!$D54=\"\",\"[BSS Entity 9]\",A_COVER!$D54)","v":"[BSS Entity 9]"},{"$f":"IF(A_COVER!$D55=\"\",\"[BSS Entity 10]\",A_COVER!$D55)","v":"[BSS Entity 10]"}]
["Topic IX. Beneficiary Support System "]
["E.IX.1","BSS entity type","Select type of entity contracted to perform each BSS activity specified at 42 CFR 438.71(b). ","Set values (select multiple) or use free text for \"other\" response"]
["E.IX.2","BSS entity role","Select roles that the contracted BSS entity performs, specified at 42 CFR 438.71(b). ","Set values (select multiple) or use free text for \"other\" response"]

{"sheet":"Glossary","index":10,"n_rows":23,"n_cols":3,"rows_kept":23}
["Glossary "]
["This tab defines key terms used in the workbook. DO NOT INPUT INFORMATION INTO THIS TAB."]
[]
["Term","Acronym","Definition/ specification"]
["Beneficiary Support System","BSS","As defined at 42 CFR 438.71, a BSS provides support to beneficiaries both prior to and after enrollment in a MCO, PIHP, PAHP, PCCM or PCCM entity. The BSS must provide at a minimum: (i) Choice counseling for all beneficiaries, (ii) Assistance for enrollees in understanding managed care. (iii) Assistance as specified for enrollees who use, or express a desire to receive, LTSS in paragraph (d) of this section. (2) The beneficiary support system must perform outreach to beneficiaries and/or authorized representatives and be accessible in multiple ways including phone, Internet, in-person, and via auxiliary aids and services when requested....(d) Functions specific to LTSS activities: (1) An access point for complaints and concerns about plan enrollment, access to covered services, and other related matters. (2) Education on enrollees' grievance and appeal rights; the State fair hearing process; enrollee rights and responsibilities; and additional resources outside of the MCO, PIHP or PAHP. (3) Assistance, upon request, in navigating the plan grievance and appeal process, as well as appealing adverse benefit determinations by a plan to a State fair hearing. (4) Review and oversight of LTSS program data to provide guidance to the State Medicaid Agency on identification, remediation and resolution of systemic issues."]
["Corrective action plan","CAP","A corrective action plan is a step by step plan of action that is developed to achieve targeted outcomes for resolution of identified errors in an effort to: (1) identify the most cost-effective actions that can be implemented to correct error causes; (2) develop and implement a plan of action to improve  processes or methods so that outcomes are more effective and efficient; (3) achieve measureable improvement in the highest priority areas; and (4) eliminate repeated deficient practices."]
["Critical incident","--","CMS uses the term \"critical incident\" to refer to events that adversely impact enrollee health and welfare and the achievement of quality outcomes identified in the person‐centered plan. However, the exact definition of \"critical incident\" and the categories that managed care plans are required to report is defined by each state. "]
["Encounter data validation ","--","The act of verifying the accuracy, completeness, timeliness, and/or consistency of encounter data records submitted to the state by Medicaid managed care plans. Validation steps may include pre-acceptance edits and post-acceptance analyses. See the 2019 State Toolkit for Validating Medicaid Encounter Data for examples of intrafield, interfield, interfile and intersource validation tests that states can use to evaluate encounter data quality. The toolkit is available at: https://www.medicaid.gov/medicaid/downloads/ed-validation-toolkit.pdf."]
["LTSS user","--","An LTSS user is an enrollee who received at least one LTSS service at any point during the reporting year (regardless of whether the enrollee was actively receiving LTSS at the time that the grievance was filed)."]
["Managed care organization","MCO","Consistent with 42 CFR 438.2, Managed care organization (MCO) means an entity that has, or is seeking to qualify for, a comprehensive risk contract under this part, and that is (1) A Federally qualified HMO that meets the advance directives requirements of subpart I of part 489 of this chapter; or (2) Any public or private entity that meets the advance directives requirements and is determined by the Secretary to also meet the following conditions: (i) Makes the services it provides to its Medicaid enrollees as accessible (in terms of timeliness, amount, duration, and scope) as those services are to other Medicaid beneficiaries within the area served by the entity, (ii) Meets the solvency standards of § 438.116."]
["Managed care plan","MCP","Consistent with 42 CFR 438.66, this document uses the term “managed care plan” to refer to MCO, PIHP, PAHP, and PCCM entities"]
["Managed care program","--","Consistent with 42 CFR 438.2, Managed care program means a managed care delivery system operated by a State as authorized under sections 1915(a), 1915(b), 1932(a), or 1115(a) of the Act. For purposes of the MCPAR, a program is defined by a specified set of benefits and eligibilty criteria that is articulated in a contract between the state and managed care plans, and that has associated rate cells."]
["Managed long-term services and supports","MLTSS","Managed Long Term Services and Supports (MLTSS) refers to the delivery of long term services and supports through capitated Medicaid managed care programs. "]
["Medical Loss Ratio","MLR","As specified under 42 CFR 438.8(d)-(h), MLR is the sum of an MCP’s incurred claims, quality expenditures, and fraud prevention expenditures divided by its adjusted premium revenue. The MCP’s adjusted premium revenue is its aggregated premium revenue minus taxes, licensing, and regulatory fees. For states that mandate minimum MLR values for MCPs, minimum values must be at least 85 percent under 42 CFR 438.8(c)."]
["Non-emergency medical transportation","NEMT","Medicaid agencies are reqired to ensure necessary transportation for beneficiaries to and from providers. For situations that do not involve an immediate threat to the life or health of an individual, this requirement is usually called “non-emergency medical transportation,” or NEMT."]
["Premium deficiency reserve","PDR","Premium deficiency reserve (PDR) indicates whether future premiums plus current reserves are enough to cover future claim payments and expenses for the remainder of a contract period."]
["Prepaid ambulatory health plan","PAHP","Consistent with 42 CFR 438.2, Prepaid ambulatory health plan (PAHP) means an entity that (1) Provides services to enrollees under contract with the State, and on the basis of capitation payments, or other payment arrangements that do not use State plan payment rates; (2) Does not provide or arrange for, and is not otherwise responsible for the provision of any inpatient hospital or institutional services for its enrollees; and (3) Does not have a comprehensive risk contract."]
["Prepaid inpatient health plan","PIHP","Consistent with 42 CFR 438.2, Prepaid inpatient health plan (PIHP) means an entity that (1) Provides services to enrollees under contract with the State, and on the basis of capitation payments, or other payment arrangements that do not use State plan payment rates; (2) Provides, arranges for, or otherwise has responsibility for the provision of any inpatient hospital or institutional services for its enrollees; and (3) Does not have a comprehensive risk contract."]
["Primary care case management","PCCM ","Consistent with 42 CFR 438.2, Primary care case management means a system under which: (1) A primary care case manager (PCCM) contracts with the State to furnish case management services (which include the location, coordination and monitoring of primary health care services) to Medicaid beneficiaries; or (2) A PCCM entity contracts with the State to provide a defined set of functions."]
["Primary care case management entity","PCCM entity","Consistent with 42 CFR 438.2, Primary care case management entity (PCCM entity) means an organization that provides any of the following functions, in addition to primary care case management services, for the State: (1) Provision of intensive telephonic or face-to-face case management, including operation of a nurse triage advice line; (2) Development of enrollee care plans; (3) Execution of contracts with and/or oversight responsibilities for the activities of FFS providers in the FFS program; (4) Provision of payments to FFS providers on behalf of the State; (5) Provision of enrollee outreach and education activities; (6) Operation of a customer service call center; (7) Review of provider claims, utilization and practice patterns to conduct provider profiling and/or practice improvement; (8) Implementation of quality improvement activities including administering enrollee satisfaction surveys or collecting data necessary for performance measurement of providers; (9) Coordination with behavioral health systems/providers; (10) Coordination with long-term services and supports systems/providers."]
["Reporting period /Reporting year","--","The 12-month period of the contract term (i.e. the contract year) for which the state is reporting information to CMS. Reporting year may also correspond to “rating period.” "]
["Risk-based capital","RBC","Risk-based capital (RBC) measures the percentage of the required minimum capital that the MCP is holding. The MCP’s minimum capital is calculated using a standard formula that measures the risk of insolvency. "]
["Sanction",null,"Sanctions are enforcement actions taken against a managed care plans. Such actions include monetary and other forms of remedies, such as suspending all or part of new member enrollments, and suspending or terminating all or part of the contract."]

{"sheet":"Crosswalk","index":11,"n_rows":151,"n_cols":12,"rows_kept":151,"merged":[[3,6,3,7],[3,8,3,10],[4,9,4,10],[6,1,6,2],[11,1,11,2],[60,0,60,2],[84,0,84,2],[95,0,95,2],[149,0,149,11]]}
["Crosswalk of MCPAR indicators by tab"]
[]
[{"$nulls":3},"Tab identifier Ø ","A","B","C1","C2","D1","D2","D3","E"]
[{"$nulls":3},"Reporting level Ø  ","Cover sheet","State-level","Program-level",null,"Plan-level",null,null,"BSS-level"]
[{"$nulls":3},"Indicator type* Ø","Set","Set","Set","Free","Set","Free",null,"Set"]
["#","Indicator","Instructions and definition","Data format"]
["n/a","Identifying information on the state, program, plan, and BSS being reported",null,null,"X"]
["n/a","Point of contact and email address","(see Tab A)",null,"X"]
["n/a","Date of report submission","(see Tab A)",null,"X"]
["n/a","Reporting period start and end date","(see Tab A)",null,"X"]
["n/a","Name of the state, program, plans, and BSS entities being reported on","(see Tab A)",null,"X"]
["I","Program Characteristics and Enrollment**",{"$nulls":3},"X","X",null,"X"]
["B.I.1","Statewide Medicaid enrollment ","Enter the total number of individuals enrolled in Medicaid as of the first day of the last month of the reporting year. Include all FFS and managed care enrollees, and count each person only once, regardless of the delivery system(s) in which they are enrolled.","Count",null,"X"]
["B.I.2","Statewide Medicaid managed care enrollment ","Enter the total, unduplicated number of individuals enrolled in any type of Medicaid managed care as of the first day of the last month of the reporting year. Include enrollees in all programs, and count each person only once, even if they are enrolled in more than one managed care program or more than one managed care plan.","Count",null,"X"]
["C1.I.1","Program contract","Enter the title and date of the contract between the state and plans participating in the managed care program.","Free Text",null,null,"X"]
["C1.I.2","Contract URL","Enter the hyperlink to the model contract or landing page for executed contracts for the program being reported in the MCPAR.  ","Free Text (hyperlink)",null,null,"X"]
["C1.I.3","Program type","Select the type of MCPs that contract with the state to provide the services covered under the program. Select one of the allowed values.","Set values (select one)",null,null,"X"]
["C1.I.4.a","Special program benefits","CMS is interested in knowing whether one or more of the following four special benefit types are covered by the managed care program: (1) behavioral health, (2) long-term services and supports, (3) dental, and (4) transportation, or (5) none of the above. Select one or more of the allowed values.  (Note: Only list the benefit type if it is a covered service as specified in a contract between the state and managed care plans participating in the program. Benefits available to eligible program enrollees via fee-for-service should not be listed here.)","Set values (select multiple)",null,null,"X"]
["C1.I.4.b","Variation in special benefits","Please note any variation in the availability of special benefits  within the program (e.g. by service area or population). Enter \"N/A\" if not applicable.","Free text",null,null,"X"]
["C1.I.5","Program enrollment","Enter the total number of individuals enrolled in the managed care program as of the first day of the last month of the reporting year. ","Count",null,null,"X"]
["C1.I.6","Changes to enrollment or benefits ","Provide a brief explanation of any major changes to the population enrolled in or benefits provided by the managed care program during the reporting year. ","Free text",null,null,"X"]
["D1.I.1","Plan enrollment","Enter total number of individuals enrolled in each plan as of the first day of the last month of the reporting year. ","Count",{"$nulls":4},"X"]
["D1.I.2","Plan share of Medicaid","Sum of enrollment in the plan (within the specific program) as a percentage of total Medicaid enrollment in the state \n• Numerator: Plan enrollment (indicator D1.I.1)\n• Denominator: Statewide Medicaid enrollment (indicator B.I.1) ","Percentage (calculated) \nNote: No data entry required; this cell is autopopulated",{"$nulls":4},"X"]
["D1.I.3","Plan share of any Medicaid managed care","Sum of enrollment in a given plan (regardless of program) as a percentage of total Medicaid enrollment in any type of managed care. \n• Numerator: Plan enrollment (indicator D1.I.1)\n• Denominator: Statewide Medicaid managed care enrollment (indicator B.I.2) ","Percentage (calculated) \nNote: No data entry required; this cell is autopopulated",{"$nulls":4},"X"]
["II","Financial Performance",{"$nulls":6},"X"]
["D1.II.1a","Medical Loss Ratio (MLR): Aggregate value","Per 42 CFR 438.66(e)(2)(i), the Managed Care Program Annual Report must provide information on the Financial performance of each MCO, PIHP, and PAHP, including MLR experience. Indicate below in D1.II.1b the level of aggregation of the reported MLR. If MLR data are not available for this reporting period due to data lags, enter the MLR calculated for the most recently available reporting period and indicate the reporting period in item D1.II.4 below. See glossary for the regulatory definition of MLR. ","Percentage ",{"$nulls":4},"X"]
["D1.II.1b","Aggregate MLR value: Level of aggregation","As permitted under 42 CFR 438.8(i), states are allowed to aggregate data for reporting purposes across programs and populations.  Select the aggregation level that best describes the MLR being reported in indicator D1.II.1a for each plan.","Set values (select one) or use free text for \"other\" response",{"$nulls":4},"X"]
["D1.II.2","Population specific MLR description","If the state requires plans to submit separate MLR calculations for specific populations served within this program, for example, MLTSS or Group VIII expansion enrollees, describe the populations here. If the state does not require this, write \"N/A.\" See glossary for the regulatory definition of MLR. ","Free text",{"$nulls":4},"X"]
["D1.II.3","MLR reporting period discrepancies","If the data reported in items D1.II.1a covers a different time period than the MCPAR report, use this space to note the start and end date for that data.","Free text",{"$nulls":4},"X"]
["III","Encounter Data Reporting",{"$nulls":3},"X","X",null,"X"]
["B.III.1","Data validation entity","Select the state agency/division or contractor) tasked with evaluating the validity of encounter data submitted by MCPs. Encounter data validation includes verifying the accuracy, completeness, timeliness, and/or consistency of encounter data records submitted to the state by Medicaid managed care plans. Validation steps may include pre-acceptance edits and post-acceptance analyses. (See Glossary defintion for more information.)","Set values (select multiple) or use free text for \"other\" response",null,"X"]
["B.III.2","HIPAA compliance of proprietary system(s) for encounter data validation","If state selected “proprietary system(s)” in indicator B.III.1, indicate whether the system(s) utilized are fully HIPAA compliant.","Set values (select one)",null,"X"]
["C1.III.1","Uses of encounter data","Federal regulations require that states, through their contracts with MCPs, collect and maintain sufficient enrollee encounter data to identify the provider who delivers any item(s) or service(s) to enrollees (42 CFR 438.242(c)(1)). Select purposes for which the state uses encounter data collected from managed care plans (MCPs).","Set values (select multiple) or use free text for \"other\" response",null,null,"X"]
["C1.III.2","Criteria/ measures used to evaluate MCP performance","Federal regulations also require that states validate that submitted enrollee encounter data they receive is a complete and accurate representation of the services provided to enrollees under the contract between the state and the MCO, PIHP, or PAHP. 42 CFR 438.242(d). Select types of measures used by the state to evaluate managed care plan performance in encounter data submission and correction.","Set values (select multiple) or use free text for \"other\" response",null,null,"X"]
["C1.III.3","Encounter data performance criteria contract language","Enter reference(s) to the contract section(s) that describe the criteria by which managed care plan performance on encounter data submission and correction will be measured. Use contract section references, not page numbers.","Free text",null,null,"X"]
["C1.III.4","Financial penalties contract language ","Enter reference to the contract section that describes the types of failures to meet encounter data submission standards for which states may impose financial sanction(s) related to encounter data quality. \nUse contract section references, not page numbers.","Free text",null,null,"X"]
["C1.III.5","Incentives for encounter data quality","Describe the types of incentives that may be awarded to managed care plans for encounter data quality","Free text",null,null,"X"]
["C1.III.6","Barriers to collecting/validating encounter data","Describe any barriers to collecting and/or validating managed care plan encounter data that the state has experienced during the reporting period.","Free text",null,null,"X"]
["D.1.III.1","Definition of timely encounter data submissions","Describe the state's standard for timely encounter data submissions.","Free text",{"$nulls":4},"X"]
["D1.III.2","Share of encounter data submissions that met state’s timely submission requirements","Enter the percentage of the plan’s encounter data file submissions (submitted during the reporting period) that met state requirements for timely submission. If the state has not yet received any encounter data file submissions for the entire contract period when it submits this report, the state should enter here the percentage of encounter data submissions that were compliant out of the file submissions it has received from the managed care plan for the reporting period.","Percentage ",{"$nulls":4},"X"]
["D1.III.3","Share of encounter data submissions that were HIPAA compliant","Enter the percentage of the plan’s encounter data submissions (submitted during the reporting period) that met state requirements for HIPAA compliance. If the state has not yet received encounter data submissions for the entire contract period when it submits this report, enter here percentage of encounter data submissions that were compliant out of the proportion received from the managed care plan for the reporting period.","Percentage",{"$nulls":4},"X"]
["IV","Grievance, Appeals, and State Fair Hearings",{"$nulls":4},"X",null,"X"]
["C1.IV.1","State's definition of \"critical incident,\" as used for reporting purposes in its MLTSS program","If this report is being completed for a managed care program that covers LTSS, provide the definition that the state uses for \"critical incidents\" within the managed care program. If the managed care program does not cover LTSS, the state should respond \"N/A.\"","Free text or N/A",null,null,"X"]
["C1.IV.2","State definition of \"timely\" resolution for standard appeals","Per 42 CFR §438.408(b)(2), states must establish a timeframe for timely resolution of standard appeals that is no longer than 30 calendar days from the day the MCO, PIHP or PAHP receives the appeal. Describe the state's definition of timely resolution for standard appeals in the managed care program.","Free text",null,null,"X"]
["C1.IV.3","State definition of \"timely\" resolution for expedited appeals","Per 42 CFR §438.408(b)(3), states must establish a timeframe for timely resolution of expedited appeals that is no longer than 72 hours after the MCO, PIHP or PAHP receives the appeal. Describe in the state's definition of timely resolution for expedited appeals in the managed care program.","Free text",null,null,"X"]
["C1.IV.4","State definition of \"timely\" resolution for grievances","Per 42 CFR §438.408(b)(1), states must establish a timeframe for timely resolution of grievances that is no longer than 90 calendar days from the day the MCO, PIHP or PAHP receives the grievance. Describe the state's definition of timely resolution for grievances in the managed care program.","Free text",null,null,"X"]
[null,"Subtopic: Appeals ",{"$nulls":6},"X"]
["D1.IV.1","Appeals resolved (at the plan level)","Enter the total number of appeals resolved as of the first day of the last month of the reporting year. An appeal is \"resolved\" at the plan level when the plan has issued a decision, regardless of whether the decision was wholly or partially favorable or adverse to the beneficiary, and regardless of whether the beneficiary (or the beneficiary's representative) chooses to file a request for a State Fair Hearing or External Medical Review.","Count",{"$nulls":4},"X"]
["D1.IV.2","Active appeals","Enter the total number of appeals still pending or in process (not yet resolved) as of the first day of the last month of the reporting year. ","Count",{"$nulls":4},"X"]
["D1.IV.3","Appeals filed on behalf of LTSS users","Enter the total number of appeals filed during the reporting year by or on behalf of LTSS users. An LTSS user is an enrollee who received at least one LTSS service at any point during the reporting year (regardless of whether the enrollee was actively receiving LTSS at the time that the appeal was filed). If not applicable, write \"N/A.\"","Count",{"$nulls":4},"X"]
["D1.IV.4","Number of critical incidents filed during the reporting period by (or on behalf of) an LTSS user who previously filed an appeal","For managed care plans that cover LTSS, enter the number of critical incidents filed within the reporting period by (or on behalf of) LTSS users who previously filed appeals in the reporting year. The appeal and critical incident do not have to have been \"related\" to the same issue  - they only need to have been filed by (or on behalf of) the same enrollee. Neither the critical incident nor the appeal need to have been filed in relation to delivery of LTSS - they may have been filed for any reason, related to any service received (or desired) by an LTSS user.  If the managed care plan does not cover LTSS, the state should write \"N/A\" in this field. Additionally, if the state already submitted this data for the reporting year via the CMS readiness review appeal and grievance report (because the managed care program or plan were new or serving new populations during the reporting year), and the readiness review tool was submitted for at least 6 months of the reporting year, the state can write \"N/A\" in this field. To calculate this number, states or managed care plans should first identify the LTSS users for whom critical incidents were filed during the reporting year, then determine whether those enrollees had filed an appeal during the reporting year, and whether the filing of the appeal preceded the filing of the critical incident.","Count or N/A",{"$nulls":4},"X"]
["D1.IV.5a","Standard appeals for which timely resolution was provided","Enter the total number of standard appeals for which timely resolution was provided by plan during the reporting period. (See 42 CFR §438.408(b)(2) for requirements related to timely resolution of standard appeals.)","Count",{"$nulls":4},"X"]
["D1.IV.5b","Expedited appeals for which timely resolution was provided","Enter the total number of expedited appeals for which timely resolution was provided by plan during the reporting period. (See 42 CFR §438.408(b)(3) for requirements related to timely resolution of standard appeals.)","Count",{"$nulls":4},"X"]
["D1.IV.6a","Appeals related to denial of authorization or limited authorization of a service ","Enter the total number of appeals resolved by the plan during the reporting year that were related to the plan's denial of authorization for a service not yet rendered or limited authorization of a service. (Appeals related to denial of payment for a service already rendered should be counted in indicator D1.IV.6c)","Count",{"$nulls":4},"X"]
["D1.IV.6b","Appeals related to reduction, suspension, or termination of a previously authorized service","Enter the total number of appeals resolved by the plan during the reporting year that were related to the plan's reduction, suspension, or termination of a previously authorized service.","Count",{"$nulls":4},"X"]
["D1.IV.6c","Appeals related to payment denial","Enter the total number of appeals resolved by the plan during the reporting year that were related to the plan's denial, in whole or in part, of payment for a service that was already rendered.","Count",{"$nulls":4},"X"]
["D1.IV.6d","Appeals related to service timeliness","Enter the total number of appeals resolved by the plan during the reporting year that were related to the plan's failure to provide services in a timely manner (as defined by the state).","Count",{"$nulls":4},"X"]
["D1.IV.6e","Appeals related to lack of timely plan response to an appeal or grievance","Enter the total number of appeals resolved by the plan during the reporting year that were related to the plan's failure to act within the timeframes provided at 42 CFR §438.408(b)(1) and (2) regarding the standard resolution of grievances and appeals.","Count",{"$nulls":4},"X"]
["D1.IV.6f","Appeals related to plan denial of an enrollee's right to request out-of-network care","Enter the total number of appeals resolved by the plan during the reporting year that were related to the plan's denial of an enrollee's request to exercise their right, under 42 CFR §438.52(b)(2)(ii), to obtain services outside the network (only applicable to residents of rural areas with only one MCO)","Count",{"$nulls":4},"X"]
["D1.IV.6g","Appeals related to denial of an enrollee's request to dispute financial liability","Enter the total number of appeals resolved by the plan during the reporting year that were related to the plan's denial of an enrollee's request to dispute a financial liability.","Count",{"$nulls":4},"X"]
["Number of appeals resolved during the reporting period related to the following services: \n(A single appeal may be related to multiple service types and may therefore be counted in multiple categories below.)",{"$nulls":7},"X"]
["D1.IV.7a","Appeals related to general inpatient services","Enter the total number of appeals resolved by the plan during the reporting year that were related to general inpatient care, including diagnostic and laboratory services. Please do not include appeals related to inpatient behavioral health services  – those should be included in indicator D1.IV.7c. If the managed care plan does not cover general inpatient services, enter \"N/A\".","Count",{"$nulls":4},"X"]
["D1.IV.7b","Appeals related to general outpatient services","Enter the total number of appeals resolved by the plan during the reporting year that were related to general outpatient care, including diagnostic and laboratory services. Please do not include appeals related to outpatient behavioral health services  – those should be included in indicator D1.IV.7d. If the managed care plan does not cover general outpatient services, enter \"N/A\".","Count",{"$nulls":4},"X"]
["D1.IV.7c","Appeals related to inpatient behavioral health services","Enter the total number of appeals resolved by the plan during the reporting year that were related to inpatient mental health and/or substance use services. If the managed care plan does not cover inpatient behavioral health services, enter \"N/A\".","Count",{"$nulls":4},"X"]
["D1.IV.7d","Appeals related to outpatient behavioral health services","Enter the total number of appeals resolved by the plan during the reporting year that were related to outpatient mental health and/or substance use services. If the managed care plan does not cover outpatient behavioral health services, enter \"N/A\".","Count",{"$nulls":4},"X"]
["D1.IV.7e","Appeals related to covered outpatient prescription drugs","Enter the total number of appeals resolved by the plan during the reporting year that were related to outpatient prescription drugs covered by the managed care plan. If the managed care plan does not cover oupatient prescription drugs, enter \"N/A\".","Count",{"$nulls":4},"X"]
["D1.IV.7f","Appeals related to skilled nursing facility (SNF) services","Enter the total number of appeals resolved by the plan during the reporting year that were related to SNF services. If the managed care plan does not cover skilled nursing services, enter \"N/A\".","Count",{"$nulls":4},"X"]
["D1.IV.7g","Appeals related to long-term services and supports (LTSS)","Enter the total number of appeals resolved by the plan during the reporting year that were related to institutional LTSS or LTSS provided through home and community-based (HCBS) services, including personal care and self-directed services. If the managed care plan does not cover LTSS services, enter \"N/A\".","Count",{"$nulls":4},"X"]
["D1.IV.7h","Appeals related to dental services","Enter the total number of appeals resolved by the plan during the reporting year that were related to dental services. If the managed care plan does not cover dental services, enter \"N/A\".","Count",{"$nulls":4},"X"]
["D1.IV.7i","Appeals related to non-emergency medical transportation (NEMT)","Enter the total number of appeals resolved by the plan during the reporting year that were related to NEMT. If the managed care plan does not cover NEMT, enter \"N/A\".","Count",{"$nulls":4},"X"]
["D1.IV.7j","Appeals related to other service types","Enter the total number of appeals resolved by the plan during the reporting year that were related to services that do not fit into one of the categories listed above. If the managed care plan does not cover services other than those in items D1.IV.7a-i, enter \"N/A\".","Count",{"$nulls":4},"X"]
[null,"Subtopic: State Fair Hearings and External Medical Reviews By Originating Plan",{"$nulls":6},"X"]
["D1.IV.8a","State Fair Hearing requests","Enter the total number of requests for a  State Fair Hearing filed during the reporting year by or on behalf of enrollees from the plan that issued the adverse benefit determination.","Count",{"$nulls":4},"X"]
["D1.IV.8b","State Fair Hearings resulting in a favorable decision  for the enrollee","Enter the total number of State Fair Hearing decisions rendered during the reporting year that were partially or fully favorable to the enrollee. ","Count",{"$nulls":4},"X"]
["D1.IV.8c","State Fair Hearings resulting in an adverse decision for the enrollee","Enter the total number of State Fair Hearing decisions rendered during the reporting year that were adverse for the enrollee. ","Count",{"$nulls":4},"X"]
["D1.IV.8d","State Fair Hearings retracted prior to reaching a decision","Enter the total number of State Fair Hearing decisions retracted (by the enrollee or the representative who filed a State Fair Hearing request on behalf of the enrollee) prior to reaching a decision","Count",{"$nulls":4},"X"]
["D1.IV.9a","External Medical Reviews resulting in a favorable decision for the enrollee","External medical review is defined and described at 42 CFR §438.402(c)(i)(B). If your state does not offer an external medical review process, please enter N/A. If your state does offer an external medical review process, provide the total number of external medical review decisions rendered during the reporting year that were partially or fully favorable to the enrollee.","Count or N/A",{"$nulls":4},"X"]
["D1.IV.9b","External Medical Reviews resulting in an  adverse decision for the enrollee","External medical review is defined and described at 42 CFR §438.402(c)(i)(B). If your state does not offer an external medical review process, please enter N/A. If your state does offer an external medical review process, enter the total number of external medical review decisions rendered during the reporting year that were adverse to the enrollee.","Count or N/A",{"$nulls":4},"X"]
[null,"Subtopic: Grievances",{"$nulls":6},"X"]
["D1.IV.10","Grievances resolved","Enter the total number of grievances resolved by the plan during the reporting year. A grievance is \"resolved\" when it has reached completion and been closed by the plan.","Count",{"$nulls":4},"X"]
["D1.IV.11","Active grievances","Enter the total number of grievances still pending or in process (not yet resolved) as of the first day of the last month of the reporting year. ","Count",{"$nulls":4},"X"]
["D1.IV.12","Grievances filed on behalf of LTSS users","Enter the total number of grievances filed during the reporting year by or on behalf of LTSS users. An LTSS user is an enrollee who received at least one LTSS service at any point during the reporting year (regardless of whether the enrollee was actively receiving LTSS at the time that the grievance was filed).","Count",{"$nulls":4},"X"]
["D1.IV.13","Number of critical incidents filed during the reporting period by (or on behalf of) an LTSS user who previously filed a grievance","For managed care plans that cover LTSS, enter the number of critical incidents filed within the reporting period by (or on behalf of) LTSS users who previously filed grievances in the reporting year. The grievance and critical incident do not have to have been \"related\" to the same issue  - they only need to have been filed by (or on behalf of) the same enrollee. Neither the critical incident nor the grievance need to have been filed in relation to delivery of LTSS - they may have been filed for any reason, related to any service received (or desired) by an LTSS user.  If the managed care plan does not cover LTSS, the state should enter \"N/A\" in this field. Additionally, if the state already submitted this data for the reporting year via the CMS readiness review appeal and grievance report (because the managed care program or plan were new or serving new populations during the reporting year), and the readiness review tool was submitted for at least 6 months of the reporting year, the state can enter \"N/A\" in this field.  To calculate this number, states or managed care plans should first identify the LTSS users for whom critical incidents were filed during the reporting year, then determine whether those enrollees had filed an appeal during the reporting year, and whether the filing of the appeal preceded the filing of the critical incident.","Count ",{"$nulls":4},"X"]
["D1.IV.14","Number of grievances for which timely resolution was provided","Enter the number of grievances for which timely resolution was provided by plan  during the reporting period. (See 42 CFR §438.408(b)(1) for requirements related to the timely resolution of grievances.)","Count",{"$nulls":4},"X"]
["Number of grievances resolved by plan during the reporting period related to the following services: \n(A single grievance may be related to multiple service types and may therefore be counted in multiple categories below.)",null,null,"(none)",{"$nulls":4},"X"]
["D1.IV.15a","Grievances related to general inpatient services","Enter the total number of grievances resolved by the plan during the reporting year that were related to general inpatient care, including diagnostic and laboratory services. Please do not include grievances related to inpatient behavioral health services – those should be included in indicator D1.IV.15c. If the managed care plan does not cover this type of service, enter \"N/A\".","Count",{"$nulls":4},"X"]
["D1.IV.15b","Grievances related to general outpatient services","Enter the total number of grievances resolved by the plan during the reporting year that were related to general outpatient care, including diagnostic and laboratory services. Please do not include grievances related to outpatient behavioral health services – those should be included in indicator D1.IV.15d.  If the managed care plan does not cover this type of service, enter \"N/A\".","Count",{"$nulls":4},"X"]
["D1.IV.15c","Grievances related to inpatient behavioral health services","Enter the total number of grievances resolved by the plan during the reporting year that were related to inpatient mental health and/or substance use services. If the managed care plan does not cover this type of service, enter \"N/A\".","Count",{"$nulls":4},"X"]
["D1.IV.15d","Grievances related to outpatient behavioral health services","Enter the total number of grievances resolved by the plan during the reporting year that were related to outpatient mental health and/or substance use services. If the managed care plan does not cover this type of service, enter \"N/A\".","Count",{"$nulls":4},"X"]
["D1.IV.15e","Grievances related to coverage of outpatient prescription drugs","Enter the total number of grievances resolved by the plan during the reporting year that were related to outpatient prescription drugs covered by the managed care plan. If the managed care plan does not cover this type of service, enter \"N/A\".","Count",{"$nulls":4},"X"]
["D1.IV.15f","Grievances related to skilled nursing facility (SNF) services","Enter the total number of grievances resolved by the plan during the reporting year that were related to SNF services. If the managed care plan does not cover this type of service, enter \"N/A\".","Count",{"$nulls":4},"X"]
["D1.IV.15g","Grievances related to long-term services and supports (LTSS)","Enter the total number of grievances resolved by the plan during the reporting year that were related to institutional LTSS or LTSS provided through home and community-based (HCBS) services, including personal care and self-directed services. If the managed care plan does not cover this type of service, enter \"N/A\".","Count",{"$nulls":4},"X"]
["D1.IV.15h","Grievances related to dental services","Enter the total number of grievances resolved by the plan during the reporting year that were related to dental services.  If the managed care plan does not cover this type of service, enter \"N/A\".","Count",{"$nulls":4},"X"]
["D1.IV.15i","Grievances related to non-emergency medical transportation (NEMT)","Enter the total number of grievances resolved by the plan during the reporting year that were related to NEMT. If the managed care plan does not cover this type of service, enter \"N/A\".","Count",{"$nulls":4},"X"]
["D1.IV.15j","Grievances related to other service types","Enter the total number of grievances resolved by the plan during the reporting year that were related to services that do not fit into one of the categories listed above. If the managed care plan does not cover services other than those in items D1.IV.15a-i, enter \"N/A\".","Count",{"$nulls":4},"X"]
["Number of grievances resolved by plan during the reporting period related to the following reasons: \n(A single grievance may be related to multiple reasons and may therefore be counted in multiple categories below.)",null,null,"(none)",{"$nulls":4},"X"]
["D1.IV.16a","Grievances related to plan or provider customer service","Enter the total number of grievances resolved by the plan during the reporting year that were related to plan or provider customer service. Customer service grievances include complaints about interactions with the plan's Member Services department, provider offices or facilities, plan marketing agents, or any other plan or provider representatives. ","Count",{"$nulls":4},"X"]
["D1.IV.16b","Grievances related to plan or provider care management/case management","Enter the total number of grievances resolved by the plan during the reporting year that were related to plan or provider care management/case management. Care management/case management grievances include complaints about the timeliness of an assessment or complaints about the plan or provider care or case management process. ","Count",{"$nulls":4},"X"]
["D1.IV.16c","Grievances related to access to care/services from plan or provider","Enter the total number of grievances resolved by the plan during the reporting year that were related to access to care. Access to care grievances include complaints about difficulties finding qualified in-network providers, excessive travel or wait times, or other access issues. ","Count",{"$nulls":4},"X"]
["D1.IV.16d","Grievances related to quality of care","Enter the total number of grievances resolved by the plan during the reporting year that were related to quality of care. Quality of care grievances include complaints about the effectiveness, efficiency, equity, patient-centeredness, safety, and/or acceptability of care provided by a provider or the plan. ","Count",{"$nulls":4},"X"]
["D1.IV.16e","Grievances related to plan communications","Enter the total number of grievances resolved by the plan during the reporting year that were related to plan communications. Plan communication grievances include grievances related to the clarity or accuracy of enrollee materials or other plan communications or to an enrollee's access to or the accessibility of enrollee materials or plan communications.","Count",{"$nulls":4},"X"]
["D1.IV.16f","Grievances related to payment or billing issues","Enter the total number of grievances resolved during the reporting period that were filed for a reason related to payment or billing issues.","Count",{"$nulls":4},"X"]
["D1.IV.16g","Grievances related to suspected fraud","Enter the total number of grievances resolved during the reporting year that were related to suspected fraud. Suspected fraud grievances include suspected cases of financial/payment fraud perpetuated by a provider, payer, or other entity. Note: grievances reported in this row should only include grievances submitted to the managed care plan, not grievances submitted to another entity, such as a state Ombudsman or Office of the Inspector General.","Count",{"$nulls":4},"X"]
["D1.IV.16h","Grievances related to abuse, neglect or exploitation","Enter the total number of grievances resolved during the reporting year that were related to abuse, neglect or exploitation. Abuse/neglect/exploitation grievances include cases involving potential or actual patient harm.","Count",{"$nulls":4},"X"]
["D1.IV.16i","Grievances related to lack of timely plan response to a service authorization or appeal request (including requests to expedite or extend appeals)","Enter the total number of grievances resolved during the reporting year that were filed due to a lack of timely plan response to a service authorization or appeal request (including requests to expedite or extend appeals).","Count",{"$nulls":4},"X"]
["D1.IV.16j","Grievances related to plan denial of request for an expedited appeal","Enter the total number of grievances resolved during the reporting year that were related to the plan's denial of an enrollee's request for an expedited appeal. (Per 42 CFR §438.408(b)(3), states must establish a timeframe for timely resolution of expedited appeals that is no longer than 72 hours after the MCO, PIHP or PAHP receives the appeal. If a plan denies a request for an expedited appeal, the enrollee or their representative have the right to file a grievance.)","Count",{"$nulls":4},"X"]
["D1.IV.16k","Grievances filed for other reasons","Enter the total number of grievances resolved during the reporting period that were filed for a reason other than the reasons listed above.","Count",{"$nulls":4},"X"]
["V","Availability, Accessibility, and Network adequacy",{"$nulls":4},"X","X"]
["C1.V.1","Gaps/challenges in network adequacy","Describe any challenges to maintaining adequate networks and meeting standards. What are the state’s biggest challenges? ","Free text",null,null,"X"]
["C1.V.2","State response to gaps in network adequacy","Describe how the state works with MCPs to address these gaps.","Free text",null,null,"X"]
["C2","State-specific measures used to monitor availability, accessibility, and network adequacy. ","(see Tab C2)",{"$nulls":4},"X"]
["VII","Quality and Performance Measures",{"$nulls":7},"X"]
["D2","State-specific measures used to monitor quality and performance across eight domains: \n(1) Primary care access and preventive care, \n(2) Maternal and perinatal health, \n(3) Care of acute and chronic conditions, \n(4) Behavioral health care, \n(5) Dental and oral health services, \n(6) Health plan enrollee experience of care, \n(7) Long-term services and supports, and \n(8) Other. ","(see Tab D2)",{"$nulls":6},"X"]
["VIII","Sanctions and Corrective Action Plans**",{"$nulls":8},"X"]
["D4","List of sanctions, administrative penalties, and corrective action plans that the state has issued to plans.","(see Tab D4)",{"$nulls":7},"X"]
["IX","Beneficiary Support System (BSS)",null,null,"X","X","X",{"$nulls":4},"X"]
["n/a","Name of the BSS entities being reported on","(see Tab A)","Free text","X"]
["C1.IX.1","BSS website","Indentify the website and/or email address that beneficiaries use to seek assistance from the BSS through electronic means. ","Free text",null,null,"X"]
["C1.IX.2","BSS auxiliary aids and services","42 CFR 438.71 requires that the beneficiary support system be accessible in multiple ways including phone, Internet, in-person, and via auxiliary aids and services when requested. Describe how BSS entities offer services in a manner that is accessible to all beneficiaries who need their services, including beneficiaries with disabilities, as required by 42 CFR 438.71(b)(2)).","Free text",null,null,"X"]
["C1.IX.3","BSS LTSS program data","Describe how BSS entities assist the state with identifying, remediating, and resolving systemic issues based on a review of LTSS program data such as grievances and appeals or critical incident data, as required by 42 CFR 438.71(d)(4).","Free text",null,null,"X"]
["C1.IX.4","State evaluation of BSS entity performance","Describe steps taken by the state to evaluate the quality, effectiveness, and efficiency of the BSS entities' performance.","Free text",null,null,"X"]
["E.IX.1","BSS entity type","Select type of entity contracted to perform each BSS activity specified at 42 CFR 438.71(b). ","Set values (select multiple) or use free text for \"other\" response",{"$nulls":7},"X"]
["E.IX.2","BSS entity role","Select roles that the contracted BSS entity performs, specified at 42 CFR 438.71(b). ","Set values (select multiple) or use free text for \"other\" response",{"$nulls":7},"X"]
["X","Program Integrity",{"$nulls":3},"X","X",null,"X"]
["B.X.1","Payment risks between the state and plans","Describe service-specific or other focused PI activities that the state conducted during the past year in this managed care program (such as analyses focused on use of long-term services and supports [LTSS] or prescription drugs) or activities that focused on specific payment issues to identify, address, and prevent fraud, waste or abuse. Consider data analytics, reviews of under/overutilization, and other activities.","Free text",null,"X"]
["B.X.2","Contract standard for overpayments","Indicate whether the state allows plans to retain overpayments, requires the return of overpayments, or has established a hybrid system.","Set values (select one)",null,"X"]
["B.X.3","Contract locations of overpayment standard","Identify where the overpayment standard in indicator B.X.2 is located in plan contracts, as required by 42 CFR 438.608(d)(1)(i).","Free text",null,"X"]
["B.X.4","Description of overpayment contract standard","Briefly describe the overpayment standard (for example, details on whether the state allows plans to retain overpayments, requires the plans to return overpayments, or administers a hybrid system) selected  in indicator B.X.2","Free text",null,"X"]
["B.X.5","State overpayment reporting monitoring","Describe how the state monitors plan performance in reporting overpayments to the state. For example, does the state track compliance with this requirement and/or timeliness of reporting?","Free text",null,"X"]
["B.X.6","Changes in beneficiary circumstances","Describe how the state ensures timely and accurate reconciliation of enrollment files between the state and plans to ensure appropriate payments for enrollees experiencing a change in status (e.g., incarcerated, deceased, switching plans).","Free text",null,"X"]
["B.X.7.a","Changes in provider circumstances: Part 1","Indicate if the state monitors whether plans report provider “for cause” terminations in a timely manner under 42 CFR 438.608(a)(4).","Set values (select one)",null,"X"]
["B.X.7.b","Changes in provider circumstances: Part 2","If the state monitors whether plans report provider “for cause” terminations in a timely manner in indicator B.X.7.a, indicate whether the state uses a metric or indicator to assess plan reporting performance.","Set values (select one)",null,"X"]
["B.X.7.c","Changes in provider circumstances: Part 3","If the state uses a metric or indicator to assess plan reporting performance in indicator B.X.7.b, describe the metric or indicator that the state uses.","Free text",null,"X"]
["B.X.8a","Federal database checks: Part 1","Consistent with the requirements at  42 CFR 455.436 and 438.602, the State must confirm the identity and determine the exclusion status of the MCO, PIHP, PAHP, PCCM or PCCM entity, any subcontractor, as well as any person with an ownership or control interest, or who is an agent or managing employee of the MCO, PIHP, PAHP, PCCM or PCCM entity through routine checks of Federal databases. In the course of the state's federal database checks, did the state find any person or entity excluded?","Set values (select one)",null,"X"]
["B.X.8b","Federal database checks: Part 2","If in the course of the state's federal database checks the state found any person or entity excluded, please summarize the instances and whether the entity was notified as required in 438.602(d). Report actions taken, such as plan-level sanctions and corrective actions in Tab D3 as applicable. Enter N/A if not applicable.","Free text",null,"X"]
["B.X.9a","Website posting of 5 percent or more ownership control [Y/N]","Report whether the state posts on its website the names of individuals and entities with 5% or more ownership or control interest in MCOs, PIHPs, PAHPs, PCCMs and PCCM entities and subcontractors following §455.104 and required by 42 CFR 438.602(g)(3).","Set values (select one)",null,"X"]
["B.X.9b","Website posting of 5 percent or more ownership control [link]","If the state posts on its website the names of the plan individuals with 5% or more ownership or control, under 42 CFR 602(g)(3), provide a link to the website. Enter N/A if not applicable.","Free text",null,"X"]
["B.X.10","Periodic audits [link]","If the state conducted any audits during the contract year to determine the accuracy, truthfulness, and completeness of the encounter and financial data submitted by the plans under 42 CFR 438.602(e), provide the link(s) to the audit results. ","Free text",null,"X"]
["C1.X.3","Prohibited affiliation disclosure","Did any plans disclose prohibited affiliations? Y/N. If the state took action, as required under 42 CFR 438.610(d), please enter interventions on Tab D3 Sanctions and Corrective Action Plans.","Set values (select one)",null,null,"X"]
["D1.X.1","Dedicated program integrity staff","Report the number of dedicated program integrity staff for routine internal monitoring and compliance risks as required under 42 CFR 438.608(a)(1)(vii). ","Count",{"$nulls":4},"X"]
["D1.X.2","Count of opened program integrity investigations","Enter the count of program integrity investigations opened by the plan in the past year. ","Count",{"$nulls":4},"X"]
["D1.X.3","Ratio of opened program integrity investigations ","Enter the ratio of program integrity investigations opened by the plan in the past year per 1,000 beneficiaries enrolled in the plan on the first day of the last month of the reporting year.","Ratio",{"$nulls":4},"X"]
["D1.X.4","Count of resolved program integrity investigations","Enter the count of program integrity investigations resolved by the plan in the past year.","Count ",{"$nulls":4},"X"]
["D1.X.5","Ratio of resolved program integrity investigations ","Enter the ratio of program integrity investigations resolved by the plan in the past year per 1,000 beneficiaries enrolled in the plan at the beginning of the reporting year.","Ratio",{"$nulls":4},"X"]
["D1.X.6","Referral path for program integrity referrals to the state","Select the referral path that the plan uses to make program integrity referrals to the state:\n· If the plan makes referrals to the Medicaid Fraud Control Unit (MFCU) only.\n· If the plan makes referrals to the State Medicaid Agency (SMA) and MFCU concurrently.\n· If the plan makes some referrals to the SMA and others directly to the MFCU.","Set value (select one)",{"$nulls":4},"X"]
["D1.X.7","Count of program integrity referrals to the state","Enter the count of program integrity referrals that the plan made to the state in the past year using the referral path selected in indicator D1.X.6\n· If the plan makes referrals to the MFCU only, enter the count of referrals made. \n· If the plan makes referrals to the SMA and MFCU concurrently, enter the count of unduplicated referrals.\n· If the plan makes some referrals to the SMA and others directly to the MFCU, enter the count of referrals made to the SMA and the MFCU in aggregate.","Count",{"$nulls":4},"X"]
["D1.X.8","Ratio of program integrity referrals to the state","Enter the ratio of program integrity referrals listed in indicator D1.X.7 made to the state in the past year per 1,000 beneficiaries, using the plan's total enrollment as of the first day of the last month of the reporting year (reported in indicator D1.I.1) as the denominator.","Ratio",{"$nulls":4},"X"]
["D1.X.9","Plan overpayment reporting to the state","Summarize the plan’s latest annual overpayment recovery report submitted to the state as required under 42 CFR 438.608(d)(3). Include, for example, the following information:\n· The date of the report (rating period or calendar year).\n· The dollar amount of overpayments recovered.\n· The ratio of the dollar amount of overpayments recovered as a percent of premium revenue as defined in MLR reporting under 438.8(f)(2).","Free text",{"$nulls":4},"X"]
["D1.X.10","Changes in beneficiary circumstances","Select the frequency the plan reports changes in beneficiary circumstances to the state. ","Set values (select one)",{"$nulls":4},"X"]
["* Standardized or pre-set indicators cover specific information that CMS would like reported consistently across all programs and plans (for example, enrollment count). State-specific or free indicators cover information that will vary based on what a state collects from its plans (for example, access measures). "]
["** Denotes sections that are required for PCCM entities, per 438.66(e)(2)."]

{"sheet":"Set values","index":12,"n_rows":56,"n_cols":39,"rows_kept":56,"hidden":true}
["This sheet will be used to prepoplate fields with set values. It will be hidden from users."]
["#",null,"B.III.1","B.III.2","B.X.2","B.X.7.a","B.X.7.b","B.X.8.a","B.X.9a","C1.I.3","C1.I.4.a","C1.III.1","C1.III.2","C1.X.1 ","C1.X.3","C2","C2","C2","C2","C2","C2","C2","D1.II.1a","D1.VI.1","D1.VI.3","D1.X.6","D1.X.10","D1.X.12","D2","D2","D2","D3","D3","D3","D3","E.IX.2","E.IX.3"]
["Indicator","State name","Data validation entity","HIPAA compliance of proprietary system(s) for encounter data validation","Contract standard for overpayments","Changes in provider circumstances: Part 1","Changes in provider circumstances: Part 2","Managed Care Oversight: Part 1a","Website posting of 5 percent or more ownership control","Program type","Special program benefits","Uses of encounter data","Criteria/ measures used to evaluate MCP performance","Excluded entities or persons","Prohibited affiliation disclosure","Domain or standard type","Standard type","Provider type","Applicable region(s) ","Population","Monitoring methods","Frequency of oversight methods","Aggregate MLR value: Level of aggregation","Delegated services","Access standards for delegated entities","Referral path for program integrity referrals to the state","Changes in beneficiary circumstances","Voluntary provider withdrawals","Domain","Measure reporting (program-specific or cross-program)","Measure set","Domain","Intervention type","Intervention topic","Has plan had CAP or had an intervention for similar reasons within the previous two years","BSS entity type","BSS entity role",null,"Not sure where this one goes - do not delete until known"]
["Level","State","State","State","State","State","State","State","Program","Program ","Program","Program","Program","Program","Program","Program ","Program ","Program ","Program ","Program ","Program ","Program ","Plan","Plan","Plan ","Plan","Plan","Plan ","Plan-measure","Plan","Plan","Plan","Plan","Plan","Plan","State","State",null,"Plan"]
["Type","Allow one","Allow multiple","Allow one","Allow one","Allow one","Allow one","Allow one","Allow one","Allow one","Allow multiple","Allow multiple","Allow multiple","Allow one","Allow one","Allow one","Allow one","Allow one","Allow one","Allow one","Allow multiple","Allow one","Allow one","Allow one","Allow multiple","Allow one","Allow one","Allow one","Allow one","Allow one","Allow one","Allow one","Allow one","Allow multiple","Allow one","Allow multiple","Allow multiple",null,"Allow multiple"]
[null,"Alabama","State Medicaid agency staff","Yes","Allow plans to retain overpayments","Yes","Yes","Yes","Yes","Managed Care Organization (MCO)","Behavioral Health","Rate setting","Timeliness of initial data submissions","Yes","Yes","General quantitative availability and accessibility standard","Maximum time to travel","Primary care","Urban","Adult ","Geomapping","At procurement","Program-specific statewide   ","Pharmaceuticals","Maximum time to travel","The plan makes referrals to the MFCU only.","Daily","Yes","Primary care access and preventive care","Program-specific rate","Medicaid Child Core Set","Sanction","Civil monetary penalty","Discrimination","Yes","State Government Entity","Enrollment Broker/Choice Counseling",null,"\tPharmaceuticals\r\n"]
[null,"Alaska","Other state agency staff","No","State requires the return of overpayments","No","No","No","No","Prepaid Inpatient Health Plan (PIHP)","Long-Term Services and Supports (LTSS)","Quality/performance measurement","Timeliness of data corrections","No","No","LTSS-related standard: provider travels to the enrollee","Maximum distance to travel","Behavioral health ","Rural","Pediatric","Plan provider roster review","Monthly","Program-specific regional","Behavioral health","Maximum distance to travel","The plan makes referrals to the SMA and MFCU concurrently.","Weekly","No","Maternal and perinatal health","Cross-program rate","Medicaid Adult Core Set","Administrative penalty","Suspension of new enrollment","False information","No","Local Government Entity","Beneficiary Outreach",null,"Behavioral Health "]
[null,"Arizona","State actuaries",null,"State has established a hybrid system",{"$nulls":3},"If yes, list website (free text)","Prepaid Ambulatory Health Plan (PAHP)","Dental","Monitoring and reporting","Timeliness of data certifications","If yes, describe (free text)",null,"LTSS-related standard: enrollee travels to the provider","Maximum time or distance","Hospital","Large counties","Adult and pediatric","Secret shopper calls","Quarterly","Statewide all programs & populations","Case management","Maximum time or distance","The plan makes some referrals to the SMA and others directly to the MFCU.","Bi-weekly",null,"Care of acute and chronic conditions",null,"State-specific","Corrective action plan","Fine","Excess charges",null,"Ombudsman Program","LTSS Complaint Access Point",null,"\tCase Management (Behavioral Health, other)\r\n"]
[null,"Arkansas","EQRO",{"$nulls":6},"Primary Care Case Management (PCCM) Entity","Transportation","Contract oversight","Use of correct file formats",null,null,"Exceptions to time and distance standards","Ease of getting an appointment timely","LTSS-personal care assistant","Small counties","MLTSS","EVV data analysis","Annually","Regional all programs & populations","MLTSS","Ease of getting an appointment timely",null,"Monthly",null,"Behavioral health care",null,"HEDIS","Other (free text, specify)","Corrective action plan","Reporting",null,"State Health Insurance Assistance Program (SHIP)","LTSS Grievance/Appeals Education",null,"MLTSS"]
[null,"California","Other third-party vendor",{"$nulls":6},"Other ","None of the above","Program integrity","Provider ID field complete",{"$nulls":3},"Appointment wait time","LTSS-assistive technology","Other (free text, specify)","Other (free text, specify)","Review of grievances related to access","Less than annually","Other (free text, specify)","Dental ","Appointment wait time",null,"Bi-monthly ",null,"Dental and oral health services",null,"Other (free text, specify)",null,"Compliance letter","Performance Improvement",null,"Aging and Disability Resource Network (ADRN)","LTSS Grievance/Appeals Assistance",null,"NEMT"]
[null,"Colorado","Proprietary system(s)",{"$nulls":8},"Policy making and decision support","Overall data accuracy (as determined through data validation)",{"$nulls":3},"Hours of operation","LTSS-adult day care",null,null,"Other (free text, specify)","Other (free text, specify)",null,"NEMT","Hours of operation",null,"Quarterly",null,"Health plan enrollee experience of care",{"$nulls":3},"Liquidated damages","Timely access",null,"Center for Independent Living (CIL)","Review/Oversight of LTSS Data",null,"\tDental\r\n"]
[null,"Connecticut","Other (free text, specify)",{"$nulls":8},"Other (free text, specify)","Other (free text, specify)",{"$nulls":3},"Provider to enrollee ratios","LTSS-SNF",{"$nulls":5},"Physician network primary care-only","Provider to enrollee ratios",{"$nulls":3},"Long-term services and supports",{"$nulls":3},"Other (free text, specify)","Other (free text, specify)",null,"Legal Assistance Organization","Other (free text, specify)",null,"\tPhysician Network Primary Care Only\r\n"]
[null,"Dist. of Col.",{"$nulls":9},"Encounter data not used for any purpose","None of the above",{"$nulls":3},"Miniumum # of network providers","Other (free text, specify)",{"$nulls":5},"Physician network specialty care-only","Miniumum # of network providers",{"$nulls":3},"Other (free text, specify)",{"$nulls":6},"Other Community-Based Organization",null,null,"Physician Network Specialty Care Only"]
[null,"Florida",{"$nulls":14},"Service fulfillment",{"$nulls":6},"Physician network primary and specialty care","Service fulfillment",{"$nulls":10},"Subcontractor",null,null,"Inpatient Care (General Acute)"]
[null,"Georgia",{"$nulls":14},"Other (free text, specify)",{"$nulls":6},"Inpatient care (general acute)","Other (free text, specify)",{"$nulls":10},"Enrollment Broker",null,null,"\tPhysician Network Primary and Specialty Care\r\n"]
[null,"Hawaii",{"$nulls":21},"Other (free text, specify)",{"$nulls":11},"Consultant",null,null,"\tOther\r\n"]
[null,"Idaho",{"$nulls":33},"Academic/Research Organization"]
[null,"Illinois",{"$nulls":33},"Other (free text, specify)"]
[null,"Indiana"]
[null,"Iowa"]
[null,"Kansas"]
[null,"Kentucky"]
[null,"Louisiana"]
[null,"Maine"]
[null,"Maryland"]
[null,"Massachusetts"]
[null,"Michigan"]
[null,"Minnesota"]
[null,"Mississippi"]
[null,"Missouri"]
[null,"Montana"]
[null,"Nebraska"]
[null,"Nevada"]
[null,"New Hampshire"]
[null,"New Jersey"]
[null,"New Mexico"]
[null,"New York"]
[null,"North Carolina"]
[null,"North Dakota"]
[null,"Ohio"]
[null,"Oklahoma"]
[null,"Oregon"]
[null,"Pennsylvania"]
[null,"Puerto Rico"]
[null,"Rhode Island"]
[null,"South Carolina"]
[null,"South Dakota"]
[null,"Tennessee"]
[null,"Texas"]
[null,"Utah"]
[null,"Vermont"]
[null,"Virginia"]
[null,"Washington"]
[null,"West Virginia"]
[null,"Wisconsin"]
[null,"Wyoming"]