The Table Column Audit screen allows the System Admin to designate the columns that will be established or removed from the audit data. Access to this frame should be limited to System Admin menus via Menu Maintenance.
Table Auditing (for Oracle Clients only)
Many kinds of transactions are already audited in journal tables whose data does not change once the record has been created; once a transaction has been written to one, it remains forever. For example:
meter_jnl: Any change to a unit’s meter.
part_jnl: All inventory transactions, including creation of new parts and cross- references, issues, returns, order requests, orders, receipts, transfers, adjustments to quantity or price, and merges of one part number into another.
unit_capital_jnl: Changes to a unit’s capitalized value, whether manually or from work orders.
unit_status_hist: Changes to a unit’s status or status-triggering dates, such as in- service date.
o_labor_chg, o_part_chg, and o_comm_chg: Charges to work orders.
acc_lab_chg, acc_part_chg, and acc_comm_chg: Charges to indirect accounts.
f_comm_prod_chg, f_unit_prod_chg: Fuel charges to units.
Some tables that look like transaction tables can actually be modified through the application; so they cannot be relied upon as an audit trail. For example, unit_asgn_hist is a table that keeps the start and end dates of unit associations to owning and using departments but users can change these dates through a screen.
If in doubt, consult AssetWorks to confirm whether a particular table’s records do not change once created.
For tables that are not reliable journal tables, a standard M5 table called audit_table_column contains the audit trail data. It can be customized via this screen.
For purposes of the audit record, the “updating session” is the one running on the application server or batch server. In other words, the host is not the user’s PC running M5 but is the server running the application components.
Table Column Audit
To select a table, double click in the Table Name field to select one from the list of values (LOV). The three columns on the right of the screen control if you wish to see when the data in the field was first inserted (Add), when it was deleted (Delete) or when it was modified (Updated).
Click on the Save button at the top of the frame when you have defined the data columns for your audit.
For more details see System Administration Application User Training.
Last Updated: 03/14/2017
NOTE: To view a list of System Flags and Role Privileges that may impact this screen, hover over the screen title in M5 to display the bubble help/tooltip. At the bottom of the bubble help/tool tip, there is a Settings hyperlink. Click that hyperlink to display the list of flags and privileges.
Additional training and technical documents on this subject may be available in the Resource Files area.