To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Fetching resignation reason and separation/resignation type in sql
Summary
Fetching resignation reason and separation/resignation type in sqlContent
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,