Create Data Groups and Extract Data Group Connections

As part of the Define Extracts process, you need to create two data groups: one for the department and one for employees. You also need to create extract data group connections.

Here are the steps:

1. Click the Design tab to create the data groups and records.
2. Create the root data group with the following information:

   Field Name	Entry
   Name	Departments
   Tag Name	Departments
   User Entity	PER_EXT_SEC_ORGANIZATION_UE
   Threading Database Item	Extract Organization Business Group ID

3. Click Save.
4. Note: The Enable Object Snapshot option appears only for the root data group.
   Select Enable Object Snapshot to allow object snapshot support through the REST service. Selecting this also enables the object snapshot key attribute. Object Snapshot Key attribute is derived from the Threading Database Item (Extract Organization Business Group ID).

   For details on Object Snapshot REST API, see Object Snapshots REST Endpoints in REST API for the Oracle HCM Cloud guide.

5. Click Add to define a new data group.
6. Complete the fields to create a new data group, as shown in this table:

   Field Name	Entry
   Name	Employees
   User Entity	PER_EXT_SEC_ASSIGNMENT_BASIC_UE

7. Click Save to create a data group for Employees.
8. Select Employees in the Object Name tree and define the data group connection details.
9. Click the Connect Data Groups tab.
10. Complete the fields to create a data group connection, as shown in the table:

    Field Name	Entry
    Parent Data Group Database Item	Extract Organization ID
    Database Item	Extract Assignment Department ID

11. Click Save.

What to do next

Define the data group filter criteria for each data group by selecting the Filters tab.

Defining a set of filtering conditions lets you restrict the data extraction. The application uses these conditions to perform the extraction on the extract data group using the extract data group criteria.

You can specify the data group filter as an expression or as a fast formula, and you can choose one or both. You can build criteria using the available database items, parameters, and operators (conditional and logical). The filter criteria become efficient as HCM Extract appends it to the User Entity SQL at the time of execution. If you can't specify the criteria as an expression, then you can place logic inside a fast formula and include this in your definition. Fast formulas return values of Y or N to indicate whether you must extract the record or not. If both criteria and formula are specified, then both conditions are applied.