Work Relationship Table in Oracle Fusion HCM

In Oracle Fusion HCM, the “Work Relationship” is a fundamental concept that represents the association between an individual worker and the organization they are employed by. The Work Relationship captures essential information about the employment status, job details, assignment details, and other pertinent data related to the worker’s relationship with the organization.

The primary table in Oracle Fusion HCM that stores Work Relationship information is typically named “PER_ALL_ASSIGNMENTS_M.” This table contains a wealth of data related to the worker’s assignments, including:

1. Assignment Details: Information about the worker’s job assignment, such as position, department, location, and manager.
2. Dates: Start and end dates for the assignment, which indicate when the worker began and, if applicable, ended the specific employment.
3. Employment Status: The worker’s employment status, which could be “Active,” “Terminated,” “On Leave,” etc.
4. Compensation: Information about the worker’s compensation, including salary, pay rates, and payment methods.
5. Job and Position: Details about the worker’s job title and the position they hold within the organization.
6. Assignment Category: Categorization of the worker’s assignment, such as regular employment, temporary assignment, etc.
7. Work Schedule: Information about the worker’s work hours and schedules.
8. Probation Period: If applicable, details about any probationary period for new employees.
9. Termination Details: If the work relationship has ended, this table may contain termination-related information.

It’s important to note that Oracle Fusion HCM may use different tables or have additional tables to store specific details related to Work Relationships, depending on the implementation and version. Also, the table names may have a suffix like “_TL” for multilingual support or “_X” for extensibility columns.