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):