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.
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.
Top 10 Popular Posts from our Knowledgebase
- DataFusing FREE Cloud based SQL Developer like tool for Oracle Cloud
- Core HR Entity Relationship Diagram (ERD) for HCM Cloud
- Most Frequently used Document IDs from Oracle Support
- FREE Oracle Training & Accreditation with Oracle Learning Explorer
- How HDL Transformation Formula works with ElementEntry Sample
- FREE Oracle Fusion Demo Instance (VISION) Access
- Top 10 FREE useful tools for Fusion Consultants
- Learning Fusion HCM Technical Skillset
- Sample HCM Data Loader (HDL) files for all Business Objects
- Most frequently used Tables list in Fusion HCM