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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Fast Formula - Identifying Contract Type based on particular date

edited May 15, 2017 3:32PM in Human Capital Management 3 comments

Summary

As opposed to current value

Content

Hello,

 

We are looking to identify if it is possible to do the following:

 

We need to check in a fast formula what the contract type was for an employee on a particular date as opposed to their current assignment record. The database item is named PER_ASG_EMPLOYMENT_CATEGORY, is possible to identify the value of this field at a particular date i.e. where the start date of the assignment is <= X Date and the end date of the assignment is >= X Date?

 

Many thanks

Kevin

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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