Attributes for When and Why

This table lists the main attributes of the When and Why business object and exceptions for any attribute, if any.

Attribute	Field Name	Description
ACTION_DATE	Action Date	Date of occurrence of action.
ACTION_ID	Action ID	Foreign key to the PER_ACTIONS_B table.
ACTION_OCCURRENCE_ID	When and Why ID	Primary key. Uniquely identifies a document record.
ACTION_REASON_ID	Action Reason ID	Foreign key to the PER_ACTION_REASONS_B table.
ACTION_TYPE_CODE	Action Type Code	Stores the action type used in the creation of this row.
BUSINESS_GROUP_ID	Business Group ID	Identifier of the enterprise used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS.
CREATED_BY	Created By	Indicates the user who created the row.
CREATION_DATE	Creation Date	Indicates the date and time of the creation of the row.
ENTITY_ID	Entity ID	Stores the surrogate key of the entity type.
ENTITY_TYPE	Entity Type	Entity type that stores the parent object of a transactional entity.
FREEZE_START_DATE	Freeze Start Date	Represents the deferred data freeze start date (defaulted to end of time).
FREEZE_UNTIL_DATE	Freeze Until Date	Represents the deferred data freeze until date (defaulted to start of time).
LAST_UPDATE_DATE	Last Update Date	Indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	Last Update Login	Indicates the session login associated with the user who last updated the row.
LAST_UPDATED_BY	Last Updated By	Indicates the user who last updated the row.
LEGAL_ENTITY_ID	Legal Entity ID	Indicates the proposed legal entity ID of the worker.
OBJECT_VERSION_NUMBER	Object Version Number	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.
PARENT_ENTITY_KEY_ID	Parent Entity Key ID	Stores the surrogate key of the entity type.
PARENT_ENTITY_TYPE	Parent Entity Type	Entity type which stores the parent object of a transactional entity.
PROPOSED_ACTION_ID	Proposed Action ID	Indicates the proposed action ID of the worker.
PROPOSED_ACTION_TYPE	Proposed Action Type	Indicates the proposed action type of the worker.
PPROPOSED_REASON_ID	Proposed Reason ID	Indicates the proposed action reason ID of the worker.
PROPOSED_START_DATE	Proposed Start Date	Indicates the proposed start date of the worker.
PROPOSED_WORKER_TYPE	Proposed Worker Type	Indicates the proposed worker type of the worker.
SUBMITTED_BY	Submitted By	Indicates the user who submitted the action.

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