Charlece, you should be able to do this with a line check the only prints the line if the patient has not printed yet. Now, you'd have to be printing in patient sequence (not in date/time sequence) to use that method. To ensure that you got the latest appointment, your sort sequence would actually be patient (ascending)/date (descending)/time (descending). If that sequence doesn't suit your purpose, you may be able to do it with an array, again bypassing the duplicate patient records when loading the array. Hope that helps! Gary Hall Clinical Applications Specialist Estes Park Medical Center Information Systems Department 970-577-4443
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Grubbs Charlece Sent: Monday, November 27, 2006 1:45 PM To: [email protected] Subject: [MEDITECH-L] Appts in Scheduling-CMG Anyone know how I can my NPR to report only one record for patients scheduled regardless to the # of appointments that have scheduled? I am using the following: Detail DPM SCH.APPT Detail Segment sch.appointment My output looks like this: Mxxxxxxxxxxxxxx VICK,MICHAEL 11/27/06 60 PRE IN 11/15/06/1353 11/27/06/1330 M.OPINP PRE-OP VISIT ------------------------------------------------------------------------ ------------------------------------------------------------------------ ---------- Mxxxxxxxxxxxxxx VICK,MICHAEL 11/27/06 60 PRE IN 11/16/06/1353 11/27/06/1400 M.OPINP PFT W/ABG'S Total Patients Scheduled:26 Total Patients Scheduled < 24 Hrs: 8 Total Patients Scheduled > 24 Hrs: 19 Total Patients Pre-Reg: 14 Total Pre-Reg Patients Scheduled < 24 Hrs:0 Total Pre-Reg Patients Scheduled >24 Hrs: 14 Source: PT: 4 PO: 60: 10 Total Percent of Patients Pre-registered of all Patients Scheduled: 53.84% Total Percent of Patients Pre-registered of Patients Scheduled within 24 hours: 0.00% Total Percent of Patients Pre-registered of Patients Scheduled more than 24 hours: 73.68% Problem is I am doing calculations based on if they were pre-registered 24hours in advance or not and I only need it to look at the last appointment for Michael Vick despite him having two appointments in my calculations. What would solve my issue is if I could just report the patient one time instead of listing it twice for each appointment? Is this possible? In the total section the patients scheduled less/greater should equal total patients scheduled but they don't because in my count I'm only counting the patient once but when I do whether scheduled less/greater than it's using the # of appointments and I don't want it to do that. Charlece M. Grubbs Application Developer - IT/S HCA Healthcare PAS - Atlanta 678.421.7715 This email and any files transmitted with it may contain PRIVILEGED or CONFIDENTIAL information and may be read or used only by the intended recipient. If you are not the intended recipient of the email or any of its attachments, please be advised that you have received this email in error and that any use, dissemination, distribution, forwarding, printing, or copying of this email or any attached files is strictly prohibited. If you have received this email in error, please immediately purge it and all attachments and notify the sender by reply email or contact the sender at the number listed. The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender of this communication immediately.
====================================== All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ______________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
