1. The Forum has been upgraded to a modern and advanced system. Please read the announcement about this update.
  2. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Employee Supervisor Table

Discussion in 'Oracle HRMS & Payroll' started by chester04, Feb 21, 2011.

  1. chester04

    chester04 Active Member

    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    100
    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
     
  2. Amy

    Amy Active Member

    Messages:
    12
    Likes Received:
    2
    Trophy Points:
    90
    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
     
  3. zangafa

    zangafa Active Member

    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    100
    Per_all_assignments_f and the column name is supervisor_id that column = person_id in table per_all_people_f
     
  4. zangafa

    zangafa Active Member

    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    100
    and if you want keep tracing that happen on the SUPERVISOR changes enable the audit on PER_ALL_ASSIGNMENTS_F
     
  5. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,719
    Likes Received:
    140
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    please have a look into the document below for audit trails in Oracle HRMS.

    Document
     
  6. sameer_srk

    sameer_srk Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    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
     
  7. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,719
    Likes Received:
    140
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    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?