Reject reason field in ORC BI Report IRC_LC_REASONS_TL,IRC_LC_HISTORY

Summary:

We have a requirement to add a candidate rejection reason field in ORC BI report. We identified the Reason Details setup present in IRC_LC_REASONS_B, IRC_LC_REASONS_TL. But we don't have matching column with IRC_CANDIDATES or IRC_SUBMISSIONS.

IRC_LC_HISTORY has transaction details with person_id and reason_id columns but reason_id value is null. We have tried joining with Subject_ID = Submission_id, but is not giving correct values

Content (please ensure you mask any confidential information):

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

Code Snippet (add any code snippets that support your topic, if applicable):