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 |