Fetching resignation reason and separation/resignation type in sql

Summary

Fetching resignation reason and separation/resignation type in sql

Content

Hi all,

 

How to fetch resignation reason and separation/resignation type(ie.resignation or termination) which is in manage work relationship using sql?

 

In which table I can fetch that? Anyone have sample query for that.

 

I used the below logic but I could'nt fetch them.

 

SELECT HTD.CREATION_DATE sub,

    htd.created_by AS usr,

    papf.person_id id,

    htd.status status,

    papf.person_number no,

HTH.MODULE_IDENTIFIER exit_type,

    to_date(DBMS_LOB.SUBSTR(HTD.DATA_CACHE,10,DBMS_LOB.INSTR(HTD.DATA_CACHE,'<DATA>',DBMS_LOB.INSTR(HTD.DATA_CACHE,'<NotifiedTerminationDate>'),1)+6),'YYYY-MM-DD') test,