SQL to get Checklist Status for Employees
Summary:
SQL to get Checklist Status for Employees
Content (required):
If we have a requirement to get Checklist status for Employees, below SQL can be leveraged.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
SELECT DISTINCT
PAPF.PERSON_NUMBER,
ACT.CHECKLIST_NAME,
ATT.TASK_NAME,
CASE
WHEN AC.CHECKLIST_STATUS = 'COM' THEN 'Completed'
WHEN AC.CHECKLIST_STATUS = 'INI' THEN 'Pending'
ELSE ' '
END AS CHECKLIST_STATUS,
TO_CHAR(AC.ALLOCATION_DATE, 'mm/dd/yyyy'),
TO_CHAR(AC.COMPLETION_DATE, 'mm/dd/yyyy'),
AC.CHECKLIST_CATEGORY,
AC.CHECKLIST_ID,
1