Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Get worker's last salary based on HR Action like 'ENDPROBATION' — 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 worker's last salary based on HR Action like 'ENDPROBATION'

Received Response
1
Views
1
Comments

Summary:

We need a formula to get the last salary of an employee in year N-1 for a specific HR action.

Content (required):

Hi Experts,

I'm actually working on a Compensation Default and Override formula type to get the updated salary after the probation period. The process of ending the probation period tracked in the system through an HR action 'ENDPROBATION'. 

To do this, I used the DBI "DEFAULT_DATA_VALUE FOR PER_HIST_ASG_ACT_ACTION_CODE IS 'N/A'" and passed the action code as a parameter.

PER_HIST_ASG_ACT_ACTION_CODE = 'ENDPROBATION' (line 61)

But when I compile the formula, I get the following error:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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