Audit Logging
activenon-billable
Total logged
84h 10m
Uninvoiced
0h 0m
Entries
27
Invoices
0
Time by team member
| Team member | Entries | Hours |
|---|---|---|
| Caleb Harvey | 27 | 84h 10m |
Recent time entries
Last 27
| Date | Description | Who | Duration | Status |
|---|---|---|---|---|
| 10 Oct 2023 | Fixing Corrupt Records - Records were corrupt if data already existed in the audit field - Cleared all audit fields not in use in a entire system update - Cleared any corrupt JSON data in existing audit records - Changed the case statement for trade audit block field to show as 1 if there is no related contract. trade field Tested audit report with success | Caleb Harvey | 2h 0m | wip |
| 20 Sept 2023 | Change “Trade Day Line #” heading to “Trade Book #” - Substitute the current audit data headings to match the new change as well Add Entry Complete to trade audit - Add the trade lock script button in front of the entry complete field and set the field Add a line to lock script for trade to clear the field when unlocked if there is a JSON corruption Change script to unlink cargo and contract to prompt the user first - If the user cancel it won’t unlink - If the cargo or contract are locked it won’t allow the user to unlink the trade | Caleb Harvey | 3h 0m | wip |
| 9 Sept 2023 | Audit Old Value of field not showing - Go into back end of reports on the test volcan - Find the audit report record and copy the configuration for the column headers - In the back end of audit report in Live EPR paste the configuration - Run up the audit report looking for the new header with success | Caleb Harvey | 0h 30m | wip |
| 8 Sept 2023 | Audit Report not Showing - Updated back end audit records to assign a value to action empty - Searched for all "empty" audit records - Delete found set - Reload up audit report with success | Caleb Harvey | 0h 30m | wip |
| 5 Sept 2023 | Adding Audit to the Price Curves in Volcan - Copying the lock/unlock button into the layout from contract and changing the fields to be relevant to the Derivative table - Creating an audit block and audit field in the derivative table - Creating an audit field in the index price table that is related to the audit block of the derivative - Adding a block reset step into the script to set the derivative audit field as one and refresh the audit field in all related index price's - Adding in an audit button to open the audit related to the derivative selected | Caleb Harvey | 2h 0m | wip |
| 4 Sept 2023 | - Step by step through entire current audit system to ensure smooth transition when merging into epr on Wednesday | Caleb Harvey | 1h 0m | wip |
| 30 Aug 2023 | - Created new parameter in CARD Audit script to append a line onto another table without carrying audit across - In the blend trade audit script when a purchase or sale contract is added append the line using the new parameter at the right moment in the script to say which contract has been added and the direction | Caleb Harvey | 2h 0m | wip |
| 28 Aug 2023 | - Blend slow when unlocking. Checked the script and forgot to turn a server scrip back on after debugging the scrip locally. | Caleb Harvey | 3h 30m | wip |
| 25 Aug 2023 | Blend add/delete contract/trades | Caleb Harvey | 2h 15m | wip |
| 25 Aug 2023 | Changing the Contracts Audit Logging - Setting the contract. #Audit relationship to be based off the _ID relation field rather than the primary key to allow the contract Audit to pick up trade auditing in relation to the contract record - Testing trade editing in linked contract to ensure it is functioning correctly - Adding 'Trade' into the audit history button to pull through trade. select - Add trade relationship to Contract. #Audit - In the scripting to reset related fields, set the new relationship to touch the trades audit block field to kick it into an update - Reset the back end to close all fields - Add the 'trade' text into the audit button on the edit layout as well - Test functionality now and all audit records are working as expected | Caleb Harvey | 1h 20m | wip |
| 24 Aug 2023 | - Ensuring audit records are acting appropriately when joining/unjoining from the cargo hedge screen - Changing scripting in swap screen for when unlinking or linking a cargo or contract to inject the ID of the cargo/contract when it gets linked and store the audit record when unlinked against that cargo ad contract still - Fixing bug in swap split button to make sure that when the trade records are duplicated on a trade that is currently in audit already, it will set the duplicated records audit fields and block to empty and 1 respectively - Now the volume is tracked correctly when running the lock script on the new records - Duplicate the swap fields with all their script triggers to the daily trade book screen to include the same auditing methods on that page - Inject a delete audit script into the deletion of trades from the cargo blend screen which takes the current audit log of the trade being deleted and moves it into the trade group's audit log which also appends new lines saying the trade was deleted | Caleb Harvey | 3h 0m | wip |
| 23 Aug 2023 | - Adding in a new field to the #Audit table that contains the primary key and other relation keys - Linking the trade group table off of audit to this new field so it finds all trade audits associated to it - Scripting in the creation of records if the main table is Trade to inject the trade ID, trade group ID, and the contract ID into the audit relation field - Making Audit records create for trades when their fields are accessed on the blend screen - Creating a trade audit record when a hedge is unlinked from the trade group that tracks this and inject the trade group id before being unlinked - after the record is created and the ID's are removed from the trade record, the audit record closes and saves the data so this can be seen instantly in the audit log as the trade table won't pick up being linked to the main table now - Doing similar when the hedge is joined to the trade but not closing off the record as this can be seen still in the audit view as the trade group's id is injected into the trade - Lot's of script debugging and tweaking variables to get it working perfectly | Caleb Harvey | 6h 0m | wip |
| 22 Aug 2023 | — | Caleb Harvey | 3h 0m | wip |
| 22 Aug 2023 | trade group auditing behaving incorrect after trade changes - Run through the unlock script on a trade group with the script debugger to isolate the issues - Trade group creating audit record but not setting its audit block to 0 - When editing the script I had removed the step to isolate the newly created audit record before updating linked tables with replace field contents - I added this back into the script and the trade group audit began behaving correctly again | Caleb Harvey | 2h 0m | wip |
| 21 Aug 2023 | Opening audit log when editing trade - For each field in the swap screen, create a script trigger that opens an audit file against the trade if one isn't already present and "unlocks" the audit block on the trade record - If the field already has a trigger or a button set field is being used, run a script to run the unlock script then perform the script originally attached to the button - Test the functionality of this with every field/button and ensure the records are being created correctly - Script the creation of audit records when using the 'split' button by injecting the psos into the script on creation of the duplicates to record their new volume in audit - In the cargo blend screen, ensure that all related trades audit fields are turning on when creating an audit - When a hedge is unlinked, the trade records audit log will update to say the cargo # that was removed and same with the linked contract | Caleb Harvey | 7h 0m | wip |
| 18 Aug 2023 | Creating Audit system for Trade table - Adding Audit Block field to trade as it was only linked to the contract - Setting this field as the trigger for Audit to appear or disappear - Testing different formulas on Audit Block and seeing the conditions it returns 1 or 0 under - created a case statement to return one if any linked tables audit block fields are set to 0 or if the current records Audit JSON field has any Audit data in it already - If this returns 1 then check the _Audit block ISO field which allows the record to be unlocked independant of related tables and if that equals 1 as well stay set as 1 - Add a trade. #Audit relatinship in the back end and add a relatinship from Trade to #Audit searching for all open Audits on that record - Create a field to set to 0 or 1 based on if an audit record has been created or not for that open trade record - When the Audit script is run after the last user logs off, search for all trades with audit open fields set to 0 as these records don't have an associated audit record - Loop through and create a record for all of these trades - Then run the previously created script to set all audit record data and close them for the day | Caleb Harvey | 6h 30m | wip |
| 2 Aug 2023 | Polishing Contract Audit - Enter the newly calculated offtake voume scheduled and planned fields in the audit log as well as the mtm slip field - Test to make sure the fields are coming up in the audit log - change formula to only track audit log of fields where data is input and not the quarterly and yearly calculation fields - Add script steps on the creation of the subtables to clear their audit field once they are linked to the contract as to be named correctly - fix up the quality adjustments audit field by showing the INFO Name when the quality type id is changed - Fix up all categories to be either general, price or volume - add contractEXTRA table into the subtables list of every button - link up the table to the audit contract table instance - add _audit field to contractEXTRA and add the fields that data can be entered in - test to ensure all data comes through correctly - add all the contract finance fields that are in the finance tab into the contract _Audit field to log - Go to the close script and add the new lock script to be performed after the final user logs off. - if it is a human user perform the script on server, if it is a server user perform script - test closing and opening the file to ensure all _audit data is transferred correctly to the #Audit records and contract is locked with all _Audit fields of the sub tables being cleared - substitue out "error JSON" steps for "[Null]" in the view audit history button so that the audit log looks clean when being opened by a user | Caleb Harvey | 5h 35m | wip |
| 2 Aug 2023 | Removing all instances of OfftakeExtra in EPR - Changing formula for volume planned and scheduled to calulcate or use itself instead of offtake extra fields - changed all input areas of the offtake extra fields to the volume scheduled and planned fields in the offtake table - copied INFO contact from extra table to offtake and changed field instance in NAV Offtake layout - Using FMPerception change any fields not yet changed over to offtake table - Ensure all data is still functioning correctly without the offtake extra table being used - Delete the table and all instances of the table from the back end | Caleb Harvey | 1h 30m | wip |
| 1 Aug 2023 | Redundant Table - found a table "OfftakeExtra" which is not needed. - scanned through fmperception to see where the table instances were being used - created amount planned, amount schedule and contract info fields in the offtake table that were being used in offtakeextra - copied all data across to the new fields - change formula for volume planned and volume scheduled to use this new number field in offtakes table | Caleb Harvey | 1h 0m | wip |
| 1 Aug 2023 | Adding Quality and trade auditing to trade group - link up the trade and quality . trade gorup. #audit fields in the back end - link up a quality. trade group. select using trade ID for the opening an unlocked audit - add calculation to qualities audit field to track which fields have been touched in the cargo section - do the same for trade | Caleb Harvey | 2h 45m | wip |
| 1 Aug 2023 | - Adding the audit script at the Trade Add cost delete script step - Adding "Trade Add Cost" to the lock/unlock and edit buttons - copying the buttons from the cargo detail page to all the cargo children menus to start the audit script from any Trade Group Screen | Caleb Harvey | 3h 25m | wip |
| 31 July 2023 | Adding Trade add cost to trade group audit - Adding an audit field into trade add cost which audits the date, type, description, price and linked contract/s - Hooking up contract to trade add cost in the back end - When the contract are linked and unlinked, the info contract # field changes which reflects in the log - Hooking up trade add cost to trade group in the audit section of the back end so that at the last log off the data is transferred over | Caleb Harvey | 1h 0m | wip |
| 31 July 2023 | Creating a Audit script to add and remove logs from the main table when a sub table has been added/deleted or allocated/unallocated - Upon deleting a record, the audit log from that record is appended to the audit log of the main tables record. - A new log is added to show that the table has been "deleted" as well - When a record is unallocated a similar process takes place however it is marked as "Unallocated" in the log - When a record is allocated a log entry is placed in using the same script step but saying "Allocated" - Tested deleting sub tables in the contract: quality, quality adjustment and contract port - Tested allocating/unallocating using the cargo: hedge - one script section in CARD Audit parameter 6 can be used universally across all tables as long as the sub and main tables are touching | Caleb Harvey | 3h 45m | wip |
| 28 July 2023 | — | Caleb Harvey | 6h 45m | wip |
| 27 July 2023 | Transfer Audit Log to Trade Group - Copied and pasted the lock and edit buttons onto both edit and regular layouts of Trade Group detail - Changes the lock table parameter to "Trade Group" - Copied the calculation from contracts _Audit field into Trade Group and changed the fields for ones on the detail page - Changes the code in Audit history button to make the same calls as in contract but only used the current table and audit history data in the audit file - Added to the script an if statement for when the table is "Trade Group" - Create custom while loop to open audit cards with parameters connect sub tables with "§" which allows the loop to get audit data for every table sent through the button parameters - Added select Audit group to #Menu Register to set whenever the view audit button is hit so we can send the current ID through parameters instead of the current Primary ID calculation - Pasted new button parameters into both contract and trade group with success - Set up audit field in Cargo and link it up to the audit table - Add search for sub group loop into the audit close script | Caleb Harvey | 4h 15m | wip |
| 27 July 2023 | - Changing the _Audit calculation in contract to add missing fields into the log - Thorough testing of all relevant fields - Audit file now gets saved into the audit record when the last person logs off of the system | Caleb Harvey | 1h 0m | wip |
| 26 July 2023 | - Adding in lines to the audit custom function to add the old value in next to the new one to show what the user changed the data from - Rewriting the Lock script to make locking and unlocking simpler and quicker - Adding functionality to create an audit record if _Audit Block is on and the main table goes into edit/unlocked mode - When this is created the tables that contain data on the main table get touched and reset their audit fields as well - Adding in a new configuration for locking and submitting the audit file - Server searches for any unlocked audit files and appends their relational table's _Audit field into its JSON field - The _Audit field of all tables are then cleared so the data isn't being carried around making the records heavy | Caleb Harvey | 7h 35m | wip |
Edit