Table Name that stores the HCM Extract Results

 

The table names are Pay_Object_Actions and Pay_Action_Information.

The data generated by the extract can be retrieved using the following tables and the below SQL. For your query, change Object Action ID.

select *

from pay_action_contexts pac

, pay_object_actions oa

, pay_action_information pai

where oa.object_action_id = 12345

and oa.object_action_id = pac.action_context_id

The column mappings from PAY_ACTION_INFORMATION can be retrieved using the following:

select de.*

from PER_EXT_DATA_ELEMENTS_B de

,pay_report_records_f rr

,pay_report_blocks rb

,per_ext_definitions_vl ed

where de.report_record_id = rr.report_record_id

and rr.report_block_id = rb.report_block_id

and rb.ext_definition_id = ed.ext_definition_id

and rr.flex_structure_code = 'PAY_ACTION_INFORMATION.ACTION_INFORMATION_CATEGORY'

order by information_column