Guidelines for Making Date-Effective Changes to Salary Range Differentials

The Salary Range Differential object is date-effective to maintain a history of any changes to the object and its child components. For example, people can see the date-effective history of a differential profile in the Compensation work area.

When you create or update a differential value, you're also adding a date-effective record to the differential value. You also need to add a date-effective record to the parent differential profile if it has no date-effective record for that effective start date. To do this, you need to include in the .dat file the parent Salary Range Differential component. It needs to have the same effective start date as the child differential value.

Here's an example of history of changes to a differential profile.

RangeDiffId	EffectiveStartDate	EffectiveEndDate	Status	Criteria	LegislativeDataGroupId	Code	Name
123	01-01-1951	01-05-2016	Active	Location	US1	US SRD	US Range
123	02-05-2016	31-12-4712	Active	Location	US1	US SRD	US Range

Here's an example of the related changes to its differential values.

RangeDiffValueId	EffectiveStartDate	EffectiveEndDate	Differential	LocationId
234	01-01-1951	31-12-4712	1.3	A
345	02-05-2016	31-12-4712	0.8	B
456	02-05-2016	31-12-4712	0.9	C

When the location B value was created, a date-effective record with the location B effective start date was also added to the differential profile. But, when the location C value was created, no date-effective record was added to the differential profile. A record for that effective start date already existed in the differential profile, so no other record was needed. If you create or update multiple differential values on the same date, then only one date-effective record is added to the parent differential profile.

Note: You don't have to include the parent Salary Range Differential component in the .dat file if the file already has a date-effective record with the required effective start date.

If you correct or update the parent Salary Range Differential object, then no date-effective record is added to its child components. For example, if you make the differential profile inactive, then a new date-effective record is added to the parent component. But, no date-effective record is added to the differential values.