Action Occurrences

When certain actions, such as Hire an Employee and Promote occur in different product areas of the application, a record of the action occurrence is stored in the PER_ACTION_OCCURENCES table.

The table stores information about different product areas and if required, the information can be retrieved by providing the appropriate entity type and parent entity type.

For example, when you cancel a work relationship, the assignment record is deleted. However, the record of the cancel action is stored in the PER_ACTION_OCCURENCES table. You can search for a person whose work relationship was canceled by querying the table. The PARENT_ENTITY_KEY_ID column in the table stores the person ID of the person whose work relationship was canceled.

This table lists the entity type and parent entity type for the objects that generate an action occurrence record. You can use this information to build your own reports to access the various actions that have occurred on the objects.

Flow	Entity Type - Entity ID	Parent Entity Type - Parent Entity Key ID
Employment pages	No entity type or ID is populated.	Person - Person ID
Delete record from Employment Details page	Assignment - Assignment ID	Person - Person ID
Salary when managed from the standalone salary pages	Salary - Salary ID	Assignment - Assignment ID
Grades	Grade - Grade ID	No parent entity type or ID is populated.
Grade Ladders	Grade Ladder - Grade Ladder ID	No parent entity type or ID is populated.
Grade Rates	Grade Rate - Rate ID	No parent entity type or ID is populated.
Jobs	Job - Job ID	No parent entity type or ID is populated.
Job Families	Job Family - Job Family ID	No parent entity type or ID is populated.
Locations	Location - Location ID	No parent entity type or ID is populated.
Organizations	Organization - Organization ID	No parent entity type or ID is populated.
Positions	Position - Position ID	No parent entity type or ID is populated.