Task Layout Details (SQL Script)

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

This Task Layout Details query displays task layout codes, types, statuses, and associated task feature metadata for various time and attendance configurations, helping administrators track and manage task-related workflows such as calendar views, shift layouts, time entry, and approval processes.

#sqlquery

SELECT 
  --SQL4Fusion (An Orbit Analytics Project)
  --Displays task layout metadata linked with task features for time-related system configurations.    
   HTTFV.TASK_NAME,
   HTTFV.TASK_SHORT_NAME,
   HTTFV.TYPE                    TASK_TYPE,
   HTB.TCLAY_CD                  LAYOUT_CODE,
   HTB.TCLAY_TYPE                LAYOUT_TYPE,  
   HTB.STATUS,
   HTB.CREATION_DATE,
   HTTR.TL_ANSWER_SET_ID,
   HTTR.TL_TASK_FEATURES_ID
FROM 
    HXT_TCLAY_B                   HTB, 
    HWM_TL_TASK_RESULTS           HTTR, 
    HWM_TL_TASK_FEATURES_VL       HTTFV
WHERE 
    HTB.TCLAYST_ID = HTTR.TL_ANSWER_SET_ID
    AND HTTR.TL_TASK_FEATURES_ID = HTTFV.TL_TASK_FEATURES_ID
    AND HTTR.ENABLED_FLAG = 'Y';