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

Reply via email to