Create Extract Records

As part of the Define Extracts process, you need to create extract records.

You decide the number of records based on the subgroup of attributes within a data group. In this example, you create two records for the Departments data group:
  • Department Details
  • Department Summary
You create one record for the Employees data group: Employee Details.

To create the records for the Departments data group:

  1. Select the Departments data group from the Object Name tree and click Add > Record.

    Extract records represent a physical collection of all required fields. If a data group has 3 records, then you can specify the sequence in which the application processes the records using the sequence field. You can also select the Next Data Group to identify which data group the application processes next.

  2. Create two records for the Departments data group.
  3. Complete the fields to create two records for the Departments data group, as shown in this table:
Field Department Summary Department Details
Name Department Summary Department Details
Sequence 15 10
Type Detail Record Detail Record
Process Type Fast Formula Fast Formula
Next Data Group NA Employees
  1. Click Save.
  2. Select the Employees data group from the Object Name tree and click Add > Record.
  3. Create one record for the Employees data group. Complete the fields to create a record for the Employees data group, as shown in the table:
    Field Name Entry
    Name Employee Details
    Sequence 5
    Type Detail Record
    Process Type Fast Formula
  4. Click Save.