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.