| Excerpt-include | ||
|---|---|---|
|
|
How does it work?
Unlike other attributes, these 'derived attributes' cannot be assigned any value directly. A formula is associated with them based on which they derive the attribute value for every user, in real time. Continuing with the example of 'age' - if an attribute 'date of birth' is already available it is easy to derive 'age' based on it & the current date. As you would see in the screenshots below, a formula (with specific syntax) is associated with such attributes.
Employee Garrison app currently supports following two derived attributes.
- Stay with us - Gives you the duration of the employee's association with your company (using current date & joining date)
- Age - Derives a value that equals to the employee's age (using current date & date of birth)
Stay with us
Stay with us attribute is derived from joining date of employment details section. Stay with us attribute provides a value that is equal to the real-time tenure of the employee. If you look at the image below, the type of stay with us attribute is stated as 'derived' which is selected by default. You cannot make any changes in this attribute type and its formula. Let us see what formula is used to calculate the stay with our value.
Formula
DAYSDIFF([CurrentDate], att(9))
This syntax is specific to Employee Garrison.
How to find the attribute key?
Click on edit attribute from where you want to derive some value. On edit pop-up, you will see a number at the right top corner, that is the identifier used in the formula.
Final output on user profile
As per formula:
DAYSDIFF([CurrentDate], att(9))
1years,7 months, & 10 days = ([26 Apr 2018] - (16 Sep 2016))
Age
The same formula is applicable to the age attribute, which is again a derived attribute from date of birth in personal details section in the system.
Formula
DAYSDIFF([CurrentDate], att(305))
This syntax is specific to Employee Garrison.
Final output on a user profile
As per formula:
DAYSDIFF([CurrentDate], att(305))
29years,0 months, and 22 days = ([26 Apr 2018] - (04 Apr 1989))
| Info | ||
|---|---|---|
| ||
Currently, we have introduced 'stay with us & age' attributes as default derived attributes. If there are any other attributes that can help you enrich the employee profile - you can raise a request on our service desk. |
|
On this page
| Table of Contents |
|---|
In this section
| Child pages (Children Display) | ||
|---|---|---|
|