Project

General

Profile

Feature #1601

[HR-Employee Report] Report All Employee kolom2 nya tidak ada data nya

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

Status:
Closed
Priority:
Normal
Assignee:
shofwan shiddiq
Start date:
09/15/2022
Due date:
09/19/2022
% Done:

0%

Estimated time:
Spent time:
4.00 h

Description

Dear tim developer mohon supportnya untuk report all employee karena tidak ada datanya.

berikut kolom2 yang kosong data nya:
Blood Type = mengambil data pada kolom blood type di master data Health record (phrp0011) dengan enddate 99991231 dan startdate paling terbaru
Institution = mengambil data di master data education (phrpa0008) di kolom institution dengan education type jenjang paling tinggi (max value) edulevel

remote.minovais.com:61121
username minovais

database sql server 2019
remote.minovais.com , 1445
minovaes_rohto_prod

stored procedure PRPTPAALLEMPLOYEE

Files

clipboard-202209151546-psska.png (106 KB) clipboard-202209151546-psska.png Muhammad Bintar, 09/15/2022 03:46 PM
clipboard-202211181028-p6crp.png (226 KB) clipboard-202211181028-p6crp.png Muhammad Bintar, 11/18/2022 10:28 AM

Also available in: Atom PDF