Oracle Fusion HCM Work Relationship Table

In Oracle Fusion HCM, the “Work Relationship” concept is used to manage an individual’s association with an organization, encompassing employment, contingent worker status, or other types of affiliations. While there isn’t a specific “Work Relationship” table, there are several tables that store information related to work relationships in Oracle Fusion HCM. Here are some key tables and views that might be relevant:

1. PER_ALL_ASSIGNMENTS_F:

• This table stores information about an individual’s assignments, including details about their job, position, employment terms, and assignment status.

1. PER_PERIODS_OF_SERVICE_V:

• This view provides information about periods of service for employees, including start and end dates of assignments.

1. PER_ASSIGNMENT_SUPERVISORS:

• This table stores data about the supervisor or manager associated with an assignment.

1. PER_PEOPLE_LEG_F:

• This table stores legal employer data related to an individual’s work relationships, such as legal employers they are associated with.

1. PAY_PAYROLL_RELATIONSHIPS:

• This table contains information about the payroll relationships between individuals and legal employers.

1. PER_PERSON_NAMES_F:

• This table stores various name-related information, including the effective dates for different names.

Please note that the specific tables and views available might vary based on the Oracle Fusion HCM version and the modules you’re using. The tables mentioned above provide information related to work relationships, assignments, and associated data. You can use these tables to gather insights into an individual’s work history, employment terms, supervisors, and related details.