BIP report for worker time entry profile
Hello,
I am trying to draft a query to fetch time entry profile for all employee.
But the below query seems to be fetching incomplete results.
Can you please suggest some changes that can be made
SELECT
PPNF.DISPLAY_NAME AS EMPLOYEE_NAME,
PU.USERNAME AS UserName,
CASE
WHEN PU.ACTIVE_FLAG = 'Y' AND PU.SUSPENDED = 'N' THEN 'ACTIVE'
WHEN PU.ACTIVE_FLAG = 'Y' AND PU.SUSPENDED = 'Y' THEN 'INACTIVE'
WHEN PU.ACTIVE_FLAG = 'N' AND PU.SUSPENDED = 'Y' THEN 'INACTIVE'
WHEN PU.ACTIVE_FLAG = 'N' AND PU.SUSPENDED = 'N' THEN 'INACTIVE'
ELSE 'INACTIVE'
END AS USER_ACCOUNT_STATUS,
HGT.GROUP_NAME AS HCM_GROUP_NAME,