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 for Oracle Cloud HCM   Begin Now

How to determine Rate Start Date within 'Rate Value Calculation' fast formula

edited May 9, 2024 5:04PM in Benefits 1 comment

Summary:

How to find Rate start date (DBI/SQL) of a plan within 'Rate Value Calculation' fast formula. We need rate start date to identify the remaining payroll periods and then split the rate accordingly. I tried to use the DBI BEN_EXT_HIST_ECR_RT_STRT_DT_DN , but it is not fetching the date consistently.

Content (please ensure you mask any confidential information):

How to find Rate start date (DBI/SQL) of a plan within 'Rate Value Calculation' fast formula. We need rate start date to identify the remaining payroll periods and then split the rate accordingly. I tried to use the DBI BEN_EXT_HIST_ECR_RT_STRT_DT_DN , but it is not fetching the date consistently.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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