All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ======================================
Just a thought.. Do you keep stats around in BAR.REV.PROC long enough (five years). If so, you could just go thru the BAR.PROC dictionary, check BAR.REV.PROC to see if there is no entry for the proc in the past 5 years, or if the count = 0 over all the periods, then that is apparently one that is not being used. Joe Cocuzzo Vice President NPR Services Iatric Systems, Inc. Phone/Fax: (978) 805-4115 Email: [EMAIL PROTECTED] Web: www.iatric.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of McGaw, Douglas Sent: Wednesday, May 24, 2006 10: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
