User Entities in HCM Extracts

A user entity is a logical entity associated with a data group defined using HCM extracts. This topic describes the often used user entities and the type of data you can extract by using those user entities.

You select user entities in the application when you define a data group.

The following table lists the most often used user entities.

User Entity Name and Code

Description

Person (PER_EXT_SEC_PERSON_UE)

Retrieves all persons across the enterprise and all person related attributes.

Employees (PER_EXT_PAY_EMPLOYEES_V2_UE)

Returns Person, Assignment, and Payroll details as on effective date.

Extract Assignment Basic History (PER_EXT_ASSIGNMENT_BASIC_HISTORY_UE)

Retrieves assignment history as on the assignment effective start date.

Extract Assignment Basic Information (PER_EXT_SEC_ASSIGNMENT_BASIC_UE)

Retrieves assignment data as on the effective date.

Assignments Range (PER_EXT_SEC_ASSIGNMENT_RANGE_UE)

Retrieves assignment history as on the effective date.

Extract Current and Future Persons (PER_EXT_SEC_PERSON_NOW_FUTURE_UE)

Retrieves current and future person details. Specify advanced filter criteria to restrict person types.

Extract Current and Future Assignments (PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE)

Retrieves current and future assignments.

Reset Context (PER_EXT_RESET_UE)

Use the Reset Context user entity in two ways:

  1. Reset the effective date contexts set dynamically by a parent data group using a runtime input parameter for the effective date. For example, the Extract Assignment Basic History user entity sets the assignment effective start date as effective date first and then retrieves the data, unlike other user entities which use the effective date only. To use the Extract Assignment Basic History user entity to include the historical data but also want to change the effective date, then include the Reset Context user entity to reset this date using input parameters.

  2. Set up the Reset Context user entity as the root user entity to be a container or header. For example, the following work structure elements: locations, positions, and legal employers aren't related to each other. To extract all in one single extract, then you can add them as child elements to the Reset Context user entity used as the root in the extract definition. Adding this user entity as the root to these elements enables you to retrieve this data separately because the elements aren't linked to a hierarchy.

Assignment Standard Working Hours (PER_ASG_SEQ_HISTORY_DETAILS_UE)

The function per_extract_utility.get_standard_working_hours selects the standard working hours for a position attached to the assignment, or for the organization, or to the legal entity, in that order.

You can view more details about the user entities using the View User Entity Details task.