Need to get seniority LOS in Years under Assignment Level in Seniority Rule — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!