Average Age and Average Length of Service

Technical name: 0PA_C01_Q0111

Based on InfoCube: 0PA_C01

Use

This query displays the average age of and average length of service for employees in the last 12 months and in the last 4 quarters (at the 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)

0PA_C01_CK002

Average Length of Service

0PA_C01_CK001

Average Age

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_Q0111_V01

Average Age: Current (Without Drilldown)

0PA_C01_Q0111_V02

Average Age: Current

0PA_C01_Q0111_V03

Average Age: Current and Previous Month

0PA_C01_Q0111_V04

Average Age: 4 Quarters

0PA_C01_Q0111_V05

Average Age: 12 Months

0PA_C01_Q0111_V06

Length of Service: Current (Without Drilldown)

0PA_C01_Q0111_V07

Length of Service: Current

0PA_C01_Q0111_V08

Length of Service: Current and Previous Month

0PA_C01_Q0111_V09

Length of Service: 4 Quarters

0PA_C01_Q0111_V10

Length of Service: 12 Months

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

·        0PA_C01_Q0112_V06 Displays the absolute average age of employees in the current (just finished) calendar month.

·        0PA_C01_Q0111_V02 Displays the average age of employees in the current (just finished) calendar month. The report is run according to organizational units.

·        0PA_C01_Q0111_V03 Displays the average age of employees in the current (just finished) calendar month and previous month. The report is run according to organizational units.

·        0PA_C01_Q0111_V04 Displays the average age of employees at 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_Q0111_V05 Displays the average age of employees in the last 12 months. The report is run according to organizational units.

·        0PA_C01_Q0111_V06 Displays the absolute average length of service of employees in the current (just finished) calendar month.

·        0PA_C01_Q0111_V07 Displays the average length of service of employees in the current (just finished) calendar month. The report is run according to organizational units.

·        0PA_C01_Q0111_V08 Displays the average length of service of employees in the current (just finished) calendar month and previous month. The report is run according to organizational units.

·        0PA_C01_Q0111_V09 Displays the average length of service of employees 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_Q0111_V10 Displays the average length of service of employees in the last 12 months. The report is run according to organizational units.