Supernumerary Crew list
- Janette Ilunio
- Daria Chebotaieva
Owned by Janette Ilunio, created
1 Description | 2 SQL Statement | 3 Field Specification
Summary | The view shows dditional personnel onboard (supernumerary crew) |
|---|---|
Keywords | Supernumerary |
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
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')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