Overview of Assignment Segments in Workforce Compensation Plan Worksheets
You can include prorated values for relevant component worksheet columns is a separate table in the worksheet when you configure assignment segments.
Rather than multiple columns in the detail table, you can show the information using separate rows for each segment. And you can let managers make changes in the relevant fields. For example, the bonus amount for this person is calculated according to their eligible earnings and target percentage for 2 segments of time during the workforce compensation cycle.
| Start Date | End Date | Salary | Currency | Days Eligible | Proration Factor | Eligible Earnings | Target % | Target Amount | Modifier | Payout Amount |
|---|---|---|---|---|---|---|---|---|---|---|
| Jan 1 | Mar 14 | 75,000 | USD | 73 |
.2 (73/365) |
15,000 | 15 | 2,250 | 1.1 | 2,473 |
| Mar 15 | Dec 31 | 82,500 | USD | 292 |
.8 (292/365) |
66,000 | 20 | 13,200 | 1.1 | 14,520 |
| 16,995 | ||||||||||
The segment values, in this case payout amounts, are summed and shown in the table footer. When the manager clicks Apply, the total passes to the read-only worksheet column that you specified.