Employee Supervisor Table

[chester04]

Hi,

what table to check if employee's supervisor has been changed?
Is it posible to create an event alert to send email notification when there is a change in employee supervisor? any reference document?

Thanks

[Amy]

Hi,

I guess a trigger can be set up for the particular field ; so that whenver there is a change in value it triggers a notification e-mail to the interested parties for further action.

Thanks,
Amy

[zangafa]

Per_all_assignments_f and the column name is supervisor_id that column = person_id in table per_all_people_f

[zangafa]

and if you want keep tracing that happen on the SUPERVISOR changes enable the audit on PER_ALL_ASSIGNMENTS_F

[Bharat]

please have a look into the document below for audit trails in Oracle HRMS.

Document

[sameer_srk]

Hi
Yes trigger can be written, But its not recommended because all hrms table is date track (i hope u understand Date track Modes in HR)
You can use this query below and change it to compare the supervisor change......... i have done this for grade changes.

select asg1.assignment_number,
case
when asg1.grade_id <> asg2.grade_id then
asg1.grade_id
else
null
end only_changed_grade
from per_all_assignments_f asg1,
per_all_assignments_f asg2
where asg1.assignment_id = asg2.assignment_id
--and asg1.person_id = 202
and asg1.grade_id is not null
and asg1.effective_start_date between to_date('01-MAR-2013') and to_date('31-MAR-2013')
and asg1.effective_start_date-1 between asg2.effective_start_date and asg2.effective_end_date

[Bharat]

In how many scenarios does the query works? I mean when we assign new grade value to it or to update the existing value or changing the old value to empty?