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. |
For more information about the Worker Work Relationship attributes, refer to the Tables and Views for HCM guide on the Oracle Help Center.