Rotation Planning View

Owned by Daria Chebotaieva, created
Last updated: Mar 21, 2023
2 min read
1 Description | 2 View Sample | 3 Main Data Selection | 4 SQL statement | 5 Columns Specification | 6 Start Page

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

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

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