Compensation (CMP) data mart
The Compensation data mart was designed for in-depth analysis of an organization's total cash compensation in order to highlight pay equity issues as well as age, race, or gender-based discrimination. Within those basic business scenarios you have flexibility to determine which dimensions and measures to include to facilitate proper analysis. The Compensation data mart provides complete analysis of total compensation within the Infor Payroll application. The information is extracted from the Payroll application and then transformed to give you the ability to see patterns and anomalies within your pay structure.
Types of analysis might include the following scenarios:
-
Average compa ratio or average pay by gender, minority status, or age
-
Average compensation by years in job (maturity curve)
-
Average compa ratio or average pay by performance rating or years in job
-
Base salary compared to external market salary by job class or department or location
-
Average compa ratio by department (used during salary increase planning process)
-
Position in range by job (salary grade range "zone" report)
You can define the dimensions for the Compensation data mart on Compensation Data Mart Setup (HC01.1).
The following dimensions are required for the Compensation data mart.
| Dimension | Description |
|---|---|
| Employee | Roll up reporting with Employee as the lowest level. |
| Measures | Cash compensation, Base Salary, User-defined cash compensation. Numbers and Market Salary. You can select more than one measure. |
| Time | Time represents the Year and Period for analysis. |
| HR Org |
Note: You must specify either an HR Org or a GL Org.
An HR company and specific level of company (for example, the company level or company and process level or company, process level and department). |
| GL Org |
Note: You must specify either an HR Org or a GL Org.
A company, specific level of company, or a group of companies (two optional views). |