DODD Monthly Rate Calculator (MRC) Service Rate Upload/Importer

DODD Monthly Rate Calculator (MRC) Service Rate Upload/Importer

With SETWorks you are able to import/upload the standard txt format Ohio DODD Monthly Rate Calculator (MRC) file as often as you would like, and have SETWorks automatically apply the rates to the appropriate services.  If authorizations do not already exist, they will have to be added manually.

The importer will create consumer/individual specific service line items within the Service/Phase Utility.  The MRC text file contains Medicaid IDs, not names, and so to map the Medicaid IDs to consumers, Entity Identifiers are used, which is the table at the bottom of the Service/Phase Utility that allows you to map values/IDs from one concept to another (in this case, mapping services to consumers).

Note that the importer does not create authorizations. These will need to be created manually if they do not already exist.

Prior to importing the MRC text file, these steps will need to be done:

1. Create the consumer-specific services.  A service can be named something like "Waiver (OSOC) - Smith, John" for the On-Site On-Call service, with a corresponding "Waiver - Smith, John" for the standard one.
2. Create the Entity Identifier mappings.  See below for an example.  The "Entity" here is the service name that maps to the "Identifier Value", which is the Medicaid ID.


To view what rates have been applied, click the "rate change" link within the Service/Phase Utility for a given service.


Uploading the MRC Spreadsheet

Open provider files:


Select the Service Rate Upload (if you don't see this, contact your administrator or SETWorks support)


Viewing historical and archived service rates

As rates can change and be applied retroactively, a report has been created to view the entire history (including archive) of the service rate history and archive of all services.  This report is called Service Rate History and Archive Report.
    • Related Articles

    • Service Isn't Showing on Record

      Why Isn't a Service Showing on Record? Administrator There are a few reasons why a service may not be showing. Terminology can be modified within SETWorks to better fit the needs of your organization. If the terminology in our articles are not the ...
    • How can I Upload a File

      How to Upload a File into SETWorks Administrator This article will explain how to upload a files into SETWorks.  This method of uploading will work in Consumer, Staff, Department, and Provider Files section Terminology can be modified within SETWorks ...
    • How can I Batch Upload a ZIP File

      How to Batch Upload a .ZIP File into SETWorks - File Utility Administrator This article will explain how to upload a .ZIP file into SETWorks. These file uploads apply to existing consumers. Terminology can be modified within SETWorks to better fit ...
    • Service/Phase Utility - All About the Service/Phase Utility

      How do I create services and/or service phases? Administrators The Service/Phase Utility is used to create & maintain your agencies services and service phases. There are core components that are required to be configured in order to effectively ...
    • Service/Phase Utility - Variable Rates

      My Funder Allows for Staff to Bill Individualized Rates - How Do I Use the Variable Rates Feature in SETWorks? Administrators SETWorks has the ability to bill the same service at different rates based upon staff experience and training.  Using ...