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



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

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



John Wilson
February 12, 2020, 3:45 PM

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:


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





Melissa Beldman

OSCAR Build Date


OSCAR Build Tag


Client Browser


Client OS

Windows 7

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


Validated by Reporter


SourceForge Link


SourceForge Reporter


SourceForge Assigned To


SourceForge Date Created


SourceForge ID


Affects versions