Bug #3566
Bugs Report All Employee
Description
Dear Team Developer,
Mohon bantuannya, untuk menampilkan data Institution yang ada di table PHRPA0008 berdasarkan EmployeeID nya. Karena pada saat ini data nya ada (free text) tapi di report All Employee belum muncul data Institution nya.
Terima kasih.
https://hris-ekno.minovais.com/Account/Login
port db: 103.153.60.89
database: MinovaES_Ekno
Files
Updated by Kezia Pawitra Yulianti 3 months ago
- Due date set to 04/17/2025
- Status changed from New to Assigned
- Assignee changed from Kezia Pawitra Yulianti to shofwan shiddiq
Updated by Kezia Pawitra Yulianti 3 months ago
- Due date changed from 04/17/2025 to 04/16/2025
- Assignee changed from shofwan shiddiq to M Azid Wahyudi
- Priority changed from Normal to High
Updated by M Azid Wahyudi 3 months ago
- File clipboard-202504151405-tzkzc.png clipboard-202504151405-tzkzc.png added
- Status changed from Assigned to QA Test
- Assignee changed from M Azid Wahyudi to Mr Ikmal
Dear ikmal , udah bisa di test ya
makasih
Updated by Mr Ikmal 3 months ago
- File Screenshot 2025-04-16 091343.png Screenshot 2025-04-16 091343.png added
- File Screenshot 2025-04-16 092021.png Screenshot 2025-04-16 092021.png added
- Status changed from QA Test to Assigned
- Assignee changed from Mr Ikmal to M Azid Wahyudi
Dear mas azid,
Mohon bantuannya untuk di report All Employee, menampilkan data KTP No dan data nya diambil dari table PHRPA0013 yg IDType nya 00 aja mas.
Terima kasih
https://hris-ekno.minovais.com/Account/Login
port db: 103.153.60.89
database: MinovaES_Ekno
Updated by M Azid Wahyudi 3 months ago
- File clipboard-202504161010-4p0bs.png clipboard-202504161010-4p0bs.png added
- Status changed from Assigned to Revise
- Assignee changed from M Azid Wahyudi to Mr Ikmal
dear ikmal , untuk setting ktp ada settingannya di PCMEPGENPARAM paramater (PRPTPAALLEMPLOYEE_IDKTP)
berikut ini settingan2 yang ada di report all employee :
DECLARE @PermanentDate VARCHAR
SELECT @PermanentDate = Value1
FROM PCMEPGENPARAM
WHERE Parameter = 'PRPTPAALLEMPLOYEE_PRMNTDATE'
DECLARE @PermanentDate2 VARCHAR
SELECT @PermanentDate2 = Value1
FROM PCMEPGENPARAM
WHERE Parameter = 'PRPTPAALLEMPLOYEE_DATETYP'
DECLARE @HiringDate VARCHAR
SELECT @HiringDate = Value1
FROM PCMEPGENPARAM
WHERE Parameter = 'PRPTPAALLEMPLOYEE_HIRINGDATE'
DECLARE @LastAssign VARCHAR
SELECT @LastAssign = Value1
FROM PCMEPGENPARAM
WHERE Parameter = 'PRPTPAALLEMPLOYEE_LASTASSGNMNT'
DECLARE @Resign VARCHAR
SELECT @Resign = Value1
FROM PCMEPGENPARAM
WHERE Parameter = 'PRPTPAALLEMPLOYEE_RESIGN'
DECLARE @Expired VARCHAR
SELECT @Expired = Value1
FROM PCMEPGENPARAM
WHERE Parameter = 'PRPTPAALLEMPLOYEE_DATESPEC'
DECLARE @joingroup VARCHAR
SELECT @joingroup = Value1
FROM PCMEPGENPARAM
WHERE Parameter = 'PRPTPAALLEMPLOYEE_DATETYP_JOINGROUP'
DECLARE @Resident VARCHAR
SELECT @Resident = Value1
FROM PCMEPGENPARAM
WHERE Parameter = 'PRPTPAALLEMPLOYEE_RESIDENT'
DECLARE @HP VARCHAR
SELECT @HP = Value1
FROM PCMEPGENPARAM
WHERE Parameter = 'PRPTPAALLEMPLOYEE_COMMTYPHP'
DECLARE @Email VARCHAR
SELECT @Email = Value1
FROM PCMEPGENPARAM
WHERE Parameter = 'PRPTPAALLEMPLOYEE_COMMTYPEMAIL'
DECLARE @IDKTP VARCHAR
SELECT @IDKTP = Value1
FROM PCMEPGENPARAM
WHERE Parameter = 'PRPTPAALLEMPLOYEE_IDKTP'
DECLARE @IDPassport VARCHAR
SELECT @IDPassport = Value1
FROM PCMEPGENPARAM
WHERE Parameter = 'PRPTPAALLEMPLOYEE_IDPSSPRT'
DECLARE @IDSIMA VARCHAR
SELECT @IDSIMA = Value1
FROM PCMEPGENPARAM
WHERE Parameter = 'PRPTPAALLEMPLOYEE_IDSIMA'
DECLARE @IDSIMB VARCHAR
SELECT @IDSIMB = Value1
FROM PCMEPGENPARAM
WHERE Parameter = 'PRPTPAALLEMPLOYEE_IDSIMB'
DECLARE @IDSIMC VARCHAR
SELECT @IDSIMC = Value1
FROM PCMEPGENPARAM
WHERE Parameter = 'PRPTPAALLEMPLOYEE_IDSIMC'
DECLARE @ResidentKTP VARCHAR
SELECT @ResidentKTP = Value1
FROM PCMEPGENPARAM
WHERE Parameter = 'PRPTPAALLEMPLOYEE_RESIDENTKTP'
DECLARE @ResidentKost VARCHAR
SELECT @ResidentKost = Value1
FROM PCMEPGENPARAM
WHERE Parameter = 'PRPTPAALLEMPLOYEE_RESIDENTKOST'
DECLARE @par_pension VARCHAR
SELECT @par_pension = Value1
FROM dbo.PCMEPGENPARAM
WHERE Parameter = 'MDREMINDERMAXAGEPENSION'
makasih