[MEDITECH-L] NPR HELP! BAR - Selecting Acct based on specific procedures

[slmed...@comcast.net]

Happy Friday,

I am DESPERATE for help right now, ready to bang my head against a wall! I am trying to come up with a report for our financial department that will capture charges, receipts, and adjustments for accounts ONLY if they have specific procedures. If the account has at least one of the specified procedures, I would need to show the above mentioned data. I can't put it directly into a select since the report would then only pull the procedures I am selecting. I am in Magic 5.5 SR2. The report is written out of BAR.BCH, Detail Segment bar.batch.txn.items, Index File bar.batch.index, selecting off of batch date.

I am thinking I may need to use a DO Loop in a macro to run through the procedures for the account to determine if it should be selected for the report. I have been tinkering with fragments and such, but I do not have much exposure to DO Loops, which I think is my best bet. I have seen them already created and saw them work, but never created one to this point. I have searched the L Archives, Meditech KB articles, and anything else I can find, but have found no help. Not to mention that Meditech already has me on a 25-30 day wait for assistance on a different report!

If anyone can throw me some tips on this, I would be forever greatful! Even if it would mean recreating the report out of a different DPM, as long as I had some direction on pulling the qualifying accounts. I would love to put this request to bed, especially considering the pressure coming at me to get this report done ASAP!

Thanks everyone,

--
Shawn Losanowych
BluePrint Healthcare IT
slmed...@comcast.net

[Mitch Lawrence]

Nothing all that fancy is needed.

Change your detail segment to bar.bch.txn.entries and use multiples in your
picture of the data

Example:

D item.procedure item.count item.amount
D item.procedure item.count item.amount

Create a footnote with the following:

MSEL @item.procedure ANY

Create a selection for your wanted procedures:

item.procedure LI For Procedure(s):

Good luck!
Mitch

[Carmody, David]

Don't bang your head against the wall, that will hurt! :)

-----Original Message-----
From: meditech-...@mtusers.com
[mailto:meditech-...@mtusers.com] On Behalf Of
slmed...@comcast.net
Sent: Friday, April 11, 2008 4:08 PM
To: Meditech L
Subject: [MEDITECH-L] NPR HELP! BAR - Selecting Acct based on
specificprocedures

[McGaw, Douglas]

OK, Shawn, here's what I'd do to select only patients with certain
procedures but then show all the procedures for that patient...

Write a report in the transactions segment of BAR.PAT where you select
for the procedures and dates in question.

Then write a fragment - also in the transactions segment or in the main
segment - to show the information you want. List the patient's
procedures here, and have that report print out on the main one.

In the first report, call the fragment (using @account as the linking
value, with no index) et voila!.... you have only the patients with
certain procedures, but now you can see all the procedures you want on
those patients.

You could also do this without a fragment, but that's more complicated.

(And, if you've been banging your head against the wall, at least when
you stop it feels a whole lot better.)

Douglas B. McGaw
Senior Systems Analyst
Newman Regional Health
1201 W. 12th Ave.
Emporia, KS 66801

dbm...@newmanrh.org
620-343-6800 x 1130
fax: 620-340-6799