CLIENT SUPPORT » CNAF

--  execute query di bawah ini untuk mendapatkan reqId Cuti sakit 

select * from core_wf_run_biz_data where bizproc_id = 'Leave_CNAF' and field_id = 'main_absence_type' and value = '0001'

-- execute query di bawah ini untuk mendapatkan semua request cuti  yang di approve pada tahun 2021

select * from core_wf_run_main where bizflow_id = 'MD_Leave_CNAF'  and workflow_status = 'F' and flow_type = '400' and LEFT(dt_create,4)='2021' and LEFT(dt_change,4) = '2021'

-- execute query di bawah ini untuk mendapatkan data cuti sakit 2021 berserta informasi requester dan approver

select distinct  biz.reg_id,main.emp_id_as as Employee_ID_requester , main.dt_create as Tanggal_Request, main.emp_id_change as Employee_ID_Approver, main.dt_change as Tanggal_Approve, biz.value   from core_wf_run_main main

inner join core_wf_run_biz_data biz on main.reg_id = biz.reg_id 

and biz.bizproc_id = main.bizproc_id

and biz.value = '0001'

 where main.bizflow_id = 'MD_Leave_CNAF'  and main.workflow_status = 'F' and main.flow_type = '400' and LEFT(main.dt_create,4)='2021' and LEFT(main.dt_change,4) = '2021'