SECTIONSSupported Day Ranges for Resource Skill Suggestion Notifications
The performance of notifications for resource skill suggestions is affected by the following factors:
- Average number of skills per assignment
- Number of assignments per resource within the days defined in the Skill Suggestions: Assignment Day Range custom setting field
- Value in the Skill Suggestions: Assignment Day Range field in the Skills Management Global Settings custom setting. This is the number of days to include closed assignments. For more information, see Skills Management Global Settings.
The day that the job to send notifications runs also affects performance. We recommend that you schedule the job to run on a day when few resources use the org. You can do this using the Day of the Month method. For more information, see Scheduling Skill Suggestion Notifications for Resources.
Determining the day range value is key to preserve performance. For that, you can use the following formula:
TR = 50 * A * (1 + S)
A: Average number of yearly assignments per resource
S: Average number of skills per assignment
TR: Total number of records. This must remain below 45,000.
To determine the day range, complete the following steps:
- Apply the formula above.
-
Do one of the following depending on the result:
- If TR is below 45,000, set Skill Suggestions: Assignment Day Range to 365.
-
If TR is over 45,000, complete the following steps:
- Repeat step 1 using half the value of A.
-
Do one of the following:
- If the value is below 45,000, set DR to 180.
- If the value is still above 45,000, iteratively halve A until the value is under 45,000. For each reduction of A, also halve the Skill Suggestions: Assignment Day Range value, starting from 365.
The following table shows sample scenarios for the day range depending on the number of skills and yearly assignments, given that assignments last longer than five days and skills zones are not used.
| Skills per Assignment | Maximum Yearly Assignments per Resource | Skill Suggestions: Assignment Day Range |
|---|---|---|
| 5 | 120 | 365 |
| 10 | 60 | 365 |
| 15 | 30 | 365 |
| 20 | 20 | 365 |
If your average assignments per resource exceeds the maximum, lower the Skill Suggestions: Assignment Day Range value to ensure the maximum assignments for the day range is respected. For example, for 20 skills per assignment and 60 assignments per resource, set the Skill Suggestions: Assignment Day Range value to 90 - 120.
We recommend that you do not set a value higher than 365 in the Skill Suggestions: Assignment Day Range field, unless the yearly number of assignments for each resource is very low.
If you need assistance to determine the day range, contact your Customer Support representative.
Supported Day Ranges for Daily Assignments
When resources are potentially allocated to an assignment each day, you can use the following formula to calculate the day range:
DR = D * 45,000 / 50 * (1 + S)
DR: Maximum day range. We recommend lowering this value to the nearest full month.
D: Average days between assignments per resource. For assignments that last a day, this value is 1.
S: Average number of skills per assignment
The formula includes a safety margin.
The following table shows sample scenarios for the day range, depending on the number of skills per assignment and the number of assignments per resource. The values are purposefully lowered to the nearest full month.
| Skills per Assignment | Maximum Daily Assignments per Resource | Skill Suggestions: Assignment Day Range |
|---|---|---|
| ≤5 | 120 | 120 |
| ~10 | 60 | 60 |
| >10 | <30 | <30 |
Supported Day Ranges When Using Skill Zones
Skill zones impact the data processing significantly. When skill zones are used, the number of skills per assignment becomes more important because the additional processing scales with the number of unique skills across assignments.
Day Ranges for Assignments Lasting More Than Five Days
The following table includes sample scenarios for the day range when assignments last more than five days.
| Skills per Assignment | Maximum Assignments per Resource | Skill Suggestions: Assignment Day Range Value |
|---|---|---|
| 5 | 90 | 365 |
| 10 | 40 | 180 |
| >15 | 20 | 60 |
Day Ranges for Daily Assignments
When resources are potentially allocated to one assignment per day, you can use the following formula to calculate the day range:
DR = D * 45000 / (20 * (1 + S * (1 + Z)))
DR: Maximum day range. We recommend lowering the value to the nearest full month when the resulting value is over 30.
D: Average days between assignments per resource. For assignments that last a day, this value is 1.
S: Average number of skills per assignment
Z: Average number of skill zones per skill
The formula includes a safety margin.
The following table includes sample scenarios for the day range. It is assumed that each skill is unique and there are three skill zones per skill. The values are purposefully lowered from the maximum assignments per resource that might be set according to the formula.
| Skills per Assignment | Maximum Daily Assignments per Resource | Skill Suggestions: Assignment Day Range Value |
|---|---|---|
| ≤5 | 90 | 90 |
| ~10 | 40 | 30 |
| >15 | 20 | 14-20 |