Crew List - Supernumerary Crew list

2 min
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

 

Looking for labels? They can now be found in the details panel on the floating action bar.

Related content