STEP 1: Creating the Data Files Forthe MTM Network

Data File Instructions

EMR or Data Registry Files

STEP 1: Creating the data files forthe MTM Network

For each measure you will create two files for submission. There is a file structure document for each measure. The data elements that are to be included in that file have each been given a naming convention and a format structure

File 1: This is a patient enrollment file.It provides enrollment and demographic information for each patient enrolled in your MTM program.

File 2: This is a visit file.

Each file has its own naming convention and it is important that you use the naming rules.

ASMA_PATENROLL_ PHARMACY ID_YYYYMM.XLS

ASMA_DETAIL_PHARMACY ID_YYYYMM.XLS

DIAB_PATENROLL_ PHARMACY ID_YYYYMM.XLS

DIAB_DETAIL_PHARMACY ID_YYYYMM.XLS

VASC_PATENROLL_ PHARMACY ID_YYYYMM.XLS

VASC_DETAIL_PHARMACY ID_YYYYMM.XLS

ThePHARMACY IDis your pharmacy’s NPI number.

The YYYYMMwill change to identify the year and monthfor the quarter for which the data is being submitted.

STEP 2: Submit your data files to the MTM Network

Each quarter you will submit files to the company that will be aggregating the data and calculating performance rates. You will be using an FTP site that has protections in place to ensure the security of the data you are submitting.

Before sending files, you will notify Data IQ in a separate email (without attachments) when files are sent. The e-mail address is . In the subject line put “Data Submission” and your pharmacy’s name.

In the body of the e-mail please provide the following information:

1)name and a telephone number of the person sending the files,

2)thefile name and the number of records that are included in that file. A record is a row that contains data (the header row(s) does not count as a record). In a PATENROLL file it will be the number of patients. In a DETAIL file it will be the number of visits.

For example:

ASMA_PATENROLL_ PHARMACY ID_YYYYMM.XLS 45 records

ASMA_DETAIL_PHARMACY ID_YYYYMM.XLS 114 records

When your files have been retrieved, read and their contents verified (file formats and verification of record counts) a DataIQ associate will send a confirmatory e-mail to the named contact.

Any discrepancies will be resolved before proceeding with additional data work.

STEP 4: Getting assistance

When you have questions about the data files— how to set up the files in Excel, naming the files, the structure of the files, or any other questions—you can obtain help by sending an e-mail to Data IQ. You will use the e-mail address .Be sure to cc me (Gary Schneider) at the MTM network using the e-mail address .