Return Values for Payroll Transformation Formula for HCM Data Loader

The return values for HCM Data loader formulas vary based on the business object and task action.

They are the same as the attribute names and must include BusinessOperation, FileName, and FileDiscriminator.

Here's an example of return values.

/*Return Values*/
RETURN BusinessOperation,FileName,FileDiscriminator,Attribute1,Attribute2,...,Attributen
/*Attributes for a particular Business Object can be found from the View Business Objects UI under the HCM Data Loader task in the Data Exchange Work Area */

For the NUMBEROFBUSINESSOBJECTS and METADATALINEINFORMATION operations, the RETURN statement is as follows.

/*Return Values for NUMBEROFBUSINESSOBJECTS and METADATALINEINFORMATION Operation*/
IF OPERATION='FILETYPE' THEN 
   OUTPUTVALUE='DELIMITED' 
ELSE IF OPERATION='DELIMITER' THEN 
   OUTPUTVALUE='|' 
ELSE IF OPERATION='READ' THEN 
   OUTPUTVALUE='NONE'
ELSE IF OPERATION = 'NUMBEROFBUSINESSOBJECTS' THEN(
   OUTPUTVALUE = '2'
   RETURN OUTPUTVALUE
   )
ELSE IF OPERATION = 'METADATALINEINFORMATION' THEN
    (
    METADATA1[1] = 'BalanceAdjustmentHeader' /*FileName*/ /*Reserved*/
    METADATA1[2] = 'BalanceAdjustmentHeader' /*FileDiscriminator*/ /*Reserved*/
METADATA1[3] = 'LegislativeDataGroupName'
    METADATA1[4] = 'BatchName'
    METADATA1[5] = 'SourceSystemId'
    METADATA1[6] = 'SourceSystemOwner'
    
    METADATA2[1] = 'BalanceAdjustmentHeader' /*FileName*/ /*Reserved*/
    METADATA2[2] = 'BalanceAdjustmentGroup' /*FileDiscriminator*/ /*Reserved*/
    METADATA2[3] = 'EffectiveDate'
    METADATA2[4] = 'PayrollName'
    METADATA2[5] = 'LegislativeDataGroupName'
    METADATA2[6] = 'ConsolidationSetName'
    METADATA2[7] = 'BalAdjBatchId(SourceSystemId)'
    METADATA2[8] = 'SourceSystemId'
    METADATA2[9] = 'SourceSystemOwner'
   RETURN METADATA1, METADATA2 /*Only two as Return value for NUMBEROFBUSINESSOBJECTS  is 2*/
    )

You can define variables with special characters. For example, use this structure to return the BalAdjBatchId(SourceSystemId) Source ID.

/*Return Values for the MAP Operation*/
    FileName = 'BalanceAdjustmentHeader' 
    BusinessOperation = 'MERGE'
    FileDiscriminator = POSITION1
    EffectiveDate = POSITION2
    PayrollName = POSITION3
    LegislativeDataGroupName = POSITION4
    ConsolidationSetName = POSITION5
    "BalAdjBatchId(SourceSystemId)"= POSITION6
    SourceSystemId = POSITION7
    SourceSystemOwner =  POSITION8
    
    RETURN BusinessOperation, FileDiscriminator, FileName, EffectiveDate, PayrollName, LegislativeDataGroupName, ConsolidationSetName, "BalAdjBatchId(SourceSystemId)", SourceSystemId, SourceSystemOwner

/*Note BalAdjBatchId(SourceSystemId) is enclosed by double quotes while assigning value as well as while putting it in the return values list */