We have onboarding 30days questionarie BI report, issue is not showing status in report
Summary:
Hi Team,
We have onboarding 30days questionarie BI report, issue is not showing status in report some of employess empty coming.
I observed that employess status showing is optional .
how can we get status ?
Thanks,
Ajay
Others' Incomplete Tasks >>>>
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
select decode(pat.status,'COM','Completed'
,'DEP','Dependent of other tasks to be completed'
,'SUS','Suspended '
,'INI','Initiated'
,'INP','In Progress'
,'OUT','Outstanding'
,'REJ','Rejected'
,'WIT','Withdrawn'
,'WAI','Not Due Yet'
) status
from
per_all_people_f papf2,