HCM Audit Table Differences - Do the audit tables keep deleted rows and the regular table does not?
I want to understand the difference of contents between a "regular" table and an "audit table" that has an "_" underscore at the end of the name. I am calling PER_ALL_ASSIGNMENTS_M a "regular" table and PER_ALL_ASSIGNMENTS_M_ an "audit" table.
I think I understand turning on the audit function so that the audit table populates the 3 additional columns at the end (audit_action_type_, audit_change_bit_map_, audit_impersonator_).
But I wanted to know the difference in what is stored between the two tables. Like how will rows match up? Is the relationship 1 to 1?
If an employee has an assignment action like starting medical leave, it will add a row to the regular table and the audit table will also have a row of 'insert'. But if that action was deleted from the assignment, would it remove the row from the regular table but keep the row in the audit table with a 'delete' action?