Create Attributes
As part of the Define Extracts process, you need to create attributes.
- 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:
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 |
|
NA |
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 |
You can click on an attribute to see the basic and additional information for the
attribute. Additionally, review the Hidden,
Required, and Wrap as CDATA check
boxes for the attribute.
Note: When business object attribute
values are supplied with special characters, it can lead to extraction failures.
Select Wrap as CDATA to prevent such issues.