What is an extract definition?

Title and music

Hello, my name is Ken. In this video, I’ll explain the components of an extract definition.

An extract definition refers to the complete setup of an extract, with various components, such as: Data Group, Record, Attributes, Parameters, and Delivery Options.

Extract data groups represent a business area or logical entity (for example person, assignment, or benefits). The application uses this information to retrieve the database item groups. You define one data group as the primary or root data group and this data group is the starting point of data extraction.

Extract records represent a grouping of related data or a physical collection of all fields required in the extract. For example, the Employee data group can have records such as Basic Details, Pay Details, Location Details, and Primary Contact.

Attributes are the individual fields inside the extract record. An attribute is the lowest attribute level of a HCM extract and represents a piece of information. For example: Person First Name, Person Last Name, or Person Date of Birth.

While creating an extract, the application saves the extract definition and automatically generates parameters based on the type of extract. The parameters control the output of an extract. Some common parameters are Effective Date, Legislative Data Group (LDG), and so on.

Delivery options give you the choice of sending the extract output in the required format to the third-party application. You can send the output to email, a File Transfer Protocol server, or a Universal Content Management server based on your business requirements.

For more information on this topic, you can view the courses on Oracle University or reference the available guides on Oracle Help Center.

Thanks for watching.