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.
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. |