Summary	The view shows all the Travel documents for all the crew.
Keywords	Travel Documents

Description

The view shows all the Travel documents for all the crew

Selection

All the crew that have at least one record in PW001P08 (Travel Documents).

SQL statement

--Travel Docuements 08/08/2022
CREATE VIEW dbo.PW001SRV26 AS
SELECT 
P08.PIN,
P01.ALTERNATIVEPIN 'EMPLOYEE NR',
ORG.NAME 'EMPLOYMENT ENTITY',
P01.NAME,
C02.NAME RANK,
P08.CODE,
C23.VISATYPE TRAVEL,
P08.DATEFROM,
P08.DATETO EXPIRY,
p08.ISSUE_COUNTRY,
P08.ISSUEDBY,
P08.TDNUMBER NUMBER,
P08.COMMENTS,
P01.EMPLOYMENTSTARTDATE,
P01.EMPLOYMENTENDDATE,
P01.CLIENT NUMORGID
FROM PW001P08 P08
LEFT JOIN PW001P01 P01 ON P01.PIN=P08.PIN
LEFT JOIN PWORG ORG ON ORG.NUMORGID=P01.CLIENT
LEFT JOIN PW001C23 C23 ON C23.CODE=P08.CODE
LEFT JOIN PW001C02 C02 ON C02.CODE=P01.RANK