Extract Rule Fast Formula to extract historical department name — 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

Extract Rule Fast Formula to extract historical department name

edited Dec 7, 2017 9:48AM in HCM Integrations 1 comment

Summary

Need help with a fast formula to extract department names effective on each assignment row

Content

In an HCM Extract we are using user entity PER_EXT_SEC_ASSIGNMENT_RANGE_UE to extract all assignment rows for employees. We need to extract the name of the department that was effective on each assignment row using an Extract Rule Fast Formula.

Can anyone show me what this fast formula needs to look like? Is it as simple as this:

CHANGE_CONTEXTS(EFFECTIVE_DATE=PER_EXT_RANGE_ASG_EFFECTIVE_START_DATE)
(
       RULE_VALUE = PER_ASG_ORG_DEPARTMENT_NAME
)
RETURN RULE_VALUE

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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