You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

SQL to get Checklist Status for Employees

edited Mar 7, 2023 7:36PM in Journeys 3 comments

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!