In order to retrieve the data about the salary reason codes you can use the column REFERENCE from the Person Salary History view.
β
You can use the function below to create a calculation and get the description for REFERENCE reason codes:
β
βPRBI_GET_HR_REFERENCE2_DESC(P_REFERENCE_CODE=>PRCI_PERSON_SALARY_HISTORY.REFERENCE, P_REFERENCE_TYPE=>'REASON')
Retrieve salary reason codes description data in Insight report
Retrieve salary reason codes data in the Insight report.
J
Written by Joshua Shooter
Updated over a month ago