Click here for downloadable PDF
mumms interfaces with a number of pharmacies. This allows seamless uploading of medications directly from the pharmacy to the PIM data base and on to Medicare claims. Contact sales@mumms.com to implement this feature.
To manually upload a pharmacy file, the file must match our spec file including the exact fields, in the same order, without any extra fields. The file must contain all columns, even if they are left blank. If the pharmacy or PBM provides the hospice with a file, put the file into the spec file format before uploading.
Please note, it is up to each hospice to provide accurate data. The system may not catch incorrect HCPCS or Revenue codes. Unique files can be uploaded manually or by direct transfer, as often as needed. The file cannot contain special characters, such as a $. Duplicates rows will not be caught and will appear on the claim. Duplicates entered may be removed or edited in the Upload Medication widget.
The screen shot below shows the required headers in the Excel Med File Template. A sample of the template may be downloaded from the mumms website.
- Enter information onto the template keeping the columns in the same order.
- Column A= MR Number
- B, C, & D=optional
- E=Drug name
- F=Fill date. Must be in MM/DD/YYYY format
- G=Rx number (optional)
- H=Revenue Code. Must contain the leading 0 (ie 0250, not 250)
- I=NDC Number. Must be 11 digits, no dashes or spaces. If it is less than 11 digits, set excel to fill with leading 0’s.
- J=HCPCS code. Required for injectables
- K=Quantity. Required for all meds with a revenue code of 0250. Number only, no units. (For example, 200 not 200mg). Column format = Number & can include decimal.
- L=UOM (Unit of Measurement) Required for all meds with a revenue code of 0250.
- M=Charge. Must NOT have any symbol (ie $); Column format = Number & must have 2 decimal points (ie 1.00 not 1.0). Any negative amounts MUST be entered as -0.00 and/or -00.00.
- Once all information is entered onto the template, REMOVE the header row.
- Save the document.
- For Windows, you will choose “Save As” and use the “Text (Tab Delimited)” option below:
- For Mac, you will choose “Save As” and use the “Windows Formatted Text” option below:
- Upload the file via the Rx Fill Widget for each site.
- For Windows, you will choose “Save As” and use the “Text (Tab Delimited)” option below:
- Drag Rx Fill Widget out to HOME page.
- Click the ‘Upload New Records’ button
- Find file
- Click OK
- A message will pop up indicating the file upload was successful.
- If the file was uploaded, any errors will be enumerated on the grid. Open the widget and fix the errors. If there are many errors, delete the file, return to the excel file, correct the errors, re-save and re-upload.
- If the upload was unsuccessful, return to the excel document and carefully review the formatting of the file. Ensure that columns are in the same order, information within the columns is in the designated format per Steps 1-3 above. Once corrected, proceed to upload.
Medication Upload File Required Fields Key
| Column | Field Name | Type | Description |
| A | MR # | varchar(9) | MR # |
| B | First Name | Varchar(20) | OPTIONAL |
| C | Last Name | Varchar(20) | OPTIONAL |
| D | Patient DOB | Date | mm/dd/yyyy OPTIONAL |
| E | Drug Name | varchar(30) | Medication name |
| F | Fill Date | varchar(10) | mm/dd/yyyy |
| G | Rx Number | varchar(25) | Unique Rx number for patient per unique medication. OPTIONAL |
| H | Revenue Code | varchar(4) | 0250: Non-injectable medications 0636: Injectable medications 029x: Infusion equipment 0294: Infusion drugs |
| I | NDC | char(11) | NDC number of the medication or compound ingredient. No dashes. Must be exactly 11 digits. |
| J | HCPCS | varchar(5) | HCPCS code for injectable medication Blank if medication is not an injectable. |
| K | Quantity | varchar(20) | Quantity of the medication or compound ingredient dispensed. Required for all non-injectable drugs with revenue code 0250 OR Standardized HCPCS units dispensed. Required for all injectable drugs and infusion pumps & Meds with revenue codes 0636, 029x, 0294 For example, HCPCS Q1234 is for 100 mg, and fill was 200 mg, report 2. Values less than 1 will be rounded up to 1. |
| L | UOM | varchar(2) | Unit of measure of the medication or compound ingredient.F2: (International Unit) GR: (Gram) Powders, topicals ME: (Milligram) Required for all drugs with revenue code 0250 |
| M | Charge | Money | Amount charged to hospice. NO DOLLAR SIGN. 2 decimal points. Any negative amounts MUST be entered as -0.00 and/or -00.00. |