1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
| SELECT
d.libel0 as service,
p.n_pers as matricule,
p.badge as badge,
ltrim(rtrim(r.NOM))+' '+ltrim(rtrim(r.PRENOM)) as noms,
TO_CHAR(p.d_hist,'AAAA-MM-DD') as ladate,
p.h_hist as heure,
case p.code
when TO_NUMBER('1') then '1 - Demande de contrôle anti-retour'
when TO_NUMBER('2') then '2 - Acces Autorise'
when TO_NUMBER('5') then '5 - Acces Non autorisé'
when TO_NUMBER('27') then '27 - Refuse anti passback en sortie'
else '0 - Inconnu'
end as statut
FROM IDTECH.HIST p
left join
(SELECT * FROM IDTECH.PERS_VIEW) r on r.PERS_OID=p.N_PERS
left join
(SELECT * FROM IDTECH.DIV) d on (d.N1=r.N_DIV1 AND d.N2=r.N_DIV2 AND d.N3=r.N_DIV3)
where p.n_lect in (TO_NUMBER('31'),TO_NUMBER('32')) |
