Hi Everyone, Need help By Mistake the user has assigned goal plans to some 100s of employee and want to delete that goal plans to that employees , I found the solution using HDL but there need some data that i am unable to extract to prepare the .dat files
METADATA|GoalPlanAssignment|SourceSystemId|SourceSystemOwner|GoalPlanExternalID
Can anyone please write the query for extracting this data associated with a particular goal plan
Here is the query that i wrote but not giving the correct things
SELECT
H.source_system_id,
H.source_system_owner ,
hgpa.GOAL_PLAN_ID,
hgpb.goal_plan_ext_id ,
hgpt.GOAL_PLAN_NAME,
hgpa.goal_plan_assignment_id ,
papf.person_number as assigned_to,
hgpa.assignment_id
from
HRC_INTEGRATION_KEY_MAP H ,
HRG_GOAL_PLANS_TL hgpt , per_all_people_f papf, HRG_GOAL_PLN_ASSIGNMENTS hgpa ,
HRG_GOAL_PLANS_B hgpb
where
H.surrogate_id = hgpa.goal_plan_assignment_id and
hgpt.goal_plan_id = hgpa.goal_plan_id AND hgpa.person_id = papf.person_id AND hgpb.goal_plan_id =hgpa.goal_plan_id
AND hgpt.goal_plan_name = :goal_plan_name
Everyone is welcome to this post with there query
Thanks you in advance