EKNO YUAG

Dear ikmal , udah bisa di test ya

makasih

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

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