1. Implementing Global Human Resources
  2. Overview of Seniority Dates

Overview of Seniority Dates

You can define, manage and use the seniority of workers using version 3 or version 1 of the seniority dates functionality.

You can configure V3 seniority dates using the Configure Seniority Dates task and a fast formula. You can manage them using the Seniority Dates task under Quick Actions.

This table describes the differences based on the decision points:

Decision V1 Version of Seniority Dates V3 Version of Seniority Dates
Available from Release 1 Release 13.17.11 (17D)
Steps required to enable seniority dates None Run the Enterprise Scheduler Service (ESS) job: Migrate to Version 3 of Seniority Dates
Which seniority dates can be managed?

Only the following seniority dates:

  • Enterprise Seniority Date
  • Legal Employer Seniority Date

Customers can configure the seniority dates at different levels, such as Person, Work Relationship, and Assignment for the following attributes:

  • Business Unit
  • Bargaining Unit
  • Collective Agreement
  • Country
  • Department
  • Enterprise
  • Grade
  • Grade Step
  • Job
  • Legal Employer
  • Location
  • Position
  • Union
From where are the seniority dates managed? Work Relationship UI Seniority Dates UI
Can the seniority dates be entered during Hire flows? Yes

No. However, refer to this MOS document for an alternate solution:
How are seniority dates calculated? Manually entered or Manually updated Automatically calculated when the following ESS job is run: Calculate Seniority Dates
Is the seniority calculated in real time? N/A No, the following ESS job must be run regularly to recalculate the seniority dates: Calculate Seniority Dates
How are the seniority dates updated or adjusted? Manually on the Work Relationship UI

Automatically based on Employment actions.

Additionally, manual adjustments can be entered for the seniority dates on the Seniority Dates UI.
The Legal Employer Seniority Date is 1-May-2018 and needs to be updated to 1-Apr-2018. How is the seniority date updated in this case? The Legal Employer Seniority Date is corrected to 1-Apr-2018. Provide an adjustment of 30 days for the configured Legal Employer Seniority Date. This will update the seniority date to 1-Apr-2018 when the ESS job is run.
Do you need to configure seniority dates?

No configuration is required.

Note: If you want to default the enterprise seniority date as the first hire date, you must set the Default Enterprise Seniority Date employment configuration option to Yes at the enterprise level.

 Seniority rules configuration is required. Use the Configure Seniority Dates task.
Can Fast Formula be used to calculate seniority dates? No

Yes

These formula types are supported:

  • Employment Seniority Date Adjustment
  • Employment Seniority Hours to Days Conversion
Do you need to update any worker assignment before the data migration? No

Yes

Update the seniority basis for all worker assignment records to the appropriate values in days or hours. You can do this using HCM Data Loader.
Do you need to run any process post data migration? No

Run the following ESS job to calculate the seniority dates for workers: Calculate Seniority Dates

This ESS job needs to be run regularly or scheduled to recalculate the seniority dates for workers.
What are the considerations when uploading worker assignments? None

You must provide a value of ORA_PER_SNDT_DAYS for the Seniority Basis attribute.

File Name: worker.dat

File Discriminator: Assignment

Attribute: SeniorityBasis
How can I update seniority dates using HCM Data Loader?

The Enterprise and Legal Employer seniority dates can be updated using the following parameters:

File Name: worker.dat

File Discriminator: WorkRelationship

Attributes: EnterpriseSeniorityDate, LegalEmployerSeniorityDate

 Not Supported
How can I load seniority date adjustments using HCM Data Loader? N/A

Adjustment for each configured seniority rule can be uploaded using the following parameters:

File Name: worker.dat

File Discriminator: SeniorityDate

Attributes: ManualAdjustmentDays, ManualAdjustmentComments
Are Database Items (DBIs) available for seniority dates? Yes Yes
Which is the table storing the seniority dates configuration? N/A PER_SENIORITY_DATES_SETUP
Which is the table storing the seniority dates of workers? PER_PERIODS_OF_SERVICE PER_SENIORITY_DATES_F
Can seniority dates be reported using Oracle Transactional Business Intelligence (OTBI)? Yes Yes
Can seniority dates be used in Eligibility Profiles? Yes Yes

For more information, see these documents on Customer Connect:

  • Seniority Dates - Troubleshooting Seniority Dates - Frequently Asked Questions (https://community.oracle.com/customerconnect/discussion/631046)

  • Seniority Dates V3 - Calculating Seniority Dates Using Fast Formula (https://community.oracle.com/customerconnect/discussion/631033)

  • Seniority Dates V3 - Common Use Cases Configured Using V3 Seniority Dates (https://community.oracle.com/customerconnect/discussion/631036)

  • Seniority Dates V3 - Enabling Enterprise and LE Seniority During Hire (https://community.oracle.com/customerconnect/discussion/631039)

Note:

If you're using V3 seniority dates, you can't view and manage V1 seniority dates of the legal employer and enterprise on the Work Relationship page.

Related Topics