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 */