Applications and Applicant Actions

Technical name: 0PARC_C01

Use

The Applications and Applicant Actions InfoCube (0PARC_C01) contains all of the data on applications and applicant actions that has been uploaded from one or more source systems. The data in this InfoCube is extracted from the Applicants (0HR_PA_RC_0), Applications (0HR_PA_RC_1), and Applicant Actions (0HR_PA_RC_2) InfoSources.

The InfoCube contains the general Number of Applicants (0APPL_CNT), Number of Applications (0APPLC_NUM), Number of Applicant Actions (0ACTION_CNT), and Age in Years (0AGE_KYF) key figures. Restricted key figures are also provided. Apart from these key figures, the InfoCube also includes numerous recruitment characteristics (such as Applicant Group, Applicant Range, Advertisement, and Instrument) that can be used in evaluations.

You can use the Calendar Day, Calendar Year/Month, Calendar Year/Quarter, and Calendar Year as time dimensions in your evaluations.

Several templates/structures containing key figures and/or specific calculation rules are provided with the InfoCube. The templates provide you with quick and easy access to frequently required evaluations (such as comparing the number of applications in the current year and previous year with absolute and percentage differences).

For more information on the InfoCube’s technical elements (characteristics, time characteristics, and so on) see the list below.

Because of the way in which the InfoSources are structured in the standard R/3 System, it is only useful to carry out some evaluations for certain InfoSources. For example, it makes sense to carry out application-related rather than applicant-action-related evaluations in the InfoSource Applications (0HR_PA_RC_1).

In the update rules, numerous fields are read from the master data tables at the end of the period (usually the last day of the month) and written to the InfoCube as characteristics. Therefore, you must ensure that master data is loaded and activated before the InfoSources.

InfoSources

0HR_PA_RC_0: Applicants

0HR_PA_RC_1: Applications

0HR_PA_RC_2: Applicant Actions

Characteristics

InfoObject

Description

0AGE_RANGE

Age Range

0ADVERT

Advertisement

0APPLICANT

Applicant

0APPLGROUP

Applicant Group

0APPLSGROUP

Applicant Range

0APPLICATION

Applicant Action Type

0APPLSTREA

Applicant Status Reason

0APPLSTATUS

Overall Status

0GENDER

Gender

0CNTCTEMPL

Contact Employee

0COUNTRY

Country

0AGE

Age in Years

0MEDIUM

Medium

0EMPLOYEE

Employee

0NATION

Nationality

0PERS_AREA

Personnel Area

0RC_INSTR

Recruitment Instrument

0PERS_SAREA

Personnel Subarea

0APPLREFID

Applicant Reference Indicator

0REFEMPL

Reference Employee

0UNSAPPGRP

Unsolicited Application Group

The Age in Years characteristic (0AGE) contains an applicant/employee’s age at the end of a period. You can define an age hierarchy according to the specific requirements of your enterprise, and then display the age structure of your enterprise, for example. To enable you to perform age-based calculations, the system includes the 0AGE_KYF key figure.

Time Characteristics

InfoObject

Description

0CALYEAR

Calendar Year

0CALMONTH

Calendar Year/Month

0CALQUARTER

Calendar Year/Quarter

0CALDAY

Calendar Day

Key Figures

InfoObject

Description

0APPL_CNT

Number of Applicants

0APPLC_NUM

Number of Applications

0ACTION_CNT

Number of Applicant Actions

0AGE_KYF

Age in Years

InfoObject

Description

Formula/Restriction

0R_PARC_001

Number of Applicants With ‘To Be Hired’ Status

Number of Applicants key figure, restricted by the applicant’s To Be Hired overall status

0R_PARC_002

Number of Applicants With ‘Contract Offered’ Status

Number of Applicants key figure, restricted by the applicant’s Contract Offered overall status

0R_PARC_003

Number of Applicants With ‘Offer Rejected’ Status

Number of Applicants key figure, restricted by the applicant’s Offer Rejected overall status

0R_PARC_004

Number of Unsolicited Applications

Number of Applications key figure, restricted to unsolicited applications (unsolicited application group 1-999)

0R_PARC_005

Number of Applications in Response to Advertisements

Number of Applications key figure, restricted to applications in response to advertisements (advertisement number 1-99 999 999)

Notes on InfoCube:

General

Because of the way in which the InfoSources are structured in the standard R/3 System, it is only useful to carry out some evaluations for certain InfoSources. For example, it makes sense to carry out application-related rather than applicant-action-related evaluations in the InfoSource Applications (0HR_PA_RC_1).

Characteristics

The Age Range (0AGE_RANGE) and Age in Years (0AGE) characteristics are calculated characteristics.

  • The Age Range characteristic contains the age of an applicant based on date of birth and the period from the respective InfoSource. The ranges are already determined by the update rules.

Note that you must edit the master data for this characteristic manually as follows:

0 Unavailable

1 < 20

2 20 - 29

3 30 - 39

4 40 - 49

5 50 - 59

6 60 - 69

7 ? 70

  • The Age in Years characteristic (0AGE) contains an applicant’s age at the end of a period. You can define an age hierarchy according to the specific requirements of your enterprise, and then display the age structure of your enterprise, for example. To enable you to perform age-based calculations, the system includes an Age in Years key figure (0AGE_KYF).

The age characteristics are calculated using update rules at the end of a period. The period depends on the InfoSource from which it is taken. For example, the end of the period can be at the end of a calendar day or month.

The Employee characteristic (0EMPLOYEE) represents an internal applicant in the Applications and Applicant Actions InfoCube (0PARC_C01).

The Contact Employee characteristic (0CNTCTEMPL) describes the employee who accepts/forwards an application addressed to the enterprise, or the employee to whom an application refers.

The Reference Employee characteristic (0REFEMPL) means the employee at the enterprise who can judge an applicant’s work, and then recommend or reject the applicant accordingly.

Key Figures

The system includes both the Number of Applicants (0APPL_CNT) and Number of Applications (0APPLC_NUM) key figures because one applicant can make several applications.

Restricted Key Figures

Restricted key figures are derived from InfoCube key figures by filtering one or more InfoCube characteristics. This results in the following restricted key figures:

  • Number of Applicants with the ‘To Be Hired’ Status (0R_PARC_001)
  • Number of Applicants with the ‘Contract Offered’ Status (0R_PARC_002)
  • Number of Applicants with the ‘Offer Rejected’ Status (0R_PARC_003)
  • Number of Unsolicited Applications (0R_PARC_004)
  • Number of Applications in Response to Advertisements (0R_PARC_005)

Hierarchies

  • Hierarchy for the Age in Years characteristic

SAP delivers age in years hierarchies in a CSV file. However, you can also define hierarchies for the Age in Years characteristic (0AGE). You can determine intervals within the structure as required, for example, in five-year intervals (25 - 29 years, 30 - 34 years, etc.) Therefore, the age structure that you define yourself offers advantages over the fixed age structure of the Age Range characteristic (0AGE_RANGE).

For example, you can use the hierarchy to display the age structure of your enterprise as follows:

< 20 [ ] x < 20

20 - 24 [ ] 20 ? x ? 24

25 - 29 [ ] 25 ? x ? 29

30 - 34 [ ] 30 ? x ? 34

35 - 39 [ ] 35 ? x ? 39

If you want to upload the hierarchy using the CSV file provided by SAP, proceed as follows:

  1. In the Administrator Workbench, choose the Source system tab page.
  2. Right click the top Source systems node, and choose Create source system.
  3. In the Select Source System Type dialog box, select File system, manual metadata, data using file interface.
  4. In the Create Source System dialog box, enter AGE_File in the Source system field, and Age in Years in the Name of source system field. Confirm your entries.
  5. Choose the InfoSources tab page.
  6. Right click the higher Master data in Personnel Administration node, and choose Create InfoSource.
  7. In the Create InfoSource: Select Type dialog box, select Master data / texts / hierarchies. Confirm your entry.
  8. In the Create InfoSource (Master Data) dialog box, enter 0AGE in the InfoObject field. Confirm your entry.
  9. Right click the lower Age in Years node, and choose Assign source system.
  10. In the Master Data InfoSource: Assign Source System dialog box, enter AGE_File in the Source system field. Confirm your entry.
  11. On the Maintain Metadata screen, choose Create hier. (create hierarchy).
  12. In the Create Hierarchy - Name dialog box, enter AGE in the Hierarchy name field, Age in Years (Hierarchy) in the Long description field, and an X in the Sorted hierarchy and Interval fields. Confirm your entries.
  13. Choose Save hier. (save hierarchy), followed by Save and Close.
  14. Right click the lower Age in Years (Hierarchy) node again, and choose Create InfoPackage.
  15. In the Create InfoPackage dialog box, enter a description as required in the Long description field. Confirm your entry.
  16. On the Scheduler (Maintain InfoPackage) screen, choose the External data tab page.
  17. In the Load external data from group box, select Application server. In the File type (if control file is switched off) group box, select CSV file.
  18. In the File name field, enter AGE_D.CSV for German node texts and AGE_E.CSV for English node texts. Save your entries.

Update Rules

In the update rules, numerous fields are read from the master data tables at the end of the period (usually the last day of the month) and written to the InfoCube as characteristics. Therefore, you must ensure that master data is loaded and activated before the InfoSources.

Structures

If structures include references to periods of time, the periods of time are represented by text variables (&0T_CYEAR&, &0T_CQUAT&) in the structure and preview. The appropriate values (calendar years, calendar quarters) are generated automatically when the queries are executed.

Example:

In the Comparison Previous Year / Current Year structure (0QT_PARC_001), the &0T_CYEAR& text variable is used for the "previous year" and "current year". When the query is executed, the text variable is replaced by the appropriate calendar years, that is, "previous year" is replaced by "1998", for example, and "current year" by "1999".

In the 4-Quarter Comparison (0QT_PARC_008) and Average 4 Quarters (0QT_PARC_009) structures, the basis of the calculation starts with the last complete quarter because it has complete values. For example, if a query compares 4 quarters and is started in the second quarter of 1999, the values of the 4 previous quarters - 1/99, 4/98, 3/98, and 2/98 - are compared.