Human Capital Management - EBS (MOSC)

MOSC Banner

How to get maximum qualification for employee

edited Feb 27, 2020 2:14AM in Human Capital Management - EBS (MOSC) 4 commentsAnswered ✓

Hi,

Below is the query to extract overall qualification details of employees,  now I need to extract maximum qualification for all employees.

select distinct

  papf.employee_number

, to_char(papf.START_DATE,'DD-MON-YYYY')    "Date of joining"

,papf.full_name                                                      "Name"    

,perq.title                                                               "Degree"

,perq.grade_attained                                             "Grade"

,perq.status_meaning                                            "Status"

,to_char( perq.start_Date, 'DD-MON-YYYY')        "Date Start"

,to_char(perq.end_date, 'DD-MON-YYYY')           "Date Completed"

,perq.name                                    

,perq.establishment                                                "Board/ University"     

,qtype.RANK                             

  from

APPS.PER_QUALIFICATIONS_V                              PERQ

,APPS.per_ALL_PEOPLE_F                                       PAPF                   

,APPS.PER_QUALIFICATION_TYPES_V                    QTYPE

where papf.person_id = perq.person_id

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center