Pull UDF values into HCM Extracts using FF

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 ''