Legal Employer and Enterprise Service Dates in Fusion
Legal Employer and Enterprise Dates on Work Relationship

 985 total views

In this article we will look into where the Legal Employer and Enterprise Dates are stored and which field on the application is stored in which attribute on back end tables.

Want to learn Fusion Technical tools? Checkout this article

We have Legal Employer and Enterprise level service dates on Work Relationship. We will look into what these fields mean and also the tables where the information is stored.

Legal Employer Service Dates relate to work relationships with a legal employer.

  • The Legal Employer Start Or Hire Date is the start date of the work relationship.
  • The Legal Employer Seniority Date is the date on which a person’s legal employer service of a particular type (employee, contingent worker, or nonworker) is based. A person can have up to three legal employer seniority dates for a single legal employer. If you enter no date, the legal employer seniority date is assumed to be the start date of the work relationship.

Enterprise Service Dates relate to a person’s service with the enterprise rather than with individual legal employers.

The Enterprise Start Or Hire Date is the start date of a person’s first work relationship of this type (employee, contingent worker, or nonworker) in the enterprise.

  • For example, a person’s nonworker enterprise start date is the start date of the person’s first nonworker work relationship with any legal employer in the enterprise. Therefore, a person can have up to three enterprise start dates one for each type (employee, contingent worker, or nonworker).

The Enterprise Seniority Date is the date on which a person’s enterprise service is based. By default, the enterprise seniority date is the start date of the person’s current primary work relationship.

All these dates are stored in the PER_PERIODS_OF_SERVICE. For every new work relationship a person has, there will be a new entry on this table.

Legal Employer Hire Date – This would be the DATE_START field on PER_PERIODS_OF_SERVICE for that corresponding assignment.
Legal Employer Seniority Date – This would be the ADJUSTED_SVC_DATE on the PER_PERIODS_OF_SERVICE for that corresponding assignment.

Enterprise Hire Date – This would be the minimum DATE_START field on PER_PERIODS_OF_SERVICE for the employee.
Enterprise Seniority Date – This would be the ORIGINAL_DATE_OF_HIRE field on the PER_PERIODS_OF_SERVICE. And this date would be same for all records on the PER_PERIODS_OF_SERVICE even if multiple records exists due to multiple work relationships.

This information is also present in Workforce Management – Work Relationship Real Time subject area Work Relationship Details folder.

Join our fastest growing technology social groups to interact with experts in the Fusion space and get your queries resolved – Telegram group, Facebook Page and LinkedIn Group

The following two tabs change content below.
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

Leave a Reply