You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!