Employee Web Clock Entries (SQL Script)

Human Capital Management (HCM) Human Resources (HRMS)
1

This Employee Web Clock Entries query displays click event details (including clicked time, sequence number, and creator) along with associated organization and person information for employees as of today, helping users analyze employee click time details within the organization.

#sqlquery

SELECT 
       --SQL4Fusion (An Orbit Analytics Project)
       --Retrieve employee click time details with organization and personal info.
       HAOUT.NAME ORGANIZATION_NAME,
       PPNFV.FULL_NAME PERSON_NAME,
	   PAPF.PERSON_NUMBER,
	   HWCT.CLICKED_TIME,
       HWCT.SEQUENCE_NUM,
       HWCT.TIMEZONE_OFFSET,
       HWCT.CREATION_DATE,
       HWCT.CREATED_BY
FROM 
       HR_ALL_ORGANIZATION_UNITS_TL HAOUT,
       PER_PERSON_NAMES_F_V PPNFV,
       PER_ALL_PEOPLE_F PAPF,
       PER_ALL_ASSIGNMENTS_M PAAM,
	   HXT_WC_CLICKED_TIMES HWCT
WHERE    
       PAPF.PERSON_ID = PAAM.PERSON_ID
       AND PAPF.PERSON_ID = PPNFV.PERSON_ID
	   AND HWCT.PERSON_ID=PPNFV.PERSON_ID
       AND PAAM.ORGANIZATION_ID = HAOUT.ORGANIZATION_ID
       AND HAOUT.LANGUAGE = USERENV ('LANG')
       AND TRUNC (SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE
                               AND PAPF.EFFECTIVE_END_DATE
       AND TRUNC (SYSDATE) BETWEEN PPNFV.EFFECTIVE_START_DATE
                               AND PPNFV.EFFECTIVE_END_DATE
       AND TRUNC (SYSDATE) BETWEEN PAAM.EFFECTIVE_START_DATE
                               AND PAAM.EFFECTIVE_END_DATE