No longer able to edit the "Record" field in PatientList
As of version 2022-04-19 of CCMDB.accdb it is no longer possible to edit the Record field from Patient List.
Cause
This wasn't a deliberate change. We now pull the start date from first service rather than right from the L_Log table. Once it’s a query like that, the field is not editable directly.
Short-term work-around
For now, you can change the Record field by first opening the record in Patient Viewer.
What do we actually need, here?
Clearly we need a way for collectors to flag a record for Medical Records Requests, the question is how best to accomplish this now that "as before" is not an option. The management of backlog is currently a personal preference. We should have a standard process for this, both to facilitate cross-coverage but also to better be able to use this data to understand workload.
Option 1
Use this as an opportunity to standardize how we manage the Patient List. A different process may no longer require us to change this field around.
I just pulled a list of all record entries for incomplete records, and there are 91 different values in this field.
- a lot of locations use it to track current location of the patient. That is essentially the latest boarding loc, or the dispo, right? If so, I could just display that as part of the list query rather than manually populate it
- at HSC we do some kind of manual MR / MR! / MR* / MR** (12 different values…) annotation – are any of those based on rules that could be data driven instead? And even if not, is this the time to make these uniform? For example, if they are now based on waiting for a hospital dispo, then at least for those where we get that info, we could start entering it and using it for this.
Option 2
Create a different screen that omits Admit DtTm and therefore can have Record field editable. In the end, we mostly need the Dispo DtTm field for this, right?
Discussion
|
|
|
Use of the Record Field
HSC
- Brynn
MR when I have ordered the chart
MR1 when I need to order a second list and I haven't finished the first one yet, so I put a number so it doesn't get reordered
MR* when a patient is discharged and I am not ready to order the chart yet
MR** when there is some sort of unresolved issue that I am waiting to deal with (example: can't figure out how to fix an error)
C when complete
And when someone is admitted, I put their current location in the record spot eg. H4, MICU, etc.
- Joyce
- Michelle
- Lisa
GGH
- Mindy
- Gail
- Sherry: I will use it to track location during the admission to my service, but once someone leaves my service I change their record to MR even if they stayed within the facility (i.e. transferred to ICU or surgery). I don't go back in to change their record. When I print my MR list I print the pages for the month I'm working on.
SBGH
- Pam
- Mailah
- Stephanie
- Val