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,