Pull UDF values into HCM Extracts using FF — 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

Pull UDF values into HCM Extracts using FF

edited Jul 31, 2018 11:33PM in HCM Integrations 4 comments

Summary

Need to pull UDT values through extract using fast formula (GET_TABLE_VALUE)

Content

Hi,

 

Below are the User-defined Table details created in HCM Cloud.

 

UDT Name: WORK_COMP_CODE

Columns: Stores all 50 US States

Rows: All active job codes

 

Worker Comp codes are based on the combination of the two, for eg, CA/JOB_1234 = '8742' and so on. This is FF is added as an Extract rule based FF as shown below in a separate block.

 

The FF looks like below (FF Type : Extract Rule)

DEFAULT FOR PER_ASG_JOB_CODE IS ''

DEFAULT_DATA_VALUE FOR PER_ASG_LOCATION_ADD_USAGE_REGION2 IS ''

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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