Brandon,
I haven't taken the time to look at the report, but - when I'm writing out of BAR - I always use an index. My usual index is either the bar.acct.adm.ser.date.index or the bar.acct.discharge.date.index. Even when writing a report that may not depend on one of these indexes, I have added the index anyway and instructed the user to make use of it. For example, one set of reports is set to look at @txn.ser.date, which does not have an index; I use both @bar.adm.ser and @txn.ser.date in the selection criteria, and have cautioned the user to select a starting @bar.adm.ser date that is about a month older than the starting @txn.ser.date in order to catch all likely patients. This way, the report runs within my lifetime. Douglas B. McGaw Newman Regional Health 1201 W. 12th Ave. Emporia, KS 66801 [EMAIL PROTECTED] 620-343-6800 x 1130 fax: 620-340-6799 ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Gauntt, Brandon K. Sent: Wednesday, March 28, 2007 4:20 PM To: Lawrence, Mitchell; [email protected]; [EMAIL PROTECTED] Subject: RE: [MEDITECH-L] Updated Final BAR report So far it is only taking about 25 minutes to run completely since I am only selecting on a single agency but then again we have only been live with Meditech for 3 years. The report works for now but I know that I have to find a better solution for down the road but I really needed something to get out to the agency. I would like to keep the same format but if you have any suggestions for making it faster without changing the format I would really appreciate it. Thanks, Brandon Gauntt Director - Information Services Hopkins County Memorial Hospital 903-439-4054 Office 903-348-2112 Cell ________________________________ From: Lawrence, Mitchell [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 28, 2007 8:33 AM To: Gauntt, Brandon K.; [email protected]; [EMAIL PROTECTED] Subject: RE: [MEDITECH-L] Updated Final BAR report You must not have many accounts in your B/AR. This would take forever to run in ours. Your report examines every account based on the index and selections you are using... Thank you, Mitch Lawrence Lead Applications Analyst - Advanced Report Writer General Financials Support CHRISTUS Information Management ': 361.881.3408 7: 361.888.6117 *: 361.549.8456 )AIM: a1d13 )MSN: [EMAIL PROTECTED] *: [EMAIL PROTECTED] Send a "thank you" <http://intranet.christushealth.org/spiritBuck/> to someone! ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Gauntt, Brandon K. Sent: Tuesday, March 27, 2007 9:38 AM To: [email protected]; [EMAIL PROTECTED] Subject: [MEDITECH-L] Updated Final BAR report I am attaching the source code of the BAR report I had asked for help for. Thanks for all the input and responses. The report I am sending is now exactly what the agency wants. I hope this may help out someone else down the road in not spending as much time as I did working on one. Thanks again, Brandon Gauntt Director - Information Services Hopkins County Memorial Hospital 903-439-4054 Office 903-348-2112 Cell This e-mail, facsimile, or letter and any files or attachments transmitted with it contains information that is confidential and privileged. This information is intended only for the use of the individual(s) and entity(ies) to whom it is addressed. If you are the intended recipient, further disclosures are prohibited without proper authorization. If you are not the intended recipient, any disclosure, copying, printing, or use of this information is strictly prohibited and possibly a violation of federal or state law and regulations. If you have received this information in error, please notify Baylor Health Care System immediately at 1-866-402-1661 or via e-mail at [EMAIL PROTECTED] Baylor Health Care System, its subsidiaries, and affiliates hereby claim all applicable privileges related to this information. This e-mail, facsimile, or letter and any files or attachments transmitted with it contains information that is confidential and privileged. This information is intended only for the use of the individual(s) and entity(ies) to whom it is addressed. If you are the intended recipient, further disclosures are prohibited without proper authorization. If you are not the intended recipient, any disclosure, copying, printing, or use of this information is strictly prohibited and possibly a violation of federal or state law and regulations. If you have received this information in error, please notify Baylor Health Care System immediately at 1-866-402-1661 or via e-mail at [EMAIL PROTECTED] Baylor Health Care System, its subsidiaries, and affiliates hereby claim all applicable privileges related to this information.
image001.gif
Description: image001.gif
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit MTUsers.NET. To check the status of the meditech-l, visit MTUsers.NET. For help, email [EMAIL PROTECTED] Visit the MTUsers WikiPedia at MTUsers.NET/mwiki ______________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
