Create or Edit Consultation Requests Does Not Log Editor/Creator Provider Number

Preconditions

None

Steps to Reproduce

1.Create a new consultation request or edit an existing one
2. Check the applicable Consultation Request tables in the database (e.g consultationRequests, consultationRequestExt) and note that there is not a column where the provider number of the user who created the consultation request or made an edit is recorded.
3. Check the log table in the database, and note that any add or edit of a consultation request is not logged there either (and therefore does not show up in the security log report)
4. set consultation_fax_enabled=true in oscar.properties

Expected Result

1. In addition to the lastUpdateDate table column in consultationRequests, there would be additional columns: creator (the provider number of the user who first created the consultation request), createdDate (timestamp indicating when this consultation request was first created), lastUpdateEditor (the most recent editor's provider number of the consultation request).
2. Each subsequent edit to a consultation request could be recorded in the consultationRequestExt table, with for example, name value column pair of name = "editor", value="<provider_no>" with the other fields (i.e. requestId, dateCreated) in the table row updated accordingly.
3. A consultation request edit or create is logged to the audit log table (i.e. the log table) so it is reflected on the admin security report for the provider who edited or created the consultation request.

Observed Result

There is no history trail at all in OSCAR indicating who created or changed a consultation request.

Additional Comments

None

Activity

Show:
John Wilson
February 12, 2020, 3:45 PM
Edited

It is stored in the providerNo field. But lets say you create the consult and your providerNo is stored there and someone goes in and edits that consult then their providerNo will overwrite yours.

It looks like that field would correspond to the Provider column on the consultation list page but that is displaying the MRP on the patients master record.

Melissa Beldman
February 12, 2020, 3:50 PM

I don’t think that’s true. The providerNo field is populated by the Referring Practitioner on the consultation request, not necessarily the editor or creator of the request.

John Wilson
February 12, 2020, 7:07 PM

ok well it is true but I see what you mean when you have both of these properties enabled:

consultation_dynamic_labelling_enabled=true
consultation_fax_enabled=true

You get the “Referring Practitioner” select field it then overrides that behaviour with your selection. Yes Yes now I get it.

Melissa Beldman
February 12, 2020, 7:11 PM

ah yes, we do have consultation_fax_enabled=true

John Wilson
February 12, 2020, 7:23 PM

For what its worth I +1 the log entry for sure

 

Assignee

Unassigned

Reporter

Melissa Beldman

OSCAR Build Date

2018/07/04

OSCAR Build Tag

oscar-stable-805

Client Browser

Firefox

Client OS

Windows 7

Are you or your organization planning on submitting a fix for this bug in the next 30 days?

Yes

Validated by Reporter

No

SourceForge Link

None

SourceForge Reporter

None

SourceForge Assigned To

None

SourceForge Date Created

None

SourceForge ID

None

Affects versions

Priority

6
Configure