Patient List: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
m (cleaned up and integrated discussion)
 
(58 intermediate revisions by 8 users not shown)
Line 1: Line 1:
The '''Patient List''' is a form listing all patients in [[CCMDB.mdb]].
The '''Patient List''' is an '''electronic form in [[CCMDB.accdb]]''' on the laptop which lists all patients.


To access this list, click the '''Patient List''' button on the [[Main Form (CCMDB.mdb) | 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 [[:Category:Data Integrity Rules|internal integrity checks]].
To access the patient list in CCMDB.accdb, click the '''Patient List''' button on the [[Main Form (CCMDB.accdb) | Main Form]].  


{{Question IT}} Discussion1
To view a patient on this list, click the [[File:Binoc button.png]] "'''binoculars'''" button before that patient.  
What does the column label '''RM''' stand for?  In this column there are labels "not yet". Kym asked. --[[User:TOstryzniuk|TOstryzniuk]] 14:55, 1 September 2010 (CDT)


If a [[Serial number]] needs to be changed it has to be done in the Patient List to ensure all re-linking happens properly and that no data integrity checks get bamboozled by the change.


{{Question IT}} Discussion2
Aside from the Serial Number you can not edit patient information in the patient list itself because these edits would not be subject to the [[Data Integrity Checks]].
*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.


== column configuration of the patient list ==
The following fields are listed on the Patient List form.


**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?--[[User:TOstryzniuk|TOstryzniuk]] 16:18, 21 September 2010 (CDT) 
Most have sort buttons located at the top of columns which can be used to sort fields numerically, alphabetically or chronologically.  
* [[Record field]]
* [[Serial number]]
* [[Last Name]]
* [[First Name]]
* [[Admit DtTm]]
* [[Dispo DtTm]]
* [[Notes field]]
* [[Chart]]
* [[RecordStatus field]]
* [[LastOpened DtTm field]]
* [[♻️ button]]


=== Row colours on {{PAGENAME}} ===
The rows on this form are dynamically coloured based on the [[Service/Location]] of the patient. The colour is stored in the "colour" field of the [[S dispo table]]. To change the colour, choose a colour in a [https://www.google.com/search?client=firefox-b-1-d&q=web+color+picker colour picker tool] and tell Tina the [[Service/Location]] to change to this colour. This will change the colour for anyone who collects that location, so it needs to be coordinated by site to have sufficient contrast between colours.


We implemented this because space is limited on this form and this way we can show the [[Service/Location]] without using extra space for a column.


{{Collapsable
| always= we could use the row colours for something else
| full=
Coloring for service isn't very useful any more in medicine now that all records have the same [[Service/Location]] (though it may be in CC where they are still different). We could use conditional formatting for something else, e.g. MR status, discharged status, etc. Open to suggestions from collectors - what conditional formatting would make this list easier or faster to use? [[User:Ttenbergen|Ttenbergen]] 20:30, 2022 April 20 (CDT)
** I'm not sure we need anything, I don't use this feature at all [[User:Lkaita|Lisa Kaita]] 08:26, 2022 June 3 (CDT)
*** If we don't have better use for auto-formatting then I will leave the conditional formatting as is; please discuss here if anyone can think of a better thing to conditionally format  by colour in this form. [[User:Ttenbergen|Ttenbergen]] 15:18, 2022 June 8 (CDT)
}}


=== Requested Changes? ===
nothing currently


== Related articles ==
{{Related Articles}}


[[Category: IT Instructions]]
 
[[Category:CCMDB.accdb]]
[[Category:CCMDB forms]]
[[Category:Main Form]]

Latest revision as of 15:18, 2022 June 8

The Patient List is an electronic form in CCMDB.accdb on the laptop which lists all patients.

To access the patient list in CCMDB.accdb, click the Patient List button on the Main Form.

To view a patient on this list, click the "binoculars" button before that patient.

If a Serial number needs to be changed it has to be done in the Patient List to ensure all re-linking happens properly and that no data integrity checks get bamboozled by the change.

Aside from the Serial Number you can not edit patient information in the patient list itself because these edits would not be subject to the Data Integrity Checks.

column configuration of the patient list

The following fields are listed on the Patient List form.

Most have sort buttons located at the top of columns which can be used to sort fields numerically, alphabetically or chronologically.

Row colours on Patient List

The rows on this form are dynamically coloured based on the Service/Location of the patient. The colour is stored in the "colour" field of the S dispo table. To change the colour, choose a colour in a colour picker tool and tell Tina the Service/Location to change to this colour. This will change the colour for anyone who collects that location, so it needs to be coordinated by site to have sufficient contrast between colours.

We implemented this because space is limited on this form and this way we can show the Service/Location without using extra space for a column.

we could use the row colours for something else   

Coloring for service isn't very useful any more in medicine now that all records have the same Service/Location (though it may be in CC where they are still different). We could use conditional formatting for something else, e.g. MR status, discharged status, etc. Open to suggestions from collectors - what conditional formatting would make this list easier or faster to use? Ttenbergen 20:30, 2022 April 20 (CDT)

    • I'm not sure we need anything, I don't use this feature at all Lisa Kaita 08:26, 2022 June 3 (CDT)
      • If we don't have better use for auto-formatting then I will leave the conditional formatting as is; please discuss here if anyone can think of a better thing to conditionally format by colour in this form. Ttenbergen 15:18, 2022 June 8 (CDT)

Requested Changes?

nothing currently

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Patient_List&oldid=156404"