All messages should be posted in plain text. HTML will be converted to
attachments. The meditech-l web site is MTUsers.com
======================================
Hi Doug,
You could do the following:
1) Create a report in BAR.PROC with the bar.proc.dict Detail Segment.
2) Use xx.count as a Select Field with the Operator EQ and the Value "0"
3) Use COMMON.date as a Select Field with the Operator GE and the Prompt
FROM DATE
4) Use COMMON.date as a Select Field with the Operator LE and the Prompt
THRU DATE
5) Use the Footnote AL START start.macro
6) Define the field xx.count with the attributes DAT=INT, LEN=1, and
VAL=/PROCS[mnemonic]+0
7) Put whatever fields you want on your Report Picture on Page 3
8) File and translate your report
9) Create a macro called start.macro with the following code:
ZZ%K(/PROCS),
COMMON.e.date^END,
COMMON.b.date^BAR.REV.PROC.date.segment,
[EMAIL PROTECTED](BAR.REV.PROC.price)
@Add(@BAR.REV.PROC.count,/PROCS[BAR.REV.PROC.proc]);
@Next(BAR.REV.PROC.proc);
@Next(BAR.REV.PROC.dept);
@Next(BAR.REV.PROC.corp);
@Next(BAR.REV.PROC.date.segment)'>END}
10) File and translate your macro, then file and translate your report again
That should do it. The above macro code loops through the DPM BAR.REV.PROC and
adds up the count of the procedures. These counts are stored in a global array
called /PROCS and subscripted by the procedure mnemonic. The xx.count field is
used as a Select Field so only those procedures whose /PROCS is equal to "0"
will be included on the report.
Please let me know if that does not work out.
Good luck,
Brian Schmit
Sr. Programmer, Picis
Direct: 781 557 3315
Fax: 781 557 3140
100 Quannapowitt Parkway
Suite 405
Wakefield, MA 01880
[EMAIL PROTECTED]
www.picis.com
Please visit www.picis.com/meditech for additional information about our NPR
Report Writing Trainings.
The information in this email is confidential and may be legally privileged. It
is intended solely for the addressee. Access or use by any other person to this
internet email is not authorized and may be unlawful. If you are not the
intended recipient, please delete or destroy this email. If you do not wish to
receive future emails from the sender, please reply directly to this email
requesting you be removed from any mailing list.
>>> "McGaw, Douglas" <[EMAIL PROTECTED]> 5/24/2006 10:03:25 AM >>>
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
CONFIDENTIALITY NOTICE: This email communication and any attachments may
contain confidential and privileged information for the use of the designated
recipients named above. If you are not the intended recipient, you are hereby
notified that you have received this communication in error and that any
review, disclosure, dissemination, distribution or copying of it or its
contents is prohibited. If you have received this communication in error,
please reply to the sender immediately or by telephone at (413)534-2500 and
destroy all copies of this communication and any attachments. For further
information regarding Holyoke Medical Center's privacy policy, Please visit our
Internet web site at http://www.holyokehealth.com
<<<<GWAVAsig>>>>
_______________________________________________
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
