Reporting on rejection comments
SummaryWhat is the name of the BI database table that stores the tracking of rejection comments for transactions?
I was easily able to find / report on the comments of the initiator (let us say the initiator is an HRBP).
But, I cannot find the table location where the rejection comment sits. (For example, if a comp manager disapproves the HRBP's submitted transaction)
Does anyone know the BI table that contains the tracking of rejection comments?
I found that initiating comments are stored in hrc_txn_comment.
Would definitely appreciate the help.
The tables are… "fa_fusion_soainfra.wftask" (this is for the statuses after the initial request by the initiator) & "fa_fusion_soainfra.wfcomments" (it holds the comments AFTER the comment initially entered by the initiator, which is stored in hrc_txn_comment. You can JOIN those two tables together based on the primary key. And, you can likely (though I need to test deeper) back-reference to the hrc_txn_header table via fa_fusion_soainfra.wftask.IDENTIFICATIONKEY or fa_fusion_soainfra.wftask. CORRELATIONID. I can now build out our preexisting BI reports to contain historical commentary data for transactions.