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
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.
There is no history trail at all in OSCAR indicating who created or changed a consultation request.
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.
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.
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.
ah yes, we do have consultation_fax_enabled=true
For what its worth I +1 the log entry for sure