Infor HRM

As part of the HCM integration, an Infor HRM Payroll Export Task has been provided. This task offers a starting point for mapping the WFM Payroll Export to Infor HRM. Specifically, the WFM Payroll Export file populates the PRTRCSV on Infor HRM. Then the PRTRCSV is updated by PR530 to create time records.

Some field specific information:

  • For EMP_NAME, the assumption is made that either Infor HRM or Infor Talent Management are the system of record for employee data. The system of record provides WFM with a unique EMP_NAME by having the first four positions as COMPANY and the next nine positions as EMPLOYEE. As part of this HRM Payroll Export Task, the system then extracts the COMPANY and EMPLOYEE data into separate entities from EMP_NAME based on that assumption.
  • Given the flexibility of both systems, mappings between time codes and pay codes must be specified in the XML before the interface can be used.
  • On Infor HRM, the client can choose to use the JOB_CODE field or the POSITION field to hold information that maps to the JOB_NAME field of WFM. This choice means that when payroll export is used, the client’s mapping may require updating. By default, JOB_NAME maps to the POSITION field.
  • Additionally, note that the default JOB_NAME value is 0 in WFM if another default is not provided or the job is not overridden. This default is not a valid JOB_CODE or POSITION in Infor HRM, unless 0 is added as a default in Infor HRM. The XML mapping should be updated with that consideration, according to the business requirements.

These are the field mapping details between WFM and Infor HRM:

Col WFM Field HRM CSV Field Field Size Examples Notes
A EMP_NAME, positions 1-4. COMPANY N 4 3004

0001

Required
B BATCH-NBR N6 12 Required if the client is not using auto-batch numbering or the PR530 parameter to assign. For now, this field can be configured to a single batch number in the XML, if needed.
C EMP_NAME, positions 5-13. EMPLOYEE N 9 245784512

000025138

Required
D TCODE_NAME PAY-CODE A 4 REG

BON3

Required. Client mapping is needed between time codes and pay codes.
E WRKD_MINUTES HOURS S 7.2 40.00 Required. Convert to hours format.
F WRKD_RATE RATE S 13.4 25.7520 Required. Defaults to employee's pay rate in HRM if left blank.
G WRKD_WORK_DATE TR-DATE N 8 ddmmyyyy 12152012 Required
H JOB_NAME JOB-CODE A 9 NURSE Optional
I JOB_NAME POSITION A 12 MANAGER Optional. Configuration is set to this field by default, but can be changed to JOB-CODE (column H), if needed.