1. HCM Data Loader
  2. Examples of Changing First Effective Start Date and Last Effective End Date

Examples of Changing First Effective Start Date and Last Effective End Date

For some objects, you can change the first effective start date or last effective end date. This topic provides examples showing how to make these changes.

To change an object's first effective start date, you include the ReplaceFirstEffectiveStartDate attribute in the .dat file and set it to Y. To change an object's last effective end date, you include the ReplaceLastEffectiveEndDate attribute in the .dat file and set it to Y. You supply the revised dates on the EffectiveStartDate or EffectiveEndDate attribute, as appropriate. You can make these changes at the same time as other changes. For example, you can change both the start date of an object and its name.

Note: The ReplaceFirstEffectiveStartDate and ReplaceLastEffectiveEndDate parameters don't appear in object template files or on the Attributes tab of the Business Object Details page. However, you can add them to .dat files for date-effective objects that support these changes.

These restrictions apply to changing first effective start date and last effective end date:

  • For some objects, the last effective end date must be 4712/12/31. Any attempt to change this date causes an error.

  • You can't change the first effective start date of the Worker object in this way. Instead, you must use the NewStartDate attribute.

  • When you include the ReplaceLastEffectiveEndDate attribute in a .dat file, you must specify a date value for the EffectiveEndDate attribute. You must not supply a #RETAIN, #ALL, or #NULL token in place of the effective end date.

Tip: On the Component Details tab of the Business Object Details page, identify whether you can change a component's first effective start or last effective end date. For example, in the Date Effectivity section on the Component Details tab for the Job object, the First start date option is selected. Therefore, you can include the ReplaceFirstEffectiveStartDate parameter in the .dat file.

Changing the First Effective Start Date of a Job Object

This example shows how to include the ReplaceFirstEffectiveStartDate attribute in a .dat file.

METADATA|Job|JobId|EffectiveStartDate|EffectiveEndDate|ReplaceFirstEffectiveStartDate
MERGE|Job|23452|1950/01/01|4712/12/31|Y

Changing the Last Effective End Date of a Recurring Element Entry

This example shows how to include the ReplaceLastEffectiveEndDate attribute in a .dat file.

METADATA|ElementEntry|ElementEntryId|EffectiveStartDate|EffectiveEndDate|ReplaceLastEffectiveEndDate
MERGE|ElementEntry|4634|2014/01/01|2014/04/05|Y

Related Topics