1. 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,747
    Likes Received:
    147
    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,747
    Likes Received:
    147
    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?