SET Instructions in Transformation Formulas

You can configure the HCM Data Loader Transformation Formula to add SET instructions. On the HCM Data Loader DAT files, add the SET instructions before the METADATA instruction.

SET instructions are optional control commands that alter the default processing of the HDL file in which they appear.

Note: You can have multiple SET instructions.

Let's consider these examples.

Example 1

You can use the ENABLE_INCREMENTAL_LOAD_EVENTS set command to enable payroll events on the data that's loaded using SET instructions.

Here's the formula to enable the payroll events:

ELSE IF OPERATION = 'SETINSTRUCTIONS' THEN
(
SET1[1] = 'PersonalPaymentMethod' /*FileName*/
SET1[2] = 'ENABLE_INCREMENTAL_LOAD_EVENTS Y'
RETURN SET1
)

Example 2

Let's assume that you're loading personal payment method data and you want the name of the personal payment method to have a pipe. The name of the personal payment method should be PPM|1.

Here's the transformed HCM Data Loader file with a single line to load the personal payment method data with delimiter as pipe.

METADATA|PersonalPaymentMethod|EffectiveStartDate|PersonalPaymentMethodCode|AssignmentNumber|Percentage|ProcessingOrder|OrganizationPaymentMethodCode|PaymentAmountType|LegislativeDataGroupName
MERGE|PersonalPaymentMethod|2018/04/04|PPM\|1|E300100006342154|100|999|PM US Sun Power Check |P|PM US Sun Po

Here's a sample snippet of the formula text to load personal payment method and user defined table:

ELSE IF OPERATION = 'SETINSTRUCTIONS' THEN
(
SET1[1] = 'UserDefinedTable' /*FileName*/
SET1[2] = 'FILE_ESCAPE \'
SET2[1] = 'PersonalPaymentMethod' /*FileName*/
SET2[2] = 'FILE_ESCAPE \'
RETURN SET1, SET2
)