No longer able to edit the "Record" field in PatientList

From CCMDB Wiki
Revision as of 11:13, 2022 April 21 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search


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?