All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ======================================
Here's some pseudo code to help get the basic idea (not elegant but it will get the basics what you want): 1)Start by writing report out of BAR.PAT for admit / service date range of 5 years to present 2)Use detail segment bar.acct.transactions 3)To create procedures used in the last 5 years create a footnote on page 3 - AL D index.procedure - or just do [EMAIL PROTECTED] in the footnote itelf 4) Also in the footnotes create - AL TR check 5) At DDC prompt output globals to Windows Clipboard 6) Massage the output to desirable format Check macro: [EMAIL PROTECTED](BAR.PROC.mnemonic,@BAR.PROC.main) @CHECK} @DEBUG @CHECK [EMAIL PROTECTED]"N"; c.procedure[BAR.PROC.mnemonic]; 1^c.not.used[BAR.PROC.mnemonic]} DEBUG %Z.ddc(0) James Purvins Inland Northwest Health Services (509) 232-8384 This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, or have otherwise received this communication in error, please delete it from your inbox, notify the sender immediately by replying to the message, and do not disclose its contents to any other person, use the information for any purpose or store or copy the information in any medium. Thank you for your cooperation -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of McGaw, Douglas Sent: Wednesday, May 24, 2006 7:03 AM To: [email protected] Subject: [MEDITECH-L] ?Looking for Report that lists charge procedures NOTused in 5 years All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ====================================== Our accounting dept presented me with a "simple" request: List all charge procedures not used in 5 years. The idea is logical and elegant. The execution, however, looks to be difficult (as in impossible?) I considered starting in BAR.PROC to list the charge procedures, then fragmenting over to BAR.PAT transaction segment to pick up whether a particular procedure has been done in the last 5 years. But can you imagine the month of Sundays it would take to do this? Then I considered trying to scan the BAR.PAT fragment only once and set up an MV array before coming back to the BAR.PROC, but I don't see how this would work. Before I beat myself silly over this, I thought I'd send out an SOS to the "L" to see if anyone has already invented this wheel. Douglas B. McGaw Hospital Info Svcs Coordinator Newman Regional Health 1201 W. 12th Ave. Emporia, KS 66801 Voice: 620-343-6800 x 1130 Fax: 620-340-6133 Email: [EMAIL PROTECTED] _______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l _______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
