Patient List: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m cleaned up and integrated discussion |
||
| (24 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
The '''Patient List''' is an '''electronic form in [[CCMDB. | The '''Patient List''' is an '''electronic form in [[CCMDB.accdb]]''' on the laptop which lists all patients. | ||
To access the patient list in CCMDB. | To access the patient list in CCMDB.accdb, click the '''Patient List''' button on the [[Main Form (CCMDB.accdb) | Main Form]]. | ||
To view a patient on this list, click the ''' | To view a patient on this list, click the [[File:Binoc button.png]] "'''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 == | == 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. | |||
* [[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: CCMDB. | [[Category:CCMDB.accdb]] | ||
[[Category:CCMDB forms]] | |||
[[Category:Main Form]] | |||
Latest revision as of 14:18, 8 June 2022
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.
- Record field
- Serial number
- Last Name
- First Name
- Admit DtTm
- Dispo DtTm
- Notes field
- Chart
- RecordStatus field
- LastOpened DtTm field
- ♻️ button
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)
|
Requested Changes?
nothing currently
