Employee Schools and Colleges Information in Oracle HRMS

 

Query:

SELECT  PAPF.EMPLOYEE_NUMBER 

               ,PAPF.FULL_NAME

               ,PEA.ESTABLISHMENT

               ,PEA.ATTENDED_START_DATE

               ,PEA.ATTENDED_END_DATE

               ,PEA.FULL_TIME

FROM    PER_ALL_PEOPLE_F    PAPF

               ,PER_ESTABLISHMENT_ATTENDANCES PEA

WHERE   1=1

AND        PAPF.PERSON_ID = PEA.PERSON_ID

--AND     PAPF.EMPLOYEE_NUMBER = 9794--1906

AND        SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE

Navigation:

1. Go to the Global HRMS Manager (Responsibility)
2. People --> Enter and Maintain
3. Enter Employee Number
4. Click on Others button and search Schools and Colleges Attended