No longer able to edit the "Record" field in PatientList: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(Created page with "{{Bug}} As of version 2022-04-19 of CCMDB.accdb it is no longer possible to edit the Record field from PatientList. == 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 actu...")
 
Line 13: Line 13:


=== Option 1 ===
=== Option 1 ===
Use this as an opportunity to standardize how we manage patient backlogs. A different process may no longer require us to change this field around.  
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.  


=== 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?
=== Related information ===
I just pulled a list of all record entries for incomplete records, and there are 91 different values in this field.
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 pull that in rather than manually populate it
* 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.
* 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?

Revision as of 14:05, 2022 April 20


As of version 2022-04-19 of CCMDB.accdb it is no longer possible to edit the Record field from PatientList.

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?