SQL or tables for Resignation Workflow Approver history
Resignation Workflow Approver history
I need to pull our the workflow details of Resignation workflow in BI. So please let me know from which tables to pull required data. I have checked that the data is populated in below tables when I initiated a resignation transaction.
hrc_txn_header, hrc_txn_data, fa_fusion_soainfra.wftask, fa_fusion_soainfra.wftaskhistory
But I can see a lot of data in hrc_txn_header for which there is no data in wftask/wftaskhistory table. I have read that data gets archived after a few days.
Please let me know if above tables are the right place to look for the data and which other tables should I check for all the old resignation transaction/approvals data also.