Schengen Visa Application
1 Description | 2 Word Document Sample | 3 Main Selection | 4 SQL Statement | 5 Attachments
Summary | Visa Application sample for the Schengen Visa |
Keywords | Visa Application |
Read more about how to work with the Merge documents https://adonishr.atlassian.net/l/c/refaMVwF
Description
This merge document template can be customized with text and bookmarks suiting your needs.
Word Document Sample
Main Selection
The data from next planned sea-service activity is checked.
SQL Statement
SELECT
p01.pin,
p01.FIRSTNAME FirstName,
p01.middlename MiddleName,
p01.lastname LastName,
natcountry.countryname Nationality,
pass.tdnumber Passport_No,
orgves.NAME AS Vessel,
orgves.NAME AS Vessel1,
p03.datefrom SIGNONDATE,
(p03.datefrom + 30) as valid,
countryOn.countryname Joining_Country
FROM PW001P01 p01
JOIN PW001P03 p03
ON p03.PIN = p01.PIN
AND p03.DATEFROM > GETDATE()
AND p03.CODE IN (SELECT CODE
FROM PW001C12
WHERE OPTIONS LIKE '%S%')
AND NOT EXISTS (SELECT 1
FROM PW001P03 t
WHERE t.PIN = p01.Pin
AND t.DATEFROM > GETDATE()
AND t.CODE IN (SELECT CODE
FROM PW001C12
WHERE OPTIONS LIKE '%S%')
AND t.DATEFROM < p03.DateFrom
)
left join pw001p08 pass on pass.pin = p01.pin and pass.code in (SELECT CODE
FROM PW001C23
WHERE OPTIONS LIKE '%T%')
left join pwcountry natcountry on natcountry.countrycode = p01.nationality
LEFT JOIN PWORG orgves
ON orgves.NUMORGID = dbo.ad_scanorgtree(p03.NUMORGID, 3)
LEFT JOIN PWCCMCHANGECREWLIST ccl
ON ccl.NEXTACT = p03.SEQUENCENO
LEFT JOIN PWORGVESACT vaOn
ON vaOn.SEQNO = ccl.SEQNO
LEFT JOIN PWPORT portOn
ON portOn.PORTCODE = vaOn.PLACEFROM
LEFT JOIN PWCOUNTRY countryOn
ON countryOn.COUNTRYCODE = portOn.COUNTRYCODE
Attachments