1. Using Compensation
  2. Assignment Segment Tables in Compensation, Detail Table Only, Performance, and Promotion Worksheets

Assignment Segment Tables in Compensation, Detail Table Only, Performance, and Promotion Worksheets

You can see prorated values for people whose assignments changed during the workforce compensation cycle in a separate assignment segments table. Each row of the table shows you the information for that segment of the cycle.

For example, this person's bonus amount 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,475
Mar 15 Dec 31 82,500 USD 292 .9

(292/365)

 66,000 20 13,200 1.1 14,520
16,995

The table footer shows the summed segment values, in this case payout amounts. When you click Apply, the total passes to the read-only worksheet column specified in the worksheet setup. The Apply button is only available if at least one row in the assignment segment table has a status of Eligible.

Caution: You can't save your changes in the assignment segments table by clicking Save or Save and Close for the worksheet.

To see the Assignment Segments table, you need to view the detail table content as a list, and not a tree. If a segment has an Ineligible status, you can only read the values for that segment. Also, you can only read the values when the person's assignment is processed or partially processed. And then only if you have read-only access to the worksheet.

Compensation administrators can see all assignment segment columns, even columns that you, as a manager, don't have visibility for when they administer workers. They can also update segment eligibility and values.

Restrictions

Here's what you can't do with the enabled worksheet assignment segments:

  • Reorder columns, apply filters, or sort rows in the assignment segments table. The table columns appear according to the assignment segments setup.
  • Freeze columns in either the detail or the assignment segments table.
  • Export the detail table content using the Export to Excel icon.
  • Include assignment segment content using Manage in Spreadsheet.