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

Complete the following steps to create attributes for the records:

1. Select the Department Details record in the Departments data group and click the Attribute tab.
2. Click Add > Database Items to search and select the following database items:
   • Organization Name
   • Organization Location Country
3. Click Save. An extract attribute is an individual field of a record.
4. Select the Department Summary record in the Departments data group and click the Attribute tab.
5. Click Add and select the following attributes:
   • String
   • Parameter
   • Summary Element

   Complete the fields as shown in the table to create extract attributes and save the record:

   Field Name	Attribute Entry	Attribute Entry	Attribute Entry
   Type	String	Parameter Element	Summary Element
   Name	Record Code	Effective Date	Employee Count
   Data Type	Text	Date	Number
   Output Column	1	2	3
   String Value	999	NA	NA
   Parameter	Effective Date	NA	NA
   Aggregate Function	NA	NA	Count
   Aggregate Record Name	NA	NA	Employees Employee Details

6. Select the Employee Details record in the Employees data group and click the Attribute tab.
7. Click Add > Database Items to search and select for the following database items:
   • Person Full Name
   • Person Gender
   • Person Date of Birth
8. Complete the fields as shown in this table to create extract attributes and save the record.

Field Name	Attribute Entry	Attribute Entry	Attribute Entry
Type	Database Items	Decoded Database Items	Database item group
Database Item	Person Full Name	Person Gender	Person Date of Birth
Name	NA	Gender	NA
Data Type	Text	Text	Date
Output Column	1	2	3
Decoded Value	NA	'M','1','F','0','','*'	NA

9. Click Save.

What to do next

Create more extract attributes for the Employee Details record, as shown in the table:

Field Name	Attribute Entry	Attribute Entry	Attribute Entry
Type	Database item group	Record Calculation	Rule
Database Item Group	Assignment Salary Amount	NA	NA
Name	Salary	Bonus	Tax rate
Output Column	4	5	6
Calculation Expression	NA	Salary * 0.5	NA
Rule	NA	NA	FAST Bank Tax Rule