1. HCM Extracts
  2. Create Attributes

Create Attributes

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

You decide the number of attributes based on the specific information required for that report. Create the following attributes for the Department Details record:
  • Department Name
  • Department Location
For the Department Summary record, create the following attributes:
  • Record Code
  • Report Date
  • Employee Count
For the Employees Details record, create the following attributes:
  • Full Name
  • Gender
  • Date of Birth
  • Salary
  • Bonus
  • Tax Rate
  1. Select the Departments data group from the Hierarchy and select the Department Details record.
  2. Create the following extract attributes for the Department Details record and select Save. An extract attribute is an individual field of a record.
  3. Complete the fields to create extract attributes for the Department Details record, as shown in this table:
Field Name Attribute Entry Attribute Entry
Name Department Name Department Location
Type Database item group Database item group
Database Item Group Organization Name Organization Location Country
  1. Save the record, then select the Department Summary record.
  2. Select the Add icon in the Extract Attributes region.
  3. Create the following extract attributes for the Department Summary record and select Save.
  4. Complete the fields to create extract attributes for the Department Summary record, as shown in this table:
Field Name Attribute Entry Attribute Entry Attribute Entry
Name Record Code Report Date Employee Count
Data Type Text Date Number
Type String Parameter Element Summary Element
String Value 999 NA NA
Parameter Effective Date NA NA
Aggregate Function NA NA Count
Aggregate Record Name NA NA Employees Employee Details
  1. Select the Employees data group from the Hierarchy and select the Employee Details record.
  2. Create the following extract attributes for the Employee Details record and select Save.
  3. Complete the fields to create extract attributes for the Employee Details record, as shown in this table:
Field Name Attribute Entry Attribute Entry Attribute Entry
Name Full Name Gender Date of Birth
Start Date 1/1/00 1/1/00 1/1/00
Data Type Text Text Date
Type Database Item Group Decoded database item group Database item group
Database Item Group Person Full Name Person Gender Person Date of Birth
  1. Complete the fields to create more extract attributes for the Employee Details record, as shown in this table:

What to do next

Field Name Attribute Entry Attribute Entry Attribute Entry
Name Salary Bonus Tax rate
Start Date 1/1/00 1/1/00 1/1/00
Data Type Number Number Text
Type Database item group Record Calculation Rule
Database Item Group Assignment Salary Amount NA NA
Calculation Expression NA Salary * 0.5 NA
Rule NA NA FAST Bank Tax Rule