BalReddy
ServiceNow Employee

 

Split a Resource Assignment

This article explains how to use Split in the Resource Management Workspace to divide one resource assignment into two at a date you choose. Effort, rates, and actuals are kept intact.

This is useful when you need to divide a resource's allocation across different time periods, reassign work mid-stream after splitting, separate future work when actuals are posted on the past.

 

What "Split" means

Split Work divides an existing resource assignment into two separate assignments at a split date:

  • The original assignment keeps its effort from the original start date up to, but not including, the split date. It keeps its sys_id, and its end date becomes the day before the split date.
  • A new assignment is created with the effort from the split date to the original end date. It gets a new sys_id.

Split doesn't add or remove effort. It divides the existing daily allocations between the two assignments.

 

 

Before you begin

  • Role required: resource_manager or it_project_manager or it_demand_manager.
  • The assignment must be a user resource assignment. Group child assignments can't be split.
  • The assignment must span at least 2 days. 1-day assignment can't be split.
  • The split date must fall between the assignment's start and end dates.
  • The split date must be after the last date with actuals (time entries).

 

About this task

Split is available from the row menu (⋯) of a resource assignment on a Resource Board in the Resource Management Workspace.

It works with every effort type (FTE, Hours, Person Days) and on Project Tasks, Demands, Epics, and operational work assignments. You can split an assignment more than once, including assignments that were created by a previous split.

Key behavior: The daily allocations from the split date onward move to the new assignment. Both assignments are then rolled up again from daily allocations, so their effort, cost, and FTE values match their own date ranges.

 

Procedure

  1.    Navigate to Workspaces > Resource Management Workspace and open a Resource Board.
  2.    Set the calendar view (Week or Month) and the effort view (Hours, FTE, or Person Days).
  3.    Find the resource assignment row you want to split.
  4.    Select the ellipsis (⋯) menu on the row.
  5.    Select Split.
  6.    Review the dialog, which shows:
  • Task Name
  • Resource Name
  • RA Start Date
  • RA End Date
  1.    Enter the Split Date, the date the new assignment should start.
  2.    Select Split to confirm. The board refreshes and shows two assignment rows.

BalReddy_0-1793815872447.png

 

 

Worked examples

Example 1: FTE assignment, even distribution

Field

Value

Assignment start

2024-08-05

Assignment end

2024-09-13

Effort type

FTE = 1 (8 h per working day)

Split date

2024-08-12

 

Before the split, there is one assignment:

Date range

Daily hours

Weekly total

2024-08-05 → 2024-08-09

8 h × 5 days

40 h

2024-08-12 → 2024-08-16

8 h × 5 days

40 h

2024-08-19 → 2024-08-23

8 h × 5 days

40 h

2024-08-26 → 2024-08-30

8 h × 5 days

40 h

2024-09-02 → 2024-09-06

8 h × 5 days

40 h

2024-09-09 → 2024-09-13

8 h × 5 days

40 h

Total

 

240 h (30 working days × 8 h)

 

After the split, there are two assignments:

Assignment

Date range

Daily rows

Allocated hours

Original

2024-08-05 → 2024-08-09

5 × 8 h

40 h

New

2024-08-12 → 2024-09-13

25 × 8 h

200 h

Total

 

 

240 h

 

Key Takeaway: Split divides the existing daily allocations at the split date. The total effort (240 h) is unchanged across the two assignments.

 

Example 2: Hours assignment, uneven daily contour

Field

Value

Assignment start

2024-08-05 (Monday)

Assignment end

2024-08-09 (Friday)

Effort type

Hours, 34 h with a different hours each day

Split date

2024-08-08

 

Before the split:

Day

Date

Hours planned

Monday

5 Aug 2024

4 h

Tuesday

6 Aug 2024

8 h

Wednesday

7 Aug 2024

6 h

Thursday

8 Aug 2024

8 h

Friday

9 Aug 2024

8 h

Total

 

34 h

 

After the split:

Assignment

Date range

Allocated hours

Original

2024-08-05 → 2024-08-07

18 h (4 + 8 + 6)

New

2024-08-08 → 2024-08-09

16 h (8 + 8 )

 

The daily contour is kept exactly as it was. Split moves the existing daily values and doesn't spread effort evenly across the new range.

Key Takeaway: Split moves the existing daily values as they are. Split functionality retains the contour.

 

Behavior reference

What each assignment keeps after a split

  • Start date: The original assignment keeps its start date. The new assignment starts on the split date.
  • End date: The original assignment ends on the day before the split date. The new assignment keeps the original end date.
  • Effort type: The original assignment keeps its effort type, and the new assignment uses the same effort type.
  • Effort value: Each assignment holds only the effort that falls in its own date range.
  • Group, role, and skill: The original assignment keeps its group, role, and skill, and the new assignment uses the same values.
  • Rate override: The original assignment keeps its rate override, and it's copied to the new assignment.
  • Rate model: Both assignments use the same project-level rate model.
  • Resource status: The original assignment keeps its resource status, and it's copied to the new assignment.
  • Actuals (time entries): The original assignment keeps all its actuals. The new assignment starts with 0 actuals.

How the rollup works

  1.    The existing resource_allocation_daily records are divided between the two assignments at the split date.
  2.    Aggregate hours and cost are recalculated on each resource_allocation record.
  3.    The recalculated values are synced back to each resource_assignment record (effort, person days, FTE).

Related data is updated as well: the weekly and monthly resource aggregate tables, resource plans, and effort estimates.

Schedules

Split works with standard and custom user schedules, such as a standard 8-5, Monday/Wednesday/Friday only, 10 hours a day, half days, and once a month. Each assignment keeps the daily values that fall in its own range.

 

Frequently encountered messages

Situation

Message

Split date is the same as the assignment's start date

Split duration should be at least for one day

Split date is before the assignment's start date

Split date should be within the current assignment period

Split date is after the assignment's end date

Split date should be within the current assignment period

Split date is on or before the last actuals date

You can split a resource assignment for the period for which actual hours are not captured. The selected resource assignment contains actuals till {date}

Assignment dates are outside the task's date range (not checked for operational work)

Duration of the assignment should be within the project date range. Realign the assignments to task and try again.

Task has no start or end date (not checked for operational work)

Task has empty start or end dates. Please update the task dates and try again

 

Limitations and known constraints

  • Split isn't available on group assignments, it is available only on user assignments.
  • Split isn't available on single-day assignments. The start date must differ from the end date.
  • The split date must be after the last actuals date.
  • Assignment dates must be within the task's date range. This doesn't apply to operational work assignments.
  • The task must have start and end dates. This doesn't apply to operational work assignments.
  • The new assignment gets a new sys_id. The original keeps its sys_id with a shorter date range.

 

Version history
Last update:
6 hours ago
Updated by:
Contributors