1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70
| MERGE INTO NEDAP.IMPORT using (select * from NEDAP.HRMS_RECEPTION_TMP where HRMS_RECEPTION_TMP.MOTIF_DEMANDE is null) H
ON (IMPORT.TIMESTAMP = H.DATE_JOUR_EXTRACTION_HRMS
AND IMPORT.PERSONNELNR = H.LOGIN
)
WHEN MATCHED THEN UPDATE
SET
IMPORT.STATUS = 'MAJ'
WHEN NOT MATCHED THEN INSERT
(
IMPORT.ID ,
IMPORT.IMPORT_FUNCTION ,
IMPORT.CARRIERTYPE ,
IMPORT.LASTNAME ,
IMPORT.INITIALS ,
IMPORT.MIDDLENAME ,
IMPORT.GENDER ,
IMPORT.TITLE ,
IMPORT.PERSONNELNR ,
IMPORT.DEPARTMENTNAME ,
IMPORT.COMPANY ,
IMPORT.IDENTIFICATION ,
IMPORT.WEIGHT ,
IMPORT.LICENSENUMBER ,
IMPORT.CARNUMBER ,
IMPORT.OWNER_PERSONNELNR ,
IMPORT.UNIT ,
IMPORT.PHONENUMBER ,
IMPORT.ARRIVALDATETIME ,
IMPORT.LEAVEDATETIME ,
IMPORT.CONTACTPERSON_PERSONNELNR ,
IMPORT.FREEFIELDID ,
IMPORT.FREEFIELDDATA ,
IMPORT.VENDOR_CODE ,
IMPORT.PICTURE_FILE ,
IMPORT.BADGETYPE ,
IMPORT.BADGENUMBER ,
IMPORT.BLOCKED ,
IMPORT.TEMPORARYBADGETYPE ,
IMPORT.TEMPORARYBADGENUMBER ,
IMPORT.VERIFIERTYPE ,
IMPORT.VERIFIERID ,
IMPORT.ACCESSDURINGHOLIDAYS ,
IMPORT.TEMPLATE ,
IMPORT.ENTRANCENAME ,
IMPORT.ENTRANCEGROUPNAME ,
IMPORT.DATETIMESCHEDULENAME ,
IMPORT.VALIDFROM ,
IMPORT.VALIDTO ,
IMPORT.DISABLED ,
IMPORT.COUNTGROUP ,
IMPORT.PRESENCETIME ,
IMPORT.NRMOVEMENTS ,
IMPORT.CANBEAPPPERSON ,
IMPORT.CARRIERGROUP ,
IMPORT.MOBILEPHONENUMBER ,
IMPORT.EMAIL ,
IMPORT.CANBEGUARD ,
IMPORT.LANGUAGE ,
IMPORT.USERNAME ,
IMPORT.ISREADONLY ,
IMPORT.STATUS ,
IMPORT.TIMESTAMP ,
IMPORT.ERRORCODE ,
IMPORT.ISACTIVE ,
IMPORT.EXTERNALBADGENUMBER ,
IMPORT.BLOCKREASON ,
IMPORT.VIOLATON ,
IMPORT.VIOLATONTYPE ,
IMPORT.DESCRIPTION
) |
Partager