Project

General

Profile

Support #978

Query untuk membaca Employee yang baru saja hiring tetapi sudah mendapat quota cuti sebelum masa kerja di bawah 1 tahun.

Added by Muhammad Bintar over 2 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Muhammad Bintar
Start date:
03/17/2022
Due date:
03/21/2022
% Done:

0%

Estimated time:

Description

Dear tim developer, mohon support untuk membuatkan query untuk membaca Employee yang baru saja hiring tetapi sudah mendapat quota cuti sebelum masa kerja di bawah 1 tahun.

tabel yang dibaca adalah master data assignment dengan employee status active dan movement type nya hiring. setelah dapat datanya, startdate nya itu di movement type hiring di join kan ke master data absence quota.

#1

Updated by Muhammad Bintar over 2 years ago

update :
SELECT md17.original_quota,md17.remaining_quota,* FROM dbo.hr_md_emp_md0002 md02 LEFT OUTER JOIN dbo.hr_md_emp_md0017 md17 ON md02.emp_id=md17.emp_id AND md02.start_date=md17.start_date
WHERE movement_type='01' AND md17.remaining_quota IS NOT NULL AND md17.original_quota IS NOT NULL AND md02.end_date >= dbo.fn_formatdatetime(GETDATE, 'yyyymmdd')

#2

Updated by Saswanto Tampan over 2 years ago

  • Status changed from New to Revise
  • Assignee changed from Saswanto Tampan to Muhammad Bintar
#3

Updated by Muhammad Bintar over 2 years ago

  • Status changed from Revise to Closed

Also available in: Atom PDF