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.