AIS Administrative Information Services

Oracle*HR (Human Resources)

Introduction

The Human Resources application covers the most valuable of CERN resources: people.

Management of people at CERN includes: the administrative management of people and the qualitative management of people.

Oracle*HR is now becoming the unique entry point for registering people and has already gathered more than 11 databases giving therefore more consistency and avoiding multiple data entry.

The currently used version of Oracle HR is HR 11.i with the applet based web user interface.

Access

Note that only central services (Record Office, Users Office, Registration Office, FI etc) have access to Oracle HR interface. Other potential users should use either HRT or EDH HR Admin (see table below). These CERN-made applications use a specific user interface to access Oracle HR data.

Usage	Kind of user	Application to be used
Data retrieval	Central Services	OHR LiveView
	Any	HRT
Data entry	Central Services	Oracle HR
	Divisional/Group Secretariat	HR Admin
	Experimental Secretariat	HR Admin

Given the upper table and if you need access to Oracle HR 11i please follow the FAQ (Frequently Asked Questions).

System Requirements

Since version 11.5.10, Oracle HR is only supported on Windows XP and Internet Explorer 7.
(a workaround exists to make Oracle HR run on Windows Vista)

Other combination of OS / Browser might work but are NOT supported but a Windows XP based configuration is accessible for Mac users through Windows Terminal Services.

Documentation

• From Oracle*HR click on the help button in the toolbar to access online help
• For CERN related questions, a FAQ (Frequently Asked Questions) is also available
  This FAQ is available in English and French

Overview

• Personal information management
• Assignments (contract) management
• Payroll elements management
• Absence entitlement management
• Career management
• Management of official documents, access rights, etc...
• Structures management (divisions, experiments) etc.
• (Recruitment management) - replaced by e-RT since 2004

• CERN staff and their families
• CERN users
• External firm staff
• External persons needing services (access, computer accounts etc.)
• Pre-registered persons from PRT and e-RT

Key figures:

• ca 100 registered users
• >180000 people registered
• >15 Giga bytes of data
• Have a look at the data HR manages with the CERN Human Resources Statistics and Reports made by HR Department

Dependencies: data sources and client applications

Click on the picture on the left to get a more precise image of AIS applications dependencies.

Apart from manual entry made by specialized services, ORACLE*HR gets its data from:

• EDH (Electronic Document Handling) for overtime information, hours worked (weekly reports), leave information...
• e-RT: the electronic Recruitment Toolkit provides all the personal information about candidates who have applied at CERN
• HR Access: the payroll computes and transfer to HR the absence entitlement figures monthly
• Foundation: through this central repository, HR gets the financial structures, email addresses etc. from other systems

• HRT: provides a user friendly interface for retrieving and consolidating HR data stored in Oracle*HR.
• Foundation: HR provides all human resources data to Foundation as well as organization and experiments structures. These data are then used by many other applications (CCDB, Phonebook, EDH, ORIAC, SIRIAC) from Foundation
• AVCL: the Advance and Claims application gets all personal data from Oracle*HR
• HR Access: the payroll is caculated monthly based on HR data
• PIE: the experiments specific user interface to Oracle*HR
• PAD: the divisional specific user interface to Oracle*HR
• CTA: the CERN Training Application used by Education Services.