Patient List

The Patient List is a form listing all patients in CCMDB.mdb.

To access this list, click the Patient List button on the Main Form. To view a patient on this list, click the View button before that patient. You can not edit patient information in the patient list itself because these edits would not be subject to our internal integrity checks.

For improvement requested go to: Improvement request for the patient list

Template:Question IT Discussion1 What does the column label RM stand for? Room number.--TOstryzniuk 17:38, 28 September 2010 (CDT)

Template:Question IT Discussion2

• From: Marie Laporte
• Sent: Monday, September 20, 2010 3:41 PM
• To: Tina Tenbergen
• Cc: Trish Ostryzniuk; Shirley Kiesman
• Subject: here's an idea
• HI Tina, I had mentionned that it would be nice to see the chart number on the patient list on ACCESS. The goal being that we would not have to open each serial number/file to get the chart number to order the chart from medical records. I am wondering if we could take it one step further: Can the list be filtered so that the pt's in medical records and those discharged to wards could generate a list using our medical records request form format? We could then print the list rather than write out medical records request lists. The list of in house but transferred pt could be used to follow up on other wards. Just a thought--perhaps something we could bring up at the upcoming meeting. Thanks Marie L.

• • That is a good idea. Save writing up yet another list for Medical records. In Access you could write a Query then Filter to the columns to include only the columns of data you need, for example MR only from the Record column along with other pt info need for MR list. I can write a query but the only problem is I had to copy my filtered query list for MR from Access to an Excel spreadsheet then print out the list ready to be fax to MR depart. It is rather easy and saves writing in out a MR list by hand. Tina....any further ideas on this?--TOstryzniuk 16:18, 21 September 2010 (CDT)

• • • This sounds like a good idea. I won't have time to get into it in the next few days, though. Could someone add it to the requested changes on the wiki? That way it will get done with the next batch of changes. I hope to also figure out what causes the run-time and out-of-memory errors by then. In order to make the data as similar to the MR form as possible, please also send me one of those forms in internal mail. Would MR accept the form via email? Access can do email Thanks.User:Ttenbergen September 22.10

• • • • This would potentially be a very good thing. I'm trying to catch up my ward here at SBGH post vacation, and when I requested more than 60 charts from medical records, they asked me to e-mail it to them as an excel spread sheet list.--Deb P.N SBGH medicine--September 22.10