Show TOC

  Data Extractor for Salary Surveys(Query SALSURVEY_EXT)

Use

This report enables you to collect data available in the SAP system for providers of salary surveys and take part in their salary surveys.

Once you have gathered all the necessary data, you can correlate it into a list or table. You can then download this information and send it to the salary survey providers.

This query is assigned to the HR: Compensation Management (/SAPQUERY/H0) user group within the Global Area .

Prerequisites

To provide the salary survey providers with as much information as possible, the following data needs to be available in the system:

Features

Selection

Your entries under Period, Selection and Program Selections determine the employee for which you want to gather salary data.

Output

The report outputs the following data:

Column

Definition

Organizational unit

Is the internal code that identifies the organizational unit

Organizational unit text

Is the name of the organizational unit, for example, Human Resources Department

Job ID

Is the internal code that identifies the job

Job name

Is the name of the job, for example, Market Researcher

Job code from survey

Is the code given to the job by the survey. Is the means of linking the jobs in the SAP system to those listed in the survey

Name of job from survey

Is the name given to the job in the survey

Average salary from survey

Average salary to be paid for this job, which you specified in Compensation Management Customizing under Start of the navigation path Basic Settings Next navigation step Define System Settings End of the navigation path .

Currency key

Currency of average salary

Unit of time for compensation

Identifies whether this amount is a monthly, weekly, annually, etc. paid amount

Evaluation points

Represents the number of evaluation points that have been assigned to the job in the Job Evaluation Results infotype (1050)

Benchmark job

Specifies whether job is a Benchmark job

Number of employees

Specifies the number of incumbents (employees) that hold the job being reported

Personnel number

Represents the unique identifier for each incumbent (employee) reported

Previous year's annual salary from survey

Annual salary which was paid for job last year, based on salary survey.

Currency key

Currency of previous year’s salary.

Current salary from salary survey

Annual salary paid for job in current year, based on salary survey.

Currency key

Currency of current annual salary.

Minimum of pay grade

Represents the minimum amount paid for a particular pay grade

Currency key

Currency of minimum of pay grade.

Unit of time for amount

Identifies whether this amount is a monthly, weekly, or annual, etc. amount

Midpoint of pay grade

Midpoint between the lowest amount in the pay grade and the highest.

Currency key

Currency of the midpoint of the pay grade.

Unit of time for amount

Identifies whether this amount is a monthly, weekly, or annual, etc. amount

Maximum of pay grade

Represents the maximum amount paid for a particular pay grade

Currency key

Currency of maximum of pay grade.

Unit of time for amount

Identifies whether this amount is a monthly, weekly, or annual, etc. amount

Total incentives paid in a given period

Represents the total of all the payments recorded in the Additional Payments infotype (0015) in a given period of time.

You can specify this period when you configure your system.For information on how to set this parameter, in Customizing choose Start of the navigation path Personnel Management Next navigation step Compensation Management Next navigation step Basic Settings Next navigation step Set System Parametersand refer to the documentation for the switch PCOMP SSINT. End of the navigation path

If you did not specify a period in Customizing, the system determines a period of a year from the date you entered on the selection screen. For example, if you entered May 12 1999 , the system would define the period as May 12 1998 to May 11 1999 .

Currency key

Currency of the sum of all premiums

City

Is the name of the city in which the incumbent's place of work is located

Postal code

Identifies where the incumbent's place of work is located

Country

Identifies the country in which the incumbent's place of work in located

Activities

  1. The user starts the relevant query.

  2. The system gathers all the data and outputs it in a list

  3. The user determines how he/she wants to display the information by choosing one of the display options

  4. The user can now download and send the information to the salary survey provider

See also:

Hay PayNet: Data Extraction for Participation in Salary Surveys (Query SALSURVEY_HAY)