Performance Goals - Status of Edited Goal

Summary

Performance Goal - Get the latest status of the edited Goal

Content

In Performance Goals, once you edit the already approved goal and submit for approval, the system creates additional record for the new information with a link to the original goal. Until, the goal is approved, you'll get the goal count as 2.

Goal_ID	Goal_Name	GOAL_VERSION_TYPE_CODE	GOAL_APPROVAL_STATE	Previous_state_goal_id
1001	My Goal	ACTIVE
1002	My Goal - Edited	PENDING_APPROVAL	ORA_UPDATED	1001

For a Goal which is approved this attribute is NULL. Reference to the original Goal is captured in PREVIOUS_STATE_GOAL_ID.