Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Need to get seniority LOS in Years under Assignment Level in Seniority Rule
Summary:
We have configured the seniority rule under Assignment level to calculate the seniority years of service.
Content (required):
SELECT
SENIORITY_LOS_YEARS
FROM
PER_SENIORITY_DATES_F
The table "PER_SENIORITY_DATES_F" which has the parameter as person_id , effective_start_date and effective_end_date
Do we have an option to pass the assignment id, if it's multiple assignment based to fetch Length of Service in Years instead of person_id
Or do we have any other table for seniority date to pass parameter as assignment_id instead of person_id
Version (include the version you are using, if applicable):
0