Infor GHR

As part of the Infor HR Talent Payroll integration, an Infor GHR Payroll Export Task has been provided. This task offers a starting point for mapping the WFM Payroll Export to Infor HR Talent.

Some field specific information:

  • For EMP_NAME, the assumption is made that Infor HR Talent is 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 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.
  • For EMPJOB_WORKASSIGNMENT, the value is the EMPJOB_WORKASSIGNMENT value of the employee job assignment record identified by the job effective on the WRKD_WORK_DATE of the employee. If the value is null/empty, then the value is set to 1 by default.
  • For any labor metrics (JOB_NAME, PROJ_NAME, DOCK_NAME, or DEPT_NAME), the value is exported as null/empty if the value is 0.

This table shows the field mapping details between WFM and Infor HR Talent:

Col WFM Field HR Talent CSV Field HR Talent Type Notes
A UNIQUE_ID UniqueID Value can be blank
B EMP_NAME, positions 1-4. HROrganization AlphaUpper4 Required
C EMP_NAME, positions 5-13. Employee Numeric13 Required
D TCODE_NAME PayCode AlphaUpper20 Required. Client mapping is needed between time codes and pay codes.
E WRKD_MINUTES Hours Decimal7.2 Required if paying hours. Convert to hours format.
F WRKD_RATE Amount Decimal18.3 Required if paying an amount
G WRKD_WORK_DATE TimeRecordDate Date Optional
H EMPJOB_WORKASSIGNMENT WorkAssignment Numeric4 Required to locate work assignment
I BATCH_NBR BatchNumber Numeric9 Required. Value can be blank; header must exist. Infor HR Talent can do auto-batch numbering.

Sample XML

<payroll_export plugin="com.workbrain.app.export.payroll.ghr.GHRPayrollExportPlugin">
   <data>
       <field name='EMP_NAME'/>
       <field name='TCODE_NAME'/>
       <field name='WRKD_MINUTES'/>
       <field name='WRKD_RATE'/>
       <field name='WRKD_WORK_DATE'/>
       <field name='JOB_NAME'/>
       <field name='DEPT_NAME'/>
       <field name='PROJ_NAME'/>
       <field name='DOCK_NAME'/>
       <dummy_field name='COMPANY'/>
       <dummy_field name='BATCH_NBR'/>
       <dummy_field name='UNIQUE_ID'/>
       <dummy_field name='EMPLOYEE'/>
       <dummy_field name='PAY_CODE'/>
       <dummy_field name='JOB_CODE'/>
       <dummy_field name='POSITION'/>
       <dummy_field name='EMPJOB_WORKASSIGNMENT'/>
   </data>
    <logic>
        <match_output>
            <output_row />
        </match_output>
    </logic>
   <format>
       <header>
           <constant>UniqueID</constant>
           <constant>,</constant>
           <constant>HROrganization</constant>
           <constant>,</constant>
           <constant>Employee</constant>
           <constant>,</constant>
           <constant>PayCode</constant>
           <constant>,</constant>
           <constant>Hours</constant>
           <constant>,</constant>
           <constant>Amount</constant>
           <constant>,</constant>
           <constant>TimeRecordDate</constant>
           <constant>,</constant>
           <constant>WorkAssignment</constant>
           <constant>,</constant>
           <constant>BatchNumber</constant>
         <new_line/>
      </header>
      <body>
           <string field='UNIQUE_ID' />
           <constant>,</constant>
           <string field='COMPANY' />
           <constant>,</constant>
           <string field='EMPLOYEE' />
           <constant>,</constant>
           <string field='PAY_CODE'/>
           <constant>,</constant>
           <number field='WRKD_MINUTES' format='########0.00' divide='60' null='***'/>
           <constant>,</constant>
           <number field='WRKD_RATE' format='#0.000' null='***'/>
           <constant>,</constant>
           <datetime field='WRKD_WORK_DATE' format='yyyyMMdd'/>
           <constant>,</constant>
           <string field='EMPJOB_WORKASSIGNMENT' />
           <constant>,</constant>
           <string field='BATCH_NBR' />
         <new_line/>
      </body>
      <footer>
      </footer>
   </format>
</payroll_export>