Mapping pay types in People Analytics is essential for categorising pay events into specific buckets, such as base pay, variable pay e.t.c to support the TCOW model. The TCOW represents the complete cost associated with the workforce contributing to the organisation, encompassing all labour costs and expenses related to supporting and maintaining this group of individuals.
To ensure accurate mapping, only pay codes that incur costs for the employer should be used. To map pay codes in PeopleXD to the set of standarised pay types in People Analytics, complete the following process:
Generate a report listing of pay codes from Insight in PXD.
Review the definitions of each standard pay type in People Analytics to determine appropriate mappings for your pay codes.
Examine examples of pay codes/analysis codes and how they can be mapped to People Analytics standards.
Follow these steps to map the reference data fields.
Report on pay codes in PeopleXD
To report on all pay codes in PeopleXD, follow the steps below in portal.
From the dashboard menu, select Insight Dashboard.
Click Store then click the Reports tab.
In the search field, search for Pay Code Extract, then click the report.
Click Download Report.
To open the report, click YES.
A dialogue box appears, select No - I'll wait then click OK.
Click ACTIONS then click Export Data.
Under Choose and Export Type , select Excel.
Click OK.
The report will download and open in excel.
Before you begin the mapping steps, we recommend reviewing the definition of each standard pay type in People Analytics.
For clarification on PeopleXD pay codes or analysis codes, check examples of PeopleXD pay codes and pay type mapping in People Analytics.