I am creating a new application and I need some advance auditing to show who changed what and when.
This auditing information should be shown, ideally, in a section of the application itself.
By example, I will have a the following data structure.
I want to show in a grid my application (without having to access the APEXSQL console) detailed information of the history of the policy (e.g. premium changes), the customer information (address changes, new phone number, etc), claims data (new claims added to the system etc).
This grid needs to report which employee of my company created or updated the records.
E.g. for a Policy I would have
Employee PolicyNumber Change Before After Type Date
Mark Watson ABC0001 CustomerName Mick Mugger NEW 01 Jan 2020
Mark Watson ABC0001 Address Hollywood NEW 01 Jan 2020
Mark Watson ABC0001 Premium 100 NEW 01 Jan 2020
Sam Sanders ABC0001 Address Hollywood Los Angeles UPDATE 24 Mar 2020
Sarah Jones ABC0001 Premium 100 98.7 UPDATE 06 May 2020
Nick Brook ABC0001 ClaimId 1 NEW 13 Aug 2020
Nick Brook ABC0001 Amount 5.7 NEW 13 Aug 2020
Nick Brook ABC0001 Description Hail NEW 13 Aug 2020
I would like my user to access these information without having to teach them how to use ApexSQL :)
Is this something possible?