Attributes for Worker Work Relationship

This table lists the main attributes of the Worker Work Relationship business object and exceptions for attributes, if any.

Attribute	Field Name	Description
ACTION_OCCURRENCE_ID	When and Why ID	Foreign Key to PER_ACTION_OCCURRENCES.
ACTUAL_TERMINATION_DATE	Actual Termination Date	Actual date of termination of employment.
ADJUSTED_SVC_DATE	Adjusted Service Date	Adjusted Service Date. For example, all plans for a rehire who was part of an acquisition may use the original hire date if they are rehired within 90 days of termination. However, a 401k plan may use the adjusted service date which was originally populated upon acquisition.
BUSINESS_GROUP_ID	Business Group ID	Identifier of Enterprise, used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS.
COMMENTS	Comments	This stores a comment associated with termination of work relationship.
CREATED_BY	Created By	Who column: indicates the user who created the row.
CREATION_DATE	Creation Date	Who column: indicates the date and time of the creation of the row.
DATE_START	Employment Start Date	Start date of the period of employment.
LAST_UPDATE_DATE	Last Updated Date	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	Last Update Login	Who column: indicates the session login associated with the user who last updated the row.
LAST_UPDATED_BY	Last Updated By	Who column: indicates the user who last updated the row.
LAST_WORKING_DATE	Last Working Date	Last Date Worked (for terminated workers).
LEGAL_ENTITY_ID	Legal Entity ID	Represents Legal Entity.
LEGISLATION_CODE	Legislation Code	Legislation code derived from Legal Entity.
NOTIFIED_TERMINATION_DATE	Termination Notification Date	Date when the termination of employment was noted.
OBJECT_VERSION_NUMBER	Object Version Number	Used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ORIGINAL_DATE_OF_HIRE	Original Date of Hire	Original date of hire.
PERIOD_OF_SERVICE_ID	Period of Service ID	System generated primary key.
PERIOD_TYPE	Period Type	Determines whether it is a period of service for an Employee or Contingent worker: E or C, or non-worker: N.
PERSON_ID	Person ID	Foreign key to PER_PERSONS.
PRIMARY_FLAG	Primary	Accepts Yes or No values. If Yes, this employment period is considered the primary for the Legal Entity.
PROJECTED_TERMINATION_DATE	Projected Termination Date	Projected employment termination date.
READY_TO_CONVERT	Include for Automatic Conversion	Column to use for converting pending worker to employee based on option.
REHIRE_AUTHORIZER_PERSON_ID	Rehire Authorizer Person ID	Foreign Key to PER_PERSONS. Represents the person who recommends the worker for rehire.
REHIRE_REASON	Rehire Reason	If rehire recommendation is Yes, then reason from recommending person is tracked through this field.
REHIRE_RECOMMENDATION	Rehire Recommendation	Accepts Yes or No values. If Yes, person is recommended for re-hiring.
REVOKE_USER_ACCESS	Revoke User Access	This stores the user's option of revoking user access for Termination. Values accepted are I for Immediately or A for After termination. Note: : For V3 Terminations, though on the Termination page, the attribute is called Review User Access but in Autocomplete, it's referred as Revoke User Access.
WORKER_COMMENTS	Worker Comments	This stores a worker comment associated with the Resignation process.
WORKER_NUMBER	Worker Number	Uniquely identifies an employee or contingent worker. Can be system-generated or manually populated.

Note: The labels for the V2 termination attributes are retained in the Worker Work Relationship business object even after you migrate to V3 termination.

For more information about the Worker Work Relationship attributes, refer to the Tables and Views for HCM guide on the Oracle Help Center.