2 Replies Latest reply: Apr 22, 2014 5:11 AM by Lynn Waters-Oracle RSS

    Position occupancy

    user12202698

      Hi all,

       

      i need to write a query to extract when a particular position was assigned to a individual. Can ne1 help me on this..

        • 1. Re: Position occupancy
          Narpalan

          Per_all_assignments_f - column POSITION_ID tells information about position that the person hold. Query this table using PERSON_ID of an individual

           

           

           

          In Per_positions - query the column NAME by passing Postion_ID that you get from Per_all_assignments_f

           

          Hope this info will be useful to you.

          • 2. Re: Position occupancy
            Lynn Waters-Oracle

            Some additional information on the tables used...

            HR_ALL_POSITIONS_F is a datetracked tables holding details of the position definition.

            The actual segment values are held in table PER_POSITION_DEFINITIONS which has a column for each segment value.

            The 2 tables are joined with column POSITION_DEFINITION_ID.