Below is the Fusion OTL Sample SQL , Shift Premium used in the SQL is the Custom Attribute . Use Custom Attributes based on your requirements . SQL Text: select papf . person_number Employee_Number , ppnf . full_name Employee_Name ,( select distinct ppnf_mgr . full_name from per_assignment_supervisors_f pasf , per_person_names_f ppnf_mgr where 1 = 1 and pasf . assignment_id = paam . assignment_id and pasf . manager_type = 'LINE_MANAGER' and pasf . primary_flag = 'Y' and ppnf_mgr . person_id = pasf . manager_id and ppnf_mgr . name_type = 'GLOBAL' and sysdate between pasf . effective_start_date and pasf . effective_end_date and sysdate between ppnf_mgr . effective_start_date and ppnf_mgr . effective_end_date ) supervisor_name ,( select dept . name f...