835 Remittance File .cx
Hello,
I have a 835 remittance file that needs to be cleaned. The file comes in at .cx and contants one long string of characters like such. 
I'm tyring to use the Monarch Utility to create page breaks but I'm unfamilar how to do so. I have following instructions on who to get it to return in word. Below, how can I do these steps in Monarch Utility?
Enter “~” in the Find what field.
Enter “~” in the Replace with field
Then click the Special button and select the Manual Line Break option
The screen should look like this. Click the Replace All button.
End Result:
Answers
-
You mentioned you are looking in the Monarch utility to create a page break, but I think what you meant was to create a line break. After you break lines you can bring reports in the Monarch desktop, and by default Monarch adds a page break after 200 lines. You can change the default page break in Monarch option.
The following instructions describes how to break lines in a 835 reports:
I am using the Monarch v14.3.
Launch the Monarch utility.
Select Prepare files for Monarch (Replace, Insert line breaks, EDI) option.
On the next screen select a folder which contains all 835 reports.
Set the filename option to *.*.
Select a folder for the output files.
Please make sure that output folder is different than the input folder.
Select the Format EDI option,
Check the Auto-detect ... option, in the segment Delimiter of the Output section enter a space character. This will add a space at the end of each line.
Enter an * in the Element Separator,
Enter a > character in the Sub-Element Separator.
Continue to the next screen and click on the Finish button.
If output files already exist, you will be prompted to replace them.
The Monarch utility program displays success or failure in the status column, so you can tell which report failed, or successfully converted.
Regards
Mo
0 -
When I processed 835's I used a free program provided by CMS. It can process an 835 into different reports, which can be saved as text files. My guess is that you want to look at denials and different payment patterns. This software will help - Medicare Remit Easy Print. The current version is date January, 2018 and is version 4.6. After finding this software, I never tried to process a raw 835 in Monarch again. Good Luck.
0 -
Altair Forum User said:
When I processed 835's I used a free program provided by CMS. It can process an 835 into different reports, which can be saved as text files. My guess is that you want to look at denials and different payment patterns. This software will help - Medicare Remit Easy Print. The current version is date January, 2018 and is version 4.6. After finding this software, I never tried to process a raw 835 in Monarch again. Good Luck.
Catrina,
As Joe suggested you can use the CMS program to display different parts of data from the 835 reports, however, this process is manual.
You can use the Monarch utility command line option to programmatically break lines using the following syntax:
"C:\Program Files (x86)\Datawatch Monarch 14\MonarchUtility.Automation.exe" "C:\datawatch\835_lineBreak\INPUT04_2013730191751.835" "C:\datawatch\835_lineBreak\out\INPUT04_2013730191751.835" /edi /osegd:" " /oelem:"*" /osube:">"
To display the command parameters enter the following command: "C:\Program Files (x86)\Datawatch Monarch 14\MonarchUtility.Automation.exe /?"
The above program assumes the Monarch desktop 32bit is installed. If you are using the Monarch desktop 32bit, the MonarchUtility.Automation.exe program should be in the following path: "C:\Program Files\Datawatch Monarch 14\MonarchUtility.Automation.exe"
You can build a monarch model using the Monarch desktop, and extract relevant information from the 835 reports and then automate the entire process using the Monarch Server Automator.
Regards
Mo
0 -
Catrina,
I used Data Prep Studio to automate the process of converting these files in their default format using a very long multi-step process which is now saved as a template. However, I ended up finding that I could not do thousands of files very efficiently with it. I was however able to create our own process using SQL databases to do this. If you have a significant number of files you are wanting to parse and analyze I'd be happy to talk with you. If your goal is to review individual files sparingly, then you should consider Medicare Remit Easy software. You are welcome to create a template in Data Prep Studio as well, just be cautious as there are many situations that are hard to code for and this can cause the data to not parse correctly but it can be done (with a LOT of time).
0 -
Altair Forum User said:
When I processed 835's I used a free program provided by CMS. It can process an 835 into different reports, which can be saved as text files. My guess is that you want to look at denials and different payment patterns. This software will help - Medicare Remit Easy Print. The current version is date January, 2018 and is version 4.6. After finding this software, I never tried to process a raw 835 in Monarch again. Good Luck.
Joe - Do you run into many situations where Medicare Remit Easy isn't efficient enough for what you are trying to accomplish? This was my situation with the software.
0 -
Altair Forum User said:
Joe - Do you run into many situations where Medicare Remit Easy isn't efficient enough for what you are trying to accomplish? This was my situation with the software.
It depends on what data you seek. If you are looking for daily action reports, Medicare Remit Easy is perfect. If you are looking for trends and statistics over time, it is a means to get to the end result. I used a hybrid solution to get those.
In order to balance the import of remits, more than likely you are going to use a product to print the remit. While most healthcare computer systems offer a solution to do that, I chose Medicare Remit Easy. The person processing the remits would "print" these reports to pdf and store them in a defined location. Daily I would run Monarch models against those pdf files and append that data to multiple Access data bases by type of data. I then used those Access data bases to create reports that trended types of denials, denials by insurance, actual payment amounts, contractuals, etc.
I tried using Monarch on 835 files directly; but never could get the desired result - not Monarch's fault. While Monarch can do the job on 835's, it requires more tech knowledge about 835's than I was willing to learn (segments and where data is located, etc) and time to perfect the data extraction than I was willing to spend. My hybrid system served me well.
0 -
Altair Forum User said:
It depends on what data you seek. If you are looking for daily action reports, Medicare Remit Easy is perfect. If you are looking for trends and statistics over time, it is a means to get to the end result. I used a hybrid solution to get those.
In order to balance the import of remits, more than likely you are going to use a product to print the remit. While most healthcare computer systems offer a solution to do that, I chose Medicare Remit Easy. The person processing the remits would "print" these reports to pdf and store them in a defined location. Daily I would run Monarch models against those pdf files and append that data to multiple Access data bases by type of data. I then used those Access data bases to create reports that trended types of denials, denials by insurance, actual payment amounts, contractuals, etc.
I tried using Monarch on 835 files directly; but never could get the desired result - not Monarch's fault. While Monarch can do the job on 835's, it requires more tech knowledge about 835's than I was willing to learn (segments and where data is located, etc) and time to perfect the data extraction than I was willing to spend. My hybrid system served me well.
Joe,
Thanks for sharing. I know all too well the struggles involved. I started my 835 journey by creating a VBA solution in Excel. Once I reached the max potential of it, I moved on and created a template (with the help of some of the Monarch Solutions Specialists) in Data Prep Studio that actually does a really good job of pulling most of the relevant elements from a true .835 file directly. I still use this when looking at a small sample of files. My current solution is a SQL database that has 33 inter-connected tables for each and every one of the data elements in the 835. I use a separate parsing tool that will look in a folder and automatically parse the data into those tables. It does about 8,000/day which is relatively efficient. I then created several "views" that will pull certain data from each of those tables into one file for better viewing. If you ever find yourself needing something big done, don't hesitate to reach out.
Austin
0 -
Altair Forum User said:
When I processed 835's I used a free program provided by CMS. It can process an 835 into different reports, which can be saved as text files. My guess is that you want to look at denials and different payment patterns. This software will help - Medicare Remit Easy Print. The current version is date January, 2018 and is version 4.6. After finding this software, I never tried to process a raw 835 in Monarch again. Good Luck.
Thank you Joe for suggesting Medicare Remit Easy Print! I'm trying to automate the entire process from beginning to end. I would like to run scripts in the background and have them do all the work. For now, I'm trying to get the the data into a nice returned format. Which the Monarch Utility was able to do, following Mo's steps above. I will need to get this information into SQL Database to do reporting that our current EMR system does not capture.
Thanks for all your suggestions! I really appreciate it.
0 -
Altair Forum User said:
Catrina,
I used Data Prep Studio to automate the process of converting these files in their default format using a very long multi-step process which is now saved as a template. However, I ended up finding that I could not do thousands of files very efficiently with it. I was however able to create our own process using SQL databases to do this. If you have a significant number of files you are wanting to parse and analyze I'd be happy to talk with you. If your goal is to review individual files sparingly, then you should consider Medicare Remit Easy software. You are welcome to create a template in Data Prep Studio as well, just be cautious as there are many situations that are hard to code for and this can cause the data to not parse correctly but it can be done (with a LOT of time).
Hi Austin, can you show me how you use SQL database to parse and analyze the data? I've been task to parse daily 835 files in my health system.
0
Altair Employee
