Summary	The view shows crew assignments in the Rotation Planning Module.
Keywords	Crew Planning
Category	Crew List View

Description

The view shows crew assignments in the Rotation Planning Module.

View Sample

Main Data Selection

All crew assigned in the Rotation Planning Module.

SQL statement

Click here to expand...

CREATE VIEW dbo.PW001SRV20 
("Plan Year",
"Plan Name",
Vessel,
Position,
"Shift Start",
"Shift End",
PIN,
"Full Name",
"First Name",
"Last  Name",
"Middle Name",
Activity,
Rank,
NUMORGID,
EMPLOYMENTSTARTDATE,
EMPLOYMENTENDDATE
) AS 
SELECT YEAR(PLN.DATEFROM)  ROTATIONPLAN_YEAR,
PLN.DESCRIPTION ROTATIONPLAN,
VSL.NAME VESSEL,
pos.Name AS Position,
SH.DATEFROM SHIFTSTART,
SH.DATETO SHIFTEND,
p01.PIN,
p01.NAME,
p01.FIRSTNAME,
P01.LASTNAME,
P01.MIDDLENAME,
act.TEXT,
C02.NAME Rank,
P01.CLIENT NUMORGID,
P01.EMPLOYMENTSTARTDATE,
P01.EMPLOYMENTENDDATE

FROM 
    dbo.PW001P01 P01 
JOIN PWROT_ACTIVE_SHIFT SH ON SH.PIN=P01.PIN
JOIN PWROT_HEADERS PLN ON PLN.SEQUENCENO=SH.ROT_HEADER
LEFT JOIN PW001C02 C02 ON C02.CODE=SH.POSITION
LEFT JOIN PWORG VSL ON VSL.NUMORGID=SH.VESSEL_NUMORGID
LEFT JOIN PW001P03 P03 ON P01.PIN=P03.PIN
JOIN dbo.PWORG POS ON  POS.NUMORGID = dbo.ad_scanorgtree(P03.NUMORGID, 5)
LEFT JOIN PW001C12 act on act.CODE = P03.code

Columns Specification

Column	Description/ Location in APM
Plan Year	The year of the Rotation Plan.
Plan Name	The name of the Rotation Plan.
Vessel	The vessel the Rotation Plan is liked to.
Position	The position within the Rotation Plan.
Shift Start	The shift start date for the selected Rotation Plan and Position.
Shift End	The shift end date for the selected Rotation Plan and Position.
PIN	The PIN number of the person assigned to the shift within the selected Rotation Plan and Position.
Full Name	The Full Name of the person assigned to the shift within the selected Rotation Plan and Position.
First Name	The First Name of the person assigned to the shift within the selected Rotation Plan and Position.
Last Name	The Last Name of the person assigned to the shift within the selected Rotation Plan and Position.
Middle Name	The Middle Name of the person assigned to the shift within the selected Rotation Plan and Position.
Activity	The Activities of the person assigned to the shift within the selected Rotation Plan and Position.
Rank	The Rank of the person assigned to the shift within the selected Rotation Plan and Position.
NUMORGID	The employment organization number of the person assigned to the shift within the selected Rotation Plan and Position.
EMPLOYMENTSTARTDATE	The employment strat date of the person assigned to the shift within the selected Rotation Plan and Position.
EMPLOYMENTENDDATE	The employment end date of the person assigned to the shift within the selected Rotation Plan and Position.

Start Page

N/A