Reese, I agree. Monarch is the way to go. Monarch is the most accurate and consistent way to extract data from text reports (even PDF's). You can also use CALL or BAT procedures externally or within Excel to pull up the report, extract the data and even push it out to another database, all with the click of a button, macro or scheduled procedure.
Even better, if you use the MPRINT application that works with Meditech you can set up reports to run to an MPRINT device, which saves the report to a network folder and then "looks" for that report and can run procedures once the new report shows up. Chase Rodgers Financial Reporting Manager Medical Center of Plano *214-473-7490 *[email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Monday, June 29, 2009 07:06 PM To: [email protected] Subject: [talkbws] RE: Help getting Started Hi Amber, I am here to offer more pity, than help when it come to Meditech. In STAR we use Monarch (Data Mining Program) to sift through and format our failed claims report, then we export that to excel. I do like the quote in your signature. I may have to borrow that from you. Thanks, Reese Reese E. Walker Lead Financial Systems Analyst Manager, Phoebe Cares Dept. Phoebe Putney Memorial Hospital Phone: (229) 312-4259 ________________________________________ From: [email protected] [mailto:[email protected]] Sent: Monday, June 29, 2009 7:42 PM To: [email protected] Subject: [talkbws] Help getting Started I am new to BWS and have only written a couple scripts using an excel file to start. Now I want to move onto bigger/better projects. The first project I am trying to tackle is answering a query within BAR for a list of accounts that fail a specific claim check. I can run the failed claims report out of Meditech, import it into Excel, reformat the data into something readable, and then run the script from the excel file. The script itself is going to be easy and I get how to do that. The problem I am having is the work to run the report and reformat the data in Excel for the script to use takes longer than just doing the job. I guess the part I need help with is best practice recommendations for 'gathering' the source data from Meditech when it changes every day. Do you use BWS to run the report, import it into Excel, reformat the data, and then manipulate it however you need? Do you attempt to run the report in MT to screen and read off the screen of one session and work in another? Do you attempt to run the report in MT to the screen and read off the screen; move all the data off to variables in BWS and then work off that variable file? Other suggestions? Any pity and help is greatly appreciated. Thanks!! Amber Holcombe Applications Analyst, Patient Accounts Olympic Medical Center Phone: (360)417-7124 Fax: (360)417-7342 "Excellence is not a skill. It is an attitude." ~ Ralph Marston ------------------------------------------------------------------------- Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended individual(s) named above and may contain confidential, privileged, and/or protected information. Any unauthorized review, use, disclosure, copying, or distribution of its contents is prohibited. If you are not the intended recipient, you have received this email in error. If so, please notify the sender immediately by reply email and delete/destroy the original and all copies of this communication. Also know that Internet e-mail is not secure. In choosing to communicate with Olympic Medical Center by email you will assume these confidentiality risks. Internet messages may become corrupted, incomplete, or may incorrectly identify the sender. ----------------------------------------- Disclaimer: The HIPAA Final Privacy Rule requires covered entities to safeguard certain Protected Health Information (PHI) related to a person's healthcare. Information being faxed to you may include PHI after appropriate authorization from the patient or under circumstances that do not require patient authorization. You, the recipient, are obligated to maintain PHI in a safe and secure manner. You may not re-disclose without additional patient consent or as required by law. Unauthorized re-disclosure or failure to safeguard PHI could subject you to penalties described in federal (HIPAA) and state law. If you the reader of this message are not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, please notify us immediately and destroy the related message. --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
