I'm working on an NCOA update, and I've been taking a look at the table ta_audit_trail to try and understand what's in there. Most of the columns are self-explanatory, but I'm not sure about alternate_key and cg_key. Does anyone know what the data in these two columns represent?
The alternate_key is the id of the entity that is being audited. For example for an address (T_ADDRESS) that would be address_no. The cg_key is the id of the entity (if any) that controls the audited entity. So in the case of an address, that would the address_type.
Hope that helps.