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.
sample
Description: sample
====================================== 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
