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.
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.