Product

Business need

User Entity Name (BASE_USER_ENTITY_NAME)

Note

HR

Job, Position, Grade, Location, Department, Legal Employer, Operating Unit

PER_EXT_WORKSTRUCTURES_UE

PER_EXT_WORKSTRUCTURES_UE can be used in the Root block. Create child blocks for each of the Business object using block link on ENTITY_ID (eg: WORKSTCUTURE_UE.ENTITY_ID = PER_EXT_SEC_GRADE_UE.GRADE_ID ).

Department: PER_EXT_SEC_ORGANIZATION_UE (in block criteria use classification code as 'DEPARTMENT'),

Business Unit: PER_EXT_SEC_ORGANIZATION_UE (in block criteria use classification code as 'FUN_BUSINESS_UNIT'),

Job: PER_EXT_SEC_JOB_UE,

Grades: PER_EXT_SEC_GRADE_UE,

Location: PER_EXT_SEC_LOCATION_UE.

HR

Organizations

PER_EXT_SEC_ORGANIZATIONS_UE

Used to retrieve all the organization based entities like Department (Classification code = ‘DEPARTMENT’), Legal Employer (Classification code = ‘HCM_LEMP’), Business Unit (Classification code = 'FUN_BUSINESS_UNIT'). Need to explicitly filter specific organization by the classification code. Should be used as a root.

HR

Job EEO Code

PER_JOBS_LEG_EFF_HRX_US_JOBS_UE

HR

List of valid grades

PER_POSITION_VALID_GRADES_UE

 -

HR

List of all employees

PER_LEG_EMP_PERSON_UE

 Includes contingent workers.

HR

All persons and person related attributes across the enterprise

PER_EXT_SEC_PERSON_UE

Used to retrieve all the Person related information. Should be used as a root.

HR

All the Person, Assignment, Salary related information

PER_EXT_SEC_ASSIGNMENT_UE

Should be used as a root.

In order to get termination date use Entity PER_EXT_SEC_ASSIGNMENT_UE or PER_EXT_PAY_EMPLOYEE_UE as root. The Termination Date is property of Relationship and Assignment. Person Enterprise Termination Date should be used to get the last person termination date in the Enterprise.

HR

Reset

PER_EXT_RESET_UE

Used to organize sections at root level, it is a dummy container and if you need more than one of above user entities to be siblings. It is also used to reset effective date if you have used Historical User entities. Do not use this user entity unless you clearly know why it is used.

HR

List of employees and their addresses

PER_EXT_PERSON_ADDRESSES_UE

PER_EXT_PERSON_ADDRESSES_UE or PER_EXT_ADDRESSES_UE join with Usage Person id to parent block.

PER_EXT_ADDRESSES_UE

HR

Future hired employees

PER_EXT_SEC_PERSON_NOW_FUTURE_UE

 -

PER_EXT_SEC_HISTORY_PERSON_UE

HR

Employee's area of responsibility

PER_EXT_PAY_EMPLOYEES_UE PER_EXT_ASG_RESPONSIBILITIES_UE

 -

HR

Employee's Legal Seniority Date

PER_PERSON_ENTERPRISE_HIRE_DATE

This gives min(ppos.date_start) from periods of service (i.e. Enterprise Hire Date).

HR

Employee's Enterprise Seniority Date

PAYROLL_INTERFACE_ORIGINAL_DATE_OF_HIRE_UE

This gives min(pps.original_date_of_hire) from periods of services (i.e. Enterprise Seniority Date).

Hire date is more driven by Work relationship. have PER_EXT_WORK_RELATIONSHIP_ALL_UE as root and create filter based on Extract relationship start date.

HR

Job name

PER_JOB_JOB_DETAILS_UE

This UE contains name of the job.

Absence

Absence data

HcmAbsMgmtAccruals

These modules contain Absence data DBIs.

HcmEmploymentAbsences

HcmGblAbsencesProcesses

HcmGblAbsencesSetup

HcmWfmCore

Payroll

Employee

PER_EXT_PAY_EMPLOYEES_UE

Used to retrieve all the Person, Assignment, Salary, Payroll (Payroll, Element Entries) information. Note: Payroll Interface User entity also serves same purpose and hence can be used in its place as a secondary user entity for specific needs.

Payroll

Historical and current Element Entry values for the Employee

PER_EXT_PAY_EMPLOYEES

PER_EXT_PAY_EMPLOYEES as root block and child as ELEMENT ENTRIES RANGE. Join both of them with Payroll Relationship Id in block link.

ELEMENT ENTRIES RANGE