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

None

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.