Headcount and FTE Headcount

Technical name: 0PA_C01_Q0110

Based on InfoCube: 0PA_C01

Use

This query displays the headcount (= number of employees) and the headcount in full-time equivalents in the last 12 months and the last 4 quarters (end of each quarter). Different organizational data can be used for the report (see Free Characteristics).

Filters

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0EMPLSTATUS

Employment Status

0EMPLGROUP

Employee Group

When the query is called, the Employment Status characteristic filters all employees with employment status 3 (= active) and the Employee Group characteristic filters all employees who belong to employee group 1 (= active). That is, the query only displays results for active employees.

Free Characteristics

InfoObject

Description

0ORGUNIT

Organizational Unit

0MAST_CCTR

Master Cost Center

0EMPLSGROUP

Employee Subgroup

0EMPLOYEE

Employee

Variables Used

Variable

Description

0S_ORG_P

Organizational Unit

Using this variable you can display and evaluate organizational units in a personalized way. If you use the personalization function, you can restrict or expand the list of organizational units, displaying some or all of the organizational units for which you are authorized.

See also: Personalization in Human Resources (HR) Web Cockpits

Columns

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0PA_C01_QT01

Compare Last 12 Months and 4 Quarters (End of Quarter)

0HDCNT_LAST

Number of Employees

0HDCNT_FTE

Headcount FTE

Views

Various views are defined for this query that depict the variants of the query. The views represent technical objects and act as a data provider for the Web templates used for BW Web Reporting.

View

Description

0PA_C01_Q0110_V01

Headcount: Current (Without Drilldown)

0PA_C01_Q0110_V02

Headcount: Current

0PA_C01_Q0110_V03

Headcount: Current and Previous Month

0PA_C01_Q0110_V04

Headcount: 4 Quarters

0PA_C01_Q0110_V05

Headcount: 12 Months

0PA_C01_Q0110_V06

FTE: Current (Without Drilldown)

0PA_C01_Q0110_V07

FTE: Current

0PA_C01_Q0110_V08

FTE: Current and Previous Month

0PA_C01_Q0110_V09

FTE: Compare 4 Quarters

0PA_C01_Q0110_V10

FTE: Compare 12 Months

The views each evaluate specific aspects of the reporting options available in the query:

·        0PA_C01_Q0110_V01 Displays the absolute headcount in the current (just finished) calendar month.

·        0PA_C01_Q0110_V02 Displays the headcount in the current (just finished) calendar month. The report is run according to organizational units.

·        0PA_C01_Q0110_V03 Displays the headcount in the current (just finished) calendar month and previous month. The report is run according to organizational units.

·        0PA_C01_Q0110_V04 Displays the headcount for the end of the last four quarters (that is, the values of the last months of the last three quarters and the value of the last finished month in the current quarter). The report is run according to organizational units.

·        0PA_C01_Q0110_V05 Displays the headcount in the last 12 months. The report is run according to organizational units.

·        0PA_C01_Q0110_V06 Displays the absolute headcount in full-time equivalents in the current (just finished) calendar month.

·        0PA_C01_Q0110_V07 Displays the headcount in full-time equivalents in the current (just finished) calendar month. The report is run according to organizational units.

·        0PA_C01_Q0110_V08 Displays the headcount in full-time equivalents in the current (just finished) calendar month and previous month. The report is run according to organizational units.

·        0PA_C01_Q0110_V09 Displays the headcount in full-time equivalents in the last four quarters (that is, the values of the last months of the last three quarters and the value of the last finished month in the current quarter). The report is run according to organizational units.

·        0PA_C01_Q0110_V10 Displays the headcount in full-time equivalents in the last 12 months. The report is run according to organizational units.