Mercer Data
Family Size Mapping to Mercer Data
Mercer classifies family size as follows: | The Equus Platform family size is entered in as a number (Here is a legend of how family size will be used |
Single | Family Size = 1 |
Married | Family Size = 2 |
Married + 1 Child | Family Size = 3 (M + 1) |
Married + 2 Children | Family Size = 4 (M + 2) |
Married + 3 Children | Family Size = 5 (M + 3) |
Married + 4 Children | Family Size = 6 (M + 4) |
Allow Negative G&S Differential for Mercer, ICS & AIRINC Compensation Calculations
There is a system preference available at both the system and company level that allows users to permit a negative Goods and Services Differential amount.
When this preference is off, if the ICS (formerly ORC) G&S Differential calculation result is negative, the amount is adjusted to 0.
When this preference is on, the amount is not adjusted.
This setting is used by both Compensation Worksheets and Cost Estimates.
The default value is No.
Using Mercer API
This Data API can be used to access data from the following Mercer Data Points:
Mercer Spendable Value and Percentage
Mercer Cost of Living
Mercer Quality of Living
Mercer Home Housing Norm
Mercer Exchange Rates
Mercer Host Housing Allowance
Mercer Schooling/Education Data
Mercer Per Diem Data
Data used through the Import Processes does not require any changes if used in features (e.g. Business Rules, User Reports).
Importing Mercer Data
These imports can be accessed from the Company Menu in the Processes section under Import Data.
Once the imports are complete you will see the status change to Processed.
Importing Mercer Cost of Living Index Data
Click on the Process link next to Mercer Cost of Living Index Import to import the cost of living and exchange rate data.
Browse to the appropriate file and then click on the Upload File button. When the file has uploaded you will notice a View Flat File link underneath the Failure Condition then you can click on the Process Import button.
Importing Mercer Home Housing Norm Percentages Data
Click on the Process link next to Mercer Home Housing Norm Percentages to import the home housing norm data from the Mercer File.
There is one parameter for this import called Mercer Effective Date. This parameter should be the effective date of the data. Mercer typically provides this file twice a year, in May and November. An example effective date would be May 1, 2010.
Browse to the appropriate file and then click on the Upload File button. When the file has uploaded you will notice a View Flat File link underneath the Failure Condition then you can click on the Process Import button.
This file format will have a M+5 column that will always be NULL per Mercer documentation. This column will not be imported into the Equus Platform but should be included on the file.
Importing Mercer Host Country Housing Cost Data
Click on the Process link next to Mercer Host Country Housing Cost to import the host housing cost data from the Mercer File.
Browse to the appropriate file and then click on the Upload File button. When the file has uploaded you will notice a View Flat File link underneath the Failure Condition then you can click on the Process Import button.
Importing Mercer Index Related Spendable Percentages Data
Click on the Process link next to Mercer Index Related Spendable Percentages to import the spendable data from the Mercer File.
There is one parameter for this import called Mercer Effective Date. This parameter should be the effective date of the data. Mercer typically provides this file twice a year, in May and November. An example effective date would be May 1, 2010.
Browse to the appropriate file and then click on the Upload File button. When the file has uploaded you will notice a View Flat File link underneath the Failure Condition then you can click on the Process Import button.
This file format will have a M+5 column that will always be NULL per Mercer documentation. This column will not be imported into the Equus Platform but should be included on the file.
Importing Mercer International Spendable Tier 2 Values Data
Click on the Process link next to Mercer International Spendable Tier 2 Values to import the spendable data from the Mercer File.
There is one parameter for this import called Mercer Effective Date. This parameter should be the effective date of the data. An example effective date would be May 1, 2010.
Browse to the appropriate file and then click on the Upload File button. When the file has uploaded you will notice a View Flat File link underneath the Failure Condition then you can click on the Process Import button.
This file format will have a M+5 column that will always be NULL per Mercer documentation. This column will not be imported into the Equus Platform but should be included on the file.
Importing Mercer Hypothetical Tax Data
Click on the Process link next to Mercer Hypothetical Tax Import to import the hypothetical tax data from the Mercer File.
There is one parameter for this import called Mercer Effective Date. This parameter should be the effective date of the data. An example effective date would be May 1, 2010.
Browse to the appropriate file and then click on the Upload File button. When the file has uploaded you will notice a View Flat File link underneath the Failure Condition then you can click on the Process Import button.
Importing Mercer Quality of Living Index Import Data
Click on the Process link next to Mercer Quality of Living Index Import to import the spendable data from the Mercer File.
Browse to the appropriate file and then click on the Upload File button. When the file has uploaded you will notice a View Flat File link underneath the Failure Condition then you can click on the Process Import button.
Things to Notes
The imports will update the record if a similar record already exists. The conditions to check will depend on the import. For example, the Spendable imports will check for a record with the same Company, Country, Region/City, Currency, Gross Salary Range and Effective Date.
The Country Code provided on the Mercer file must be the 2 character ISO code and must be in the Equus Platform. An invalid country code will cause the record to fail to be imported.