Discoverer Workbooks

The following table contains information regarding the Oracle Discoverer Workbooks that are supplied as part of Oracle HR for France.

It details the item types used by each worksheet, and any required keys that must be selected for the item type in order for the worksheet to display the correct data. This is done during the creation of the template in the Generic Summary Process window.

Field Field Lookup
Employment (E)
E1 1 Employee Category
E2 2 Employee Category
E3 3 Employee Category
E4 4 Employee Category, Month
E5 1 Employee Category, Gender
E6 1 Employee Category, Gender, Age
E7 1 Employee Category, Gender, Seniority
E8 1 Employee Category, Gender, Nationality
E9 1 Gender, CAGR
E10 5 Month
E11 23 None
E12 9 Gender
E13 7 Month
E14 10 Employee Category, Contract Category
E15 10 Employee Category, Contract Category
E16 10 Employee Category, Contract Category
E17 10 Employee Category, Age Less Than 25
E18 10 Employee Category, Seasonal Worker
E19 11 Employee Category, Leaving Reason
E20 11 Employee Category, Leaving Reason
E21 11 Employee Category, Leaving Reason
E22 11 Employee Category, Leaving Reason
E23 11 Employee Category, Leaving Reason
E24 11 Employee Category, Leaving Reason
E25 11 Employee Category, Leaving Reason
E26 12 Employee Category
E27 11 Employee Category, Leaving Reason
E28 11 Employee Category, Leaving Reason
E29 13 Employee Category
E30 14 Employee Category
E31 15, 16 Employee Category
E32 17 Employee Category
E33 18, 19 Employee Category
E34 20 None
E35 24 None
E36 21, 22 Employee Category
E37 21 Employee Category, Absence Category
E38 21 Employee Category, Absence Category
E39 21 Absence Duration Band
E40 51 Employee Category
E41 21 Employee Category, Absence Category
E42 21 Employee Category, Absence Category
E43 21 Employee Category
E44 21, 22 Employee Category
Remuneration and Fringe Benefits (R)
R1 30 Employee Category, Gender
R2 30, 34 Employee Category, Gender
R3.1 31 Employee Category, Gender, Month
R3.2 31 Employee Category, Gender
R4 32 Employee Category, Gender
R5 30, 33 Employee Category, Gender
R6 40 Employee Category, Remuneration Band
R7 34 None
R8 35, 36 None
R9 30 Employee Category
R10 30 Employee Category
R11 30, 37 Employee Category
R12 30, 38 Employee Category
Hygiene and Security (H)
H1 50 Employee Category
H2 51 Employee Category
H3 52 Employee Category
H4 53 Work Accident Code
H5 50, 60 Employee Category
H6 51, 60 Employee Category
H7 54 None
H8 55 None
H10 56 Work Accident Code
H11 56 Work Accident Code
H12 56 Work Accident Code
H13 56 Work Accident Code
H14 56 Work Accident Code
H15 56 Work Accident Code
H16 57 Illness Type
H18 58 Illness Type
C1 60 Employee Category
Other Working Conditions (C)
C2 61 Employee Category
C3 61 Employee Category
C4 62 None
C5 63 Employee Category
C6 64 Employee Category
C7 65 Employee Category
C8 66 Employee Category
C9 70 Employee Category
C11 71 Employee Category
C12 72 Employee Category
C21 67 Medical Examination Type
C22 67 None
C24 68 None
C25 69 None
Professional Bodies (P)
P1 90 Establishment, Representation Body
P4 91 None