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
) |
