I have a report written out of SCH.APPT that is pulling on a booked appointment where there are multiple resources. I have CDS queries that are pulling to this report as well. The issue that I am having is that the CDS query is duplicating with each resource associated with the appointment, but I only want it to list it once. Can anybody help me with code to make this happen? We are Magic 5.64.
Thanks!
Jen
Jennifer Fleming
Administrative Applications Consultant
IWK Health Centre, IT Department
5850/5980 University Ave
PO Box 9700, Halifax
Nova Scotia B3K 6R8
Tel 902 470-7838
Cell 902 717-2694
Fax 902 470-6684
Jennifer,
I am not an expert, but I believe I know a bit about SCH module and MIS. It depends on which type of CDS you have identified within the SCHED MODULE, in otherwords, how it was built. There are 6 different types of SCHED CDS that are identified within the MIS CDS dictionaries. You might have the same CDS inserted in both the resource and appt type, etc….
Vida
Hi Vida,
I’m not sure I understand, but we only have one CDS and it is associated to the appointment group in SCH in the Default Schedule CDS.
Jen
Jennifer Fleming
Administrative Applications Consultant
IWK Health Centre, IT Department
5850/5980 University Ave
PO Box 9700, Halifax
Nova Scotia B3K 6R8
Tel 902 470-7838
Cell 902 717-2694
Fax 902 470-6684