Viewing and exporting aggregate salary survey data

Use the Aggregate Salary Survey Export Template to export the average salary information in a format where you can submit it to a survey provider.

Before you start, you must run the Create Market Survey Data action to display aggregate data.

Select Compensation > Reports > Market Survey Reports > Aggregate Export Template.
Specify this information:
This aggregate data is displayed for each survey provider position.

Note:
The amounts are all expressed in the organization's base currency.
- On the Salaried tab:
  
  Position
  
  The survey provider position.
  
  Note:
  Click the position to view the matching internal positions.
  
  Title
  
  The survey provider title.
  
  Employees
  
  The number of salaried employees that are matched to this position.
  
  Base Pay
  
  The average base pay for the salaried employees that are matched to this position.
  
  Target Bonus
  
  The average target bonus for the salaried employees that are matched to this position.
  
  Percent Of Salary Target Bonus
  
  The average percent of salary target bonus for the salaried employees that are matched to this position.
  
  Bonus
  
  The average bonus payout for the salaried employees that are matched to this position.
  
  Note:
  This includes bonus amounts, special incentive amounts, and lump sum payments.
  
  Total Cash Compensation
  
  The average total cash compensation for the salaried employees that are matched to this position.
- On the Hourly tab:
  
  Position
  
  The survey provider position.
  
  Note:
  Click the position to view the matching internal positions.
  
  Title
  
  The survey provider title.
  
  Employees
  
  The number of hourly employees that are matched to this position.
  
  Base Pay
  
  The average base pay for the hourly employees that are matched to this position.
  
  Target Bonus
  
  The average target bonus for the hourly employees that are matched to this position.
  
  Percent Of Salary Target Bonus
  
  The average percent of salary target bonus for the hourly employees that are matched to this position.
  
  Bonus
  
  The average bonus payout for the hourly employees that are matched to this position.
  
  Note:
  This includes bonus amounts, special incentive amounts, and lump sum payments.
  
  Total Cash Compensation
  
  The average total cash compensation for the hourly employees that are matched to this position.
To export this information to a CSV file:
1. On the Salaried tab, select Options > Export to CSV.
2. Save the file to your machine in .csv format, renaming it to include the name of the survey provider, and the type of report (for example, COMPDATA2010AggregateSalariedData.csv).
3. Repeat steps a and b for the Hourly aggregate data.
Submit the report to the survey provider.

Note:
You can put the CSV file in the format required by the survey provider. This is done outside of Infor HR Talent.