The data differences between the Transaction console Child table and compensation salary tables

Summary:

Hi Team,

We have a requirement, Create custom query to extract report for all Salary transaction changes(Approved/Bypassed transactions) in year 2025.
When we observed the all salary changes are not present in Transaction tables.

Could you please suggest,

• why the data differences in Transaction HRC_TXN_CHILD_OBJECTS child and CMP_salary table.

• if we upload the salary changes rows through HDL/HSDL , will trigger approval work flow or not.

Is any custom BIP report available or someone can assist SQL to achieve the above requirement.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):