CMS-10398 #13 MACFIN_outpatient-upl-template

[Medicaid] Generic Clearance for Medicaid and CHIP State Plan, Waiver, and Program Submissions (CMS-10398)

VI MACFIN_outpatient-upl-template.xlsx

#13 (Revision): Medicaid Accountability – Nursing Facility, Outpatient Hospital and Inpatient Hospital Upper Payment Limits

OMB: 0938-1148

⚠️ Notice: This form may be outdated. More recent filings and information on OMB 0938-1148 can be found here:

Document [xlsx]

Download: xlsx | pdf

Overview

State Attestation
Overview & Instructions
Data Dictionary
Required State Input – OPH
OP Cost
OP Payment
UPL Demonstration Summary
Optional_Sheet_1
Optional_Sheet_2
Optional_Sheet_3
Optional_Sheet_4
Optional_Sheet_5
Optional_Sheet_6
Optional_Sheet_7
Optional_Sheet_8
Optional_Sheet_9
Optional_Sheet_10
Optional_Sheet_11
Optional_Sheet_12
Optional_Sheet_13
Optional_Sheet_14
Optional_Sheet_15

Sheet 1: State Attestation

Upper Payment Limit Demonstration Report		This cell is intentionally left blank
1. I HEREBY CERTIFY that I have read this certification statement and that I have examined the accompanying electronically filed and/or manually submitted Upper Payment Limit demonstration
report prepared by:
(please insert the state Medicaid official (or other person who prepared this UPL demonstration report) Name(s), title(s), and Contact Number(s))
for the report period beginning (MM/DD/YYYY):
and ending (MM/DD/YYYY):
I further certify that, to the best of my knowledge and belief, this report is true, accurate, and complete, and except as noted, have been prepared from the books and records of the providers and Medicaid agency in accordance with applicable instructions. I further certify that I am familiar with the laws and regulations regarding the provision of health care services, and that the services identified in this Upper Payment Limit demonstration report are provided in compliance with such laws and regulations.
2. I certify that the costs reported in this Upper Payment Limit demonstration represent a reasonable estimate of the amount that Medicare would pay for these Medicaid services, consistent with 45 CFR part 75 and 2 CFR part 200, with expenditure/cost data trended forward based on historical data.
3. State and/or local funds are available and will be used to pay for total computable allowable expenditures included in this statement, and the source(s) of such state and/or local funds are in accordance with all applicable federal requirements for the non-federal share of expenditures (including that the funds are not Federal funds in origin or are Federal funds authorized by Federal law to be used to match other Federal funds, and that the federal funds received to match the claimed expenditures will not be used to meet matching requirements under other Federally funded programs).
4. I understand that this information may be used as a basis for claims for federal funds, and that falsification and concealment of a material fact may be prosecuted under federal or state civil or criminal law.
5. I certify that, to the best of my knowledge and belief, all necessary information has been provided to support the determination of the UPL amount, including supplemental materials used to complete the template. I certify that, to the best of my knowledge and belief, none of the calculations or formulas in the template have been changed, and the most recent version of the template has been used for this submission.
6. I certify that, to the best of my knowledge and belief, the structure of this OMB approved and locked template has not been altered in any way, all applicable instructions in the guidelines and directions have been followed in completing this UPL demonstration, and the template has been completed consistent with the definitions in the data dictionary.
7. I am the officer authorized by the relevant state government agency to submit this form and I have made a good faith effort to ensure that all information reported is true and accurate.
Electronic Signature:
Title & Contact Information:
End of Worksheet

Sheet 2: Overview & Instructions

This worksheet is for providing an overview and instructions for the Outpatient UPL Template. Use the arrow keys to read through the document.

Overview
States are required to demonstrate, and Centers for Medicare and Medicaid Services (CMS) has accepted a reasonable estimate of the Upper Payment Limit (UPL) based on a comparison of Medicaid (MCD) payments to equivalent Medicare (MCR) payment or Medicaid cost using Medicare principles. CMS has developed guidance documents to help states meet statutory and regulatory requirements that can be downloaded from:

CMS Accountability Guidance

CMS has created templates with a single data input tab for all demonstration types within a single service type to simplify data entry. These templates have been developed to assist states in meeting UPL requirements and increase comparability across states. This workbook contains templates for the outpatient hospital UPL demonstrations.

For each facility, please complete the tab labeled "Required State Input – OPH." Data for multiple demonstration types may be entered into the "Required State Input – OPH" tab. Valid demonstration types for this template include:
- OP Cost for cost-based demonstrations (e.g., cost-to-charge ratio x Medicaid covered OP charges)
- OP Payment for payment-based demonstrations (e.g., payment-to-charge ratio x Medicaid covered OP charges)

If a cell has a red background, critical data for that variable is missing or invalid. Once the data is filled in with valid data for the specified cell, the template will remove the red color from the cell. For details about the valid data format and valid values for each variable, please see the Data Dictionary tab. If a cell has a gray background, that means that variable is not relevant for that record based on the demonstration type selected in variable 104.

States may not enter data into the tabs labeled "OP Cost," "OP Payment," and "Total_Adjusted_UPL_Gap." The template calculates the content on these tabs automatically based on the data entered on the input tab. They are included as a reference only.

States may use the worksheet tabs labeled "Optional_Sheet_1," "Optional_Sheet_2," etc. to include supplementary data needed to calculate the content for the "Required State Input – OPH" tab. These sheets are optional. If you choose to enter data in the optional worksheet tabs, please provide a brief explanation of the content at the top of the worksheet.

Please ensure the top section of each input tab in the template is completed, which includes the state, the start date for the demonstration, and the end date for the demonstration. This is used to ensure that there are no gaps between yearly submissions.

States may apply different UPL formulas for state government owned or operated facilities, non-state government owned or operated facilities and private facilities; however, the formula should be consistently applied to each provider within the category. Additionally, each facility should only be included in one type of UPL demonstration. In filling out the input tab within this template, data for each individual provider should be included on one separate row. Additionally, all supplemental payments made by the state should be reported for each individual provider and reported separately from regular Medicaid payments. There may be instances where a variable is not applicable to your UPL calculation. Please leave these variables blank, enter a 0, or enter a 1 based on the variable instructions.

Information Requested:
Within each outpatient UPL template, CMS requests the following information for each outpatient hospital:
- Demonstration Information asks for basic information such as the state, demonstration rate year, service type (outpatient), and demonstration type (cost, payment, DRG, other)
- Provider Information asks for provider identification numbers and names for each facility included, the ownership category type (private, non-state government owned, state-government owned), and whether the hospital is a critical access hospital
- Medicare Information for the Base Period asks for Medicare base year data relevant to the calculation of the UPL
- Medicaid Information for the Base Period asks for Medicaid charge data used to calculate the UPL, as well as Medicaid payment data that is used to determine whether or not the state has made payments in excess of the UPL

- Medicaid Payments Inflated to Demonstration Year asks for inflationary or volume adjustment data that are made by the state to reflect changes in the Medicaid program that have occurred between the base and current rate year periods
- UPL Calculation & Inflation to Demonstration Year instructs the state to calculate the UPL and asks for inflationary adjustments to appropriately trend UPL data from the base to the current rate year
- Adjustments to UPL asks for other adjustments to the UPL that are not included in the UPL calculation (e.g., provider taxes for cost-based demonstrations)
- Calculation of UPL Gap instructs the state to calculate the UPL gap for each facility by subtracting (adjusted/inflated) Medicaid payments from the calculated UPL

CMS has developed an instructional document for outpatient facilities to help states create their UPL demonstration. For example, detailed information on where to find the source data from the Medicare cost reports can be found in section III of the Outpatient Hospital Services UPL Instructions document. This document can be downloaded from:

CMS UPL Instructions for Outpatient Hospital Services

Payment and Cost Data: Enter to the nearest dollar (i.e. $1,234,567.89 should be entered as $1,234,568)
Proportion and Percentage Data: Enter with no more than four decimal places (i.e., 0.12345 should be entered as 0.1235)

Detailed descriptions for each variable are provided in the next sheet labeled "Data Dictionary." A hypothetical hospital's data has also been entered for each template to provide guidance and formulas regarding the data requested for each column.

PRA Disclosure Statement:
According to the Paperwork Reduction Act of 1995, no persons are required to respond to a collection of information unless it displays a valid OMB control number. The valid OMB control number for this information collection is 0938-1148. The time required to complete this information collection is estimated to average 40 hours per response, including the time to review instructions, search existing data resources, gather the data needed, and complete and review the information collection. If you have comments concerning the accuracy of the time estimate(s) or suggestions for improving this form, please write to: CMS, 7500 Security Boulevard, Attn: PRA Reports Clearance Officer, Mail Stop C4-26-05, Baltimore, Maryland 21244-1850.

End of Worksheet

Sheet 3: Data Dictionary

This worksheet includes a data dictionary to assist in completing the Outpatient Template. The table includes the variable number, required variable format, a short description of the input variable, a longer and more detailed description of the variable, and a key for which of the template tabs the variable is used in. Use the arrow keys to read through the document.
Table 1. CMS UPL Outpatient Template Data Dictionary
Variable numbering scheme is used for internal identification of each variable and is not meant to be presented in numerical order
Variable Number	Variable Designation	Variable Format	Short Description	Long Description	Variable Status
001	Required	2-character text	State	2-character state ID (e.g., Kentucky = KY)	0: Variable relevant to all OP demonstration types
002	Required	Date [DD/MM/YYYY]	Demonstration Begin Date	Start date of the State demonstration rate year	0: Variable relevant to all OP demonstration types
003	Required	Date [MM/DD/YYYY]	Demonstration End Date	End date of the State demonstration rate year	0: Variable relevant to all OP demonstration types
100	Required	2-character text	State	2-character state ID (e.g., Kentucky = KY)	0: Variable relevant to all OP demonstration types
101	Required	4-digit number	State Demonstration Rate Year	State demonstration rate year YYYY (e.g., 2014)	0: Variable relevant to all OP demonstration types
102	Required	2-character text	Service Type	Service type: OP = Outpatient	0: Variable relevant to all OP demonstration types
103	Not Applicable to this Template (N/A)	N/A	N/A	N/A	N/A
104	Required	Text	Demonstration Type (Cost, Payment, DRG, Per Diem)	Demonstration type (Cost= Cost-based; or Payment= Payment-based)	0: Variable relevant to all OP demonstration types
105	Provide if Applicable (PIA)	Unspecified	Other State Provider ID Number	State provider ID number that is not a Medicaid (MCD) ID number (if applicable).	0: Variable relevant to all OP demonstration types
106	N/A	N/A	N/A	N/A	N/A
107	Required	Unspecified	State-specific Provider ID (MCD ID)	Medicaid (MCD) ID number.	0: Variable relevant to all OP demonstration types
108	Required	Text	Provider Name	Provider name	0: Variable relevant to all OP demonstration types
109	Provide if Applicable (PIA)	10-11 digit number	National Provider ID (NPI)	National Provider Identification Number	0: Variable relevant to all OP demonstration types
110	Required	Text	Ownership Category Type (Private, NSGO, SGO)	Ownership category type (private= private; NSGO= non-state government owned; SGO= state government owned).	0: Variable relevant to all OP demonstration types
111	N/A	N/A	N/A	N/A	N/A
112	Required	6-digit number	MCR Certification Number (MCR ID)	Medicare (MCR) ID number. In the instances where a facility is Not Medicare Certified (NMC), the state should enter "NMC."	0: Variable relevant to all OP demonstration types
113	Provide if Applicable (PIA)	Text	Critical Access Hospital (CAH) Status (Y/N)	Y= critical access hospital; N= not a critical access hospital	0: Variable relevant to all OP demonstration types
114-115	N/A	N/A	N/A	N/A	N/A
116	Provide if Applicable (PIA)	Text	Retrospective/Prospective Demonstration	An indicator that identifies the demonstration as retrospective or prospective. UPL is considered retrospective when it is submitted on or after the start of the demonstration period, and considered prospective if submitted prior to the start of the demonstration period.	0: Variable relevant to all OP demonstration types
117	Provide if Applicable (PIA)	10-character text	State Plan Amendment (SPA) Number	The state plan amendment number associated with the demonstration submission. The expected format is: 2 letter state abbreviation-##-#### (for example, OR-19-0002).	0: Variable relevant to all OP demonstration types
200.1	Required	Date [MM/DD/YYYY]	MCR Cost Report Begin Date	Medicare (MCR) Cost Report begin date of MCR data provided that is used to calculate the UPL.	0: Variable relevant to all OP demonstration types
200.2	Required	Date [MM/DD/YYYY]	MCR Cost Report End Date	Medicare (MCR) Cost Report end date of MCR data provided that are used to calculate the UPL.	0: Variable relevant to all OP demonstration types
201	N/A	N/A	N/A	N/A	N/A
202	Required	Text	MCR Cost Report Filing Status	Medicare (MCR) Cost Report filing status (filed or settled).	0: Variable relevant to all OP demonstration types
203	Required if Cost Demonstration	$ Amount	MCR Costs	Base year Medicare (MCR) costs used to calculate the MCR Cost-to-Charge Ratio (CCR) (Variable 208). These costs are usually input as the total costs, regardless of payer, as reported in the Medicare 2552 cost report. Values of blank or zero will trigger an error for this field.	1: Variable relevant to OP Cost But NOT relevant across all OP demonstration types
204	Required	$ Amount	MCR Charges	Base year Medicare (MCR) charges used to calculate the MCR Cost-to-Charge Ratio (CCR) (Variable 208). These charges are usually input as the total charges, regardless of payer, as reported in the Medicare 2552 cost report. Values of blank or zero will trigger an error for this field.	0: Variable relevant to all OP demonstration types
205	Required if Payment Demonstration	$ Amount	MCR Payments	Base year Medicare (MCR) payments used to calculate the MCR Payment-to-Charge Ratio (PTC) (Variable 209); state should ensure appropriate matching to MCR charges (gross payments to gross charges or net payments to net charges). Values of blank or zero will trigger an error for this field.	2: Variable relevant to OP Payment But NOT relevant across all OP demonstration types
206-207	N/A	N/A	N/A	N/A	N/A
208	Calculated	Proportion	MCR Cost-To-Charge Ratio (CCR)	Calculated as MCR Costs (Variable 203) / MCR Charges (Variable 204).	1: Variable relevant to OP Cost But NOT relevant across all OP demonstration types
209	Calculated	Proportion	MCR Payment-To-Charge Ratio (PTC)	Calculated as MCR Payments (Variable 205) / MCR Charges (Variable 204).	2: Variable relevant to OP Payment But NOT relevant across all OP demonstration types
210-226	N/A	N/A	N/A	N/A	N/A
300.1	Required	Date [MM/DD/YYYY]	Time Period of MCD Charge and Payment Data - Begin Date	Beginning date of base year Medicaid (MCD) payment and charge data (note: should match Medicare (MCR) Cost Report data period).	0: Variable relevant to all OP demonstration types
300.2	Required	Date [MM/DD/YYYY]	Time Period of MCD Charge and Payment Data - End Date	End date of base year Medicaid (MCD) payment and charge data (note: should match Medicare (MCR) Cost Report data period).	0: Variable relevant to all OP demonstration types
301	Required	$ Amount	MCD Charges	Base year Medicaid (MCD) charges, which are applied to the MCR CCR (Variable 208) or MCR PTC (Variable 209) to derive the Calculated MCD UPL Amount (Variable 400).	0: Variable relevant to all OP demonstration types
302	Required	$ Amount	MCD Base Payments	Total Medicaid non-supplemental payments for base year.	0: Variable relevant to all OP demonstration types
303.1	Required	$ Amount	MCD Supplemental Payments	Medicaid supplemental payments associated with the UPL demonstration year. In the notes section, the state should explain the type(s) of payment reported and the related amount(s). The state may not report DSH payments as supplemental payments. If not applicable, this variable should be populated with $0.	0: Variable relevant to all OP demonstration types
303.2	Required	$ Amount	MCD Supplemental Payments - GME / Training	Medicaid supplemental payments associated with the UPL demonstration year for GME (Graduate Medical Education). In the notes section the state should explain the type(s) of payment reported and the related amount(s). The state may not report DSH payments as supplemental payments. If not applicable, this variable should be populated with $0.	0: Variable relevant to all OP demonstration types
303.3	Required	$ Amount	MCD Supplemental Payments - Other	Other Medicaid supplemental payments (not previously reported in Variables 303.1 or 303.2) associated with the UPL demonstration year. In the notes section the state should explain the type(s) of payment reported and the related amount(s). The state may not report DSH payments as supplemental payments. If not applicable, this variable should be populated with $0.	0: Variable relevant to all OP demonstration types
304-305	N/A	N/A	N/A	N/A	N/A
306	Calculated	$ Amount	Total MCD Supplemental Payments	Sum of Medicaid (MCD) Supplemental Payments for the expected payment associated with the demonstration year, includes the following variables: Variable 303.1 + Variable 303.2 + Variable 303.3.	0: Variable relevant to all OP demonstration types
307	Provide if Applicable (PIA)	Text	MCD Inflation Factor Type	Description of Medicaid (MCD) payment trend factor used to reflect changes in the Medicaid program between the base and current UPL Demonstration year periods (e.g., Market Basket). If the value for variable 308 is anything other than 1.0, then variable 307 should be populated with data.	0: Variable relevant to all OP demonstration types
308	Required	Proportion	MCD Inflation Factor	Cumulative Medicaid (MCD) payment trend factor used to reflect changes in the Medicaid program between the base (midpoint of Variable 300.1 and Variable 300.2) and current UPL Demonstration year periods (note: 1.00 = no change) (use "mid-point to mid-point approach"). A value less than 1 or greater than 1.04 for this field will trigger an error.	0: Variable relevant to all OP demonstration types
309	Required	Proportion	Other Adjustment to MCD Payments	Cumulative other adjustment (e.g., volume adjustment) factor used to reflect changes in the Medicaid (MCD) program between the base (midpoint of variable 300.1 & variable 300.2) and current UPL Demonstration year periods (note: 1.00 = no change) (use "mid-point to mid-point approach"). Values of blank or zero will trigger an error for this field.	0: Variable relevant to all OP demonstration types
310-317	N/A	N/A	N/A	N/A	N/A
318	Calculated	$ Amount	Inflated MCD Payments to Demonstration Year	Calculated as Total MCD Supplemental Payments (Variable 306) + (MCD Base Payments (Variable 302) * MCD Inflation Factor (Variable 308) * Other Adjustment to MCD Payments (Variable 309)).	0: Variable relevant to all OP demonstration types
400	Calculated	$ Amount	Calculated MCD UPL Amount	Calculated UPL amount based on instructions provided in spreadsheet (e.g., for cost-based demonstration: base year MCR CCR base year * MCD charges) For Cost: (MCR Cost-To-Charge Ratio (CCR) (var 208) * MCD Charges (var 301)) For Payment: MCR Payment-To-Charge Ratio (PTC) (var 209) * MCD Charges (var 301)).	0: Variable relevant to all OP demonstration types
401	Required if Cost Demonstration	$ Amount	MCD Provider Tax Cost	For cost-based demonstrations, Medicaid (MCD) provider tax costs can be added to the UPL separately. Report here only the Medicaid portion of the cost of the provider tax.	1: Variable relevant to OP Cost But NOT relevant across all OP demonstration types
402	Required	$ Amount	Other Adjustments to the UPL Amount	Adjustments made to the UPL that are not otherwise accounted for in the UPL calculation (e.g., adjustments for managed care transition, ACA adjustments to the UPL). This field should only include values that specifically increase or decrease the UPL. These adjustments represent changes to the UPL prior to the calculation of the UPL gap. If the state provides this as an aggregate adjustment and does not have this information broken out by individual facilities, these adjustments should be distributed across all facilities as appropriate. Any adjustments made in this field must be properly documented and explained in the notes section. If not applicable, this variable should be populated with $0.	0: Variable relevant to all OP demonstration types
403	Calculated	$ Amount	Adjusted MCR UPL Amount	Calculated as Inflated UPL Amount (Variable 406) + Other Adjustments to the UPL Amount (Variable 402) [+ MCD Provider Tax Cost (Variable 401) for cost-based demonstrations]. This calculated estimate represents the amount that Medicare would pay for Medicaid services.	0: Variable relevant to all OP demonstration types
404	Provide if Applicable (PIA)	Text	UPL Inflation Factor Type	Description of cumulative trend factor used to inflate the Calculated MCD UPL Amount (Variable 400) from the base year to the UPL Demonstration year (e.g., Market Basket). If the value for variable 405 is anything other than 1.0, then variable 404 should be populated with data.	0: Variable relevant to all OP demonstration types
405	Required	Proportion	UPL Inflation Factor	Cumulative trend factor used to inflate the Calculated MCD UPL Amount (Variable 400) from the base year (midpoint of Variable 200.1 and Variable 200.2 to the UPL Demonstration year (note: 1.00 = no change) (use "mid-point to mid-point approach"). A value less than 1 or greater than 1.04 for this field will trigger an error.	0: Variable relevant to all OP demonstration types
406	Calculated	$ Amount	Inflated UPL Amount	Computed as Calculated MCD UPL Amount (Variable 400) * UPL Inflation Factor (Variable 405).	0: Variable relevant to all OP demonstration types
407	Calculated	$ Amount	UPL Gap Amount	Calculated as Adjusted MCD UPL Amount (Variable 403) - Inflated MCD Payments to Demonstration Year (Variable 318).	0: Variable relevant to all OP demonstration types
408	Required	$ Amount	Adjustment to the UPL Gap	Adjustments made to the UPL gap. For example, states may utilize this variable to report an anticipated reduction in payment during the UPL demonstration year. Any adjustments to the UPL gap should be distributed across all facilities as appropriate and the adjustments must be documented in the notes section. If not applicable, this variable should be populated with $0.	0: Variable relevant to all OP demonstration types
409	Calculated	$ Amount	Adjusted UPL Gap	Calculated as UPL Gap Amount (Variable 407) + Adjustment to the UPL Gap (Variable 408).	0: Variable relevant to all OP demonstration types
410-424	N/A	N/A	N/A	N/A	N/A
End of Worksheet

Sheet 4: Required State Input – OPH

(Required)

State

[001]

(Required)

Demonstration
Begin Date

[002]

(Required)

Demonstration
End Date

[003]

(PIA)

Retrospective/ Prospective Demonstration

[116]

(PIA)

State Plan Amendment Number (SPA)

[117]

This cell is intentionally left blank

Data Validation Key

This cell is intentionally left blank

EXAMPLE

Grey Shading, White Italic Font: Field does not apply to Demonstration Type entered for row.

EXAMPLE

Yellow Shading, Black BOLD Font: Duplicate provider info values entered for 1) Elements 105, 112, 107, 108, or 2) Element 109

This cell is intentionally left blank

EXAMPLE

Red Shading only: Required field is left blank. Red Shading, White BOLD font: Invalid value entered in field.

This cell is intentionally left blank

Database
Description &

Variable
Number

Demo Info:

(Required)

State

[100]

Demo Info:

(Required)

State
Demonstration
Rate Year

[101]

Demo Info:

(Required)

Service
Type

[102]

Demo Info:

(Required)

Demonstration
Type

[104]

Provider Info:

(PIA)

Other State
Provider ID
Number

[105]

Provider Info:

(PIA)

National
Provider ID
(NPI)

[109]

Provider Info:

(Required)

Medicare
Certification
Number
(Medicare ID)

[112]

Provider Info:

(Required)

State-specific
Provider ID
(Medicaid ID)

[107]

Provider Info:

(Required)

Provider Name

[108]

Provider
Info:

(Required)

Ownership
Category
Type

[110]

Provider
Info:

(PIA)

Critical
Access
Hospital
Status

[113]

MCR Info:

(Required)

Medicare Cost
Report Begin
Date (DOS)

[200.1]

MCR Info:

(Required)

Medicare Cost
Report End
Date (DOS)

[200.2]

MCR Info:

(Required)

Medicare Cost
Report Filing
Status

[202]

MCR Info:

(Required if Payment Demonstration)

Medicare
Payments

[205]

MCR Info:

(Required if Cost Demonstration)

Medicare
Costs

[203]

MCR Info:

(Required)

Medicare
Charges

[204]

MCD Info:

(Required)

Time Period of
Medicaid Charge
and Payment Data -
Begin Date (DOS)

[300.1]

MCD Info:

(Required)

Time Period of
Medicaid Charge
and Payment Data -
End Date (DOS)

[300.2]

MCD Info:

(Required)

Medicaid
Charges

[301]

MCD Info:

(Required)

Medicaid
Base
Payments

[302]

MCD Info:

(Required)

Medicaid
Supplemental
Payments

[303.1]

MCD Info:

(Required)

Medicaid
Supplemental
Payments
(GME/Training)

[303.2]

MCD Info:

(Required)

Medicaid
Supplemental
Payments (Other)

[303.3]

MCD Inflated
Payment Info:

(PIA)

Medicaid Inflation
Factor Type

[307]

MCD Inflated
Payment Info:

(Required)

Medicaid
Inflation
Factor

[308]

MCD Inflated
Payment Info:

(Required)

Other
Adjustment
to Medicaid
Payments

[309]

UPL Calc Info:

(PIA)

UPL Inflation
Factor Type

[404]

UPL Calc Info:

(Required)

UPL Inflation
Factor

[405]

UPL Adjustment
Info:

(Required if Cost Demonstration)

Medicaid
Provider
Tax Cost

[401]

UPL Adjustment
Info:

(Required)

Other
Adjustments to
the UPL Amount

[402]

UPL Gap Info:

(Required)

Adjustment to
the UPL Gap

[408]

No Data

End of Worksheet

Sheet 5: OP Cost

(Required)

State

[001]

(Required)

Demonstration
Begin Date

[002]

(Required)

Demonstration
End Date

[003]

(PIA)

Retrospective/ Prospective Demonstration

[116]

(PIA)

State Plan Amendment Number (SPA)

[117]

This cell is intentionally left blank

Database
Description &

Variable
Number

Demo Info:

(Required)

State

[100]

Demo Info:

(Required)

State
Demonstration
Rate Year

[101]

Demo Info:

(Required)

Service
Type

[102]

Demo Info:

(Required)

Demonstration
Type

[104]

Provider Info:

(PIA)

Other State
Provider ID
Number

[105]

Provider Info:

(PIA)

National
Provider ID
(NPI)

[109]

Provider Info:

(Required)

Medicare
Certification
Number
(Medicare ID)

[112]

Provider Info:

(Required)

State-specific
Provider ID
(Medicaid ID)

[107]

Provider Info:

(Required)

Provider Name

[108]

Provider
Info:

(Required)

Ownership
Category
Type

[110]

Provider
Info:

(PIA)

Critical
Access
Hospital
Status

[113]

MCR Info:

(Required)

Medicare Cost
Report Begin
Date (DOS)

[200.1]

MCR Info:

(Required)

Medicare Cost
Report End
Date (DOS)

[200.2]

MCR Info:

(Required)

Medicare Cost
Report Filing
Status

[202]

MCR Info:

(Required if Cost Demonstration)

Medicare
Costs

[203]

MCR Info:

(Required)

Medicare
Charges

[204]

MCR Info:

(Calculated)

Medicare
Cost-To-
Charge Ratio

[208]

MCD Info:

(Required)

Time Period of
Medicaid Charge
and Payment Data -
Begin Date (DOS)

[300.1]

MCD Info:

(Required)

Time Period of
Medicaid Charge
and Payment Data -
End Date (DOS)

[300.2]

MCD Info:

(Required)

Medicaid
Charges

[301]

MCD Info:

(Required)

Medicaid
Base
Payments

[302]

MCD Info:

(Required)

Medicaid
Supplemental
Payments

[303.1]

MCD Info:

(Required)

Medicaid
Supplemental
Payments
(GME/Training)

[303.2]

MCD Info:

(Required)

Medicaid
Supplemental
Payments (Other)

[303.3]

MCD Info:

(Calculated)

Total
Medicaid
Supplemental
Payments

[306]

MCD Inflated
Payment Info:

(PIA)

Medicaid Inflation
Factor Type

[307]

MCD Inflated
Payment Info:

(Required)

Medicaid
Inflation
Factor

[308]

MCD Inflated
Payment Info:

(Required)

Other
Adjustment
to Medicaid
Payments

[309]

MCD Inflated
Payment Info:

(Calculated)

Medicaid Payments
Inflated to
Demonstration Year

[318]

UPL Calc Info:

(Calculated)

Medicaid UPL
Amount

[400]

UPL Calc Info:

(PIA)

UPL Inflation
Factor Type

[404]

UPL Calc Info:

(Required)

UPL Inflation
Factor

[405]

UPL Calc
Info:

(Calculated)

Inflated UPL
Amount

[406]

UPL Adjustment
Info:

(Required if Cost Demonstration)

Medicaid
Provider
Tax Cost

[401]

UPL Adjustment
Info:

(Required)

Other
Adjustments to
the UPL Amount

[402]

UPL Adjustment
Info:

(Calculated)

Adjusted
Medicare UPL
Amount

[403]

UPL Gap Info:

(Calculated)

UPL Gap
Amount

[407]

UPL Gap Info:

(Required)

Adjustment to
the UPL Gap

[408]

UPL Gap Info:

(Calculated)

Adjusted UPL
Gap

[409]

No Data

End of Worksheet

Sheet 6: OP Payment

(Required)

State

[001]

(Required)

Demonstration
Begin Date

[002]

(Required)

Demonstration
End Date

[003]

(PIA)

Retrospective/ Prospective Demonstration

[116]

(PIA)

State Plan Amendment Number (SPA)

[117]

This cell is intentionally left blank

Database
Description &

Variable
Number

Demo Info:

(Required)

State

[100]

Demo Info:

(Required)

State
Demonstration
Rate Year

[101]

Demo Info:

(Required)

Service
Type

[102]

Demo Info:

(Required)

Demonstration
Type

[104]

Provider Info:

(PIA)

Other State
Provider ID
Number

[105]

Provider Info:

(PIA)

National
Provider ID
(NPI)

[109]

Provider Info:

(Required)

Medicare
Certification
Number
(Medicare ID)

[112]

Provider Info:

(Required)

State-specific
Provider ID
(Medicaid ID)

[107]

Provider Info:

(Required)

Provider Name

[108]

Provider
Info:

(Required)

Ownership
Category
Type

[110]

Provider
Info:

(PIA)

Critical
Access
Hospital
Status

[113]

MCR Info:

(Required)

Medicare Cost
Report Begin
Date (DOS)

[200.1]

MCR Info:

(Required)

Medicare Cost
Report End
Date (DOS)

[200.2]

MCR Info:

(Required)

Medicare Cost
Report Filing
Status

[202]

MCR Info:

(Required if Payment Demonstration)

Medicare
Payments

[205]

MCR Info:

(Required)

Medicare
Charges

[204]

MCR Info:

(Calculated)

Medicare
Payment-To-
Charge Ratio

[209]