Defining Segmentation

This chapter provides an overview of segmentation and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Segmentation Setup

Segmentation refers to the process of calculating all or a subset of elements in a process list in separate slices or segments. You can segment components of pay based on events such as changes in compensation or employee status during a pay period. For example, if an individual changes jobs during a pay period and your organization separates components earned in the first job from those earned in the second job, you can set up the system to trigger segmentation of earnings results on the payslip when there’s a change to the job change action/reason field in PeopleSoft Enterprise Human Resources.

This section discusses:

Click to jump to top of pageClick to jump to parent topicTypes of Segmentation

Global Payroll offers two types of segmentation:

Selecting Elements to Segment

With period segmentation, the system segments all elements on the process list automatically. With element segmentation, you must specify which elements in the process list to slice. To do this, you add the elements to be segmented to an element list that you define using the Segmentation Event Definition page that is described in this chapter.

See Also

Defining Segmentation Events and Types

Click to jump to top of pageClick to jump to parent topicRelationship of Period, Segment, and Slice Dates

For every pay period, the system generates begin and end dates for:

All three sets of dates (period, segment, and slice) are generated, regardless of whether a period is sliced or segmented. The begin and end dates for periods, segments, and slices, are stored in the output result tables for the period and made available as system-computed elements for use in other calculations.

Example 1: Unsegmented Period

In an unsegmented period the number of periods equals the number of segments, which equals the number of slices. All three have identical begin and end dates.

This diagram illustrates the relationship between period, segment, and slice begin and end dates for an unsegmented period.

An unsegmented period

Example 2: Segmented Period

This diagram shows a period with two segments; segment 1 contains a sliced element:

A segmented period

Click to jump to top of pageClick to jump to parent topicBasic Rules of Element Resolution

This section discusses the basic rules of element resolution for period and element segmentation.

Using Period Segmentation

With period segmentation, all elements are resolved once for each segment.

Using Element Segmentation

When using element segmentation:

Note. To define the elements to be sliced, you use the Segmentation Event Definition page.

Example of Period Segmentation

In period segmentation, all elements are calculated once for each segment and there are multiple gross-to-net processes.

This table lists examples of elements and the associated period segmentation rules:

Element

Calc Rule

Base

%

Prorate

E1 (Base Pay)

Amount

N/A

N/A

Yes

E2

Base × Percent

E1

10%

No

D1 (Deduction)

Base × Percent

A1

10%

No

A1 (Accum)

E1 + E2

N/A

N/A

N/A

Assume that E1 represents base pay and that the value of E1 increases from 10,000 to 20,000 on September 16, triggering the segmentation of the September pay period into two equal parts. This scenario is represented in this table:

Element

Segment 1: September 1– September 15

Segment 2: September 16– September 30

E1 (Base Pay)

10,000 × ½ = 5,000

20,000× ½ = 10,000

E2

E1, Segment 1 × 10% = (5,000 × 10%) = 500

E1, Segment 2 × 10% = (10,000 × 10%) = 1,000

A1

Sum of E1 and E2 for Segment 1 = (5,000 + 500) = 5,500

Sum of E1 and E2 for Segment 2 = (10,000 + 1,000) = 11,000

D1 (Deduction)

A1 for Segment 1 × 10% = 550

A1 for Segment 2 × 10% = 1,100

Net Pay

Net Pay for Segment 1 = 4,950

Net Pay for Segment 2 = 9,900

In this example, all the elements on the process list are segmented and there are two separate gross-to-net processes.

Example of Element Segmentation

When you use element segmentation, the system segments only those elements that are included in the list of elements to be segmented. The system performs only one gross-to-net calculation.

This table lists examples of elements and associated segmentation rules:

Element

Calc Rule

Base

%

On Element List for Segmentation?

Prorate

E1 (Base Pay)

Amount

N/A

N/A

Yes

Yes

E2

Base × Percent

E1

10%

No

No

D1 (Deduction)

Base × Percent

A1

10%

No

No

A1 (Accum)

E1 + E2

N/A

N/A

No

N/A

Assume that E1 represents base pay and that the value of E1 increases from 10,000 to 20,000 on September 16, triggering the slicing of element E1 into two equal parts. This scenario is represented in this table:

Element

Slice 1: September 1–September 15

Slice 2: September 16–September 30

E1 (Base Pay)

10,000 × ½ = 5,000

20,000 × ½ = 10,000

E2

Sum of E1 × 10% = (5,000 + 10,000) × 10% = 1,500

A1 (Accumulator)

Sum of E1 and E2 = (15,000 + 1,500) = 16,500

D1 (Deduction)

A1 × 10% = (16,500 × 10%) = 1, 650

Net Pay

14,850

E1 is sliced once on September 16, resulting in two separate calculations for E1—one for each slice. There is only one gross-to-net process, and the Net Pay element represents the sum of E1 in each slice and E2 in each slice minus D1 (deduction 1).

See Also

Defining Segmentation Events and Types

Click to jump to top of pageClick to jump to parent topicEffective-Dated Element Definitions

All effective-dated elements contain a Definition as of Date field that tells the system which effective-dated row to use when retrieving the definition of an element. Options include calendar period begin date, calendar period end date, and payment date.

The same Definition As Of Date definition is used for all segments and slices within the period.

See Also

Understanding the Process of Selecting Definition As Of Dates

Click to jump to top of pageClick to jump to parent topicRules for Slicing Accumulators and Accumulator Members

This section describes the rules for slicing accumulators and accumulator members.

Using Period Segmentation

With period segmentation, every element and supporting element is segmented—a situation cannot exist in which an element is segmented but the accumulator to which it belongs isn’t segmented.

Using Element Segmentation

The slicing of a member of an accumulator does not cause slicing of the accumulator, but the slicing of an accumulator causes all member elements to be sliced.

Rules for slicing an accumulator that is used as a driver are covered in the chapter that discusses multiple resolutions of earnings and deductions.

See Also

Defining Element Segmentation with Accumulator Drivers and Driver Elements

Click to jump to top of pageClick to jump to parent topicRules for Parent and Child Element Resolutions

When an element is composed of (or based on) other elements, the system defines those other elements as child elements and the elements that are based on them as parent elements. Elements and supporting elements can be parents or children.

Say Tax A is a percentage of earnings E1 and earnings E2 (Tax A = 10% × ( E1 + E2)). In this example, Tax A is the parent and earnings E1 and earnings E2 are the children. The concept of child and parent elements is central to understanding how an element that’s based on other elements is resolved.

Matching and Mismatching Slices and Segments

During period segmentation, all elements are segmented equally, and parent and child elements always match.

During element segmentation, parent and child elements can be sliced equally, or one may be sliced more than the other. For example, the parent might be included in the list of elements to segment, while the child is not. If the parent and child slices are identical, the parent and child are said to match; if they are not identical, they are referred to as mismatching.

Global Payroll follows specific rules for processing matching and mismatching elements. These rules are illustrated in the following examples.

Examples 1–7: Parent Element Is a Primary Element or a Supporting Element

The following cases use these elements:

This table summarizes the examples that follow in this section. The child and parent slices in these examples do not always match, as indicated in the Match/No Match column.

Case Number

Parent Action

Child Action

Child Type

Match/No Match

Process Rule

1

Sliced

Not Sliced

Primary Element (E2)

No Match

Use the value of the child for each slice of the parent.

2

Sliced

Sliced

Primary Element (E2)

Match

Use the slice value of the child for each slice of the parent.

3

Sliced

Sliced

Primary Element (E2)

Partial Match

Child Sliced More

Sum the value for each child slice that matches the parent slice.

4

Sliced

Sliced

Primary Element (E2)

Partial Match

Child Sliced Less

Use the Slice value of the child where dates match. If they don’t match, sum the value of all child slices. May return incorrect values.

5

Sliced

Sliced

Primary Element (E2)

No Match

Sum the value of all child slices. May return incorrect values.

6

Not Sliced

Sliced

Primary Element (E2)

No Match

Sum of the child values.

7

Sliced

Not Sliced

Supporting Element (F1)

Not applicable.

Matching does not matter when the child is a supporting element.

Resolve the value of the child for each slice of the parent.

(See note following case details.)

Note. The following examples show the results with and without proration. Prorated amounts are in parentheses.

Case 1

Assumptions:

E2 (primary element) = 100

E3 (primary element) = 10% of E2

Proration on E3

Scenario: Parent is sliced; child is not sliced. Child is a primary element.

E3 (parent)

Slice 1

10% of 100 (50)

Slice 2

10% of 100 (50)

E2 (child)

Slice 1

100

Each slice of E3 uses the full value of the child (E2), producing a warning message.

Case 2

Assumptions:

E2 (primary element) = 100

E3 (primary element) = 10% of E2

Proration on E2

Scenario: Parent is sliced; child is sliced. Child is a primary element.

E3 (parent)

Slice 1

10% of 100 (50)

Slice 2

10% of 100 (50)

E2 (child)

Slice 1

100 (50)

Slice 2

100 (50)

When the parent's slice dates equal the child's slice dates, the parent uses the child's value. Although the slice dates match, without proration, the results may be incorrect.

Case 3

Assumptions:

E2 (primary element) = 100

E3 (primary element) = 10% of E2

Proration on E2

Scenario: Parent is sliced; child is sliced more. Slices partially match. Child is a primary element.

E3 (parent)

Slice 1

10% of 100 (33.33)

Slice 2

10% of 200 (33.33 + 33.34)

E2 (child)

Slice 1

100 (33.33)

Slice 2

100 (33.33)

Slice 3

100 (33.34)

Slice 1 of the parent and child match, so the system sums the child slices (slice 1, in this example). For the second slice of E3 (the parent), the system sums slice 2 and slice 3 of E2 (the child), because the begin date of slice 2 and end date of slice 3 match slice 2 of E3 (the parent). This scenario will generate a warning message.

Case 4

Assumptions:

E2 (primary element) = 100

E3 (primary element) = 10% of E2

Proration on E2

Scenario: Parent is sliced; child is sliced less. Slices partially match. Child is a primary element.

E3 (parent)

Slice 1

10% of 100 (33.33)

Slice 2

10% of 200 (66.67)

Slice 3

10% of 200 (66.67)

E2 (child)

Slice 1

100 (33.33)

Slice 2

100 (66.67)

Generally, if the child is a primary element, it should be on the same list of elements to be segmented as the parent element. This ensures that both the child and parent have matching slices. Otherwise, the above scenario could occur and should be avoided.

The resolution is twofold. When there are exact matches (as in slice 1 of the parent and the child), the system uses the child’s value. If the parent or the child has proration turned on, the result is correct. The second resolution of the parent sums all resolutions of the child (200, in this example), resulting in an overcalculated amount. This is because the system cannot get a match on the slice dates for the parent and the child. Even with proration turned on, the amount of the child is overstated (see the amounts in parentheses).

Case 5

Assumptions:

E2 (primary element) = 100

E3 (primary element) = 10% of E2

Proration on E2

Parent is sliced. Child is sliced. No match on slice dates. Child is a primary element.

E3 (parent)

Slice 1

10% of 300 (100)

Slice 2

10% of 300 (100)

E2 (child)

Slice 1

300 (100)

Slice 2

300 (100)

Slice 3

(100)

Generally, if the child is a primary element, it should be on the same list of elements to be segmented as the parent element. This ensures that both the child and parent have matching slices. Otherwise, the above scenario could occur and should be avoided.

As in the second resolution in Case 5, when the parent’s slice dates do not match any child slice dates, the system sums the value of all child slices for each resolution of the parent, resulting in a warning message.

Case 6

Assumptions:

E2 (primary element) = 100

E3 (primary element) = 10% of E2

Proration on E2

Parent is not sliced. Child is sliced. No match on slice dates. (Slice dates are not applicable to the parent.) Child is a primary element.

E3 (parent)

Slice 1

10% of 200 (100)

E2 (child)

Slice 1

200 (100)

Slice 2

200 (100)

When the parent isn’t sliced, and the child is—and the child is a primary element—the resolution of the parent element sums the values of all resolutions of the child, generating a warning message.

Case 7

Assumptions:

E1 (primary element) = 10% of F1

F1 (supporting element) = 100

Proration on E1

Parent is sliced. Child is not sliced. Child is a supporting element.

E1 (parent)

Slice 1

10% of 100 (50)

Slice 2

10% of 100 (50)

F1 (child)

Slice 1

100

Slice 2

100

Slice 1 of E1 resolves child for the slice 1 time period. F1 is sliced because, as a supporting element child, it will resolve for each parent’s slice.

Note. A parent element that is on the process list as well as the list of elements to be segmented, dictates the time period of the slice periods. If the supporting element is populated through an array, bracket, or a formula, then that array, bracket or formula element must be on the same list of elements to segment as the parent. (Define the list of elements to segment using the Element List grid on the Segmentation Event Definition page that is described in this chapter.)

General Rules for Warning Messages

If the child element is a primary element and its slice dates don’t match the parent’s slice dates, the following situations can cause warning messages:

If the child element is an accumulator, a warning message is issued whenever the accumulator’s slice dates don’t match the parent’s slice date.

Click to jump to top of pageClick to jump to parent topicSegmentation and Payee Overrides

You can define two types of overrides at the payee level:

Both types of overrides are called payee overrides, and the system follows the same basic rules for applying these overrides to segmented and unsegmented periods. Generally, when a pay period has period or element segmentation, payee overrides are applied to a segment based on the segment end date and the end date of the override, following the rules below. The rules are the same for primary and supporting element overrides at the payee level; only primary element overrides are discussed here. Any minor differences in these two types of overrides are clarified in the following examples.

The rules for applying overrides at the payee level are:

This diagram shows an example of a primary element override:

A primary element override

The following examples offer a more detailed view of how payee overrides are applied to segmented and unsegmented periods:

Scenario: Two payees are eligible to receive an earnings element (E1) whose value is 100. Assume that Payee 1 has no segmentation and that Payee 2 has period segmentation in the January pay period. The segment dates for Payee 2 are January 1, 2005−January 15, 2005 and January 16, 2005–January 31, 2005. The payees have identical supporting element overrides, and the pay period being processed is January 1, 2005–January 31, 2005. This table lists cases that show how the system applies primary element overrides:

Note. In this example, override is abbreviated Over.

Case

Over. Begin Dt

Over. End Dt

Over. Value

Payee 1 Results

Payee 2 Results

Reasons

1

Jan. 1, 2000

Dec. 31, 2004

200

100

100

End date is less than period/segment end date.

2

Jan. 1, 2000

Jan. 5, 2005

200

100

100

End date is less than period/segment end date.

3

Jan. 1, 2005

Jan. 5, 2005

200

100

100

End date is less than period/segment end date.

5

Jan. 5, 2005

Jan. 20, 2005

200

100

S1=200

S2=100

For Payee 2, Segment 1 uses the override because the end date is greater than Segment 1’s end date.

6

Jan. 20, 2005

Jan. 25, 2005

200

100

100

The override’s begin date is greater than Segment 1’s end date and its end date is less than Segment 2’s end date, so the override doesn’t apply to either segment of Payee 2. For Payee 1, the override’s end date is less than the end date of the period, so no override applies.

7

Jan. 5, 2005

Jan. 31, 2005

200

200

S1=200

S2=200

The override’s begin date is before the end date of Segment 1, and its end date is greater than or equal to the end dates of both segments, so it applies to both segments.

8

Jan. 20, 2005

Feb. 1, 2005

200

200

S1=100

S2=200

For Payee 2, Segment 1 doesn’t use the override, because the override’s begin date is greater than Segment 1’s end date.

Note. Although these examples refer to period segmentation, the same basic rules apply to element segmentation—if a sliced element is overridden at the payee level, the override applies to the slices just as it applies to segments with period segmentation.

See Also

Setting Up Overrides

Click to jump to top of pageClick to jump to parent topicProration and Segmentation

This section discusses:

Segmentation with Proration

To have the system prorate a segmented earnings, deduction, or frequency-based entitlement element, specify proration as part of the element's definition. Then, when segmentation or slicing occurs, the element automatically calls the appropriate proration rule.

You must define the proration rule to use in segmentation processing, because the rule is not hard-coded. Generally, a proration rule that you define consists of a numerator, representing the slice or segment, and a denominator, representing the entire pay period.

You can determine how to define the numerator and denominator that constitute the proration factor. The numerator and denominator can be any of these elements:

Note. When you define a proration element, the Always Recalculate check box on the Proration Name page is automatically selected. This is to ensure that the system correctly calculates the proration factor when there is element segmentation.

Segmentation without Proration

To apply segmentation without proration, select the No Proration option on the Rounding/Proration page of the Earnings/Deduction Definition component or the Absence Entitlement component.

Example: Segmentation without proration.

This table provides an example of segmentation without proration:

Element

Calc Rule

Base

%

On Element List for Segmentation?

Prorate

E1 (Base Pay)

Amount = 20,000

N/A

N/A

Yes

No

E2

Base × Percent

E1

10%

No

No

A1 (Accum)

E1 + E2

N/A

N/A

No

N/A

E3

Base × Percent

A1

10%

No

No

Note. You can slice or segment a period without applying proration, but an element cannot be prorated unless there is segmentation.

Assume that E1 represents base pay and that E1 is sliced on September 16, halfway through the pay period. None of the interrelated elements are defined to be prorated. This scenario is represented in this table:

Element

Slice 1: September 1– September 15

Slice 2: September 16– September 30

E1 (Base Pay)

20,000

20,000

E2

(E1, Slice 1 + E1, Slice 2) × 10% = (20,000 + 20,000) × 10% = 4,000

A1 (Accumulator)

Sum of E1 (Slice 1 + 2) and E2 = (40,000 + 4,000) = 44, 000

E3

A1 × 10% = (44,000 × 10%) = 4,400

Because E1 is not defined to be prorated, the system incorrectly calculates the value of E1 in each slice (slices 1 and 2) as 20,000 (the true value in each slice should be 20,000 × ½). This leads to additional errors: When E2 is calculated, the system sums up E1 in each slice, to yield a value of 40,000 × 10% (the correct amount is 20,000 × 10%). Similarly, A1 resolves to 44,000 instead of 22,000. And E3, defined as A1 × 10%, resolves to 44,000 × 10%, yielding 4,400 (the correct result is 2,200).

It’s important to understand why segmentation does not automatically result in proration. For example, if E2 is a percentage of E1 and both are sliced, E1, but not E2, is prorated.

Note. When you define a proration element, the Always Recalculate check box on the Proration Name page is automatically selected. This is to ensure that the system correctly calculates the proration factor when there is element segmentation.

Click to jump to top of pageClick to jump to parent topicRetroactive Processing and Segmentation

When a retroactive trigger is generated in response to an event, the system writes the effective date of the change to trigger occurrence tables. The system uses this date to determine how far back in time to recalculate closed periods, using this logic:

See Also

Defining Backward and Forward Retroactive Processing Limits

Trigger Table Data

Defining Retroactive Processing

Click to jump to top of pageClick to jump to parent topicPositive Input with Segmentation

Like payee level overrides, positive input enables you to override the value of an element in a pay period. And like payee overrides, positive input uses begin and end dates (the begin and end dates are optional with positive input). Thus, when a calendar pay period has period or element segmentation, positive input is assigned to a segment or slice based on the end date of the instance. Unlike payee overrides, positive input is applied only to a single element or slice and is never prorated. Other rules that affect the assignment of positive input are:

See Also

Segmentation Considerations

Click to jump to top of pageClick to jump to parent topicSegmentation System Elements

This table lists the system elements that are delivered for segmentation:

System Element

Description

FIRST ACT SEGMENT

First Active Segment (Y/N) Indicates whether the segment that is being processed is the first active segment within the calendar period.

FIRST SEGMENT

First Segment (Y/N) Indicates whether the segment that is being processed is the first segment within the calendar period.

LAST ACT SEGMENT

Last Active Segment (Y/N) Indicates whether the segment that is being processed is the last active segment within the calendar period.

LAST SEGMENT

Last Segment (Y/N) Indicates whether the segment that is being processed is the last segment within the calendar period.

Click to jump to top of pageClick to jump to parent topicSetting Up Segmentation

This section provides an overview of setting up segmentation and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Segmentation

To set up segmentation:

  1. Define an event ID and segmentation type on the Segmentation Event Definition page.

    Segmentation can be caused by events such as paygroup transfers, pay entity transfers, and new hires. The system does not automatically know what type of segmentation (period or element) to apply to an event. When you create an event ID, you specify:

  2. Define the fields that trigger segmentation on the Trigger Definition page, and link them to the event ID.

    These fields become trigger fields, which trigger segmentation in response to changes in payee data. By attaching the event ID to a field, you tell the system what type of segmentation to use when the event occurs.

See Also

Setting Up Triggers

Segmentation Triggers

Click to jump to top of pageClick to jump to parent topicPages Used to Set Up Segmentation

Page Name

Object Name

Navigation

Usage

Segmentation Event Definition

GP_SEG_EVENT

Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Triggers, Segmentation Event Definitions, Segmentation Event Definition

Define segmentation events, specify a segmentation type, and select individual elements for segmentation.

Trigger Definitions

GP_TRGR_SETUP

Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Triggers, Trigger Definitions, Trigger Definitions

Define triggers.

Click to jump to top of pageClick to jump to parent topicDefining Segmentation Events and Types

Access the Segmentation Event Definition page.

Country

Displays the country that uses the trigger event ID defined on this page. Event IDs are defined by country because one country (or organization in a country) might decide to process an event by segmenting one subset of elements (in the case of element segmentation), whereas another might decide to process the same event by segmenting a different subset of elements. Or one country might use period segmentation while another uses element segmentation to process the same event.

Trigger Event ID

Displays the trigger event ID that you entered to access this page.

This ID tells the system which segmentation type to use to process segmentation events and which elements to segment if you use element segmentation.

Segment Type

Select a segment type. Options are Period and Element.

See Types of Segmentation.

Effective Date

Enter the effective date of the trigger event ID. You can enter multiple effective-dated rows for each trigger event ID if the trigger event definition changes.

Status

Select the status of the trigger event ID. Options are Active and Inactive.

Element List

If you use element segmentation to process an event, you must specify which elements in the process list should be sliced, because element segmentation affects only a limited set of elements. Enter the elements to be segmented in the Element List group box.

Entry Type

Select the type of element to segment. Options are: Abs Entitl (absence entitlement), Array, Bracket, Date, Deduction, Earnings, Formula, Seg Accm. (segment accumulator), and WritArray (writable array).

Only segment accumulators are available for segmentation.

Element Name

Select the element name.

See Also

Defining Backward and Forward Retroactive Processing Limits

Trigger Table Data

Defining Retroactive Processing

Click to jump to top of pageClick to jump to parent topicDefining Trigger Fields

Access the Trigger Definition page.

On this page you define the fields that trigger segmentation, and link them to an event ID.

Note. The Trigger Definition page is also used to define iterative and retroactive triggers.

See Also

Setting Up Triggers

Click to jump to top of pageClick to jump to parent topicManaging Segmentation

Trigger data is generated automatically by the online system based on the conditions that you specify during setup. After the online system generates segmentation triggers, use the Review Triggers - Segmentation page to manage those triggers so that segmentation occurs only when you want it to—and only in response to appropriate changes in system data.

This section discusses how to view, add, and cancel segmentation triggers.

Click to jump to top of pageClick to jump to parent topicPage Used to Manage Segmentation

Page Name

Object Name

Navigation

Usage

Review Triggers - Segmentation

GP_TRIGGER_SEG

Global Payroll & Absence Mgmt, Absence and Payroll Processing, Prepare Payroll, Review Triggers, Segmentation

View, add, or cancel segmentation triggers.

Click to jump to top of pageClick to jump to parent topicViewing, Adding, and Canceling Segmentation Triggers

Access the Review Triggers - Segmentation page.

Use this page to view segmentation triggers for each employee ID/employee record combination. You can also manually add and delete trigger rows through this page.

See Also

Setting Up Triggers

Viewing and Managing Triggers