...
Description
...
| Table of Contents | ||||||||
|---|---|---|---|---|---|---|---|---|
|
| Page Properties | |
|---|---|
|
...
|
...
File / Script Link
...
Description
Supernumerary are additional personnel on board other than the crew. In the list, the activity used is ONBDUP which means onboard supernumerary. Included in the report are those activities that are planned is equal to Y and N.
SQL Statement
| Code Block |
|---|
SELECT P01.PIN, |
...
P01.NAME, |
...
pos.NAME AS 'Position', |
...
vsl.NAME AS 'Vessel Name', |
...
ORG.NAME AS 'Manning Agent', |
...
P01.NATIONALITY AS Nationality, |
...
P01.PERSONALIDNO AS 'PersonalIdNo', |
...
dbo.ad_SignOnDate(p2.NUMORGID, p2.PIN, p2.DATEFROM) AS 'Sign On Date/Planned Sign On Date', |
...
p2.TODATEESTIMATED AS 'Estimated End Date/Estimated Planned Date', |
...
C12.CODE AS [Activity Code], |
...
p2.PLANNED AS 'Planned Activity [Y/N]', |
...
PUser.LOGIN_NAME AS 'Created By', |
...
P01.LASTNAME AS Lastname, |
...
P01.FIRSTNAME AS Firstname, |
...
P01.CLIENT AS NUMORGID, |
...
P01.EMPLOYMENTSTARTDATE, |
...
P01.EMPLOYMENTENDDATE, |
...
ccl.WATCH, |
...
C12.CODE, |
...
p2.DATEFROM, |
...
p2.DATETO |
...
FROM PW001P01 AS P01 INNER JOIN PW001P03 AS p2 ON P01.PIN = p2.PIN LEFT OUTER JOIN PW001C12 AS C12 ON C12.CODE = p2.CODE LEFT OUTER JOIN PWSECURITY_USERS AS PUser ON p2.CREATEDBY = PUser.USERID LEFT OUTER JOIN PWORG AS pos ON pos.NUMORGID = dbo.ad_scanorgtree(p2.NUMORGID, 5) LEFT OUTER JOIN |
...
PWORG AS vsl ON vsl.NUMORGID = dbo.ad_scanorgtree(p2.NUMORGID, 3) LEFT OUTER JOIN |
...
PWORG AS DEP ON DEP.NUMORGID = dbo.ad_scanorgtree(p2.NUMORGID, 4) LEFT OUTER JOIN |
...
PWORG AS ORG ON P01.CLIENT = ORG.NUMORGID LEFT OUTER JOIN |
...
PWCCMCHANGECREWLIST AS ccl ON ccl.NEXTACT = p2.SEQUENCENO AND ccl.SIGNON = 1 AND p2.PIN = ccl.PIN AND ccl.CHANGEDONE = 1 AND ccl.DATEOFCHANGE = p2.DATEFROM |
...
WHERE (C12.CODE = 'ONBSUP') AND (p2.DATEFROM <= GETDATE()) AND (p2.DATETO IS NULL) AND (p2.PLANNED = 'N') OR |
...
(C12.CODE = 'ONBSUP') AND (p2.DATEFROM >= GETDATE()) AND (p2.DATETO IS NULL) AND (p2.PLANNED = 'Y') |
...
Compatibility APM Version
...
Compatibility SQL Version
...
Supernumerary are additional personnel on board other than the crew. In the list, the activity used is ONBDUP which means onboard supernumerary. Included in the report are those activities that are planned is equal to Y and N.
Selection
Field Specification
Name, Position, Vessel Name, Manning Agent, Nationality, PersonalIdNo, Signon Date/Planned Signon Date, Estimated End Date/Estimated Planned Date, Activity Code, Planned Activity [Y/N], Created by
Other